Can anyone line up the office connector reporting to the following report within AP
AP --> Reports --> Invoice Regesiter --> Invoices Selected for Payment
I would like to generate this report within Office Connector to have the information within…
New to SAGE & Office Connector
Trying to determine how to reset my Period fields in Office Connector once the Fiscal Year has been closed. As an example, how do I get all periods of 2020 when the year has been closed and moved to 2021. I have been using…
We will be migrating to a new server because we have to upgrade to Version 20. Are the latest versions of Sage add ons, specifically Paperless, My Assistant, and Office Connector compatible with V20?
Where do I find info on this? I only see info on…
I'm having trouble joining the JC Job Master file with the PJ Job master file. This seems like it would be straightforward joining "JOB" ON "JNUM" but it's not working. Any ideas?
Does anyone have any experience and/or documentation as to how to create custom reports using Office Connector. More specifically adding the as of date fields. Any help would be appreciated.
Eg. I have created a custom forecast report, but my job cost…
It doesn't look like there is an ability to use the Write function to update the Original Contract Amount in the JC Job (1) Master table from Office Connector. Is this something that we are able to add in? We would like to keep this field updated for…
Does anyone have any experience and/or documentation as to how to create custom reports using Office Connector. More specifically adding the refresh and as of date fields. Any help would be appreciated.
Hello Everybody,
Just wondering if anybody ever used Office Connector SQL Editor.
I'm not sure what I'm doing wrong, but every time I try to manually update SQL query, even with simple things like GROUP BY, there is an error message.
The message…
Sage 300 Construction and Real Estate (formerly Sage Timberline Office) Office Connector automatically connects your Sage 300 Construction and Real Estate data to Excel. You can save hours on reporting and analysis tasks using Excel. Best of all, Office…
I am starting out on Sage 300 Construction and Real Estate. Timberline/Sage is installed and I have a username and password to access the system.
I can also connect via Office Connector to the data and therefore have an data connection string. I would…
How often does your accounting team work with information in Microsoft® Excel that, after working with it in Excel, results in information that is later entered into Sage 300 Construction and Real Estate as journal entries, time cards, estimates, purchase…