Skip to main content
Solved

Sending out an SO with one inventory ID and receiving a different inventory ID


Kandy Beatty
Captain II
Forum|alt.badge.img+16

I am about 95% sure that this will not work but looking to see if anyone else has a solution.

I have client who deals with seeds (such as peas and beans), they send the seeds to a grower who then grows the seed. They are sent on a sales order with item such as 1270. The grower grows the seed and a Purchase Order is created for the seed. The purchase order needs to use a different inventory ID such as 1270-GR. They need a way to account for the seed leaving their warehouse and then bringing it back into stock. The grower is the customer and the vendor. 

Does anyone have a solution or work around for this?

I know also that I could receive as the PO with 1270 then do adjustments and a receipt for 1270-GR but that is going to be extra steps. 

Best answer by Kandy Beatty

Chris Hackett wrote:

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

No we did not.

They have decided to create a new item and just reference both stock items on the SO and PO.

View original
Did this topic help you find an answer to your question?

8 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • July 18, 2023

Hello @kandybeatty49 ,

I have a few ideas that may help (not a full solution).  After reading your story above, I am thinking the client is really sending out one item, a seed, and receiving back a different item, such as a sapling.

I wonder if the 2nd tier item being received on PO can be considered a Kit, like:  seed + water + sunlight + labor + time = sapling. 

This situation also reminds me of steps in a BOM, where an outside service is performed on an item that is being manufactured (like sending a part out to be welded and receiving it back).

Best regards,

Laura


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Author
  • Captain II
  • 2209 replies
  • July 18, 2023

HI @Laura02 

They are not keen on the idea of kits. I explored that option. 

The BOM process would not work either as they may not receive the full quantity back. 

Thank you for the suggestions though. It is appreciated. 


Forum|alt.badge.img+1
  • Jr Varsity III
  • 66 replies
  • July 18, 2023

You could set up a virtual warehouse at the “vendor” and transfer the seeds to the vendor.  Then you could create a sales order for the grown seed (vegetable, fruit, etc.)  The grown seed could be a subcontract item which contains to seed, fertilizer, or any other material provided to grow the seed. If the grower issues a purchase order to your client for the seed, it could be “shipped” from the virtual location.


Dana Moffat
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 616 replies
  • August 8, 2023

Hi Kandy,

Have you explored the possibility of Cross Reference (vendor part number or customer part number) and extending the Customer as Vendor?

This assumes, of course that this should be treated as a single item in inventory.

-Dana

 


craig2
Pro I
Forum|alt.badge.img+3
  • Pro I
  • 100 replies
  • August 9, 2023

Hey @kandybeatty49 ,

If the request is simply tracking individual seeds or lots, could you just use standard SO/Shipment, PO/Receipt functionality with lot numbers?  You could then use the LotSerialNbr in your GI’s/Reports to trace the sapling(?) back to it’s roots.


Forum|alt.badge.img+5
  • Semi-Pro III
  • 294 replies
  • August 13, 2023

Two ideas:

  1. How about treating this as a manufacturing process? Create a labor item of “growing seed”, and a separate warehouse to represent when the seed is at the grower (this inventory cannot be sold from this warehouse). The manufacturing output of seed + growing seed labor item = grown seed sku. Once you have a grown seed, it should be transferred back to the main warehouse for sale.
  2. Create an integration with a SAAS product that does this out of the box: i,e, Seed-to-Sale Software For Growers | RedBud Software (redbudsaas.com)

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2757 replies
  • August 30, 2023

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


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Author
  • Captain II
  • 2209 replies
  • Answer
  • August 31, 2023
Chris Hackett wrote:

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

No we did not.

They have decided to create a new item and just reference both stock items on the SO and PO.


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