LSMW upload for Vendor and Customer Open items

[Former Member]

Hi Experts,

1. I wanted to use to use LSMW to upload through FB60 for Vendor Invoices through recording, but the problem is Amount in Document Currency is 'USD' and Amount in Local Currency is 'INR'. While recording it is not allowing to input values in Amount in Local Currency while my upload file has values in both Amount in document currency as well as Amount in Local currency. Any help with this regards?

2. Do i need to open the all fiscal years which are there in upload file?

3. Any better option to upload the Balances with LSMW?

Any useful information will be Highly appreciated.

Thanks in Advance

[Former Member · Accepted solution]

Hi Rajkumar,

To upload Open items of Vendor and Customers, in LSMW, you will have two files header and line items with a link linking both the files.

Now, Suppose if you have to enter an amount in USD, then in the header file, enter USD in the currency field and give Exchange rate also in the header file and give the exact exchange rate which should be the value of your Amount in Local Currency INR.

In such cases, you do not enter directly the amount in local currency field.. It is a calculated figure..

Yes, depending on the posting date, all those fiscal years need to e open for which you are posting the data.

LSMW is a tried and tested method for uploading open items.. Simple Go Ahead...

Regards,

SAPFICO

[Former Member · Accepted solution]

Hi SAP FICO,

Thanks for the suggestion, i will get back after testing the solution.

Raj

[kim_khan · Accepted solution]

U Rock Raj

[iklovski]

Don't use recording; it's better to use BAPI method in LSMW for such an upload.

[Former Member]

Hi Eli Klovski,

Please can be give more understanding of BAPI and its steps to follow to execute with related to Vendor open items.

Thanks

Raj