Small and medium business | Business Central, N...

How to get from Approval Entry Table

(0) Share

Report

Posted on by SammySevens

130

Hi BC Community,

How can I get from Approval Entry Table (454). Its PK is an entry No. which is not referenced (I think) anywhere else. So when I get....I can not find any records.

Any advice would be appreciated, my sample code is below:

trigger OnAfterGetRecord()
            begin
                if purchaseHeader.Get("Purchase Line"."Document Type", "Purchase Line"."Document No.") and (Type = Type::Item) then begin
                    approvalEntry.SetFilter("Document No.", purchaseHeader."No.");
                    if approvalEntry.get(approvalEntry."Entry No.") then
                        if purchaseInvoiceHeader.Get(purchaseHeader."Last Posting No.") then
                            if purchaseInvoiceLine.Get(purchaseInvoiceHeader."No.") then begin
                                purchaseInvoiceLine.Reset();
                                purchaseInvoiceLine.SetRange(purchaseInvoiceLine."Document No.");
                                if purchaseInvoiceLine.FindSet() then begin

                                end;
                            end;
                end
            end;

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to get from Approval Entry Table

Get only works with Primary key and does not findfirst along,

we have FINDFIRST, FINDSET, FINDLAST.

You can follow the below link to understand them better

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-find-method
SammySevens 130 on at

Like (0)

Report

RE: How to get from Approval Entry Table

That's cool, I will try that.

Can I ask, am I able to use GET / FINDFIRST to get records from a table? I am only used to using GET.....i guess there are other methods?
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report
RE: How to get from Approval Entry Table

Hi,

Your declaration of set filters are wrong please try below

trigger OnAfterGetRecord() begin if purchaseHeader.Get("Purchase Line"."Document Type", "Purchase Line"."Document No.") and (Type = Type::Item) then begin approvalEntry.SetFilter("Document No.", purchaseHeader."No."); if approvalEntry.findfirst then if purchaseInvoiceHeader.Get(purchaseHeader."Last Posting No.") then if purchaseInvoiceLine.Get(purchaseInvoiceHeader."No.") then begin purchaseInvoiceLine.Reset(); purchaseInvoiceLine.SetRange(purchaseInvoiceLine."Document No."); if purchaseInvoiceLine.FindSet() then begin end; end; end end;
SammySevens 130 on at

Like (0)

Report

RE: How to get from Approval Entry Table

Hi Nitin,

I am trying to use a GET method on the approval entry table (454). The issue I see is that the PK for approval table is the "entry no", no table I am aware of references this field. So what variable can i put in approvalEntry.GET(). I currently have access to purchase header, purchase line.

Hope that helps to clarify
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to get from Approval Entry Table

Hi,

I am not clear with your requirement what you are trying to achieve, can you please brief it more?