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:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Ariba Mehdi 166 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,873 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RomRyan on at

Like (0)

Report
Copy link

Link copied!

is the below correct?

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

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,304 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RomRyan on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,544 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

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

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

Thanks.

ZHU

Was this reply helpful? Yes No
tanya07 1,638 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No