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:

Opportunity Management

Administration and permissions

Project management

Integration to Power BI, Power Apps, Power Automate and Dataverse

Inventory and warehouse management

Purchasing

Reports and Business Intelligence

Integration with Dynamics 365 products

Financial Management

Service management

All responses (7)

Answers (0)

tanya07 1,535 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 64,622 Super User 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,775 Super User 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 5,353 Super User 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 154 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!