Customer Reports

SUGGESTED

I have very limited experience using this program and have a very basic question.

We have two types of customers, COD and account customers. We would like to be able to run reports for sales from both groups separately. 

What is the best way to differentiate the two types when creating the customers?

How do I run a report that would only include sales totals from one customer type.

Thanks for any help I can get on this!

Stacey

  • 0
    SUGGESTED

    You could set up different nominals for COD and account customers, e.g. nominal 4000 for COD customers and nominal 4001 for account customers. If you already further subcategorise your sales, you could have a range of different nominals for COD and account customers, e.g. 4000-4005 for COD customers and 4006-4100 for account customers. 

  • 0
    SUGGESTED

    Hi Cacf Accounting.

    Thanks for using Sage City. 

    Lowri is correct you could have a nominal for each Sales Type for customers but if you have lots of these you may end up with lots of nominal codes under Sales, So you could also use the departments option so everything goes to your standard sales nominal but the customers all have departments so when raising this can be set per customer. 

    I have also seen people use the spare analysis codes in Customers > Defaults Tab and in each customer put the type of customer they are and we can then filter the customer list by this so then when we run reports only this "Filtered" type of customers show.  

    If this has answered your question please click More > Verify Answer.

    Regards,

    Michael
    Sage UKI

  • 0 in reply to Lowri

    Excellent thanks, that hadn't occurred to me but does exactly what we want it to do. And since you seem to have a vast knowledge of this program maybe you can also answer another question.  I am creating for the first time an inventory and vendor item lists. It appears I am doing something wrong, however. I can add the item number and description on the invoice  but it does not store this information. I have also  gone to maintenance then inventory & service as recommended in the help topics and can't seem to add the info there either. Any advice you can give would be greatly appreciated.