cancel
Showing results for 
Search instead for 
Did you mean: 

COGS Allocation

0 Kudos

Hi,

I don't know is this is possible.

We have different Sales types: Vans and Trucks, Aftersales and Services, Parts.

Each of these has their own Sales Account.

However when the inventory used on any sale is processed to recognise the COGS cost, it all goes into the 1 COGS account (2710).

Is there a way (other than using department codes) to do the following rule:

SALE TYPE SALE GL COGS GL

Van/truck 2300 2710

Aftersales/Service 2400 2715

Parts 2500 2720

Thanks

Matt

Accepted Solutions (0)

Answers (1)

Answers (1)

agustin_marcoscividanes
Active Contributor
0 Kudos

Hi

by default, you can assign a cost center to sales or purchase accounts, not inventory.

If you want to do this, you have to overwrite the behavior of SBO. Before doing anything, list all cases you can find and elaborate a solution for each case: you have to check the journal entry in SBO and compare with the one you expect.

When you have done, you can evaluate the solution. SBO generates one line for the inventory account, and if you have several COGS in sales, you have to separate the amounts. Try to manage items accounts by item groups, and check the journal entry.

Kind regards

Agustín