OE Module

SOLVED

Hello All,

When a shipment is posted in I/C order entry, without creating a corresponding invoice ("create invoice" box is unchecked), the shipment clearing account is debited. When the invoice associated with this shipment is subsequently created, the same shipment clearing account is supposed to be credited, leaving a net zero balance in the shipment clearing account for this order.

I am finding that for the OE-SH transaction Sage 300 is selecting the shipment clearing account associated with the item's "Category Code", "Cost of Goods Sold" Account, and for the OE-IN transaction Sage is selecting the from the "Account Set" Code, "Shipment Clearing" Account.

As a result, the shipment clearing debit entry and credit entry are going to different GL accounts which means the shipment clearing account is not clearing out! Shouldn't shipment and invoice creation reference the same set of accounts, either "Category" or "Account Set", when posting the debit and subsequent credit to the shipment clearing account in order entry? Why is Sage looking to the "Category" set of accounts to select the shipment clearing account for the debit entry (OE-SH) and looking to the "account set" set of accounts to select the credit entry (OE-IN)?