evergrowth consulting ltd.
  • Home
  • Core Values
  • Accounting Services
  • Support Services
  • Useful Sites
  • In Your Community
  • Contact Us
  • Email Us
  • Codes and Scripts

PO Authority Script

10/16/2014

0 Comments

 
This script is used to pull the information from Great Plains regarding the PO Enhancements module, specifically the authority limits and reporting lines.  It is useful to get a snapshot view of who can authorize what, and for whom.
0 Comments

tax info data pull

10/16/2014

1 Comment

 
This script is used to pull data that may be required for a government audit.  The usual form of audit requests is for a previous year, with the following information being provided:
  • Account Number
  • Account Name
  • Transaction Date
  • Posting Date
  • Entry Source
  • Journal Entry Number
  • Description
  • Batch Number
  • Debit (Functional Currency)
  • Credit (Functional Currency)
  • Net Amount (Functional Currency)
  • Transaction Currency
  • Debit (Originating Currency)
  • Credit (Originating Currency)
  • Net Amount (Originating Currency)
  • Originating Control Number (i.e. A/R or A/P transaction number)
  • Originating Master ID (i.e. Customer ID or Vendor ID)
  • Originating Master Number (i.e. Customer Name or Vendor Name)
  • Originating Document Number

This information pulls from the GL20000 and GL30000 tables (current year transactions and historical transactions.)  The data can be exported into whatever format the government agency is requesting.
1 Comment
(c) by evergrowth consulting ltd.
C.J. McCullough
James McCullough