Open item upload

[Former Member]

Hi gurus,

Can anyone assist with the procedure to do an open items upload?

Regards

[Former Member · Accepted solution]

Hi Victor,

You can use LSMW or BDC to upload the transaction data.

Let me explain you the procedure for the vendor open items.

For uploading any legacy data, you have to create an uploading GL account. Say, for vendor open items, you can create a Vendor uploading GL.

Now, for Invoice open items, the posting should be as follows-

Posting = Debit

Posting key = 40

Gl a/c = uplaod GL a/c

Posting = Credit

Posting key = 31

Gl a/c = Vendor a/c

For Advances made-

Posting = Debit

Posting key = 29A (A is the spl GL indicator)

Gl a/c = vendor a/c

Posting = Credit

Posting key = 50

Gl a/c = upload GL a/c

Hope this gives you a picture of the open items upload. If you have more questions, kindly revert.

Regards,

Mike

[Former Member · Accepted solution]

Thanks - problem solved