Company, Property and GL code mapping table

Hello,

One of our client use SAGE 300 software. Now they require some custom report. We have develop Income Statement Trial Balance report. All figure are matching except "ELECTRICITY-OFFICE"(account title). The amount is $341.37 now they want to bifurcate this amount into multiple property or company.

Is there any table available for mapping of Company, Property, GL account and Account title?

The amount comes from Company – AGT, Property – AGENTS, GL Account – 60850,

Account Title - ELECTRICITY-OFFICE

Can anybody help me please?

Bhavin Panchal

Parents
  • 0

    More information is needed regarding your client setup and the applications they are using.  

    1. You state "all figures are 'matching' except "Electricity-Office". What is the item to which you are matching? 

    2. Are GL Prefixes used to designate specific properties or companies? If so, provide an example of the full actual GL Posting account.  In your example, is "60850" a Base Account, or is that the full account number?

    3. Did the expense that you wish to bifurcate originate in Accounts Payable from entry of an invoice or from another source, such as a GL Journal Entry?  Invoices entered through AP can be reclassified by using AP > Tasks > Change Invoices.  GL Journal Entries can be modified by using GL > Tasks > Change Entries or by making an additional Journal Entry to reclassify the expense using GL > Tasks > Record Entries.  The preferred method is to always make the change in the same way the entry originated, so if the Electricity Expense was the result of an invoice entered in AP, use Change Invoices to correctly distribute the expense to the various accounts.

    Art Minds

    Pasadena, California

Reply
  • 0

    More information is needed regarding your client setup and the applications they are using.  

    1. You state "all figures are 'matching' except "Electricity-Office". What is the item to which you are matching? 

    2. Are GL Prefixes used to designate specific properties or companies? If so, provide an example of the full actual GL Posting account.  In your example, is "60850" a Base Account, or is that the full account number?

    3. Did the expense that you wish to bifurcate originate in Accounts Payable from entry of an invoice or from another source, such as a GL Journal Entry?  Invoices entered through AP can be reclassified by using AP > Tasks > Change Invoices.  GL Journal Entries can be modified by using GL > Tasks > Change Entries or by making an additional Journal Entry to reclassify the expense using GL > Tasks > Record Entries.  The preferred method is to always make the change in the same way the entry originated, so if the Electricity Expense was the result of an invoice entered in AP, use Change Invoices to correctly distribute the expense to the various accounts.

    Art Minds

    Pasadena, California

Children
No Data