Hi All,
After successful upload/commit of physical stock count figures, my "Physical Inventory Discrepancy Sheet" is Blank in RMS. When I did some checking at the table level, I found value of "PhysicalInventoryId" column in "PhysicalInventoryEntry" table is "0".
Any idea on what could have caused this?
*This post is locked for comments
Hi RKU.
Can You give us more details on the environment? The SQL database is on other machine or it's in local?? If it is like that, what is the Operating Sistem You have on the database machine? Can You make a complete windows update on the PC where you have this problem??
This sometimes happens, in some implementations, where You have multiple RMS HQ / RMS SO Manager users, attacking the database from different machines and not all of the machine are capable of receiving the after-insert returning value, like in this case the ID of the Header table...
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.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156