Exchange Rate Differences Problem on Execution Date

[Former Member]

Hello experts,

My client have a problem in exchange rate difference, if they want to adjust receivables or payable account they only adjust for posting date not based on due date transaction. But in exchange rate differences only display receivable or payable account base on due date transaction not for posting date of the transaction.

Example :

AR Invoice transaction:

ar invoice posting date 02.07.2012

ar invoice due date 02.08.2012

Exchange Rate Differences

Execution Date 1-----> 02.07.2012

Execution Date 2-----> 02.08.2012

Result execution date 1 ----> data is not available.

Result execution date 2 ----> show the data, can process the differences

Does anybody know how to solve this problem?

Thanks

[julie_jamieson2]

Hi Deasy,

It makes sense that there is no revaluation at posting date, as the document is valued at the rate in the system for that date on entering it.

The revaluation process calculates changes in value from that point onwards to the new rate you set, then, on closing the document, any changes are calculated and journalled in the system.

[Former Member]

Hello Julie,

Thanks for your point of view.

But how about:

There are invoice which due date are in the next month, not include in exchange rate differences which execution date on closing period (the end of month). That made my client adjust the exchange rate manually.

[julie_jamieson2]

If these documents have been paid between month end and execution date, has the cutomer ticked the "Consider reconciliation date" check box?

[Former Member]

julie,

yes it is but still no data available on exchange rate differences

[julie_jamieson2]

I have checked with my customers who run these monthly, they leave the date range blank and enter only the execution date, and tick consideer reconciliation date. The jopournals are flagged as reversing.

[Former Member]

yeah thanks julie, i already done that.

Maybe i want to upgrade pl of my database to test again this scenario.

[julie_jamieson2]

If your execution date is the invoice date, there will be no difference to post, as there are no days to adjust for. If you have execution date as 31/7/12, does your invoice appear?

[KennedyT21]

HI Deasy Witono

There are two different posting logics for balancing exchange rate differences. You can either use the standard posting logic or the alternative posting logic, depending on the requested time of the material valuation: Using the standard logic, the system valuates an external procurement with the exchange rate of the invoice receipt date. The alternative posting logic uses the exchange rate of the goods receipt date. This means that the system valuates identical business processes differently due to the different times of valuation.

Check with the link to understand better.

http://help.sap.com/saphelp_erp60_sp/helpdata/en/45/5c4a52eedd2f95e10000000a155369/content.htm

Regards

Kennedy

[Former Member]

Kennedy,

For what localization did you send in the link above?

My localization is australia and im confuse about prerequisites and integration which you send.

Thanks

[former_member186095]

Hi Deasy,

What version of SAP B1 are you using ?

Check if the user has entered the date in the posting date field, i.e.execution date field.

Smoga berhasil (good luck)

Regards,

JM

[Former Member]

Hello Jim,

SAP Business One 8.82 (8.82.064) PL: 03, yes i have try by myself.

i have entered the posting date field in ar invoice and execution date on exchange rate differences.

the result is still the same like my example above.

[former_member186095]

Hi Deasy,

If you still use SAP B1 8.82PL03, I am afraid it is probably bugs.

You may check if the issue also happened in the SAP B1 8.82 PL04 and higher versions.

The official version of SAP B1 is starting from 8.82 PL04. The 8.82 PL03 was a ramp up version.

You may use development server to check the issue.

Good luck

Rgds,

JM

[Former Member]

hello jimmy,

i think its not bug, because i have tested the scenario in pl below and 8.82 pl 7 and the result on exchange rate differences still like my above mention.

Thanks anyway.

[former_member186095]

Hi,

You may try this following selection criteria :

What is the result ? Is the difference be able to processed ?

Rgd,

JM

[Former Member]

jim, i have done selection criteria like your screen shot and

exchange rate differences show the data, but my invoice data didn't there. It only show other transaction which i have ticked (all gl account).

So my assumption because of gl account, after that i have change my tick in business partner but the result still the same "data is not available."

[former_member186095]

Hi Deasy,

I am afraid it is probably bugs. You may log a message to sap support in order to solve this issue.

Regads,

JM