6 Replies Latest reply on Jan 5, 2009 6:46 PM by 517519

    PO Distribution Account Update

    PavanVasireddy
      Hi All,

      We have a requirement to update the Charge and Variance Accounts for existing Purchase Orders at the Distribution level.

      While processing the PO for the update, the Import Standard Purchase Orders program is rejecting the records with the following error:

      Error Code: "PO_PDOI_STD_PO_LINE_NUM_EXISTS"
      Error Message: "Error: Line number populated already exists on the Standard Purchase Order"

      Can anyone let us know how resolve the above issue and proceed with updating the charge accounts on PO Distribution.

      Thanks in advance.
      Pavan Vasireddy.
        • 1. Re: PO Distribution Account Update
          517519
          we encountered the same error - does anybody know how to use the PDOI interface for updates on standard POs ?
          or alternatively an api that does updates on existing po-lines/... ?

          (instance: 11.5.10)

          thanks in advance

          regards, Gerd
          • 2. Re: PO Distribution Account Update
            628428
            I am assuming that these updates for the expense PO distributions. If yes, can you not pass the line number, but just the item and change the item description (set option to change the item description to yes) by appending with some so that the PDOI recognizes the change and updates the distributions as well?

            Thanks
            Nagamohan
            • 3. Re: PO Distribution Account Update
              PavanVasireddy
              Hi Nagamohan,

              Thank you for your response.

              I have tried by appending the item description with a string, and passing 'Yes' to create or update item parameter of the Standard PO Import program.

              The Line error got resolved, but a new PO line is being created instead of the updating the existing line.

              Pavan Vasireddy
              • 4. Re: PO Distribution Account Update
                628428
                Pavan
                Do not pass Update items as Yes. It updates or creates the item master which you do not want. Just pass the item_Id and change the description from what you have in PO to a new one by appending a string.

                Thanks
                Nagagamohan
                • 5. Re: PO Distribution Account Update
                  PavanVasireddy
                  Nagamohan,

                  I have tried passing 'No' to the create or update item parameter, even then it is creating a new PO line instead of updating the existing line.

                  Thanks in advance.

                  Pavan Vasireddy.
                  • 6. Re: PO Distribution Account Update
                    517519
                    hi,

                    thnx for your info - my problem is a little bit "more generic":
                    I have to synchronize two apps instances - that means I have to create POs (standard, blankets and releases) on the second instance. So far so good:
                    1) creating a standard po works
                    2) releases are inserted as standard pos (because there is no interface that creates releases like standard po (releases are created directly from requisition)) - or at least I do not find out how.
                    3) updating -> on the source instance changes in the standard po might occur - then new release numbers are created. when I try to create these releases with the PDOI i get the error with the line (nevertheless I used another revision!)

                    so my basic question is: is it possible to create standard POs with revisions with the PDOI - or is there another interface to do the updates?

                    regards, Gerd