Inventory Transaction View 1

[zedsded]

Hi Guys,
Macola 7.6.400a - MS SQL
In "Inventory Transaction View" (Screen Name:IMTRXHST), from which table/field does the following field come from?
- Total Cost
- Old Unit Cost

I found where all the other "cost" fields are coming from (i.e., IMNVTRXHST or POORDLINE), but not the two fields above.

Thank you in advance.

 

[dgillz]

The old unit cost is iminvtrx_sql.old_unit_cost.
The total cost is iminvtrx_sql.amount.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[zedsded]

Don,
sorry for the delay on my response. that tip was very helpful. thanks!