Sage 100

 View Only

  • 1.  2017 Premium (SQL) printing a SO Picking Sheet.

    Posted 09-05-2017 08:57
    2017 Premium (SQL) printing a SO Picking Sheet. Where is the SO_PickSheetWrkxxxxxxxxxxxxx work file get stored? I need to look at it.


  • 2.  RE: 2017 Premium (SQL) printing a SO Picking Sheet.

    Posted 09-05-2017 08:59
    Work files for Premium are in tempdb


  • 3.  RE: 2017 Premium (SQL) printing a SO Picking Sheet.

    Posted 09-05-2017 09:06
    trying to run a query on it but cant seem to be able to do it. Any suggestions?


  • 4.  RE: 2017 Premium (SQL) printing a SO Picking Sheet.

    Posted 09-05-2017 09:59
    You have to type out the select statement... the right-click menus are not available in tempdb. use tempdb; select * from tablename


  • 5.  RE: 2017 Premium (SQL) printing a SO Picking Sheet.

    Posted 09-05-2017 10:08
    DSD also offers a free enhancement to view the files in DFDM. http://www.dsdinc.com/enh/downloads/LMDF540.exe


  • 6.  RE: 2017 Premium (SQL) printing a SO Picking Sheet.

    Posted 09-05-2017 10:47
    Worktable has to still be in-use in preview mode. Then look for the latest table with SO_PickSheetWrk as prefix for the name.


  • 7.  RE: 2017 Premium (SQL) printing a SO Picking Sheet.

    Posted 09-05-2017 10:58
    thanks everyone. Got it resolved.


Related Content