Is it possible to show extended prices at a rate of 2.7 on invoices from OE but have a rate of 2.6882 go to AR and the GL as the sale price?

Hi Ishana,

Unless I'm understanding your need incorrectly, I'd say the answer is no as that would seem to defy the integrity of the accounting data between the modules which should try to ensure that what was billed is exactly what tracks through to the AR and GL, and that the Sub and General Ledgers remain in balance

Pete

Ishana:

Please explain what you are trying to accomplish, maybe someone will be able to suggest an alternative.

The client wants to bill from Order Entry at a rate of 2.7 for each US dollar. However, they want the price that is going over to AR and the Ledger to be at a rate of 2.6882.

At first as per their initial explanation to me was that they wanted to bill all their EC clients at a rate of 2.7 instead of the usual 2.6882 which is what is being used in other modules as well as the ledger, so of course the only modules this could be accomplished with is OE and AR.

I created a special rate in Multi-currency to facilitate this and change the control account set to reflect this and the invoices were being converted at a rate of 2.7 and the US value that went to the ledger is at 2.7. However now the client is stating that they don't want invoices going to AR and the ledger at a rate of 2.7 but at it's usual rate of 2.6882., but still want the invoice to reflect a rate of 2.7.

I tried to explain the the client that this is not possible, the sub-ledgers would be in accurate and once the bill is done there is no way to change the figures unless done manually, but this would mean that AR doesn't match OE with the audit lists amounts and the Ledger would not match Order Entry figures as well.

Still he insists that this can be done so I am asking to cover all the angles, as I agree with Pete's response about the integrity of the data.

While this can't be done from Adagio, or any other accounting software that I'm aware o as this effectively contravenes GAAP, there is nothing to stop your client from revaluing AR & GL afterwards (issue the invoices at 2.7 and the revalue to 2.6882). This would book the necessary foreign exchange adjustment, something that I suspect your client doesn't want to see.

Another option would be to issue the invoice at 2.6882 but then use PrintBoss to change the math on the printed document (invoice).

What does your client expect to accomplish from this exercise? At the end of the day if your client receives payment at 2.7, it's in AR at 2.6882.