• Is there a way to Export Past Due Orders into Excel and Update the Date and Import back to Sage to auto-update?

    Currently, we are exporting the past due orders into excel, then manually updating each and every one of their dates in Version: Sage 50 Accounting This takes a large chunk of time to do manually. Does anyone know a way to speed this process up?
  • Link JrnlHdr to itself

    I added the JrnlHdr to the report twice in hoping the link the second JrnlHdr to itself. How do I do this? My first instance JrnlHdr is restricted to JrnlHdr.JournalKey_Journal 11 - Sales Orders. While my second is restricted to JrnlHdr.JournalKey_Journal…
  • Missing report

    I have been using Sage 50 accounting. The PC got infect with virus. And after a full scan, the Reports and Forms window did not show any standard reports any more. Is there a way for me to recover those reports. Thank you very much
  • Exporting Check Register for Banking Positive Pay File

    Hello, using the import export feature, we are trying to export a check register just collecting the Check Name, Check Amount, Date and Check Number. We tried using a purchase journal report but it shows duplicates on every check if a check is used…
  • How do I find all checks written on a specific day via an ODBC connection?

    I'm on Sage50, 2019. I've connected to the ODBC driver and have found the following query gets me part way there. SELECT a.Reference, a.AmountPaid,a.Description, a.JrnlKey_Journal, a.TransactionDate, a.MainAmount, a.Reference, a.TrxName, a.* FROM…
  • 64 bit ODBC

    I am hoping I am wrong and someone can point me in the right direction. I need a 64 bit ODBC driver to connect to Sage 50. I can't work in 64 bit Office or in Visual Studio with the 32 bit Pervasive Client driver. Surely it can't be possible that there…
  • Migrate/Extract data from Sage 50 to Sage 300

    How to Migrate company data from Sage 50 Premium 2015 to Sage 300. How do I extract data from .DAT file?
  • I can't establish a connection via ODBC

    Hello Colleagues, I have a problem connecting to Sage 50 from ODBC, when I try to connect to the database from excel or another program it does not validate my credentials. I have done all the processes in the documentation, I enabled the permissions…
  • JrnlRow payrollfieldnumber

    How does the jrnlrow payrollfieldnumber relate to the DefaultPayrollField table and the PayType table. Is the PayType table a new table in 2021?
  • Business Intelligence report - using POSOisclosed filter in report and data not correct when running report

    I have created a excel pivot report using the BI report manager and connector. I have several fields used to construct an open order report by ship date I them use Vlookup to link to anoither table from our MRP system to show On Hand FG inv and current…
  • Migración de datos

    Hola a todos Quisiera saber si se pueden migrar datos de una empresa a otra Como por ejemplo,pasar los clientes o facturas de una empresa a otra Si pudieran ayudarme se los agradeceria
  • Issues linking Crystal Reports to databases after new PC install

    Hello, I recently installed new computers and since then when trying to connect Crystal Reports to our Sage company files, I get the following error message. Failed to retrieve data from the database Details: ADO Error Code: 0x Source: Pervasive…
  • Sage Crystal Report error

    Good day Fellas :) looking for anyone who can help :), i'am having a problem regarding with our companies' sage 50, my users are trying to generate crystal reports using their workstations but unfortunately it is asking for a database password which…
  • Using Peachtree 2012, how do I export my crystal reports to be used in else where?

    I'm using ancient peachtree 2012, and I cant seem to figure out how to export all my crystal reports from the program, and can't seem to find a helpful how to on this process. Any help on this would be great Thanks.
  • Attachments Table

    I'm trying to create a report that shows any sales invoices or vendor invoices that do not have an attachment (our documentation). I'm looking for the table that stores all attachments (i.e sales invoices, vendor invoices) and the key field for that…
  • cannot locate the named database you specified

    I have a report I've been running for a few years now and as of August it no longer works and I can't see that anything has changed with my information to cause it to fail. When I try to refresh the report data, a box pops up for the OLE DB Provider.…
  • Pervasive error No. 4905

    I have this error message accesing Sage50 via ODBC. Any know what means?
  • Not directly crystal related but maybe some help could be provided. Data extraction for reports

    I need to find which tables Item Qty on hand and item cost are . Using Access ODBC, and need to extract Inventory Stock status data for connecting to Power BI. Any help?
  • Use indexes or server for speed

    I have been finding recently that on certain computers, Crystal Reports will give an error message if I don't uncheck the box “Use indexes or server for speed” in the Report Options. Unchecking this makes the report run much slower. At one client I…