By using this website, you agree to our Terms of Use (click here)
im trying to shows sold qty past half a year .
like this one item one line :
Inventory ID | Inventory des | Begin QTY | QTY out
123-XXX 123-XXX 5 3
456-XXX 456-XXX 4 1
789-XXX 789-XXX 5 2
i tried some tables ( like ARtran , ARinvoice ,initemsitehit ), but seems not currect
also PX.Objects.IN.InventoryTranHistEnqResult ,but yeah that table seems can be use .
If you're looking for Inventory movements, try INSiteStatus.
Royce ,
Thank you for reply , but i need filter a period sold qty for my item ,
the relations i tried
inventory | left |ARtran like this
results grid is
ARTran >>>>>QTY
but ARtran . qty and item status . Qty avail was wrong cuz they're duplicate ,
like this
i hope them can shows like
QTY Avail : 7
QTY : 13
whats realation do i need ?
Thnak you
Build your query table by table and check the results at each step.
Don't group/aggregate anything until you get the correct data.
I suspect you have multiple rows in both INSiteStatus and INItemCost for one row in InventoryItem - you are therefore creating a cartesian product.
this is my inventory relations between INitemcost and INSitesStatus
what did i miss somthing ?.....
wanna shows this qty out . but the InventoryTranHistEnqResult table seems doesnt work in acumatica ,what do i use other table replace it ?
You cannot access InventoryTransHistEnq* tables in GI, they are application tables, not data tables.
All I can say is that if you are getting duplicated data in your results, make sure you don't have any grouping or aggregates enabled and build the query table by table to see where the duplicates are coming from.
Thanks For reply
when i didnt grouping the data was perfect , but when i grouping ,the last cost value was qrong became to double
how do i let the last cost be double value ?
when i didnt grouping the data was perfect , but when i grouping ,the last cost value was qrong became to double
So doesn't that suggest that your grouping conditions are wrong?
You could always cheat and enter Max in the Aggregate Function column.
If you have multiple locations, I believe that will create 2 entries into InSiteStatus. You would have to add a line to your join (or condition) that restricts to a single location.
Thank you ,i followed ryan's way to max their qty ,and made condition for it , but always shows recored products , how can shows unrecored products ?
like those records
Do you want to show zero for the blank rows?