Skip to main content
Answer

Control COGS (Cost of Goods) GL Account by customer

  • November 11, 2025
  • 2 replies
  • 22 views
debbiereed72
Varsity I
Forum|alt.badge.img

I have found many entries related to this same topic, but no “simple” solution.  Depending on type of sale (which is based on the customer), I need a different COGS account than the standard one on the Item. I’ve looked at using Reason Codes, looked at the Order Types, Posting Classes.. none of these appear to have a way of controlling the COGS account.  There is only the COGS on the Posting Class or Item.  But we need to sell the item in different scenarios and need a different COGS account (we can control the sales account but not cogs).  Any ideas besides customizations, GI’s to give data for users to generate GL entries to reclass…?

Thank you!

 

Best answer by debbiereed72

Hi ​@nickcerri32 thank you for taking the time to respond.  I think I’ve come up with a reasonable solution.

This particular scenario is for Intercompany Sales, where the other companies are not in the shared tenant so intercompany features are not useful.  The plan:

Create an intercompany warehouse. When the sale is for an intercompany transaction, transfer the item(s) to the intercompany warehouse and sell from there.

On the Posting Class, set the COGS account to use the Warehouse.

 

Fortunately, in this client’s case, they do just a handful of intercompany per month, so this seems to be an acceptable solution.

Debbie Reed, W.M. Synergy

2 replies

nickcerri32
Jr Varsity III
Forum|alt.badge.img+1
  • nickcerri32
  • Jr Varsity III
  • November 11, 2025

​@debbiereed72 - That’s a tricky one!  Short of using GI’s, Business Events, UDFs, etc., what about creating duplicates of the items with different suffices (Formatted as [Part#][Account] or something like that) that you can set as related items and select based on the customer?  I know this isn’t ideal, but it may work with the constraints you have.  

Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
debbiereed72
Varsity I
Forum|alt.badge.img
  • debbiereed72
  • Author
  • Varsity I
  • Answer
  • November 11, 2025

Hi ​@nickcerri32 thank you for taking the time to respond.  I think I’ve come up with a reasonable solution.

This particular scenario is for Intercompany Sales, where the other companies are not in the shared tenant so intercompany features are not useful.  The plan:

Create an intercompany warehouse. When the sale is for an intercompany transaction, transfer the item(s) to the intercompany warehouse and sell from there.

On the Posting Class, set the COGS account to use the Warehouse.

 

Fortunately, in this client’s case, they do just a handful of intercompany per month, so this seems to be an acceptable solution.

Debbie Reed, W.M. Synergy
Chris Hackett
nickcerri32
Terms & ConditionsCookie settingsAccessibility statement
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