D365 Finance & Operations and Dynamics AX Forum

Hi all!

I am using F&O 10.0.25 (10.0.1149.40) and I urgently need your help with the pegging in Master planning.

We apply Make to Order:

- Place Sales orders for Manufactured items (with Formula)

- Run Master planning

- Check Planned order / Item requirements. I want to have a direct link between the Item requirements for Formula components and the Sales order number/Customer account of the Manufactured item.

Here's an elaborate explanation.

1. I go to the Item Net requirements.

2. I apply necessary filters.

3. I go to Inquiries.

4. I check the pegging. What I want is an entity that reflects this pegging. In other words, an entity that links the following together:

• Item number (here 103039)
• Planned order number and reference (here PlnO-045495 and Planned purchase orders)
• Reference, Number and Customer account (here Sales order, SO22000011, and C00012)

Kindly advise if there is such an entity OOB. If not, any idea how to customize it?

Your input is appreciated.

Thank you,

Hi all!

I am using F&O 10.0.25 (10.0.1149.40) and I urgently need your help with the pegging in Master planning.

We apply Make to Order:

- Place Sales orders for Manufactured items (with Formula)

- Run Master planning

- Check Planned order / Item requirements. I want to have a direct link between the Item requirements for Formula components and the Sales order number/Customer account of the Manufactured item.

Here's an elaborate explanation.

1. I go to the Item Net requirements.

2. I apply necessary filters.

3. I go to Inquiries.

4. I check the pegging. What I want is an entity that reflects this pegging. In other words, an entity that links the following together:

• Item number (here 103039)
• Planned order number and reference (here PlnO-045495 and Planned purchase orders)
• Reference, Number and Customer account (here Sales order, SO22000011, and C00012)

Kindly advise if there is such an entity OOB. If not, any idea how to customize it?

Your input is appreciated.

Thank you,

Hi all!

I am using F&O 10.0.25 (10.0.1149.40) and I urgently need your help with the pegging in Master planning.

We apply Make to Order:

- Place Sales orders for Manufactured items (with Formula)

- Run Master planning

- Check Planned order / Item requirements. I want to have a direct link between the Item requirements for Formula components and the Sales order number/Customer account of the Manufactured item.

Here's an elaborate explanation.

1. I go to the Item Net requirements.

2. I apply necessary filters.

3. I go to Inquiries.

4. I check the pegging. What I want is an entity that reflects this pegging. In other words, an entity that links the following together:

• Item number (here 103039)
• Planned order number and reference (here PlnO-045495 and Planned purchase orders)
• Reference, Number and Customer account (here Sales order, SO22000011, and C00012)

Kindly advise if there is such an entity OOB. If not, any idea how to customize it?

Your input is appreciated.

Thank you,

Jessica, one of my colleagues has provided this which might help:

Tables required for pegging query:

REQTRANS – net requirements table

REQTRANSCOV – pegging table

Table joins to query pegging:

FROM REQTRANS AS PRT

LEFT OUTER JOIN REQTRANSCOV  AS RTC

ON PRT.RECID = RTC.ISSUERECID

LEFT OUTER JOIN REQTRANS AS CRT

ON CRT.RECID = RTC.RECEIPTRECID

Where PRT is the parent reqtrans record and CRT is the component reqtrans record.

Hi all!

I am using F&O 10.0.25 (10.0.1149.40) and I urgently need your help with the pegging in Master planning.

We apply Make to Order:

- Place Sales orders for Manufactured items (with Formula)

- Run Master planning

- Check Planned order / Item requirements. I want to have a direct link between the Item requirements for Formula components and the Sales order number/Customer account of the Manufactured item.

Here's an elaborate explanation.

1. I go to the Item Net requirements.

2. I apply necessary filters.

3. I go to Inquiries.

4. I check the pegging. What I want is an entity that reflects this pegging. In other words, an entity that links the following together:

• Item number (here 103039)
• Planned order number and reference (here PlnO-045495 and Planned purchase orders)
• Reference, Number and Customer account (here Sales order, SO22000011, and C00012)

Kindly advise if there is such an entity OOB. If not, any idea how to customize it?

Your input is appreciated.

Thank you,