How to Add or Modify a Distribution Code in Accounts Receivable for Sage 300
Before You Start
- Decide on the distribution codes to use.
- If you are adding a new distribution code, determine the general ledger accounts to assign to it.
(If necessary, add the general ledger accounts you want to assign.)
You assign the following general ledger accounts to distribution codes:- Revenue.
- Inventory (used only with an item list).
- Cost of goods sold (used only with an item list).
- If you are deleting a distribution code:
- Make sure the code is not assigned to any item records. (You cannot delete a
distribution code if it is assigned to any items.) - Post any outstanding batches containing transactions that use the code you want to
delete. Although you can post these batches later, you must enter a new code.
- Make sure the code is not assigned to any item records. (You cannot delete a
To add a distribution code:
- Open Accounts Receivable > A/R Setup > Distribution Codes.
- In the Distribution Code field, enter a new distribution code.
- In the Description field, enter a description of the code.
- In the General Ledger Account fields, enter the account numbers to which to post transactions that use the distribution code.
If you do not use items in Accounts Receivable, enter the number for the revenue account only.
If you plan to use the distribution code with an item list, you must enter numbers for all three accounts.
If you use Sage 300General Ledger with your Accounts Receivable database, you can click the Finder or press F5 to display a list of general ledger account numbers. Highlight the account you want, then press Enter to insert it in a field. - Specify a default discount status for the distribution code.
Your choice for the distribution code appears as the default discount status when you use the distribution code in an invoice, credit note, debit note, or recurring charge detail. - Click Add.
To edit a distribution code:
- Open Accounts Receivable > A/R Setup > Distribution Codes.
- Enter the distribution code you want to change.
- Make your changes.
Notes:- If you make a distribution code inactive, you can no longer assign it to items or use it in summary invoices.
- Changing the general ledger account numbers assigned to a distribution code has no effect on existing transactions that use the distribution code. If you want to use the new account numbers with the transactions, you must edit the documents to enter the new account numbers.
- Click Save.
To delete a distribution code:
- Open Accounts Receivable > A/R Setup > Distribution Codes.
- Enter the distribution code you want to delete.
- Click Delete.
After adding or modifying a distribution code
- Print and file the Distribution Codes report. For more information, see “Printing the A/R Distribution Codes Report” (page 328).