automatic Invoice from data file

[Former Member]

Hi everybody,

As per the requirement of our client Pgi will be done in a 3rd party system & they also do the billing & will generate a invoice no. & they will send those data in a exel format to our SAP.

against that invoice no.& given data system will automatic do invoice processing.while creating billing it should refer to the original delivery doc(we have to consider both the things reference delivery doc & data file from third party system)

can anybody please suggest how to go with this process?

Thanks in advance

Susrikant

[Former Member]

Dear susrikant,

1.Upload XL file and read through prog.

2.Call sales order ,delivery and billing in backround through BDC .

3. You can use the LIKP-LIFEX ( goto header - administration - field name 'Ext.delivery' ) to store the client delivery as reference document from which you can identity the SAP document in future or reporting purpose.

4.Suggesstion : when you read XL file , you can display as ALV report sothat if any data error in XL file , you can identify and the process for automation .

5.Use transactin SHDB for recording salesorder, delivery and billing processing and go to ABAPer for coding in SAP .

Please revert , if any clarification required

saravanan

[Former Member]

Dear saravanan,

Thanks a lot for ur suggestion

there is a small differnce Whatever update we receive will be through an XML format not in XL format still the process remains the same?

regards

susrikant

[Former Member]

No it is not for XML .

If it is XML , then go far RFC , access its database and get the data and display in ALV listing . You can do this either by scheduling or as a user end also.

saravanan

[Former Member]

please give some advice, i want some ideas it may or may not be relevant every ideas are welcome.

i know EDI will surly come into picture.if anybody having this type of experience or document then that will be helful.

Answers will be rewarded.

thanks

susrikant

[Former Member]

can anybody give me a opinion on this?

susrikant

[Former Member]

hi,

for this purpose, u need to get the help from an ABAP person. You hv to tell him the logic, what are the datas u want to pick from the third party excel sheet.

other option will be u hv to use EDI for this purpose.

Regards,