Automatic posting of accounting document from excel into sap (F-02).

[satendra_sapco]

Requirement:

My client currently doing JV entry posting by manually and they want to post JV now automatically . we tried in bdc but it worked to generate single document number but our client wants to multiple document document number (say for example if they gives 10 lines items means first 5 needs to generate one document number and next 5 line item needs to generate another document number )
Please suggest me the possible methods to solve this
Regards
Satendra

[raymond_giuseppi · Accepted solution]

Better use some BAPI like BAPI_ACC_DOCUMENT_POST than BDC.

If, for any reason whatsoever, you want a BDC, don't build it yourself but use following FMs, you won't have to worry for dynpro number.

• POSTING_INTERFACE_START
• POSTING_INTERFACE_DOCUMENT
• POSTING_INTERFACE_END

Hint: In the Excel sheet provide a column for document break /or/ sum debit/credit amounts (document and company currencies) and close current document when balanced and open another if not last line.

[VenkatRamesh_V]

Hi,

use BAPI BAPI_ACC_DOCUMENT_POST

Regards,

Venkat.

[TammyPowlas]

I am not a big fan of this, but we use an LSMW to upload journal entries - it works fine. There are several posts to walk you through this - just search LSMW FB50