Duties Import Shopify

​@TamaraW 

Acumatica has landed costs functionality which can be used for duties but this is for purchases.

Could you utilise a new tax id for this purpose?

​@aiwan thanks for the response. 

Never thought about using the tax ID for that purpose. 
Maybe this could be an option. 

I’m not quite sure if this error message is somehow related to the duties topic. But i have one order in Shopify where we collected taxes and duties. 
The customer then told us, that he wanted to cancel one item. So we edited the order in shopify and refunded the amount of the item + tax + duties. This edit caused the following error message when i tried to synch it:
Invalid object name 'SOQuickPrepaymentInvoice'.

We’re not creating prepayments, so the error message doesn’t really makes sense for me.
 

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

​@Chris Hackett no, not yet. 
The tax ID doesn’t seem to be a good workaround.

I’ll give an update when i found a proper solution.

could you create a non-stock item as the duty and import it that way?   how are the duties getting calculated on the order in shopify? 

​@kkeating24 was also my idea but i’m not sure how to set it up in the e-commerce/objects section of Accumatica. This is how it looks like in Shopify:
 

So i need to say: If there are duties in the order, add a non-stock item to the order with the amount of the duties line in shopify.

Any ideas how i can set it up?

I’m not a shopify developer, but I know apps like FLOW can interject and add things.   

Or can you send the JSON of the order to see if it is contained there?  if it is we might be able to map it...

All you need to do is add “.JSON” to the Order URL. 

​@kkeating24 i’m not able to send you the whole json information (GDPR), but what i can see with duties is:

"currency":"EUR","current_subtotal_price":"30.07","current_subtotal_price_set":{"shop_money":{"amount":"30.07","currency_code":"EUR"},"presentment_money":{"amount":"34.99","currency_code":"USD"}},"current_total_additional_fees_set":null,"current_total_discounts":"0.00","current_total_discounts_set":{"shop_money":{"amount":"0.00","currency_code":"EUR"},"presentment_money":{"amount":"0.00","currency_code":"USD"}},"current_total_duties_set":{"shop_money":{"amount":"4.51","currency_code":"EUR"},"presentment_money":{"amount":"5.25","currency_code":"USD"}},"current_total_price":"39.30","current_total_price_set":{"shop_money":{"amount":"39.30","currency_code":"EUR"},"presentment_money":{"amount":"45.73","currency_code":"USD"}},"current_total_tax":"0.00","current_total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"EUR"},"presentment_money":{"amount":"0.00","currency_code":"USD"}},"customer_locale":"en-US","device_id":null,"discount_codes":[],"duties_included":false,

but also in the same order this:

"original_total_additional_fees_set":null,"original_total_duties_set":{"shop_money":{"amount":"4.51","currency_code":"EUR"},"presentment_money":{"amount":"5.25","currency_code":"USD"}},

ok, interesting, are you familiar with how to use the entity mapping in ACU?  you might need to play around with that “original_total_duties_set” to see if you can get it to work...otherwise this is feeling a bit like a customization...

​@kkeating24 do you mean with entity mapping this section?:

that’s correct.