Hi Dhiraj,

I did a test in sample data. In order for COGS account to show up in Customer Inquiry, the actual transaction needs to have the COGS account on it.  See below example from my test from sample data:

Have you checked for your invoice, IN00121039, do you see the COGS account on the actual transaction? 

Thank you

WTang

Sage Support 

Hi Wendy,

Thank you for your response.

Please note that invoicing is done through the OE Module in Sage 300 and then upon invoice posting in OE Module, we process day end and a AR Invoice Batch is created. However, in the AR Invoice batch, only the sales GL Account is picked:

Any further recommendations on this?

Hi Dhiraj

For the GL accounts to be used in OE invoice, it usually depends on the items. In this case, I would recommend you to give us a call ( Sage 300 support) at 1-800-253-1372 so that we can review your data and your setup to see what's going on. 

Thank you

Wendy 

I don't know if this has changed - have you upgraded to a new version recently? In version 2025, AR invoices originating from OE are created using AR's "inline" sales/COGS/inventory tracking, where the sales and COGS amounts are embedded in a single AR detail line:

If you're reporting on the AR invoice details, you will need to pull the sales and cost amounts from the separate fields on the same detail line, rather than as separate detail lines. Or better yet, base your reporting on the OE sales history tables.

The behavior where AR Invoice details are generated based on consolidated amounts posted to the revenue, shipment clearing, and COGS accounts, is only applicable when no detail-level optional fields are present.

When optional fields are specified at the detail level, the system adopts a new method that maintains a one-to-one mapping between AR and OE details. This ensures that the optional field values are preserved consistently from Order Entry (OE) through to the General Ledger (GL).

We had a look at the data in the above example and two optional fields were introduced in Jan 2025 when the change in behavior occurred.