Flexicoder

Recoding Method

New distribution accounts are generated by replacing account segments. For example, the first segment of the sales distribution is to be recoded based on the customer. The segment 100 is assigned to the customer Aaron Fitz Electrical and segment 200 is assigned to the customer Adam Park Resort. When the document is saved, the default sales account of 000-1100-00 will be changed to 100-1100-00 for Aaron Fitz Electrical and 200-1100-00 for Adam Park Resort.

 

When recoding Sales Order Processing documents, multiple distribution accounts can be generated for line specific Replace By options (i.e. Item Number, Item Class, Salesperson, Sales Territory, Location). For example, the third segment of the freight distribution of a Sales Order Processing invoice is being recoded based on the salesperson. The segment 10 is assigned to salesperson Gary Wood and the segment 20 is assigned to Sandra Martinez. Two items are added to an invoice, one where the salesperson is Gary Wood and one where the salesperson is Sandra Martinez. The default freight account of 000-7041-00 is split into 2 distributions; 000-7041-10 and 000-7041-20. The amounts for each of these distributions is proportional to the extended prices of each line item. The total of the 2 distributions is equal to the freight amount.

 

Distribution lines are consolidated if the account and distribution type are the same. For example, if you recode a Sales Order Processing invoice with 3 line items, 3 sales distributions will be generated. If 2 of the accounts recoded are the same, Flexicoder will consolidate to only 2 sales distributions.

 

If the new account generated by the recoding process is not a valid account number, the account will not be changed. The invalid account number will be saved in a table so that it can be reported upon.