Setting the AR GL account by sales order type

Modified on Tue, 11 Jul 2023 11:56 by Freddy Donovan Categorized as Accounts Receivable , Order Entry

{TOC}

===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. 


[imageauto||{UP}/Accounts Receivable/SOTYPE2_ARGLACCT.png]




===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. Warehouse Maintenance - Invoice AR Account (if an entry exists for the matched warehouse, it will override the CID Maintenance account)

2. SO Type Overflow rule - AR GL account (if it exists, it will override the CID AR default and the Warehouse Invoice AR account)

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.

6. POS Cash Accounts (POSACCT) Rule - The AR GL Account (text3) will override all of the above levels. It is intended '''ONLY''' for use with the insufficient funds (NSF) cash code type.

Meta Keywords:
Meta Description:
Change Comment:

Desktop Adjutant

Navigation¶

Setting the AR GL account by sales order type