Set Up Posting by Division in Sales Order

Home | FAQs & Troubleshooting

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

By using multiple divisions in Accounts Receivable, the customer's division number can determine the account number to use for the Accounts Receivable, Cash Sales, Discounts Allowed, Freight, and Sales Tax account postings. These accounts are maintained in Division Maintenance.

The Sales, Sales Returns, and Cost of Goods Sold accounts numbers used for posting sales are specified in Inventory Management Product Line Maintenance. For miscellaneous charges and items, the account number specified in Miscellaneous Item Maintenance is used. For special items, the account number specified in Sales Order Options is used. The appropriate sub-account (division) specified in Accounts Receivable Division Maintenance is substituted for the division segment.

Use this procedure to set up the system to post Sales, Sales Returns, and Cost of Goods Sold accounts by customer division.

 

To set up posting by division in Sales Order

  1. Select Accounts Receivable Setup menu > Accounts Receivable Options.

  2. Select the Accounts Receivable Divisions check box. For more information, see Accounts Receivable Options - Fields.

  3. At the G/L Segment to Post A/R Sales field, select Department or Location.

  4. The department is the second segment of the account number. For example, ###-##-#### where ## is the department.

  5. The location is the third segment of the account number. For example, ###-##-#### where #### is the location.

  1. Click Accept.

  2. Select Accounts Receivable Setup menu > Division Maintenance.

  3. In the Post to field, enter an alphanumeric value for each division. This value will be substituted into the main account number based on the customer's division. For more information, see Division Maintenance - Fields.

  4. Click Accept.

  5. Select General Ledger Main menu > Account Maintenance.

  6. Create account numbers which include all the segment values. For more information, see Create and Maintain Accounts in Account Maintenance.

  7. Select Sales Order Setup menu > Sales Order Options.

  8. Set the Post Sales to General Ledger by Division to Yes. For more information, see Sales Order Options - Fields.

  9. Click Accept.

The Sales Order module has been set up to post by division.