My customers no are from 1..50000 in the customer list, how can I add "C" infront of 1 for the exisiting customerrecords up to 50000. I want to do it programmatically by renaming it, the reason, we are merging with the other systems. After renaming the customer no, looks like C1,C2,C3,..C50000. Pls suggest to do it in one go..
*This post is locked for comments
This can be possible in NAV.
Easiest way is to use a process only report to do this so that you do not want to use any repeat commands or do not have to worry about other issues.
Create a new report and in the report properties set it to Process Only to true.
Make the report data item as Customer (18)
And in the body of the report write the following code
Share
Report
All responses (
Answers (
Customer.RENAME('C' + Customer."No.");
This will modify the records without any problem.
Hi Navbsa,
You can use report with a Customer DataItem, and rename Customer No. in OnAfterGetRecord trigger:
IF (COPYSTR("No.", 1, 1) <> 'C') THEN BEGIN
lRec_Customer.GET("No.");
lRec_Customer.RENAME('C' + "No.");
END;
lRec_Customer is a local variable (Customer Record) of OnAfterGetRecord function.
Using report filter, you can process group of customers. In addition, you can set report as ProcessingOnly to increase speed.
Cust.RESET;
IF Cust.FINDSET THEN
REPEAT
Cust2 := Cust;
Cust2.Rename('C' + Cust."No.");
UNTIL Cust.NEXT = 0;
Please try it in Test database first after taking backup
it's done by c/al command RENAME.
msdn.microsoft.com/.../dd355313.aspx
sample code for one record:
customer.GET('10000');
customer.RENAME('C10000');
place the code in a loop (repeat until, while do end, ...)
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156