[Question] Implementing Sales or Inventory Codes in Pastel

[Joan]

Hello,

Please can someone help me with a query.

I have been asked by my manager to implement sales codes in Pastel, so that I can give management a monthly report of sales figures for various categories. Having looked at what sales codes are in Pastel and how to set it up, I don't think that's what he is wanting. I think it might be more a case of implementing inventory codes.

Our clients are grouped into categories.
Every invoice we issue is made up of line items which fall under various headings. eg. 01 - Consulting, 02 - Software sales through to 05 Admin. An invoice can have all five of those different headings and he wants me to be able to draw a report at month end to show sales figures of these.

From what I've understood in Pastel invoicing, only one sales code can be allocated to an invoice as this pertains to a sales person.

If I were to create sub headings in my G/L under 1000/000 Sales. eg. 1000/010 - Consulting etc., would that not enable me to draw a broken down report or will that mess up my Income Statement.

Gosh - this seems quite a story.
Hope someone can make sense of what I'm asking.

Look forward to hearing from you.
Thanks and regards
Joan

[Mike C]

Hi Joan. I think that your suggestion sounds very workable. When you create your first sub account, however, the total amount contained in the main account will be moved to the sub-account. That might confuse your stats for the first year unless you make some journal adjustments moving the relevant moneys into their correct sub-accounts.

What you might like to do ... is to make a copy of your present company and experiment in your copy company. That way you won't mess anything up while you test it out.

[Joan]

Hi Mike. Thank you so much for your feedback and suggestions. As soon as I get a gap, I will do what you suggested and experiment in a copy company. I'm sure this will work, going forward.
Thanks again - much appreciated.