479
I am getting this error after trying to changing a field value if a condition is met. I am doing this in a report extension to try and change a column value to either '' or 'Paid' depending on if the Remaining Amount == 0.
Here is what I have in my report extension:
Hi,
Whenever you get the error with the message "Identification fields and values", you will see that it also asking you put the values in that particular field, like in this message its "No.", so its a No. field's value you have provide of that "Sales Invoice Header" table.
"YourSalesInvheader" means you have you put the No. field's value of the sales invoice header table.
Thanks.
Just a quick question for future reference. What do I do with the "Identification fields and values" that are given in the error. Does that mean I have to include that in get()? Also what would I even put for "yoursalesinvheader" like you mentioned in this response?
You can try to complete these short course
https://docs.microsoft.com/en-us/learn/modules/intro-basics-al-programming/
Hi jdrco ,
Please follow the below steps.
Declare global variable.
Declare above variable as column in Head Data item
Put the login on AfterGetrecord trigger
After doing above changes, show this column as a text in the report and publish the app and then run the report.
Thanks for responding.
Right now I am working on a report extension, and I want to add a column that changes depending on the value of "Remaining Amount" on the Invoice.
I want this column field to display "Paid" when the "Remaining Amount" on the invoice is 0 and if it isn't 0 then just display an empty string on the report.
I tried adding a custom field called 'PAID' using a table and page extension (extends the Sales Header and Sales Invoice), and modifying the value of the field using the method above (Head.Paid := 0). As you said, this won't be accepted by the system, so is there another way of doing this without using the .rdlc format layout? (Just AL programming)
Hi jdrco,
Can you please elaborate your requirement more? I am not sure what you want to achieve
Thanks.
Hi jdrco ,
I see your code, there are bit changes you have to do, I also checked that you are trying to modify Sales Invoice header field in Report extension which system will not permit you to do that, Instead you have to find other way to accomplish you task. by the way there are bit changes in the code you have to do.
head.get(yoursalesinvheader."No.");
Head.calcfields("Remaining Amount");
if head."Remaining Amount = 0 then
head.paid := 'Paid'; // You can not modify Posted data.
Thanks.
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
Share
Report
All responses (
Answers (