Codes and Scripts

PO Authority Script

10/16/2014

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

0 Comments

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.

0 Comments