Record Not getting inserted into table VendInvoiceInfoTable_W

(4) Share

Report

Posted on by TU1506

147

Hi Team,

I am facing one issue: When I am manually importing a record in VendInvoiceInfoTable thru Data Management Import Group >> VendInvoiceHeaderEntity. System is inserting records in tables VendInvoiceInfoTable_ & VendInvoiceInfoTable_W which is perfectly ok. But if similar record is getting inserted thru a Third-party system which auto creates Pending Supplier Invoices thru OCR, system is creating record only in VendInvoiceInfoTable not in VendInvoiceInfoTable_W . Even though Third-Party system also uses Data Management Import Group >> VendInvoiceHeaderEntity. I need to update field PurchReceiptDate_W of VendInvoiceInfoTable_W table, but since record is not getting created, I am not able to update the field also.

Any advice would be a great help!!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

If I'm not mistaken the table VendInvoiceInfoTable_W is part of a localization. Do you import the same type of data and columns via the manual import and the 3rd party system? Is the legal entity the same or is the import of both in different environments?

Was this reply helpful? Yes No
TU1506 147 on at

Like (0)

Report

Hi Andre,

Thanks for your reply.

Everything is same in terms of Data, environment, legal entity.

Table VendInvoiceInfoTable_W is localized but when i am inserting new record thru New Button in PSI , system is inserting record in VendInvoiceInfoTable_W also.

Was this reply helpful? Yes No
Raj Borad 1,428 on at

Like (0)

Report

Hi @TU1506,

It looks like the the issue is from the way the third-party OCR system interacts with the 'VendInvoiceHeaderEntity'. While manual imports and PSI-created records trigger the insertion into 'VendInvoiceInfoTable_W' - a localized table - the OCR-based import does not.

This thing suggests that the third-party integration may bypass some business logic or event handlers responsible for populating the '_W' table. Ensure that the OCR integration respects the same code paths or triggers as the manual process, particularly any customizations or event subscriptions on 'VendInvoiceInfoTable'.
You might need to add a post-processing class or event handler to populate 'VendInvoiceInfoTable_W' after import completion.

Thanks.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Record Not getting inserted into table VendInvoiceInfoTable_W

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Record Not getting inserted into table VendInvoiceInfoTable_W

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 > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates