Sage 100

 View Only

  • 1.  Sage 100 2014 Standard - customer is receiving Err

    Posted 03-20-2018 15:38
    Sage 100 2014 Standard - customer is receiving Error 11 Record Not Found Or Duplicate Key On Write Program: SO_SalesOrderDetail_BUS.PVC Line 0613 When they try to post an invoice batch The Sage KB is silent on this particular error. Any ideas short of rebuilding everything ?


  • 2.  RE: Sage 100 2014 Standard - customer is receiving Err

    Posted 03-20-2018 15:40
    Also receiving an Error 14 SO_SalesOrderHistory.PVC at line 0437


  • 3.  RE: Sage 100 2014 Standard - customer is receiving Err

    Posted 03-20-2018 16:11
    How many invoices are there? I am not 100% on this, but I think I had an error similar to the this and it was missing the Order Status in DFDM. Can you export the data and look for missing info? That might take longer than a rebuild.


  • 4.  RE: Sage 100 2014 Standard - customer is receiving Err

    Posted 03-20-2018 16:47
    Not a lot of invoices but they have tons of history so the rebuild is dragging on. They got to the update part and now it keeps wanting to restart when going back to the invoice.


  • 5.  RE: Sage 100 2014 Standard - customer is receiving Err

    Posted 03-20-2018 17:56
    Not sure but rebuilt sorts may have fixed this. There also could have been some type file locking issue by a third party app (Master Console showed nobody in there).


  • 6.  RE: Sage 100 2014 Standard - customer is receiving Err

    Posted 03-21-2018 14:07
    Wayne, if you want to send me that program, I can tell you exactly which file.


  • 7.  RE: Sage 100 2014 Standard - customer is receiving Err

    Posted 03-21-2018 17:32
    Thanks, Marcos. After rebuilding sorts the process completed. I'm not sure what got hung up but they are back and running.


Related Content