Foreign Currency in Sub-Ledgers (tricking Nav)

pengweninc

We have a client that is trying to "trick" Navision into showing the "Additional Reporting Currency" on the sub-ledgers.

The equivalent of what they want is this. Let’s say you have a USD company. All of the transactions are in the local currency (USD). No currency codes are selected, no conversion takes place. But, your accountant is more comfortable looking at CAD, and while he can see CAD reporting on the G/L, he’d like to be able to see it at the sub-ledger level as well (even though the sub-ledger transactions are in the local currency, USD, and had nothing to do with CAD).

I’m trying to “trick” the system into displaying both on the Customer and Vendor ledger entries. Any ideas?

jglathe

No way, Jose :-( Honestly. There are AddOns out there that will add FCY to the G/L, but ACY to the subledgers? In a reliable way? Nope.

pengweninc

That's pretty much what Microsoft said as well...only they were a little more eloquent. Thank you

jglathe

You're welcome There's a reason for the fast "no". I've done this for a G/L subledger (open items, full FCY/LCY/ACY support). What it boils down to is that you have to maintain the application in three currencies. And when you adjust ACY, you have to maintain the state of the open items, remainig amount, application amounts, adjustments and so on, like it's done for FCY and the customer/vendor open items. You have to be a bit masochistic to pull this through.