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?

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Alok.kulshreshtha 934 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

I sometimes use below website

dynamicsdocs.com/.../

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Vinita_Kas 336 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

chigivigi 77 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No