Adding a Invoice with COGM column

[Former Member]

Hi,

I am trying to add invoice records with COGM column using SAP Business One DI API. However, I am not sure where the corresponding column to COGM resides in SAP Buisness One Database. I know that COGM is a calculated value that should be stored somewhere in some table in SAP Business One Database, but i don't know where.

Any help is greatly appreciated.

Thank you in advance,

Sunny

[richardduffy · Accepted solution]

Sunny,

in SAP Business One you can switch on the Debug view and then when you hover over a field on a B1 form it will give you the Table and Field name in the status bar

[Former Member · Accepted solution]

Richard,

I did that earlier but because it is a derived field from some calculation somewhere. The value showed when I hovered the mouse over was "[Form = 133 Item = 38 Column = 37 Row =1 Variable = 56]"

Sunny

[Former Member · Accepted solution]

Hi Sunny

Itlooks like it is stored in INV1.GrossBuyPr

Hope it helps,

Adele

[Former Member · Accepted solution]

Adele,

Thnak you for your answer. But I am wondering if you also know what is GrossBuyPr in Document_Lines Object for INV1 (in the DIAPI).

I appreciate your help.

Sunny