Sage 100

 View Only
  • 1.  Have a client with an Inventory Transaction batch

    Posted 11-07-2017 05:19
    Have a client with an Inventory Transaction batch he was updating from home and lost connection during the update. Batch now says it's Updating and I can't find anyway to change it. You can't select it to get the Restart prompt, the GL_CompanyBatch file has """" as the status, the TransactionRestart file is empty, the Reset option on the batch selection screen doesn't work because you can't select the danged thing in the first place. HELP - where can I go behind the scenes and change the status?


  • 2.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 06:11
    Can you reboot the server?


  • 3.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 06:13
    That was the suggestion on Sage's website and I'm trying hard to keep away from that option. Lots of users all over the place. :-(


  • 4.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 07:01
    use DFDM and look at GL_CompanyActiveBatch - field Status


  • 5.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 07:02
    sorry, Field = ""BatchStatus


  • 6.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 07:06
    @DavidOverholt - it's blank


  • 7.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 07:14
    sorry, I see that in your post now. I didn't read close enough. does the update show in master console?


  • 8.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 07:20
    GOOD THOUGHT!!!!!!!!!!!!!!!!! Am looking now!


  • 9.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 08:21
    You can also check IM_TransactionRestart.M4T


  • 10.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 08:32
    @KennethPhillips - I had already checked it, it was blank. But @DavidOverholt has redeemed himself for not reading my post...LOL - it was still running in Master Console and all is well now. The client and I were both going ""DOH, why didn't we look there first?"" THANKS!


  • 11.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 09:35
    So Beth, I'm curious. By looking in Master Console, are you just verifying that it's still running, or is there some hidden feature I am unaware of, that lets you restart the batch or something?


  • 12.  RE: Have a client with an Inventory Transaction batch

    Posted 11-07-2017 09:55
    Once we killed it in Master Console, it let us do the Restart like normal. I did see on Sage's website that there is as Reset button (on the right side in the listing of batches available) that can change a status. Never knew that.