By using this website, you agree to our Terms of Use (click here)
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?
The report I created is Sales Profitability by Customer Class and Item
Trying to display shipped quantity for item of a particular Customer class
For profitability, I would do this off of ARTran.
Actually, there are a few reports available in the Accounts Receivable module that do just that.
Yes, But I am trying to create a new profitability report by Customer Class and Item. I want to display the quantities shipped for a Particular item of a Customer Class as in this screenshot
But in this report that I made the quantities column is not showing desired values
Is there any reason why you want "shipped quantities" instead of "invoiced quantities?
Aren't they same? shipped quantities and invoiced quantities?
Because whatever gets shipped will be invoiced
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
I would think that they should be the same, but I'd want to do some validation like you are doing.
Are you using ARTran.Qty?
It might have something to do with Unit of Measure. You might try ARTran.BaseQty.
Yes I am using ARTran.Qty.
I tried using ARTran.BaseQty but it didn't show any difference
I think it is something to do with the table relationships in the schema builder
What should be the relationship between Customer and InventoryItem table in this case?
Ya, that relationship definitely isn't right. But I wouldn't actually do the relationship between Customer and InventoryItem. Shouldn't it be between ARTran and InventoryItem?
Where are you getting the quantity of 38 from?
The quantity 38 is for the items with customer class SP
Ah, looks like that field is actually SO Order Type. Are you sure that every customer with a Customer Class of "SP" is using an SO Order Type of "SP"?
Yes,
It worked after changing the Group Collection in the Report designer
The mapping wasn't right before
Online Members
