OE - Cost of Goods Sold and Sales account by Customer Type 1

[johnhugh]

Hi, Is it possible to have different COGS and Sales accounts based on customer types in Accpac 6?
I'm trying to show the margin by customer with GL financial reporter.

 

[ettienne]

No, but you can however change the Category in OE for each line item. The category determines the sales and COS accounts, so if you setup one category per customer then you will get that separation in the GL, but to be honest I think that is a daft idea. Do your sales/margin reporting from OE sales history (OESHDT), all the information is available there. Reports like this should not come from the GL, you are just cluttering the GL with non financial data. Typically you would report sales/margins summarised at a category level from the GL.

 

[johnhugh]

Thanks Ettinne