Hi, I am trying to update my test DB with live. There are few items created after I copied the test DB.
I want to import all those items to my test. I have data port from item table.
I exported item as text file from live using a dataport
I am trying to import the same item using the same data port in the test, but showing below error while importing:
'This No. is used as Barcodes for Item .'
There are no barcodes with that item number. Is there any other solution for this?.
,Abdul.
*This post is locked for comments
okay, thank you.
Hi,
The change you have made is correct.
Hi Mahesh,
I already ran it using debug itself and got to know that there is a validation in the item table No. field, which blocks importing. How ever, I had a confusion on the validation code. please see below:
IF Barcode1.GET("No.") THEN;
ERROR(
Text99001525,
FIELDCAPTION("No."),Barcode1.TABLECAPTION,TABLECAPTION,Barcode1."Item No.");
I do not know why they put ';' after IF condition. So it was blocking.
Now I removed that ';' from .GET, now it is imported.
Hope my changes will affect the system table.
Thank you for your advise.
,Abdul
Hi,
This is actually a part of LS Retail integration. This code works correctly.
If you still couldn't find any Barcode with that Item No, perhaps you may debug to check whether the code is executed correctly.
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... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156