@royce-lithgo Thank you Royce!! Its makes it more complete!

@shawn-slavin thank you Shawn , thats make sense !!i will try this way 😀 😀

@nicholas-smith thanks for reply, i add a condition for this situation , like this and worked

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 ?...

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 l...

wanna shows this qty out . but the InventoryTranHistEnqResult table seems doesnt work in acumatica ,what do i use other table replace it ?

this is my inventory relations between INitemcost and INSitesStatus what did i miss somthing ?.....

Royce ,Thank you for reply , but i need filter a period sold qty for my item ,the relations i triedinventory | left |ARtran like this results...

hi tim thank you you replied me , but i cant findding that buttons ,would you tell me how to do that ?

Hi Tim ,Im just a beginner,this discussion is so helpful to me .follow your step ,but my Generic inquiry doesnt have Suggest bottom , Suggest bottom i...