Which table has relations between Dimension and Purchase Invoice Table

(0) Share

Report

Posted on by chigivigi

I am creating a new Page Api in which I will create actions that will interact with Purchase Invoice and Dimensions. The action would define the Dimensions for a newly created Purchase Invoice and create a connection between the Dimension values and the new Purchase Invoice.

What table is used to save table relation data between Dimension and Purchase Invoice table?

All responses (7)

Answers (0)

Suggested answer

Steven Renders 5,500 Moderator on at

Like (0)

Report

RE: Which table has relations between Dimension and Purchase Invoice Table

Have a look here for more information about the design details:

docs.microsoft.com/.../design-details-dimension-set-entries-overview

docs.microsoft.com/.../design-details-searching-for-dimension-combinations

docs.microsoft.com/.../design-details-table-structure
Suggested answer

chigivigi 77 on at

Like (1)

Report

RE: Which table has relations between Dimension and Purchase Invoice Table

Thank you. The dimension set entry table is what I needed.
Suggested answer

Vinita_Kas 325 on at

Like (0)

Report

RE: Which table has relations between Dimension and Purchase Invoice Table

HI

Is this what you need table no 122

It has got both Dimension 1 and 2 values in it

Let me know if that helped.

Regards

Vinita
Suggested answer

Inge M. Bruvik 1,023 Moderator on at

Like (0)

Report

RE: Which table has relations between Dimension and Purchase Invoice Table

You should also be aware that there is a standard api for handling the dimension sets that you can use when you need to find / create a dimension set from an API.
Suggested answer

MahGah 15,437 on at

Like (0)

Report

RE: Which table has relations between Dimension and Purchase Invoice Table

I sometimes use below website

dynamicsdocs.com/.../
Suggested answer

Alok.kulshreshtha 934 on at

Like (0)

Report

RE: Which table has relations between Dimension and Purchase Invoice Table

table between Purchase invoice and Dimension is a Dimension set entry. on purchase invoice table , you will find "dimension set entry" column .in this column you will find a numeric value. with this value you can filter on dimension set entry table and get the values
Suggested answer

JAngle 83 on at

Like (0)

Report

RE: Which table has relations between Dimension and Purchase Invoice Table

Dimension set ID is a field on the vast majority of transactional entries/documents. That relates to the dimension set entry table. Each ID can equate to one or more dimension combinations. A unique ID for every possible combination as and when it is used on a transaction