You’re offline. This is a read only version of the page.
Currently, I only have access to the Dynamics SL database, and I need to identify the available inventory quantity for each product to calculate the gross margin. I have reviewed the main inventory tables such as ItemSite, INTran, LotSerMst, and other related tables, but I have found discrepancies between the recorded quantities and the transactions. For instance, the quantities in ItemSite.QtyOnHand often do not match the calculations derived from the transactions in INTran.
Additionally, some records in the IN10990_ItemSite table are empty or do not reflect the expected data. Furthermore, the transactions have different TranType values (such as RC, IS, II, etc.), which complicates identifying the inventory movements.
My goal is to calculate the available inventory quantity for each product (InvtID) by site (SiteID), as well as determine the gross margin using the costs (ItemCost) and sales prices (SlsPrc). In which table and field can I find the definitive data for the available inventory quantity for each product, and how can I ensure that I am using the correct information to accurately calculate the gross margin?
Share
Report
All responses (
Answers (