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 150 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,583 on at

Like (0)

Report
Copy link

Link copied!

I sometimes use below website

dynamicsdocs.com/.../

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,682 Moderator on at

Like (0)

Report
Copy link

Link copied!

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