Material Value in Delivery Printout

[Former Member]

Hi Friends,

We have a process wherein we create the Sales Order and Delivery Challan for each delivery. We do not create Billing for each Delivery/SO as we run a program at the month end and we create a consolidated Invoice for all the transactions/deliveries done in a month. Also these goods that we supply to our customers are on RENT and NOT FOR SALE.

Now the problem is that since we are not able to capture the value in the SAP delivery we are creating manual hand written challans. And there is a good volume of deliveries in a day. Further problem is sometimes the qty entered in SAP does not match the qty written in challan....

Is there any way thru which we can capture the value of material on the SAP delivery print. Or any other process by which we can avoid manual challans?

Thanks,

SSK

[former_member266852]

Hii

For the same you have to create one Smartform where you have to give one logic that the multiply the delivery qty from LIPS table then pass the delivery number in VBFA table with preceding document number (sales order number) get the document condition number VBAK-KNUMV pass the same in KONV table and based on POSNR (Item number) get the material rate (KWERT) and multiply the same with delivery quantity and get it printi in delivery challan against material

Hope it will solve the problem

Regards

Shambhu

[jignesh_mehta3]

Hello,

The SAP Delivery Output is a Smartform (SAPScript in older SAP versions) which is assigned to Print Program & Delivery Output Type. This Smartforms is nothing but a Z-program which is custom developed just like Z-Reports where SAP Standard is not sufficient.

Now the Value posted in Accounts (Delivery Accounting entry) when you Post Goods Issue is the Cost of Goods Sold, which I am sure you would not like to Print on Delivery Output. In your case you would like to print the Sales Value of the material.

All you need to do is design the Layout the Delivery Output with the Client & the approach your ABAPer. Ask him to fetch the Price of the Material from Sales Order & Print the same in Delivery Output based on Delivery Quantities. For this you might have to give him the details of LIKP, LIPS, VBRP & KONP / KONP Tables.

Hope this clarifies,

Thanks,

Jignesh Mehta

[od_manikandan]

Hai Sarvesh,

Make a output smartform for delivery.

and in that capture the qunaity from delivery and rate from sales order pricing condition.

MAKE SURE THE CHALLAN WILL BE REPLACED BY DELIVERY OUTPUT PRINT OUTPUT

and no goods go out with MANUAL CHALLAN

In the output, record all the time of creation and change.

Give authorization to two user for create and change.

Else identified a text field in delivery item level and train user to enter the value there and use in the output program.

Regards,

Mani

[Former Member]

Yes, you can write logic in your output program to capture the material net price from sales order, you need to use table VBFA/VBAK/KONV ect, ask your abaper to write logic to get values from order.

[jpfriends079]

Hello,

You can try this by creating 'Z' Output Type and take assistance of an ABAPer in your team to create SMARTFORM as per your business requirement.

Thanks & Regards

JP