Hi Josh,
I can fully understand your request however am guessing that the vast majority of businesses will need to record the GL account based on the type of items not customer.
I am guessing you need to split your sales in this manner by the customer type due to different tarrif or alcohol tarif calculations??
Can I suggest that if you report your item sales based on Customer Groupings (using the Customer Custom fields) you would be able to achive the result you are looking for and also still be able to see the Items being bought.
You may need to use one of the Add on Advanced reporting solutions to get exactly what you need, see:
http://myob.com.au/addons/category/3/advanced-reporting/
As an example using Business Intelligence for MYOB, if you were to use a Custome List to allocate each Customer the Customer Type then you would be able to report your P&L in the following collumns for any given date range:
Qty $Sales $COGS $Profit Margin%
- Domestic distributors -
- Export agents
- Drect retail customers
From there you could Filter or drill down to get the break down of Customers and or Items in each grouping Export etc.
I can't add an excel example to this post however you can see in our Online User Help how easy this is to do and the results you could get.
We have a number of Wineries and Acholol distributors using our software to help with their liquor reporting requirements.
I hope this helps, all details are on our website at www.BIforMYOB.com or call on 02 8912 4120.
Jennifer Kelly CA
Business Intelligence for MYOB
Related Content
- 2 months agoAccessSDM
- 10 months agoQiu
- 8 months agogodinez1949
- 2 years agoMicah07