3,027
Hi
I am getting the above error in below code
Share
ReportIF "Detailed GST Ledger Entry"."Gen. Bus. Posting Group" = '' THEN BEGIN
IF recLocation.GET("Detailed GST Ledger Entry"."Buyer/Seller Reg. No.") THEN
CName := recLocation.Code;
END;
Thanks
*This post is locked for comments
Has this query got any relation with your recent post of "Buyer Seller State Code in Detailed GST Ledger Entry"?
If so, please use the same thread, instead of multiple questions on the same.
You need to write following code for getting location name. You are passing the wrong field.
IF "Detailed GST Ledger Entry"."Gen. Bus. Posting Group" = '' THEN BEGIN
IF recLocation.GET("Detailed GST Ledger Entry"."Location Code") THEN
CName := recLocation.Code;
END;
The recLocation.GET uses the Primary Key of the Location table, which is 10 characters in length. Your "Detailed GST Ledger Entry"."Buyer/Seller Reg. No." is more than 10 characters, so it's causing the error.
As mentioned by Marcell, do you think "Buyer/Seller Reg. No." stores the Location Code?
Hi Jsshivalik,
I think your problem is with the recLocation.GET because the application is expecting a maximum 10 characters long Location Code and the Detailed GST Ledger Entry"."Buyer/Seller Reg. No." is 15 characters long.
Are you sure this code is going to get you a location?
Check this msdn article about GET: msdn.microsoft.com/.../dd301056(v=nav.90).aspx it's expecting values stored in the primary key fields.
Also you should turn on the debugger and execute your code, it will help you pinpoint the problem.
What is the length of variable CName?
If it is 10 then increase to equal the length of location code.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
