Foreign currency revaluation,

(0) Share

Report

Posted on by Community Member

Hi experts,

I have some problems with Foreign currency revaluation for Account receivable. When I run Foreign currency revaluation for account receivable, it revaluate all customer transactions but I don't want to take part of customer's prepayment. Anybody has an idea to do this??

I’m extremely grateful for your help. Thanks in advanced

Best regards,

Huyen

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

Daxer Persson 3,005 on at

Like (1)

Report

You need to let AX know / identify what a prepayment is ? Is it based on e.g. voucher series - invoice number - prepayment journal voucher or other as seen from your point? Possibly you can see from transactions to be excluded?

Once you know this then in the Foreign currency revaluation form you can filter on transactions to be excluded with these data (use ! in front of value).

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Standard AX does not support your requirement.

Was this reply helpful? Yes No
Daxer Persson 3,005 on at

Like (0)

Report

Hm...

Looking into the issue again - as Lally - had a different view to it.... Hm... Thanks Lally for this!

I must admit that your requirement is not supported directly....

Only a few fields from customer transactions are supported for limiting the transactions found. And eg. voucher number nor prepayment field not among those.

NB: Still good to fillter on currency from transactions rather than main account.

However the button Simulation offer a whole list of fields from Customer transactions (so not limitng to the few for the actual simulation). Possibly you can use this report generated in order to do some corrections as to not requiring the total transactions part of the currency revaluation?

NB: "Normal" revaluation is about ensuring that the amount in Company currency in AR-module is same as amount in main account in GL based on a "specific rate". Therefore all transactions should be considered - as to "normal" practice.

Why would you want to exclude prepayments ?

NB: Sorry, but I'm from Europe not knowing so much about your "local" requirements.

Thanks.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Huyen,

lally seem right. Yet, I am wondering about your Business requirement. Why would one exclude prepayments made by customers from foreign currency revaluation? Aren't those amount subject to the same exchange rate risk as any other ordinary open customer balance?

Would be very much interested in the underlying reason for this request.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Daxer Persson,

I've tried your way but failed because the Posting profile in Foreign currency revaluation use to record the foreign currency revaluation transactions not used to filter transactions revaluation.

Best regards,

Huyen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Lally

Thanks for your answer, it is useful for me,

Best regards,

Huyen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Daxer Person,

Thanks for your answer, it is useful for me,

Best regards,

Huyen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig Reinhard,

Because my client requests it, I don't know why they ask for it.

Thanks for your answer, it is useful for me,

Best ragards,

Huyen

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello huyentran450,

Maybe you have the chance finding out why your client requests this?

I believe that it might help us understanding more and probably finding a workaround that might help.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig Reinhard,

thank you very much,

Best regards

Huyen

Was this reply helpful? Yes No