Recreating an inventory history
Ken Temkin
Customer has asked me to develop a report that will recreate their inventory history in a specialized format.
Can someone critique my logic?
For any item, its inventory history is the sum of:
1) from the Account.OrderLine control, the quantity from the [checkedin] field with a datetime of the [timestamp] field, taken as a positive number.
2) from the Account.SaleLine control, the quantity from the [unitquantity] field with a datetime of the [timestamp] field, taken as a negative number.
3) from the Account.InventoryCountReconcile control, the quantity from the [qohchange] field with a datetime of the [createTime] field, taken as it exists in the field, either positive or negative.
So, for any item, I would have a transactional history with quantities and datetimes.
dan.s...@lightspeedretail.com
You should also consider updates to ItemShops in the Account.Item control for manual adjustments to inventory, breaking down boxes of items into singles (if they are using those), and I'm sure other miscellaneous adjustments. You will need to load the relation for ItemShops and somehow account for the new [qoh] value being compared to the previous value, if you need to show a difference.
There may be other situations I'm not recalling, but if you have access to a Cloud account you should definitely do some testing and see what kind of entries you see in the History tab for items and get an idea of what areas of the API you need to look at for those. Some aren't recorded nicely like you are seeing in Account.OrderLine/SaleLine, but rather just change the ItemShop entry directly.
Hope this helps!
