topic Re: Error in transaction currency while posting GL open items in Application Development and Automation Discussions

Error in transaction currency while posting GL open items

Former Member — Tue, 15 Dec 2009 09:31:19 GMT

Hello,

I have made an LSMW template to upload GL open items data; the flat files are perfectly getting converted but while uploading, I encounter error messages stating;

Message type      Message ID           Message No             Message Text
E                             RW                         609	[FI]:Error in document: BKPFF $ <CLNTNAME>
E	          F5                          702	[FI]:Balance in transaction currency

Please help me resolve this issue.

Thanks,

Zahack

Re: Error in transaction currency while posting GL open items

Former Member — Tue, 15 Dec 2009 09:46:48 GMT

Hi Zahack,

Can you please se for which it is giving this error ??

When you find the erroneous record,

use its values while manually trying to upload through transaction FB01 and

there you can see if you get the same error and then see the detail of that error by double clicking on it.

let me know !!

Regards,

Salil.

Re: Error in transaction currency while posting GL open items

Former Member — Tue, 15 Dec 2009 10:40:02 GMT

Hello Salil,

I upload a flat file with amount in document currency as 249 EUR for instance and it supposed that by giving the exchange rate; it'll gonna calculate amount in local currency; so I dont provide amount in local currency.

When I upload this file; it's getting converted but not getting uploaded and giving me the error balance in transaction currency.

Re: Error in transaction currency while posting GL open items

Former Member — Tue, 15 Dec 2009 15:15:02 GMT

Well Salil,

Thanks for your reply;

Actually; i got to manually assign -1 for the next line item for credit; for that I got to go to 5th step of LSMW; at WRBTR field; I had to run a select from tbsl table to check for bschl and shkzg fields; and then make an if; whether shkzg is 'H' - Credit type; if it is then bbseg-wrbtr = bbseg-wrbtr * -1. This resolved the issue.

Well, this can also help developers working with the GL open items.