Foreign Currency in Sub-Ledgers (tricking Nav)

pengweninc
pengweninc Member Posts: 38
edited 2015-07-20 in NAV/Navision Classic Client
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?

Comments

  • jglathe
    jglathe Member Posts: 639
    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
    pengweninc Member Posts: 38
    That's pretty much what Microsoft said as well...only they were a little more eloquent. Thank you :D
  • jglathe
    jglathe Member Posts: 639
    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. :mrgreen:

Categories