Using values from InventoryTranHistEnqResult table
How can I use QtyOut values from InventoryTranHistEnqResult table?
Since this table is created specifically for Transaction History page it is not present in the database.
I want to add the QtyOut column to a report in report designer but I am getting error as "Invalid object name 'InventoryTranDetEnqResult'" in the Trace screen.
Is there any other table where the shipped quantities are stored in the database?
I tried using Qty from AR and the report showed these values(36 qty shipped)
Even the net sales are not accurate (the net sales should be 391.4 because the unit price is 10.30)
Whereas it should be 38
Am I missing out something? I thing the tables are not related correctly...it is not able to pull correct item data for a customer class