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;

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No
SammySevens 130 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report
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;

Was this reply helpful? Yes No
SammySevens 130 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to get from Approval Entry Table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to get from Approval Entry Table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates