You’re offline. This is a read only version of the page.
Does anybody know how to set the next auto-assigned Inventory Transfer Out number as we have arrived up to number 10000000 and the system will not automatically generate 10000001?
*This post is locked for comments
PONumber created only at stores
the only way from HQ is PO and transfers worksheets
I'm not sure if I made myself clear when initially posting. I am referring to the Store Operations part of Microsoft Dynamics RMS. IS this what you are referring to as well?
you should use manual or automatic first time use RMS,
automatic check the max value then add 1 to get the next PONumber
manual will corrupt your data as you may have different length
The PONumber can be either entered manually or system generated. When I select MAX(PONumber) i get our largerst (alphabetic) number "ZejtinInv46" I am suspecting this is hardcoded! I hope it is not... What could be the case in my opinion is that it is calculating the PONumber based on a combination of fields including the POType.
What do you think?
Yes, PONumber is text,
try
select max(PONumber) from PurchaseOrder
Hi Mohammed,
Thank you for your reply. The PONumber is a text field [nvarchar](20) NOT NULL. I have gone through all the tables and have not found anything relating to the PONumber field
setting this number will need to change your maximum value at PONumber in PurchaseOrder table,
you must care about if you already used those new numbers before
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (