I am currently developing an application that populates the Inventory Transaction Entry scrolling window with items. The items populate currently but when I go to manually add a line I get the error "you cannot change this item because the information has been saved". Any advice is greatly appreciated.
*This post is locked for comments
Hey Richard,
It seems I can add a record once I focus on the item number and select the look up button of every line. Once I do this I am able to add a record. I guess I am missing running the change script that probably generate the line sequence number. Thanks for all your help
I am inserting data while the Inventory Transfer form is open and there are multiple lines of data. I do not see an extra line being created in SQL after the automatic insert of the lines. This might be a dumb question but could it be a blank item number in the table buffer?
Other than a bit of PHP and a bit of SQL, I retired from programming about 20 years ago with 20 years under my belt by that time. But I always am willing to share what I know....
The Line SEQ number is typically populated with values about 16k apart. The first line is 16,xxx something. Put in a order manually with 3-4 lines and you will see what these values are. This lets a user insert lines between two lines and the sequence numbers do not need to be changed, 27,??? will be used to insert between the first and second original line.
Are you inserting data while the Inventory Transfer form is open? If so, are you inserting multiple lines of data and then refreshing the display? When you complete the import of data and before trying to manually insert any data, leave the windows alone and switch to SQL Server Manager and look at the lines of data in the transfer transaction table for the transaction number you are creating. Are there any lines with blank item numbers? THAT would be a problem.
Hi Richard,
First thank you for replying. What I trying to accomplish with my program is to automatically populate the scrolling window of the Inventory Transfer Form. I successfully populate the scrolling window but when I go to manually add a new item on the next blank line I get that error. I am updating the scrolling window by inserting records into the IV_TRX_WORK_LINE table and filling the scrolling window. I notice if I do not set the Line SEQ Number it defaults to the largest value. I can set the Line SEQ Number but when I do this I am getting the error. Any advise?
Well, the error means that a line has been created and saved and you are trying to change the item number. Is your program adding a line with a blank part number?? It seems to be treating the "blank line" as a saved line.
BTW, just say yes and the system will allow you to change the blank line to a real part number. However, your code's blank line could create other issues when posting ( it is not marked as non-inventory buy it cannot find a matching part number in stock ...)
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
