Solved

COGS Breakdown Report

  • 10 March 2023
  • 1 reply
  • 156 views

Hi,

 

Do we have a standard or customized report do generate from Acumatica, where we can see the breakdown of the Cost of Goods sold (COGS)?

 

This report needs to have the direct costs (PO cost) and the indirect costs (Freight, Customer duty, SST, Demurrage, etc) separately?

Example : 

 

Or else, is there a way to record the indirect costs (From landed costs) to a separate GL account without including it in the Inventory account?

 

Thanks in advance

 

icon

Best answer by umeshramaswamy82 10 March 2023, 13:28

View original

1 reply

Userlevel 5
Badge

Hi @Firazfaisal164 ,

 

You can explore following options:

  1. If are using non stock items for indirect costs (Freight, Customer duty, SST, Demurrage) on a PO then you can drive those costs as expenses to separate G/L accounts defined on those non stock items.
  2. Or you can define separate Landed Cost codes for each of those indirect costs and define a landed cost account separately for each of them. You can use the same Landed cost G/L account but use different Subaccounts too, as shown below -
  3. You may have to create a GI to get to details of COGS expenses/costs breakdown.

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved