Sage 100

Sage 100 Premium - If using premium and need to move the paperless office pdf files, here is some SQL code you can use to make the data path changes without having to use the slow link maintenance utility: Update dbo.PL_ReportPDFLog Set Directory = REPLACE(Directory, '\\SERVER-DC1\MAS90 Paperless\', '\\ABC-SAGE-01\Sage 100 Paperless\') Where Directory like '\\SERVER-DC1\MAS90 Paperless\%' --Use With the following tables --MAS SYSTEM Tables --dbo.PL_ReportPDFLog --dbo.PL_PeriodEndPDFLog --dbo.PL_JournalPDFLog --Can Also Use to Update Paperless Office Settings in the System Tables --dbo.PL_Report --dbo.PL_PeriodEndReport --dbo.PL_JournalRegister --dbo.PL_Form --MAS_ABC Tables --dbo.AP_VendorPDFLog --dbo.AR_CustomerPDFLog

@JimWoodhead , didn't you have a stored procedure or SQL process for this? Any efficiencies that could be gained from Doug or yours?

Is this what you are referring to @LarryBradford http://www.evernote.com/l/AQ6wJyv2d8tJwYQVSDjBBBI9PeY_MWLOzCo/

Is there something similar for Sage 100 Advanced?

Advanced is where it all started.... https://90minds-com.socialcast.com/messages/32215236/comments/7930346?ref=stream

@CYNTHIAHAY The DSD program that @MoiraGoggin shared the link for will/should work for either Premium SQL or Advance and Standard. It is written in ProvideX. The one I dleveloped is written in T-SQL and will only work for Premium. If I would have known this program already existed it would have saved me the time of developing a SQL program that only works for premium.

If Sage would have developed a better utility it would have saved us all a lot of work.

Yes, if pigs could fly, the road to hell would be paved with gold and we would all be much richer... I am amazed that they sometimes are able to tie their shoelaces and walk without tripping. Midvale School for the Gifted students, they are not even!

Thanks.