Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Case: can I use custom product characteristics for tracking from purchasing to sales?

Posted on by Microsoft Employee

Dear AX forum users.

I hope someone can help me with the following case:

  1. Unsorted and dirty material is purchased and delivered.
  2. Upon arrival, the material is given a batch-number + for every delivery the supplier is identified.
  3. For every batch a production order is made to convert unsorted and dirty material -> sorted and cleaned products.
    1. I.e. we have one input material and multiple output products.
    2. Outputs are products in fraction 1-6mm, 6-12mm, and several types of minerals.
  4. Sorted and cleaned products are stored and sold in lots.
    1. There can be multiple batches in one lot.
    2. Batches can be sold in multiple lots.

At the moment we have lots of item numbers in AX. I.e. one product for every supplier and fraction. Furthermore, we assign a batch number in the name/description of every production order. This gives me no analysis options, as I cannot automatically match a batch-number to a lot which is sold. Furthermore, all those different item numbers could be reduced in my opinion, because the products are all physically the same, and only some characteristics (supplier, fraction) are different.

What options do I have for batch-tracking? I want to manually assign a batch-number to a production order. Later on, I need to know what batches are sold in which lots.

Can I give my items custom attributes such as supplier-name and fraction in mm?

Hope someone can help me out.

Kind regards,

Kevin

  • Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Case: can I use custom product characteristics for tracking from purchasing to sales?

    Hi Kevin,

    Were you able to resolve it? Please mark YES against the answer if it helped you. As the forum would be marked closed & will be beneficial for other community members. Thanks

    Warm Regards,

    Zain

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Case: can I use custom product characteristics for tracking from purchasing to sales?

    I am still working on it. Thank you. When I need any further help, I will reply on this topic.

    Kind regards, Kevin.

  • Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Case: can I use custom product characteristics for tracking from purchasing to sales?

    Hi Kdizij,

    Good day!

    Were you able to work with the inventory batch attribute? Were you able to make them assist in your case, is any further help needed in this case?

    Warm Regards,

    Zain

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Case: can I use custom product characteristics for tracking from purchasing to sales?

    Hi Zain.

    Thanks for your reply. I will need some time to figure out how these batch attributes work, but the initial information i've read seems hopeful.

    Any other ideas from other members?

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Case: can I use custom product characteristics for tracking from purchasing to sales?

    Hi Kevin,

    Have you tried using inventory Batch attributes? Batch attributes are characteristics of raw materials and finished products that make up inventory batches. Batch attributes can vary depending on factors such as environmental conditions, the quality of the raw materials that are used to produce the batch, or the outcome of the finished product.

    You can use supplier/Fraction as an inventory batch attribute.

    For more information on this you can see,

    docs.microsoft.com/.../batch-attributes

    Warm Regards,

    Zain

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans