Skip to main content
Question

How to connect sales part and purchase part

  • December 20, 2023
  • 6 replies
  • 295 views

Forum|alt.badge.img+10
  • Sidekick (Customer)
  • 78 replies

We created a sales part from an inventory part. Then created a purchase part manually and not from the inventory part. So the purchase part and sales part are not “connected.” Is there a way to connect them after they are created?

6 replies

Forum|alt.badge.img+11
  • Hero
  • 193 replies
  • December 21, 2023

Hi,

Does this mean the Inventory part number is not the same as your purchase part number?

Thanks

Asanka


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 78 replies
  • December 21, 2023

The inventory part, sales part and purchase part all have the same part number. The purchase part is connected to the inventory part. And the sales part is connected to the inventory part. But the purchase part and sales part are not connected.

 

Below, you can see the inventory part connected to the sales part, but the purchase part number is “blank” even though a purchase part with that same number exists.

 

The purchase part was not created when the inventory and sales parts were. The purchase part was created later, manually. It was automatically connected to the inventory part but not the sales part even though they all have the same part number. 

 

 

 

 

 

 


Buddhika Kurera
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • 388 replies
  • December 22, 2023

There is no setup to connect the purchase parts, if the part no are same the connection should exist. The connection is implicit. 

For an example, create an inventory part (Part Type = Manufactured) and then no Purchase Part is automatically created. Then you create the sales part and the purchase part using the same part no. In that case you need to see the Purchase Part in the Sales Parts window. Even you can use a different name as the Sales Part no because the inventory part connection to the sales part can be given (it is explicit).

Try querying the part in Warehouse Management\Part\Inventory Part and then RMB > Purchase Part, if this brings you to the right Purchase Part the connection exists. Sometimes I mixed up parts in different sites, just check for that as well.

Hope this helps !


Forum|alt.badge.img
  • Do Gooder (Customer)
  • 2 replies
  • March 11, 2025

We just ran into this issue as well. All the numbers (Sales, Purchase, Inventory) are identical, but the “Purchase Part” field was not populated. Is there a way to manually add it in from the application or do we have to go into the database? 


Forum|alt.badge.img+7
  • Hero (Employee)
  • 39 replies
  • March 13, 2025

I believe that was a bug in older versions of IFS and judging from your screenshot, you are using an older non Cloud version. You could use a very simple FNDMIG Foundation Migration job to set the purchase part number to be the same as the part no on the sales part (part no is the inventory part number, not the sales part number although they may be the same). 


Forum|alt.badge.img
  • Do Gooder (Customer)
  • 2 replies
  • March 13, 2025

Thank you for your reply. Yes, for my case we are on IFS10. Still a month away from cloud. I think the FNDMIG might be overkill as we just need the one instance populated and not the entire column in the database.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings