SBX - Search With Button

SBX - Forum Post Title

What is the use of 'HeaderReference' field in "Vendor invoice line" data entity

Microsoft Dynamics AX Forum

Sangram Shinde asked a question on 18 May 2018 7:43 AM
My Badges

Question Status

Verified

Hi Techies,

We are looking for field details of 'HeaderReference' in "Vendor invoice line" data entity, this field is mapped with "TableRefId" field of VendInvoiceInfoLine table, but we can't see this on front end (AP>Invoices>Pending vendor invoices) anywhere, when we create a record manually this field gets generated as we can see in table.

Now here is what we are checking for - what is the exact purpose of this field, where we can see this on front end and why it is mandatory in staging table? 

Does anyone have any idea?

Any response is appreciated!

Thanks.

Reply
Verified Answer

Hi Sangram,

This value is coming from the System ID number sequence which can be setup on the Legal entity form. It is an internal reference to keep all vendor posting related tables (but also sales posting) together. In fact it is the "primary key" for a vendor invoice or other sales/purchase related update.

Reply
Sangram Shinde responded on 23 May 2018 8:18 AM
My Badges

Thanks Andre for valuable reply!

Reply
Verified Answer

Hi Sangram,

This value is coming from the System ID number sequence which can be setup on the Legal entity form. It is an internal reference to keep all vendor posting related tables (but also sales posting) together. In fact it is the "primary key" for a vendor invoice or other sales/purchase related update.

Reply

SBX - Two Col Forum

SBX - Migrated JS