Sage 100

 View Only
  • 1.  I have a client that needs to change a bunch of pu

    Posted 03-20-2014 10:01
    I have a client that needs to change a bunch of purchase orders from Backordered Status to Completed. I tried to do this with VI, but get a message that says the status cannot be changed. Is there a way to remove the validation that is being done here? They realize that we will have to adjust the purchases clearing acct etc. manually.


  • 2.  RE: I have a client that needs to change a bunch of pu

    Posted 03-20-2014 10:03
    What version?


  • 3.  RE: I have a client that needs to change a bunch of pu

    Posted 03-20-2014 10:03
    I believe when I did this in VI for a client I forced the BO Qty to 0 in addition to the status.


  • 4.  RE: I have a client that needs to change a bunch of pu

    Posted 03-20-2014 10:03
    4.5


  • 5.  RE: I have a client that needs to change a bunch of pu

    Posted 03-20-2014 12:58
    Isn't the issue that so long as there are line items which are under-received the status keeps flipping to BO. I've had this several times and believe that that was always the challenge. Can't remember if there's a good workaround.


  • 6.  RE: I have a client that needs to change a bunch of pu

    Posted 03-20-2014 13:56
    I did what Chris suggested and made the BO qty0 and the received and invoiced quantity and amounts the same as the ordered quantity. I had to DFDM the dde file to allow me to import into the qty received, the received amt and the invoiced amt.


  • 7.  RE: I have a client that needs to change a bunch of pu

    Posted 03-20-2014 18:18
    In v4.4 when PO'w went to the framework, you no longer could use VI to change this flag from BO to complete. However, as it has been posted here several times, you can hack the data dictionary to allow this. Unfortunately, I don't know the hack, but maybe someone more knowledgeable can post. This would be one that I make a note of for future use.