How to validate a batch (Sage 300)

Although the integration program itself performs a number of validations (such as checking to make sure that an account specified on a transaction is an account in Sage 300), it is a good idea to check some of the data to ensure that things have worked reliably.


Invoices

To verify accounts receivable invoices in Sage 300, navigate to Accounts Receivable > Invoice Batch List

Expenses

To verify expenses as accounts payable invoices in Sage 300, navigate to Accounts Payable > Invoice Batch List

Item Receipt

To verify item receipts as AP Batches in Sage 300, navigate to Accounts Payable > Invoice Batch List

Inventory Adjustment

To verify inventory adjustment in Sage 300, navigate to Inventory Control > Adjustments

Inventory Transfers

To verify inventory transfers in Sage 300, navigate to Inventory Control > Transfers

GL Entries

Sage 300 does not support products; so, the integration does not map to Product Types. Instead, there are two General Journal Entry types that these transactions will use:

  1. Manage Item Receipts > Sage A/P Invoice Entry

  2. Manage Invoices > Sage A/R Invoice Entry

These types are mapped to Manage Item Types as follows, and will apply the following transactions:

  1. Manage Inventory

    • Purchase (Item Receipt)

      • Accounts Payable     Credit

      • Inventory         Debit

    • Sale (AR Invoice)

      • *Inventory         Credit

      • *COGS             Debit

      • Revenue         Credit

      • Accounts Receivable     Debit

  2. Manage Non-Inventory, Service, Other Charge (or NULL/Unknown)

    • Purchase (Item Receipt)

      • Accounts Payable     Credit

      • COGS             Debit

    • Sale (AR Invoice)

      • Revenue         Credit

      • Accounts Receivable     Debit

*This transaction is handled by the accounting package directly, not the integration. 


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.