In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Problem With Drop-Ship Invoicing Locked "drop ship lines on PO are not linked to any sales order lines"
I have run into a problem with an order on Acumatica I just can't seem to remedy.... hoping someone can help me out!
I have a sales order with two item lines on it, one is product, the second is a service. I am trying to invoice the prepare the invoice via actions, but I get the error: "Some of the drop ship lines on PO are not linked to any sales order lines. Check trace for more details". I do not have access or know how to use trace. The only thing I notice that is out of place is I have 0 quantity on shipments; open quantity 1 for the service- but I am unable to edit or change this of course.
I did try to "ship" the second line with the open quantity to see if that would remedy the problem, but it did not seem to help, so I deleted that shipment.
On the Sales Order shipments tab, I see Drop - Shipment "Receipt, PR00####" when I click that it shows both item lines, with 0 open quantity. This seems proof to me that the order is somehow linked to the PO for 2 item lines.
When I look at the Purchase Order, I see both item lines, "order qty" matches "qty on receipts", type is "Drop Ship", and the PO has been received, and shows completed. Everything appears fine.
I thought trying to reverse the PO receipt might help unlock things, but apparently doing a return is my only option. As this would not unlock the Purchase order, I deleted the return.
So in summary - I'm not sure what is actually triggering the problem, and I don't know how to fix that problem because everything seems to be locked down by the PO being received. What am I looking for to show that the PO is linked to sales order?
Has anyone else had this problem and found a solution? Please advise!
This is an error we ran into occasionally. Although we never pinned down the exact cause, I do have some notes on how to fix individual orders. Hope this helps!
Symptom: When attempting to prepare an invoice for a DI sales order the action will fail and display the error message. “SO Error: Some of drop-ship lines in the purchase orders are not linked to any sales order lines. Check Trace for more details.”
Cause: Root cause unknown – likely related to DI order lines not having the item warehouse field set to ‘DI’.
Solution: Relink the SOLineSplit records in SQL
Select statement to verify:--Set OrderNbr and OrderType DECLARE @OrderNbr NVARCHAR(7); DECLARE @OrderType NVARCHAR(2); SET @OrderNbr = '9999999'; SET @OrderType = 'DI'; SELECT SOLineSplit.OrderType, SOLineSplit.OrderNbr, SOLineSplit.LineNbr, InventoryItem.InventoryID, InventoryItem.InventoryCD, SOLineSplit.POType, SOLineSplit.PONbr, SOLineSplit.POLineNbr, SOLineSplit.POCreate, POReceiptType, POReceiptNbr, RefNoteID, POReceiptLine.POType, POReceiptLine.PONbr, POReceiptLine.ReceiptType, POReceiptLine.ReceiptNbr, POReceiptLine.NoteID FROM SOLineSplit LEFT JOIN InventoryItem ON SOLineSplit.InventoryID = InventoryItem.InventoryID INNER JOIN SOOrderShipment ON SOLineSplit.OrderNbr = SOOrderShipment.OrderNbr AND SOLineSplit.OrderType = SOOrderShipment.OrderType INNER JOIN POReceiptLine ON SOOrderShipment.ShipmentNbr = POReceiptLine.ReceiptNbr AND SOLineSplit.InventoryID = POReceiptLine.InventoryID WHERE SOLineSplit.OrderNbr = @OrderNbr AND SOLineSplit.OrderType = @OrderType;
Thank you for your suggestion above, however, I have no idea how to apply your suggestion in actual practice.
Incase anyone else runs across this problem - here's how I was shown to fixed it:
On the PO Screen, for each PO Line, click the VIEW SO DEMAND button Confirm that each PO line is linked to a SO. A line that is linked will be listed under the DEMAND with Sales Order Number etc. listed for each item. ** I had one that was, and one that was without a demand
If an item is not linked but needs to be, go to the Sales Order Screen and click the "Mark for PO" check box (the column may be far off on screen, or need to be made visible by clicking the file-cabinet/drop down select looking icon next to the paperclip icon in header above item lines).
Once it is checked, for each line click the PO Link button (Above the Item line Headers) ** This is where my problem was, never having used this method before or even noticing this button while trying to problem solve.
Select the correct PO to link the SO to from options provided. This successfully linked my PO to SO and vice versa.
Hopefully someone can benefit from my former frustrations; while an easy fix in retrospect, missing one vital step can be quite frustrating!