Skip to main content
Question

PART NUMBER RELATIONSHIPS


Hello, I was wondering if anybody knew of a way to link part numbers together.  We have a RAW part number XXXXX-R which can either get polished or powder coated.  Once they are polished or powder coated, we receive them back in under the same part number minus the R XXXXX less (-R).  This will mean that we have 250 finished parts in stock but the RAW part was taken  out of inventory.  It may take 6 months to get down to 100 parts where we need to order more but the system is already telling us to order the RAW part as soon as it is polished or powder coated because the RAW part was taken down to a quantity of 0 in the system.  Is there a way to link the finished part to the RAW part so that when the finished part is down to 100 it tells us to order the RAW part for 250?

11 replies

Forum|alt.badge.img
  • Jr Varsity II
  • 42 replies
  • November 9, 2023

This would be really helpful for us as well. We use a similar method for parts which we either store in “bulk” or “packaged” and this issue means that we don’t have a way to use the replenishment options in Acumatica since we buy/product the bulk parts, but only care about inventory levels for the packaged versions.

 

It would be great if there was a way to specify that if part x requires replenishment then part y is what gets ordered/replenished.


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 466 replies
  • November 9, 2023

@BALAMEDA - why don’t you set up a Bill of Material (Subassembly) for the Powder coated part that includes the RAW part? that way when there is demand for the powder coated part - it will also create demand for the raw part? 


  • Author
  • Freshman I
  • 3 replies
  • November 9, 2023

@Debbie Baldwin , we have thought about this but in order to keep costing correct it doesn’t quite work.  The powder coating is an outside company and in order to get them paid it will populate the last cost field for the part.  If we added it to the BOM there would be more costing that isn’t in the BOM.

 It would put inventory into the system that really isn’t there and also add a cost to the system that isn’t there.  If we did it at $0 cost, I believe that might cause an issue with bottom line costs or finding costs in the future.


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 466 replies
  • November 9, 2023

@BALAMEDA you would add another item on the BOM for Outside Processing cost and make it Actual costed. 

 

FG or Subassembly = Powder coated part

BOM = Raw part + OSP part

 

I have a couple of videos on how Outside Processing works  - if you would like to email me I can send them to you? 

Or… your partner should be able to help you with this question?

 

 


  • Author
  • Freshman I
  • 3 replies
  • November 9, 2023

@Debbie Baldwin .  Debbie, I would appreciate the videos.  Maybe I am overthinking this but in order to get the vendor paid for the part all at once we would have to receive the finished part in. 

 

Are you saying not to bring the finished cost into the “finished” part number and let it be handled in the BOM. So I would add PN XXXXX-R for $275 and part XXXXX for $25 instead of bringing the costing into the finished part at $300?

 

I hope that made sense.


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 466 replies
  • November 9, 2023

@BALAMEDA - not really :) let me send you the video.

Debbie.baldwin@acumatica.com - send me an email. 


  • Author
  • Freshman I
  • 3 replies
  • November 10, 2023

@Debbie Baldwin I sent you an email yesterday with my email address.  Hopefully you received it.

 


Forum|alt.badge.img
  • Jr Varsity II
  • 42 replies
  • November 10, 2023

@Debbie Baldwin

Hi Debbie, would you mind if I reached out to you regarding a similar scenario for our company?


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 466 replies
  • November 10, 2023

@BALAMEDA - hopefully you received my email today. 


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 466 replies
  • November 10, 2023

@caseyh35 - feel free to send me an email. 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2679 replies
  • December 14, 2023

Hi @BALAMEDA were you able to find a solution? Thank you!


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