How to fulfill Shopify orders through drop ship PO in Acumatica

@mikeho , in Sync History it will look like this (note, Receipt keyword for POs, while shipments have just their ID there):

@Yuri Karpenko - That’s great news, thanks!

@Yuri Karpenko , Thanks for the hint. In the release notes i didn’t find this improvement - was it developed under the release radar or am i blind? ;)

(https://help.acumatica.com/(W(117))/Help?ScreenId=ShowWiki&pageid=258373da-50b0-4c84-94d6-78ab7f28baf1)

@PatrickSchlenker90 , sorry, I don’t monitor release notes. I just happen to know this, since I used this functionality. :) 

Hello, I’m trying to sync drop-shipped items per the above, but am receiving the following error.

This shipment cannot be processed because the shipped quantity of the item might exceed the ordered quantity in the external system. Set the same tracking number for this shipment in the ERP and in the external system or delete this shipment in the external system.

I’ve verified that the quantities in both systems are the same. Any ideas what might be causing this error? We are on 23R1.

@Cash4WRA , I’ve see this error before. Since it’s a different topic though, I recommend that you start a new thread on the community site with more details, screenshots, steps, etc.

We have this available in 22R2 as well, however it needs to be mapped while regular shipments don’t need to be mapped. 

We’re we’re running into issues is when we map the the PO Receipt we loose the regular shipment tracking sync. Acumatica recommended doing a if else formula. Any idea how to do that? 

@Jeff96 , I would try something like this: =iif([BCShipments.ShipmentNumber] = Null, [BCShipments -> POReceipt.VendorRef], [BCShipments.ShipmentNumber])

In this mapping:

Yuri Karpenko wrote:

@Jeff96 , I would try something like this: =iif([BCShipments.ShipmentNumber] = Null, [BCShipments -> POReceipt.VendorRef], [BCShipments.ShipmentNumber])

In this mapping:

 

I have a custom field for that, but it’s on the line level. Can I point to that table or does it need to be the header?

@Jeff96 , it needs to be on the header for 2 reasons:

1. Credit terms are not line specific (neither in Acumatica, nor in Shopify)
2. We don’t have access to order line metafields from Shopify.

Hope this helps.

We’re talking about tracking, not sure why you’re referencing credit terms order metafields

@Jeff96 , sorry, I have a few conversations going on at the same time :)

But regardless, we don’t have access to PO Receipt Line fields. So you will need to use a header level data. Also, you can’t use custom data natively - that can only be done through a customization.

Hello Mike,

I have read the notes on this, and like that the 23R1 has fixed this.  The only thing I did not see on here was where is the Ref Number entered.  AKA the tracking information.  We have a UPS tracking number from the manufacturer so I was trying to find where to enter that for it to transfer over to Shopify Automatically.  

Regards,

Kevin