Chargelogic is Invoicing a different USD amount from the Sales Order when the Exchange Rate Changes.

(0) Share

Report

Posted on by Community Member

We're using Chargelogic in the UK for Credit Card transactions with Pensio. We're having an issue where a USD Sales Order placed in a preceding month is invoicing at the new USD exchange rate in a subsequent month. We need it to use the same USD amount and post the current GBP amount like below. Currently it's changing the USD rate to match the new GBP to USD exchange rate. We don't know if it's a setup or code issue. GBP is our Local Currency.

Here's how we want it.

Month	$	£	FX	$ Charge Customer	£ Post in Navision
July	1,000	650	0.65	1,000	650
August	1,000	640	0.64	1,000	640
September	1,000	660	0.66	1,000	660
October	1,000	700	0.7	1,000	700

It's currently doing this which we don't want.

Month	$	£	FX	$ Charge Customer	£ Post in Navision
July	1,000	650	0.65	1,000	650
August	1,000	640	0.64	984.6154	640
September	1,000	660	0.66	1015.385	660
October	1,000	700	0.7	1076.923	700

We're using Lanham's eShip and invoicing when the sales order lines are posted. We're using Chargelogic Version 4.00.05.00.

Thank You!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

CDsilva 4,188 on at

Like (0)

Report

As ChargeLogic is an addon, I feel you need to raise a ticket and discuss with ChargeLogic support about your requirement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It's very difficult to get help from Chargelogic. We spent a few thousand dollars with our Dynamics partner on one problem. The system was invoicing the full amount on a partial shipment when the payment method was a credit card. It took a year and a meeting at NAVUG to finally get them to realize and help. If they can't replicate on their system they are loathe to give any assistance. We have three current credit card issues with the software and I'm trying to reach out to the community for some insight. Thank you.

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (0)

Report

Hi,

It seems like that ChargeLogic calculates the FX-amount a second time based on th LCY-amount.

Do you process the Sales Order in FX or LCY?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We process the order in FX. LCY is GBP and the USD order value is calculated based on the Exchange Rate Table which we update monthly. It is calculating the FX amount a second time and changing the USD amount on the Sales Order based on the new Exchange Rate. When you manually invoice it asks you the question. Something like "Would you like to Post using the current exchange rate or the exchange rate from the month the order was placed?"

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (0)

Report

Normally, when posting a Sale Order, NAV is using the Posting Date to determine the FX-rate automatically (and doesn't ask).

The message you are describing seems to be a customization?

Your problem is complex due to involved parties (NAV, ChargeLogic + potentially individual customizations) and that's why it's difficult to resolve through a forum. I'm an independent NAV consultant based in the UK. If you like drop me a message at hello@hannesholst.com and we could discuss if and how I could help you in detail.

Was this reply helpful? Yes No