Microsoft Dynamics AX (Archived)

Sales Product ID and Factory Product ID

(0) Share

Report

Posted on by Community Member

Hi,

Could you please indicate some hints to realise requirment below?

We have a requirement as below:

Sales department generates a transfer order with a "sales product ID" to factory
Factory plans production with different set of "factory product ID"s corresponding to "sales product ID" on the transfer order.
"factory product ID" is dependent of many factors such as machine that is used for the production and end users.
There could be more than one "factory product ID" against a "sales product ID"
Factory dispatches product with "sales product ID"
Sales department accumulate revenue using "factory product ID"

Sincerely,

ABTS

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi ABTS,

You are not providing information if this is all in one legal entity or multiple. Can you provide this? You are talking about a transfer order in the first requirement. What do you mean with that?

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (1)

Report

Need some more info, but I'll work of assumptions.

Sounds like you have a customer product that you do work on.

You also have a business process that doesn't fit with AX standard, but it can be reworked so you can use AX. Book a manufacturing consultant to come and guide you. Might give you some eye opening moments.

Off the bat...

1) Use sales orders with negative item line for receiving the item. Use batch ID to handle the tracking of these products and make sure your manufacturing staff picks and use the right items. It is also a great cost bearing object for calculating actual costs and revenue. The transport and planning of these items works great.

2) Let off the "Factory Product ID" and use default AX manufacturing processes. The info you put in to this string will be provided in several other moving parts (resource, production ID and so on). It sounds restricted that this is in the ID field as it might be subject for change...

Good luck.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much!

I will attempt to use two staged item structure.

First, I will register one item with "Sales product ID" and another product master with configuration to represent multiple "factory product ID".

Second, register a BOM so that item with "Sales product ID" act as parent and product master act as a child.

I will see if factory planner is able to select configuration on "Factory product ID" item when an order is recieved on "Sales product ID" item.

Sincerely,

ABTS

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

I can't seem to get a grasp on the meaning of these terms in association with AX. It might be that your business process could be a 100% fit for AX, but you just use different descriptions?

What does the factory product ID actually mean? Is it a product you produce through a set route with a certain BOM if so it is configuration? Given that you can group it on a common item.

So maybe your Sales Product ID could be the Item which is a item master and then have your configurations of this item be the "factory product ID"?

Was this reply helpful? Yes No
Tim Schofield on at

Like (0)

Report

Hope this helps, but I fear it may add confusion. Assuming this isn't intercompany (one sales company and one manufacturing company), it sounds more to me like you need a BOM on your 'sales product id' which defines one or more 'factory product id's' that are actually manufactured. The last step in your factory (before they despatch the 'sales product id' would be to run a simple production order (or BOM journal) to consume the factory product ids out of inventory and receive the sales product id - and then you despatch that.

Fredrik's suggestion of using batch numbers to track is a good one.

The other thing you could look at is the product configurator (product builder in earlier versions) I'm pretty sure that can create you a new item number for your sales order line (the sales product id).

Simplest all round if everyone uses the same item numbers though.

Was this reply helpful? Yes No