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

RDR1.GrossBuyPr 'Field cannot be updated' error : Sales Order DTW update

Hi all.

This is my first post, so please be gentle :-).

I am attempting to update the unit prices on a bunch of Sales Orders via DTW.

Some items update successfully, but some do not, failing with the error :

RDR1.GrossBuyPr line: x, 'Field cannot be updated (ODBC -1029)'Application-defined or object-defined erroroOrders

I am not attempting to modify this column, although I am guessing that this is calculated by Business One internally.

I am using 2 tab-delimited files :

Documents.txt, which contains the RecordKey & DocEntry columns.

Documents_Lines.txt, which at the moment contains RecordKey, LineNum, UnitPrice & ItemCode.

I have tried it with the UnitPrice column renamed to Price, and with and without the ItemCode column present, and they give exactly the same error.

If I remove the price column completely, then it works (but nothing has updated, obviously).

I have searched the forums, the only thing I can see that comes close is the UnitPrice / Price renaming.

Or am I going about this the wrong way? The prices that I want to import already exist as a price list, and we can manually change these in Business One by going Form Settings -> Price List when in a Sales Order, but I am unsure how to do this via DTW. There are approx 3000 items that need changing, so doing it manually is not really an option.

Grateful for any and all help.

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 04:53 PM

    Something to confirm. Are those sales orders brand new? I mean: there are no target documents at all.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 09:21 PM

    Hi Roger,

    What percentage of your records can be updated? If it is not too small, chances are you have problem with your file format. Do you save file as CSV instead of Tab Delimited Text format? You should use later to try.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 03:55 PM

    Forum does not support attaching any files. Copy & paste few lines from your files please.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Here you go....

      Documents.txt :

      RecordKey DocEntry

      RecordKey DocEntry

      0 18664

      1 19397

      2 19578

      3 20804

      4 20808

      5 20884

      6 21114

      7 21801

      8 22222

      9 22390

      10 22455

      11 22513

      12 22889

      Document_Lines.txt :

      RecordKey LineNum UnitPrice

      RecordKey LineNum UnitPrice

      0 0 22.000000

      1 2 49.000000

      2 0 0

      3 0 109.000000

      3 1 115.000000

      3 2 98.000000

      3 3 104.000000

      3 4 159.000000

      3 5 32.000000

      3 6 41.000000

      3 7 82.000000

      4 0 131.000000

      5 0 207.000000

      6 4 49.000000

      7 0 87.511900

      8 0 72.000000

      9 1 306.000000

      10 5 0.000000

      11 0 58.000000

      12 4 1.000000

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.