55
Hi All,
I am very new to RMS and I need some help
I am doing some RMS reports accessing the tables from the SQL server
What I need to know is where does RMS store the Date the Item was booked into Inventory when the Item is received from a PO? On the PurchaseOrderEntry table there is a field for the QuantityReceived but where is the Date Received stored?
Any help would be much appreciated
*This post is locked for comments
Hi there.
OK, check the InventoryTransferLog table, link it with the PurchaseOrderEntry table by:
- the field ReferenceID is the ID of your POrder header;
- the StoreID is obvious (in HQ environment only)
- the ReferenceEntryID field is the PurchaseOrderEntry.ID field
- the ItemID field is the PurchaseOrderEntry.ItemID
- the quantity field is the quantity received
- at the end, the DateTrasffered field is what are you looking for...
Kind regards, A.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (