Skip to main content

Accounting Inventory Transactions: Configuration for posting transactions to accounting from inventory & billing

Check and prepare your setup before posting transactions from Inventory & Billing to Accounting

Updated over a month ago

Before posting, please make sure all necessary settings and account numbers are correctly set up to avoid posting errors. There are 6 important steps to complete before you proceed with posting to Accounting.

Step 1: Check Posting Setup

  1. Go to Setup, General Setup, Account No.

  2. Review all GL Account Numbers for:

    • Sales

    • Purchase

    • Cash Sales

  3. Make sure all account numbers are correct.

Step 2: Print Chart of Accounts (from Accounting System)

  1. Open the Accounting System.

  2. Go to Reports, General, Print Chart of Accounts.

  3. Use this chart to confirm the correct account numbers for:

    • Sales

    • Purchase

    • Cash Sales

Step 3: Check Item File Maintenance

  1. Go to Maintenance, Item Maintenance, Item File Maintenance.

  2. Review and ensure the following codes use the correct GL account numbers:

    • Credit Sales Code

    • Cash Sales Code

    • Sales Return Code

    • Purchase Code

    • Purchase Return Code

Step 4: Check Group Maintenance

  1. Go to Miscellaneous Files, Group Maintenance.

  2. Check the following groups:

    • Cr.Sales

    • Cs.Sales

    • Sales Ret.

    • Purchase

    • Purc.Ret.

  3. Ensure each group is linked to the correct account numbers.

Step 5: Preview Before Posting

  1. Go to Post to Accounting, Preview.

  2. Review all account numbers shown in the preview screen.

  3. Confirm they are correct before you post to Accounting.

Step 6: Verify Invoice Details (After Posting)

  1. If you find any issues in the accounting reports, return to the Inventory System.

  2. Go to Customer & Sales, Search Invoice.

  3. Open the invoice and check the GL A/C field in Invoice Details.

  4. Verify that the correct account number is used.

Note: Please ensure to run file organization after done posting to accounting.

Did this answer your question?