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

Purchase Line extension + Posting

(1) Share

Report

Posted on by RomRyan

Dear All,

I have extended purchase line table and added a field that is compulsory. I want if I post my purchase invoice or order, the field will reflect in table Purch. Inv. Line i.e. Posted purchase invoice in the lines and if possible (and no a must) it should hit General ledger the debit account. What should I do? any Idea?

Categories:

Business Central

All responses (7)

Answers (0)

tanya07 1,554 on at

Like (0)

Report

Purchase Line extension + Posting

Hi ,

the new field seems a amount value field where you wish to reflect to the GL acc being hit as a debit amount , am I right ?

BR,

Tanya
Suggested answer

YUN ZHU 73,698 Super User 2024 Season 2 on at

Like (0)

Report

Purchase Line extension + Posting

Hi, hope the following helps.

Dynamics 365 Business Central: How to flow/pass custom field values

https://yzhums.com/4118/#toc1

Thanks.

ZHU
RomRyan on at

Like (0)

Report

Purchase Line extension + Posting

Which objectType, the object it's self and event should I subscribe to make sure my customized field in purchase line is updated/inserted to Purch. Inv. Line? I have tried severally but it's not responding during posting of purchase invoice.
Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

Purchase Line extension + Posting

As long as the field no is the same between the Purchase Line and Purch. Inv. Line table, it will get transferred automatically during posting.

To hit General Ledger, it will be more difficult because you need to transfer it to General Journal Line and then General Ledger Entry.
RomRyan on at

Like (0)

Report

Purchase Line extension + Posting

is the below correct?

[EventSubscriber(ObjectType::Table, Database::"Purch. Inv. Line" , 'OnBeforeInsertEvent', '', true, true)]
Suggested answer

gdrenteria 12,183 Most Valuable Professional on at

Like (0)

Report

Purchase Line extension + Posting

Hi

Here some information, i hope this can help you and give you some hints

Dynamics 365 Business Central: How to flow/pass custom field values | Dynamics 365 Lab (yzhums.com)

Best regards

Gerardo
Ariba Mehdi 160 on at

Like (0)

Report

Purchase Line extension + Posting

Hi there,

Assign the same field ID to your custom field in both tables. Hopefully, it will reflect the values in Posted purchase lines after posting.

Hope it helps!