Skip to Content

How we can update the weight of material

Hi,

We create a material by mistake without net weight and create sale order, delivery order and invoice. now we required to update weight in these documents.i already cancel the invoice(billing document) and update in the material master but i can't update it in the sale order. there are more then 150 billing documents. how i can update it with easy way.

Regards

Khan

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2012 at 03:04 PM

    Hi Muhammad ,

    As other member suggested, the fix has to be done manually. Since it is manual work, it involves lot of effort.

    To minimize the effort, understand the significance of the weight in the process? Do you want to appear on the Output? Is transportation cost base on the weight?

    . Most of the time as per my understanding, it is used in the Delivery Note Output. It is critical to show the weight in the Delivery Note if it is a export process as a legal requirement.

    So talk with the business and understand the importance of the weight field and based on it, decide to do the changes.

    In your client, it is important to have weight only in export process. If i face such a scenario, I will identify the delivery related to export and update the weight in the delivery document manually.

    Make sure the weight in the material master is maintained on a regular basis so that these issues can be avoided. If possible make the weight field mandatory in the material master.

    Regards

    Vinu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2012 at 07:07 AM

    Dear Muhammad

    if its for single sale order then

    Go to your sale order, double click on line item and on shipping tab add manually.

    Else you can create a BAPI with your ABAPER "BAPI_SALESORDER_CHANGE" where with the reference of sale order you do the updating.

    Thanking you!

    Ashish Mishra

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 21, 2012 at 07:14 AM

    Hi ,

    Please think about Debugging in Table Level to update the Values.

    Side Comment : I am not sure ,this is good or any effect on system performance .Lets wait ,may some more experts would give their ideas on this.

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 21, 2012 at 07:19 AM

    Hello,

    As the PGI is already done for Delivery, you cannot change the Weight in Sales Documents.

    You will have to reverse the entire cycle (Invoice, PGI & Delivery) and then try to change in Sales Order or create a new Order.

    Also I dont think there is any other easy way to correct this mistake.

    Thanks,

    Jignesh Mehta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2012 at 05:12 PM

    Hi Muhammad ,

    Try LSMW or Custom Program to update the weight in the existing Delivery Document.

    Regards

    Vinu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dears,

      Understand this thread is very old. But for the benefit of whoever searches this thread again.

      The report program WSLIPS03 may be used to update the delivery (came across from another thread).

      Is there similar one for Invoice?

      -S.N.Jayaraman

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.