Can any one give light in the matter of po creation .
we had paid in advance for fuel filling to our vehicles.the price is varing after advance paid .now after 90 days our advance amount is nullified. the fuel consumed for different departments(cost centers).there are around 500 entries by each day consumption and different departments at different rates.we prepared excel sheet for this .is there any option to upload the excel sheet without entering all details to made po.
There is no standard SAP way.
You can do with custom programs: Through ABAP, you can create a program where excel file will be uploaded and create a PO in background. You can use FM BAPI_CREATE_PO1.
Note: Header information should be avialable in that file othherwise you can take input through parameter of customer report.
Hope it will help to solve the problem.