I want to update hundreds of ItemCodes (In OITM Table) to new ItemCodes.
I know this can be done manually. Is there any way to do this via B1Tech Ver 2007?
Testing on a single Item using this code in B1Tech:
I get a -5002 error message in B1Tech.
1. Does any one know what this error message means?
2. Did any one try changing hundreds of Itemcodes via B1Tech and has the correct syntax for this?
3. Is there any other better way to change ItemCodes using other tools (DTW, est.)?
please refer below Notes
1 . 1303019 DI_Cannot add an invoice with Withholding Tax data
2 . 1336306 LOC_CEE_DI_Cannot copy FC Invoice to Correction Invoice
3 . 1281188 DI_Can't add DPM, error DPM sum cannot be greater than total
4 . 1286672 DI_Cannot add Correction Invoice for item with no warehouse
5 . 1262795 DI_Cannot create document with batches and serial numbers
Apologies as I am not sure what "B1Tech" is. I am assuming that this is a tool similar to the DTW for data import and/or update into SAP Business One.
With respect to the Item Master, if you have an item that has transactions on file for that item, you cannot make a change to the ItemCode. The system prevents this until all transactions are reversed or removed. This is also the case if you try to change the item code via the Business One user interface ... you will not be allowed.
If you have an item or items that do not have ANY transactions on file, then the system does let you change the ItemCode property. Again, you can test this via the user interface for Business One.
Any application/add-on that uses the DI API will follow the same rules as above with respect to a key property on a master record. The DTW, which uses the DI API, would also error if you tried to update an ItemCode that has transaction on file for it also.
Hope that helps,