Is it possible to record a sales analysis code or category per line item in a sales transaction?
My Reasoning:
The line item on my sales invoice may be "Labour Jim" this reports to my GL Code Labour. But I also want to break it down so I can see what kinds of job it was e.g. Labour Jim (Inventory) and Hot Water Unit Replacement (Category) or Blocked Drain (Category).
The Categories and Sales Person features that currently exist only allow me to record one per transaction so when I run a report on categories I see the whole sale and not just the one line item that may be applicable e.g. I don't want my 'Callout' inventory item linked to my 'Hot Water Replacement' category.
Does that make senses...
So, if on each line item I could record a cetegory I would be able to use the category report to further break down my Profit and Loss report and see what categories are making money.
P.s. I don't want to have to setup a new inventory item for every fieldworker (Jim) and every category
P.p.s. I already use jobs for tracking jobs so this won't work either.
Hi,
Ordinarily I would say Jobs is what you should be using to be able to break down each transaction to different components.
With Jobs you can allocate at the line item level to different Jobs, however with Categiroes Only one can be added to each transaction. I would not think that Catgories is the way to go to identify things like Call out v Hot water replacement. Categories are more designed to keep track of different Branches or divisions in a business.
You say you are already using Jobs. Other ways of breaking up the info by jobs into more detail are:
- Use Activity Slips/Time billing to capture both the person performing the task and what Activity they are doing. These can then be allocated to a job.
- Use Items to Track what work is being done so an Item for Callout , and one for HW replacement. Then you can analyse by Job broken down to the different Income compontents. It sounds like you are using Items to also track the person doing the work? Maybe use SAlesperson for the worker?
- Use Sub jobs - eg Job Header is for the House build and then have a number of sub jobs under each header Good if you have a smaller number of jobs with a number of segments.
- Use GL to break ups each Job by different components - So if you have say 10 different "types of work" then you could have a Labour GL account down at that level e.g. Callout , HW replacement. then allocate each line to that GL account and allocate to the job. you can then do a JOb P&L that breaks down to that level.
Deciding which is the best for you will depend on the type of jobs you have e.g. small number of large complex jobs, or a large number of small jobs for a large number of clients. Your MYOB CC will be able to help you work this out.
Reporting?
The other issues is it is fine to do all this work to capture this level of detail however how do you then want to report on it? Combining all of these different elements and getting flexible reports out of standard MYOB can sometimes be a challenge.
There are a number of Add-on solution that can help you if you choose any of the above options to get really flexible reports by JOb Header, JOb Customer, by Activity Slip, by Category etc.
See http://myob.com.au/addons/category/3/advanced-reporting/
If you would like to know more about some advanced reporting options for MYOB let me know.
Jennifer Kelly CA
Business Intelligence for MYOB
02 8912 4120
