Sage 100

Client on 4.5.4 has an issue where only the 1st/initial report is showing up when generating the Paperless .pdf. Has anybody experienced this? For example, when going thru the Update process for PO ROG/ROI when both ROG and ROI Entry exists, the .pdf that's generated only shows the ROG Register; no ROI Reg or Daily Purchases Journals. If do the same Update process when only ROI Entry exists, the .pdf only shows the ROI Register; no Daily Purchases Journals. If go thru the Update process for A/P Invoice Entry, only the A/P Inv Reg shows on the .pdf; no ""AP"" DTR on 2nd page (I don't mean the GL DTR). The .pdf's in the Paperless Viewer are also wrong. All data appears to have posted properly, all the way to the G/L. I only tested PO and AP but it really appears this is happening anytime there's multiple reports generated for a given Update process.

Are there files in the Paperless folder with different extensions? I haven't seen this since 4.3, but at that time there was a problem with having the wrong version of the CDINTF.DLL file and the second pages would have some other extension that meant something to Adobe but no one else.

I think this is what @BethBowers is referring to: http://infosource.sagesoftwareonline.com/sw_attach/kdb.asp?isresolutionconceptid=495429

That's probably it, @ThereseLogeais. I'm sure it took you negative 6 seconds to find that... I also had it happening with the AP Invoice Register - the GL summary page was missing. I now see there was some talk about this where Jeff had a cdintf.dll file that kept being created with a 0 size on a MAS200 and when he ran it as an application instead of a service it started working. So many weird errors in Paperless, so little time.

I think it was anything that had a secondary report but I know I first ran into it with the Gross Profit report.

We had a similar thing happen at a late last year in Receipt of Invoice. Prior to the end of December 2011, Registers with a Variance would consist of 4 sections, Receipt of Invoice register, Daily Purchases Journal, Daily Purchases Tax Journal Summary and a Receipt/Invoice Variance Register. Since December, they had been missing some Receipt/Invoice Variance Registers. Exploration showed a register with a variance will print the first two and then only the Daily Purchases Tax Journal Summary or the Receipt/Invoice Variance Register, but not both. Usually the Variance Register was the one missing. I spent a great deal of time on this with Chris Powers and we never really got it solved. I found out that they did not use AP Tax but that it was turned on. I went through the steps to get it turned off and then with only three reports to print it did fine. Still don't have a real answer.

Good stuff, folks! Thanks, a lot! I look forward to trying your suggestions. Btw, this issue is happening on multiiple workstations, multiple user id's, and is not company-specific.

No go on the CDINTF.DLL route; it didn't work. And this issue isn't happening on the server though, so therefore we're dealing with some sort of workstation-specific issue. Also just heard of another similar situation but it's only related to printing/previewing, not Paperless .pdf'ing.

What type of OS on the workstations and who did the initial install? Perhaps a uninstall/reinstall of the WS as Admin will solve the issue. What about the AV settings? 90 or 200?

@JeffSchwenk: MAS 200 OS = Win7 64-bit Wkstn uninstall and reinstall as Admin user was no help. What did you mean by, ""What about the AV settings""? I believe they use Norton.

Are the exclusions set properly?

I'll check. Thanks.

Btw, this issue is mostly happening all the time with the PO update process, but not every single time. And with the AP update process, the issue isn't happening all the time either. Strange. I would think that if it was related to the .dll, that it would happen every time, so maybe it does have something to do with AV/Malware protection. ??

Are the failures always on the same workstation(s)? Or are you saying sometimes it works and sometimes it doesn't from the same workstation??

Issue is happening on multiple workstations, and on a given workstation, sometimes it works (although rarely) but mostly it fails. Temporarily disabling AV had no impact.

@BrettZimmerman, I saw your post on the community. We never were able to find out why this was occuring and we worked around it by removing the need for one of the reports in the chain. That did not cure it completely but it reduced the occurances to the point we are not getting complaints. Our Case # was 4843779 from February, March & April of this year. The primary support person i worked with was Chris Powers. If you end up starting a case, maybe they can look at our case notes and talk to Chris.

Thanks, @JohnBroadfoot.

I have bumped this post as we are having the same issue again after upgrading a client from 4.4 to 2013. This time it is the Sales Order Gross Profit Journal that is left out. We have lost the preview of the GP report completely but randomly it does make it to the PDF. Has anyone ever gotten a resolution for this issue?

I've been dealing with the same issue with the gross profit journal not always being added to the .pdf. Sometimes it's there and sometimes not. Dealing with Sage 2013 PU4 on a Windows 7 machine. It works fine on XP machines. The system is creating files with a .pdf.cat extension and letting them in the paperless folder each time it doesn't work. It appears to be a timing thing where the system is trying to open .pdf file before it's done combining the sales journal and the gross profit journal when the gross profit journal is many pages. In my case the sales journal was 4 pages and the gross profit journal was 29 pages. I don't know what the exact breaking point is. It's supposed to create that .pdf.cat file until the 2 documents are combined into one .pdf and then delete the file. As a workaround, I found if I turn on the option to print Daily Sales Recaps and let it sit on that prompt for a bit before answering No, it gives it enough time to finish combining the sales journal and the gross profit journal. Sage was finally able to recreate on their end today so hopefully they'll get it fixed.

@MaryJoKrueger - thanks for that update. I love knowing how the programs work behind the scenes.

@MaryJoKrueger, Thanks for all the info. Now I will know to look for the .pdf.cat files. I agree totally with the timing theory and am so glad you were able to give them something they could duplicate.

@MaryJoKrueger - This is very similar to an issue I opened with Sage last October after upgrading a client to v2013. Paperless works great on an XP but the Win 7 WS processes to fast for the two pdf's to concatenate properly so error message appears. If you look in the paperless viewer, the two files do appear as one properly. Sage hasn't been able to put their fingers on the pulse. The CAT extension issue brings back memories of v4.3 or v4.4 when this was occurring all the time. Sage did release a patch for it, but the client was left with a LOT of cleanup.

Received this email from Nathan at Sage today: I've attached an updated SO_GrossProfitJournal.rpt file (it's from 2014, but I changed the Summary so it works with 2013) which runs a lot faster than the previous form and allows it to get added to the Sales Journal PDF in time. We have a utility that will be available in the next Service Update that will fix printing performance issues in 2013 which occurred when the Header font was Microsoft Sans Serif and bold. The utility will scan all reports and change the font to Arial.

OMG it's a font issue?? https://90minds-com.socialcast.com/messages/19588123

This is the second time I've heard that from Sage personnel. Them changing the fonts is supposed to be a cure all for all the Crystal performance issues we've been dealing with the last couple of versions. Made me roll my eyes too

Well, they are changing all the report fonts in v2014. At least they are providing a utility to change them in v2013. So does this mean no one will be hearing me talk about using PTQ's to improve report performance???? Damn!!!!