Could you help me to see inventory availability by its variants vs location?
Thank you in advance.
Where do you want to see it (page, report, external by CU)?
In any cases - you need to see all data in the table 32 (Item Ledger Entry).
P.S. But if you need Bin, then warehouse entry only.
From wherever its possible. On Item Ledger Entry table, Item and its location can be seen, but variants are lacking. I want to know available amount of each variants which are registered in one item code ( as one item) by location.
The field 5402 "Variant Code" (Code 10) here from version 3.60 or 3.70 (I don't remember now).
Use the dataset sequance: Item->ItemVariant->Locaion