Re: [sap-acct] value date at the time of clearing
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by ron.roberts (Senior SAP FI/CO Consultant) on Aug 6 at 1:40 AM |  Mark as helpful |
Sorry for the delayed response, but I was ending an assignment and took some
days off.
yes, the posting date is the key date for determining the currency exchange
rate in SAP. That is standard SAP.
If you are entering the bank statement mechanically, can you get yourt bank
to place the value date into the posting date field? This may create more
accounting documents, but give you the exchange rate that you desire. Just
a thought....
On Fri, Jul 31, 2009 at 12:01 AM, MIG via sap-acct <
sap-acct@groups.ittoolbox.com> wrote:
> Posted by MIG
> on Jul 31 at 1:02 AM Thx
> Ron for your reply...
> The gain/loss being created in in local currency only, and there lies the
> problem. If we see in foreign currency, the bank gl is zero balance but when
> seen in local currency it shows some gain/loss amount as remaining balance.
> We also came to this conclusion that this is the SAP standard. To overcome
> the issue, we have created new document type for bank recon, and have
> defaulted bank Buying rate on it.
> This is now picking the correct rate type but one issue remains. It is
> picking the rate that is on the posting date of statement. We are entering
> weekly statements and want the system to post the clearing transaction by
> picking the rate on the value date, the date which is entered on each
> statement line item.
> Please tell me this is possible :-|
__.____._ days off.
yes, the posting date is the key date for determining the currency exchange
rate in SAP. That is standard SAP.
If you are entering the bank statement mechanically, can you get yourt bank
to place the value date into the posting date field? This may create more
accounting documents, but give you the exchange rate that you desire. Just
a thought....
On Fri, Jul 31, 2009 at 12:01 AM, MIG via sap-acct <
sap-acct@groups.ittoolbox.com> wrote:
> Posted by MIG
> on Jul 31 at 1:02 AM Thx
> Ron for your reply...
> The gain/loss being created in in local currency only, and there lies the
> problem. If we see in foreign currency, the bank gl is zero balance but when
> seen in local currency it shows some gain/loss amount as remaining balance.
> We also came to this conclusion that this is the SAP standard. To overcome
> the issue, we have created new document type for bank recon, and have
> defaulted bank Buying rate on it.
> This is now picking the correct rate type but one issue remains. It is
> picking the rate that is on the posting date of statement. We are entering
> weekly statements and want the system to post the clearing transaction by
> picking the rate on the value date, the date which is entered on each
> statement line item.
> Please tell me this is possible :-|
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
ron.robertsSAP Accounting Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
