GL Account extraction

(0) Share

Report

Posted on by Romryan

Hi Guys,

I need to retrieve the GL account that is assigned to Gen. Prod. Posting Group of an Item such that when I pick Item, Fixed asset or Charge(Item) when entering a Purchase Invoice, I should get the GL account on Purch. Account.

How should I do achieve this AL or C/AL?

Kindly assist.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

darcnus 247 on at

Like (0)

Report
Copy link

Link copied!

I don't fully follow what you're asking - can you rephrase the questions?

If you are looking to change which G/L your purchases map to, that would be under General Posting Setup or General Ledger Setup.

docs.microsoft.com/.../finance-posting-groups

If you are looking to default to the GPPG, you can set that on individual items and charges as well.

Please reply and clarify if that doesn't answer your question.

Was this reply helpful? Yes No
Suggested answer

JAngle 135 on at

Like (0)

Report
Copy link

Link copied!

You will need a case statement and then go to the relevant setup table with a GET or setrange and findfirst. Something like:

Case SalesLine.Type Of

SalesLine.Type::Item:

Begin

<code to get setup data>

End;

Etc.

You will need variables for the setup tables. It will be based on posting groups so use the line data for that. You could do it as a calculated field page instead of being on the table unless you need it for reporting. Another pattern would be a flowfield. For either method here are some handy resources:

www.hougaard.com/.../

www.hougaard.com/.../

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Romryan,

If I am following your question, you want to make sure every time that you enter/create a Purchase Invoice for an Item, Fixed Asset, or Charge(Item) the General Posting Setup/Purchasing Account is posted too. I will use the following as an example to explain the setup:

In my screenshot above I show that when I enter a Purchase Invoice and the Vendor is Gen. Business Posting Group = DOMESTIC, an enter any Gen. Prod. Posting Group classification, my Purchase Account will = 54100, except GPPG = Raw Mat. If my Ge. Bus. Posting Group = EU then my Purchase Account = 54200, except GPPG = Raw Mat.

As for Fixed Assets, when you select Type = Fixed Assets, on the Purchase Invoice Line, the entry does not pass through the Purchase Account but post to the FA Posting Group GL Account.

As for the Charge(Item), this will follow the same logic as the Item, except that the Item Charge/GPPG value, which in my example = Services, will produce the Purchase Account = 54100.

I hope the above setups explain how the Posted Purchase Invoice transaction will post to the Purchase Account for Item and Charge(Item) via the General Posting Setup (GBPG and GPPG) combination. If my understanding of your question is not correct, maybe you can write back an example.

Thanks,

Steve

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report
Copy link

Link copied!

Josh,

I have reached here as per below,

If Type = Type::Item then

Itm.Get("No.");

PstGrp := Itm."Gen. Prod. Posting Group";

Any insight on how I can now get the GL account attached to the items?

Was this reply helpful? Yes No
Suggested answer

JAngle 135 on at

Like (0)

Report
Copy link

Link copied!
field(GLAccount; GetGLAccount()) { ApplicationArea = All; Caption = 'G/L Account from Posting Group'; } } } local procedure GetGLAccount(): Code[20] var GLPostingSetup: Record "General Posting Setup"; FAPostingGroup: Record "FA Posting Group"; FA: Record "Fixed Asset"; begin case Rec.Type of Rec.Type::Item: begin If GLPostingSetup.Get(Rec."Gen. Bus. Posting Group", Rec."Gen. Prod. Posting Group") then exit(GLPostingSetup."Purch. Account"); end; Rec.Type::Resource: begin If GLPostingSetup.Get(Rec."Gen. Bus. Posting Group", Rec."Gen. Prod. Posting Group") then exit(GLPostingSetup."Purch. Account"); end; Rec.Type::"Charge (Item)": begin If GLPostingSetup.Get(Rec."Gen. Bus. Posting Group", Rec."Gen. Prod. Posting Group") then exit(GLPostingSetup."Purch. Account"); end; Rec.Type::"Fixed Asset": begin If FA.Get(Rec."No.") then if FAPostingGroup.get(FA."FA Posting Group") then exit(FAPostingGroup."Acquisition Cost Account"); end; end; end;

This is more like what you need. Most of the data is already present on the line table you just have to present it to the user. I would probably add an editable = false property just in case too. Please consider this is on the page only so you can't run a table query and get the result.

If this answers your question please verify so others using the forum know.

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report
Copy link

Link copied!

Thank you so much Josh. I really appreciate.

Was this reply helpful? Yes No