We are having trouble with Native Acumatica, and want to see if there are any options.
We receive a lot of items in Sea Containers. Multiple orders are put in to a container shipment when they are all ready to ship.
Our typical work flow to place an order is:
- Place a main order for a container of products. We will call this PO-001. Maybe this PO takes 90 days to prepare for shipment.
- During this time, we will add PO’s for smaller items, generally repair parts. So let’s say that during the time it takes to get PO-001 ready, we make PO-002, PO-003, PO-004, and PO-005.
- Now PO-001 is ready to ship, and most of the other open PO’s (PO-002 through PO-005) are also shipping in this sea container. But sometimes, one or 2 items will not be ready in time to make the shipment, so it will still be left on order for shipping at a later date.
- Our people need to see an accurate delivery date and tracking info for this shipment, and need to know that all of these shipped in the same container. So right now, we go to each individual PO, manually update the promised date, add tracking, and add notes. And anything that did not make the shipment, we will delete and make a new PO to keep it on order. Very time consuming.
So instead of manually going through each PO, updating the promise date, adding the same container tracking, removing items and making new PO;s for the items that did not make the shipment, and adding notes that they all shipped together, how would we consolidate this process?
What we have tried:
We have tried to make a Purchase Receipt and receive the items that shipped to an In Transit location - But that does not work, because we do not always have the correct dollar amounts at this stage, so it messes with the financial end of things. If we enter items at zero dollars and then later correct them, it posts these figures in a way that does not work. AND not only that, but receiving them messed up our inventory replenishment. Because the In transit location had to be a location that was unavailable, so once we received it there, the items were no longer on PO, but were also out of stock, so Acumatica was generating Auto Reorder PO’s. It was a mess.
We also tried the PC Bennet Container Receiving Module, but it did not work with serial numbers. Although at this point, we do not need to work with serial numbers, but the PC Bennet Solution had other hangups.
What I imagine we need:
All we really need is a step in between a PO and Purchase Receipt - So we could just receive the items from the PO’s on to one consolidated PO, then we could have one place to look to see whats coming in.
All we need to do is take orders that are on multiple PO’s, and show that they have all shipped in one shipment. Whether it is a small UPS Box, or a sea container. If we could have some kind of step that takes these PO’s and combines them to one master PO, that would solve it.