Skip to Content
author's profile photo Former Member
Former Member

Update LineNum in Sales Order line Details

Dear All,

I have imported a sales order into a database from another database on SAP B1 2005A using DTW. The sales order has only one line item.

However, after importing, the linenum of the target table RDR1 is 0 while the source has it as 1. All the other fields have been updated with the correct data.

I am trying to update the same sales order's LineNum to 1 using DTW with the 'update' option ticked and the process runs successfully. However upon checking the database I find out that it has added another line item with the same details. Can a linenum field be changed/updated? The reason behind my need to change the linenum is because after trying to import a sales delivery linking it to that sales order it gives me an error :[DLN1.BaseEntry][Line: 1] 'No matching records found [ODBC:2028]'.

Kind Regards,

Asif

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 20, 2009 at 09:24 AM

    hi,

    While importing row level datas thru DTW,LineNum always starts from 0,1,2,3 etc.,

    Line Number can't be updated thru DTW.

    In SAP GUI row number shows as 1,2,3 etc.,

    Don't try to update line number by any another means.

    Hope it clarifies.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2009 at 11:46 PM

    Asif,

    The number of lines in the Sales Order does not neccesarily co-relate to the line number.

    Just a simple example:

    Create a Sales Order....Add a line item..add Sales Order

    Open the same sales order..delete the line item (delete row) and add the same item / another item. Though the Sales Order seems to have only one item..now if you check RDR1 the linenum would be 1.

    The architecture of SAP B1 is to generate a new linenum each time you add a row.

    Thats probably why you are seeing the difference.

    If you want to match the target linenum. simply delete the row and add the same line item and Update SO.

    DTW will not update the linenum as it is system managed.

    My recommendation for your situation is - if you do not have the same item more than once on a Sales Order - then it is better to get the BaseLine from the Database you imported the Sales Orders to.

    Let me know if you need any further direction with this.

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Suda,

      Thanks for your reply.

      The first option you have suggested by deleting rows and adding the same item again would change the linenum thus helping me to link the delveries extracted from the source database. But this, I understand, is a long process if we are considering around 3000 sales orders thereafter linking around 4000 deliveries to these sales orders.

      We do not have the same Item more than once in any sales order. The BaseLine from the Database I imported the Sales Orders to has some different numbers to the deliveries i want to import the database from. Is there an easier way to get the correct baseline so that i can import the sales deliveries linking to the sales orders successfully?

      Kind Regards,

      Asif

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.