Sage 100

V2013 Standard, PU 5 this week, also running ACS MB and just installed this week the UDF's and panel mods for True Commerce EDI integration. Ever since the PU 5 upgrade, SO picking sheets have been printing slowly. For one or two line orders, it isn't very noticeable, for twenty plus line orders, it takes over two minutes to crank out the picking sheet. IF you immediately reprint the picking sheet, it reprints in 1/5 the time. (2:40 vs :25). Any thoughts on what I might look at? I have verified the database for the report, changed the database source to the sotamas90 driver.

Try reinitializing the print work files

Test the speed of your custom against the standard report. is Paperless involved? if so look at the font - I heard that the San Serif font can cause issues in PDF printing. Are there any linked tables, logos or images with a large file size added to the report?

@MaryJoKrueger - Nada on reinitializing. @DavidOverholt no PDF involved, not linked tables, logos or images. Just the good old printing sheet WRK table. The bigger question is why does it speed up by 80% after you have printed it one??? It appeared to have started with the PU, not the TC enhancement. The standard form is also slow.

Is Crystal designer installed on this workstation? Have you unchecked the check for updates option under help menu?

@MoiraGoggin - No Crystal installed....

@JeffSchwenk found this on a thread in Sage City: ""Below are a couple of suggestions. 1. Verify that 2013 (5.0)C/S ODBC Driver is running and pointed to correct install. See Sage 100 Install Guide | Configuring the Client/Server ODBC Driver. 2. Verify ODBC Trace is not on - client and server x86 - c:\windows\system32\odbcad32.exe x64 - C:\windows\syswow64\odbcad32.exe Tracing Tab - If When to Trace = Stop Tracing Now. Select Stop User DSN Tab - SOTAMAS90 - Debug Tab = Unselect Enable Debug 3. Rerun workstation from the 5.0.4 system 4. If Citrix and Remote Desktop is used from the workstation to the Sage 100 Workstation Remote Desktop Connection/Local Resources Tab/Deselect Printers. John Nichols Sage

thanks - Sage 100 Standard so there is on CSOCBC driver. Unsure why the trace would be on but will check it off. Not sure how to rerun the 5.0.04 workstation since the system is now .5 but I will rerun the workstation update as I did not do it (owner). No Citrix or TS.

Here's a way to check if it's a PU5 thing with TC or ACSG. Look in the mas90\Links folder. Do you see a SO_PickingSheetPrinting_rpt.pvc or SO_PickingSheetPrinting_UI.pvc ? If so rename them temporarily but not while anyone is printing a picking sheet. Now try picking sheets again. IF you get your speed back for a 20+ line order on the 1st try now look in \mas90\SO for a SO_NNN_PickingSheetPrinting_rpt.pvc where NNN = 525 (True Commerce) or 404 (ACSG) in the filename (and also naming convention of the filename may vary from this example). That's who you contact (and also rename the files in Links back). But if it's still slow then it's seems more like a pure PU5 thing (the MS Sans Serif bold font issue maybe).

Issue resolved by contacting Ron Chompf at ACS. With the last MB update, they tweaked the code for allocations which is resulting in a much slower pick sheet generation as the program creates allocations for the items on the order. The second time around, the allocations exist, so it is much faster. They are working to make the code more efficient. Thanks to all the great suggestions.

I really like it when the real reason is actually found. The 'second time around' was the clue.