Sage 100

 View Only

  • 1.  I tried doing a VI to change all purchase orders t

    Posted 03-04-2012 05:52
    I tried doing a VI to change all purchase orders to type ""S"". They were originally entered as ""D"". However, it automatically changed the ship to address to the address of the company. I need the ship to address to remain unchanged. I am obviously missing a simple step in the import.


  • 2.  RE: I tried doing a VI to change all purchase orders t

    Posted 03-04-2012 06:05
    Version? Delete all fields from the vi job except the key field and the one(s) you want to update.


  • 3.  RE: I tried doing a VI to change all purchase orders t

    Posted 03-04-2012 06:40
    ver 4.5. There are only 2 fields in the VI, the PO number and the type. The txt file it uses has this sructure PurchaseOrderNo,OrderType, The orderno is replace and the type is assign


  • 4.  RE: I tried doing a VI to change all purchase orders t

    Posted 03-04-2012 08:20
    Import the address too.


  • 5.  RE: I tried doing a VI to change all purchase orders t

    Posted 03-04-2012 08:26
    Thanks I figured I could do that I was just wondering why I would need to. Is there something behind the scenes that as soon as the type is changed to ""S"" it should change the ship to address? It doesnt make sense since they could originally create a po with ""S"" and the drop ship address. The main issue is they want to do a ROG (They have a DS warehouse) which is not allowed with a ""D"" type PO.


Related Content