Page History: Setting the AR GL account by sales order type
Compare Page Revisions
Page Revision: Wed, 25 Sep 2019 09:18
General Information
Default Menu Location Maintain >> System >> Rule Maintenance
Function The accounts receivable (AR) GL account used during the invoicing/shipping process and the point-of-sale (POS) can be established based on the sales order type. To utilize this feature, you need to update the Sales Order Type Overflow rule with the sales order type(s) and AR GL accounts you want to post against. Once the rule is updated properly, all orders with a matching SO Type will post the AR amounts to the specified GL account.
Rule Setup – Sales Order Type Overflow Rule
The Sales Order Type Overflow Rule Maintenance record may need to be updated to include the AR GL Account field. Contact your implementation consultant if you need any assistance with this step, or if the rule does not exist in your system.
Add a Rule Maintenance detail record for the desired sales order type with the AR GL account. The SO TYpe Code must match the single letter SO Type Code from the Sales Order Type rule. The AR GL Account must be a valid GL account.
AR GL Account Hierarchy
The invoicing process will determine the AR GL account to use in the following order:
1. CID Maintenance - Accounts Tab - Accounts Receivable field GL account
2. SO Type Overflow rule - AR GL account (if it exists, it will override the CID AR default)
3. Customer BillTo record - AR account (if it exists, it will override all other defaults)
The POS process will determine the AR GL account to use in the following order:
1. CID Maintenance - Accounts Tab - Accounts Receivable field GL account
2. SO Type Overflow rule - AR GL account (if it exists, it will override the CID AR default)
3. Customer BillTo record - AR account (if it exists, it will override all other defaults)
4. CID Maintenance - Accounts Tab - POS AR field GL account (if it exists, it is considered a global override, and will override all of the above)
5. Warehouse Maintenance - Accounts Tab - POS AR field GL account will override all of the above if the Sales Order header warehouse matches a warehouse with an entry in the POS AR field.