web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Table for Co-Products in a batch order

(0) ShareShare
ReportReport
Posted on by

Hello All,

I have a batch order with several co-products.

I have checked the table 'PmfCoByProdCalcTrans' to get the details of the co-product and the details like raw material and the resources as per screen below.

However, in the table I am unable to find the link between one specific co-product and its respective raw material/resources.

Is there a way to retrieve the detail of one specific co-product from this table or is there another table.

  • Co-product 1

8780.pastedimage1585761685929v3.png

  • Co-product 2

6507.pastedimage1585761768228v4.png

Thanking you

Kind regards,

Rina

I have the same question (0)
  • Allen Dejoux Profile Picture
    Microsoft Employee on at

    Hi Rina,

    I will try and find an expert who knows these table links/joins and will give you an answer as soon as possible.

    Thanks!

  • Community Member Profile Picture
    on at

    Hello Allen,

    Thank you loads for your help. Really appreciate it.

    Kind regards,

    Rina

  • Allen Dejoux Profile Picture
    Microsoft Employee on at

    Hi Rina, 

    Are you able to try the following:

    • Do personalization to add production type to released product grid
    • Stand on co-product
    • Click on Engineer>Formula>Where used
    • Get Item ID
    • On Item ID (Released Products), look at Formula.
    • On Formula look for Co-products.
    • Go to All Production Orders and find a Batch Order.
  • Community Member Profile Picture
    on at

    Hello Allen,

    Please find below screenshot of a batch order with several co-products

    pastedimage1586323064110v2.png

    Screenshot of the formula with the co-products defined

    pastedimage1586323193758v3.png

    Kindly let me know if you require more details.

    Kind regards,

    Rina

  • Allen Dejoux Profile Picture
    Microsoft Employee on at

    Hi Rina,

    I may need you to give a little more clarification on what your asking or create a support ticket to have someone walk through specifically what you need.

    However, below are the tables used when co-product is clicked. 

    pic2.png 

  • Community Member Profile Picture
    on at

    Hello Allen, 

    Thank you loads for the tests.

    On my batch order, there are 6 co-products taking  SFPO0007 and SFPO0008 as example.

    On both co-products, in the overview costing tab, there is the item SFPO0004 and resource RSM-KILL01 (and other resources).

    Co-product 1

    pastedimage1586363377136v1.png

    Co-product 2

    pastedimage1586363463159v2.png

    In the table PmfCoByProdCalcTrans, the information appear as below. 

    pastedimage1586363689688v3.png

    I have 6 lines of co-products (Lines 2-7) and 6 lines of items (Lines 8-13), the SFPO0004.

    I wanted to know which column in the table helps to determine which line of SFPO0004 corresponds to which line of co-product, similarly for the resource RSM_KILL01.

    Basically, Item SFPO0004 in line 8 correspond to which co-product from line 2 to 7.

    I am using table browser to retrieve the information and does not have access to the AOT. Perhaps I am missing some important primary keys or relation with other tables.

    Kind regards,

    Rina

  • Suggested answer
    Allen Dejoux Profile Picture
    Microsoft Employee on at

    I don't think this can be done. We only saw that relationship somewhat expressed in InventTransOrigin. It was not perfect. We saw ProdLines just by Reference and does not tells anything in regards to the structure.

  • Community Member Profile Picture
    on at

    Hello Allen,

    Okay. Thank you for the feedback.

    Kind regards,

    Rina

  • Guy Terry Profile Picture
    29,011 Moderator on at

    Hi Rina,

    Your original question about how to find the raw materials which are responsible for the production of a specific co-product item... I'm afraid that is not how Production orders and Co-products are structured in F&O. There is no way to define that relationship. The production order has raw materials which can be consumed. And it has Co-products, which can be made. There is no link between which says these specific raw materials will make this specific Co-product.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 173 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 104 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 102 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans