Purchase Order import - sequence numbers

SOLVED

Is it possible to import purchase orders and assign the PO number at the time of import.  These PO's are coming over from the retired system and we do not want to use the sequence as part of the import.  Looking at KB 95260 it implies this is not possible.  

  • 0
    SUGGESTED

    Hello,

    I am not able to find the KB 95260.

    Have you tried to remove the POHNUM field from the standard POH import template ?

    While importing your file, the system might generate automatically the identifiers of the POs.

    Regards

  • +1
    verified answer

    Hi Kyle,

    We have our Sage X3 (ver. 9) configured so that the system will allow manual Purchase Order Number (POHNUM) entry or will use the sequence number format we have defined in Setup> General parameters> Sequence number definition.  To allow manual entry of the Purchase Order Number, you need to set the "Manual" flag under Sequence number assignment to "Yes".  

    Manual Seq. No. Assignment

    This should provide the flexibility of importing pre-defined PO numbers (as long as they don't conflict with any existing PO) and allowing the system to auto-generate PO numbers in the future.

  • 0 in reply to hkopec

    I had tried that, but was getting the following "A Sequence number must be assigned to each document".  I thought it was because I had set it to no, however there were some new documents on the next page that had not been assigned sequence numbers yet.  Thank you hkopec