Sales file layouts can vary widely because of royalty requirements and what your accounting software, distributor or retailers provide. Many files can be imported as is while others need to be slightly modified.
You may have one sales file layout for source file 1 and a different sales file layout for source file 2.
Example 1: A simple sales file where returns quantity and amounts are negative numbers.
In the table above the entry type field is not required because the returns quantity and returns amount are negative numbers.If no entry type is indicated positive values are imported as sales, negative values are imported as returns.
Example 2: A sales file where the returns quantity is positive and the returns amount is negative.
The table above includes an entry type of R for the returns because the returns quantity is positive. The R was added using an excel formula in the entry type column. The formula is =IF([SaleAmount cell]<0,”R”,””). If the SaleAmount is less than zero the value is R, otherwise the the value is empty.
During the import process you tell the software how to handle entries marked as “Returns.”
Example 3: A sales file that includes the customer’s country.
If royalty rates are based on territory; i.e. 50% of the standard royalty on sales to customers outside the United States, you need to include the territory in the sales file.
Customer and Sale Date
If the source file does not contain a column for customer or sale date these fields can be populated in the import mapping screen.
Values in the “or use this value:” column will be applied to all sales records in the import file.
The software calculates the discount rate for the sale based on the retail price, quantity and total sale amount. If the import file does not contain the retail price the software will used the retail price stored in the edition record to calculate the discount.