@K2a , we are using presentment currency to import the Order and Payment currently. It’s impossible to map it in the Entity mapping screen. But it may be a solution to add an option to let user choose which currency should be used. I think our BAs are working on it. @KarthikGajendran Thanks @simonliang91 - so I assume this means we’d HAVE to enable multicurrency accounting in order to process as of now?
@K2a I assume your base currency is USD in Shopify and customer paid with CAD currency. In Acumatica Sales Order, we always display two currencies. Order Currency Order Base Currency In your case, in Acumatica Sales order, you would have Order Currency as CAD and Order Base Currency as USD and the exchange rate brought from Shopify. Acumatica Payment will be created in CAD currency as well and applied against the Order created in CAD. Now, are you expecting the system to create the Acumatica Sales Order in USD? Meaning both the Order Currency and Base Currency to be USD? Please let me know. @KarthikGajendran - we do not have MultiCurrency enabled, so would this functionality work as you describe without CAD enabled as a currency? Because when I tried to import the Markets Pro order I get the following Commerce Error:
@KarthikGajendran - just want to confirm - we WOULD need to enable multicurrency to deal with this type of order?cheers,k2
@KarthikGajendran - I think that could help a lot of folks that are in the same boat as us. If we have the ability to sell on shopify in multiple currencies but import to ACU without using multi-currency setup, that would be super!
@KarthikGajendran - another comment on this, it looks like Markets Pro is handling all the currency conversion and even pays us in USD. So again, I think it would be helpful to be able to import the order/payment in our base currency based on the daily spot rate:
@K2a - it looks like it populated the ((Shipping_Contact.Attention)) in the greeting. For the other placeholders, did you select the values from the INSERT->DATAFIELD list or copy them from another template? Wondering if the SOOrder and SOContact are available in the list or if they have different name in the Shipments Screen (SO.30.20.00). That’s gotten me before. I think you may be partially right.I changed the GI used for the screen...however when I change it back it still doesn’t seem to pick up the new values.k2
@K2a - Is the source Screen for the Email Template no longer the Shipments (SO.30.20.00) screen then? If so, I don’t know that you will be able to add a new Email Activity from the Shipment screen and use the SELECT TEMPLATE action to populate the values from the selected Shipment. You could use a Business Event triggered by action if you’re source is a GI. Ya it’s a new GI and that was reason I referred back to the SO302000 screen was to get it to work, but how do I edit the SO302000 query to add the fields I need?
@ehylinski - thanks for this, I need to CC the Salesperson from the SO (email addy). That’s the one field that always gets us on most queries because you have leap through a few tables to get to it. That’s the only one i’m missing
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.