Return To the top of the peachpro.com
PeachPro sets you free
AIG More Information to G/L

Would you like more control over what information Account Payable sends to your General Ledger? With AIG - More Information to G/L get a more concise, more meaningful audit trail. Specify the information you want transferred to G/L's reference and description fields based on the type of A/P transaction. You can choose from a list of fields such as Vendor ID, Vendor Name, Check Number, Comment, Invoice Number, Ref Code, and up to three user defined fields. You can even piece together text from multiple fields and add free form descriptions.

After installing AIG - More information to G/L you will have a new program option, G/L Transfer Options in your Maintenance menu:

                        ======= Program Options =======
                       |  O - Set Module Options       |
                       |  P - Set Printer Assignments  |
                       |  G - G/L Transfer Options     |
                        ===============================

When you select "G - G/L Transfer Options", you will be prompted to define what information "Create G/L Journal Entries" will transfer to G/L's reference and description fields. Specify what information you would like transferred for each transaction type by entering a combination of text and numeric codes that represent the different A/P fields available. Below is a list of A/P fields and the codes that are associated with each field.

 ===============================
|  Code  Length   Field Descr   |
|   1       6    Vendor ID      |
|   2      25    Vendor Name    |
|   3       8    Check Number   |
|   4      25    Comment        |
|   5      23    Invoice Number |
|   6       8    Ref Code       |
|   7            UserDefined    |
|   8            UserDefined    |
|   9            UserDefined    |
 ==============================

The number of times that a code digit is repeated determines how many characters of the associated field will be transferred to G/L. For example, entering "222222" will transfer six digits of the Vendor Name. Or, "22222222 from 44" would transfer eight digits of the Vendor Name field, the word "from", and two digits of the comment field into the General Ledger.

Fields can also be broken into sections, for example "333 111111 33333" would transfer the first three characters from the check number (Code 3), a space, six characters from the vendor ID (Code 1), then the remaining five characters from the check number (Code 3).

The characters that will be transferred are taken from the left side of the field. For example, entering "4444" would transfer the leftmost four characters of the comment field to G/L. Entering "44" would transfer the first two characters of the comment field. The maximum number of characters that can be transferred for a particular field is determined by the Length column, which is the size of the field in A/P.

Below are two examples of the options screens:

The first example shows the Peachtree defaults when Transfer Vendor Name to G/L is set to "Y".

+--------------------------------------------------------------------------------+
¦APMAINT2              Maintain Accounts Payable Options        COMPANY ID: SP   ¦
¦01/01/94                  Software Professionals, Inc.         GENERATION #: 14 ¦
+--------------------------------------------------------------------------------+
| Transaction        Ref        Description              For the field  Use Code |
| -----------      -------- -------------------------    -------------  -------- |
| Entered Invoice           2222222222222222222 - INV    Vendor ID         1     |
| Entered Auto Inv 33 Auto  A/P Entered Auto Invoices    Vendor Name       2     |
| Invoice Dist              2222222222222222222 - IND    Invoice Number    3     |
| Auto Inv Dist    33 Auto  A/P Auto Invoice Distribu    Invoice Comment   4     |
| Edited Invoices  33333333 111111 - Edited Invoices     Check Number      5     |
| Discount Taken            2222222222222222222 - DIS    Reference Code    6     |
| Open Credit      33333333 2222222222222222222 - OCR    UserDef1          7     |
| Open Cr Dist     33333333 2222222222222222222 - OCD    UserDef2          8     |
| Payments         55555555 2222222222222222222 - PAY    UserDef3          9     |
| Cash             55555555 2222222222222222222 - CSH                            |
| Deleted Invoice  33333333 2222222222222222222 - DIN                            |
| Deleted Inv Dist 33333333 2222222222222222222 - DID                            |
| Deleted Open Cr  33333333 2222222222222222222 - DOC                            |
| Deleted Spec Cr  66666666 2222222222222222222 - DCR                            |
| Void Ck Payment  55555555 2222222222222222222 - VCP                            |
| Void Ck Cash     55555555 2222222222222222222 - VCC    (Press F1-Help          |
| Void Ck Discount 55555555 2222222222222222222 - VCD     for examples)          |
|                                                                                |
|  F1-Help   F5-Defaults   F6-Sample   F7-Def Codes   F8-Undo   F10 Done         |
+--------------------------------------------------------------------------------+

The second example shows the Peachtree defaults when Transfer Vendor Name to G/L is set to "N".

+--------------------------------------------------------------------------------+
¦APMAINT2            Maintain Accounts Payable Options        COMPANY ID: SP     ¦
¦01/01/94                  Software Professionals, Inc.       GENERATION #: 14   ¦
+--------------------------------------------------------------------------------+
|                                                                                |
| Transaction         Ref       Description              For the field  Use Code |
| -----------      -------- -------------------------    -------------  -------- |
| Entered Invoice           111111 - Entered Invoices    Vendor ID         1     |
| Entered Auto Inv 33 Auto  A/P Entered Auto Invoices    Vendor Name       2     |
| Invoice Dist              111111 - Invoice Dist.       Invoice Number    3     |
| Auto Inv Dist    33 Auto  A/P Auto Invoice Distribu    Invoice Comment   4     |
| Edited Invoices  33333333 111111 - Edited Invoices     Check Number      5     |
| Discount Taken            111111 - Discounts Taken     Reference Code    6     |
| Open Credit      33333333 111111 - Open Credit         User Def 1 Title  7     |
| Open Cr Dist     33333333 111111 - Open Credit Dist    User Def 2 Title  8     |
| Payments         55555555 111111 - Payments            User Def 3 Title  9     |
| Cash             55555555 111111 - Cash                                        |
| Deleted Invoice  33333333 111111 - Deleted Invoice                             |
| Deleted Inv Dist 33333333 111111 - Deleted Inv. Dis                            |
| Deleted Open Cr  33333333 111111 - Deleted Open Cre                            |
| Deleted Spec Cr  66666666 111111 - Delete Credit                               |
| Void Ck Payment  55555555 Payments Void Check                                  |
| Void Ck Cash     55555555 Cash, Void Check             (Press F1-Help          |
| Void Ck Discount 55555555 Discounts Taken, Void Che     for examples)          |
|                                                                                |
|  F1-Help   F5-Defaults   F6-Sample   F7-Def Codes   F8-Undo   F10 Done         |
+--------------------------------------------------------------------------------+

F1 - Help can be selected from any field. It will show a description of how the system works, the legend of numeric codes, and an example.

F5 - Default will change all fields back to the standard format A/P currently uses for its transfers to G/L.

F6 - View Transfer will display an on-screen preview of how the transfer will look with the settings you have selected.

F7 - Def Codes allows you to specify which three of the five user-defined fields are represented by the numeric codes 7, 8, and 9. After selecting F7 - Def Codes the following box will appear.

+------Select Field------+
¦  7 - UserDef1          ¦
¦  8 - UserDef2          ¦
¦  9 - UserDef3          ¦
+------------------------+

Selecting "7", "8", or "9" will allow you to choose which user defined field you will associate with that code.

+- User Defined Fields -+
¦  1 - User Def 1 Title ¦
¦  2 - User Def 2 Title ¦
¦  3 - User Def 3 Title ¦
¦  4 - User Def 4 Title ¦
¦  5 - User Def 5 Title ¦
+-----------------------+

For Example, if you wanted AIG Code #8 to transfer information from User Defined Field #2 you would Hit [F7], then select "8", and then select "2" for User Defined field #2.

Technical Note: Not all fields have valid information for all transactions types. If you specify a field that is not defined for a particular transaction type, the field will be blank for that type of transaction. (For example, entering "55555" for the reference field would result in a blank reference field because there is no check number associated with the transaction when you enter an invoice.)

Contact Information:
Email Sales
Email Support
11020 Audelia Rd., Suite C109
Dallas, TX 75243
Phone:
214-342-3939
Toll Free:
800-289-4626
Fax:
214-342-2929