Transmitting an 810 in Canadian Dollars 1

[NJAnalyst]

We are doing business with a major retailer with stores in Canada. The customer is sending us orders in Canadian dollars. We can convert the dollars on the inbound 850 with a price code to get US dollars internally. The problem is transmitting an 810 back in Canadian dollars. We want to track our sales in US dollars. What am I missing? I am hoping that someone else out there has run across a similar problem. Thank you.

Jonathan Nelson
Business Systems Analyst
Horizon Group, USA

 

[dgillz]

I would check with 2 people on this. One would be Brad Nelson with Techtonics Software Architects. Brad wrote the Macola EDI module. The other person is Matthew Bather with Exact Software Canada. I have to believe that one of these people have run into this before.

I have invited both of these people to respond to this forum, so hopefully we will hear from them directly.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[canimp]

Currency manager in use? This will determine next steps.

Progression or ES + version, please.

 

[canimp]

Another excellent resource who frequents this forum regularly would be kscheeler. (Matthew is out of the country for the next week - KScheeler may provide a more rapid response - will give him a heads-up to view this thread).

 

[kscheeler]

Since you are tracking sales in US dollars, I'll assume that you currently are not using Currency Manager. That may be your only choice without alot of programming. To be able to send an invoice in a foreign currency, you need to store the conversion factor in the system. You need this so you can send the invoice again at a later date if necessary at the same rate as the first time.

This wouldn't affect sales as Macola converts the amount when it gets posted into AR. The order history files show the actual prices in US Dollars. With the conversion factor on the header, you can also get the Canadian amount as well.

Does the customer expect the invoices back to them in Canadian dollars? What currency do you expect to be paid in.

The 2nd question might affect being able to use currency manager or not.

To sum things up. There are no special settings in the EDI module for foreign currency. If you are using the currency manager module, it should handle it on both the inbound and outbound sides.


Kevin Scheeler

 

[NJAnalyst]

Thank you for the responses. I spoke to someone from Exact at Engage and they said that currency manager could not be used in conjunction with EDI. It sounds like that was bad information. The customer expects the invoices to be in Canadian dollars. We expect to receive payment in US dollars.

Jonathan Nelson
Business Systems Analyst
Horizon Group, USA