Sales Item Map
For Every Stock item you can choose which account it can post to
if you have ten items on an invoice and 1 sis selected with sales item mapping it will not follow the posting of an invoice but it will follow the setup done on item mapping
This manual shows one how to setup Sales Item Mapping
Go to Debtors Module > Configuration > Add. Debtor Properties
.png)
Click on the tab for Sales Item Map, click on search to check current setup Sales Item Mappings.
.png)
If Mapping does not exist or new one to be created.
Click on the Add button to add a new Sales Item Map
Input the relevant field mappings required
.png)
Field definitions
Select the relevant Invoice group category The Invoice layout shows you which data the system looks at to execute the mapping rule Therefore the result will be as follows You can check in the following places Check the invoice lines and then check on the Sales Item Mapping section to see if you have matches. If not you will need to setup When this occurs one must check the invoice line details If you have amounts in the Revenue – Unallocated GL ledger, it means there are sales mappings missing. Therefore the system will default to the default GL Links setup account. Invoice Group + Service Code = GL Account (Sales Mapping setup) NOTES Once mapping is setup, next import or manual invoice will follow the sales item mapping rule. One will have to clear this account with a General Ledger Journal and allocate the values to the relevant Sales Revenue accounts.
Invoice Group
–
This can also be found under the Invoice Group Tab
Stock Item
– This is the service line item which is show on the lines of the invoice
Sales Account
– Insert the relevant sales ledger account
Once setup the Mappings will appear on the grid.png)
.png)
.png)
Trouble shooting Revenue Unallocated This happens when there is no Sales Item Mapping Link1.
1
Invoice line detail
2
Related transactions
3.
3
Income statement detail lines
Invoice line detail Income statement (Financial Performance) reports Run the report and print to screen Check the detail of the invoices that make up the Revenue – Unallocated by clicking on the name to get the detail. You will now see all the invoices that make up the value of the sales revenue posting. Now click on the Reference line of one of the invoices to see the detail of the invoice Go and check the following information on the invoice Go and check the Sales Item Mapping grid to see if the Map exists, if not create a new one. Existing Revenue – unallocated posting in books One needs to check on a monthly basis that this account does not have any values.