Sage 50 US

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?

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…

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

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…

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…

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…

How to Migrate company data from Sage 50 Premium 2015 to Sage 300. How do I extract data from .DAT file?

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…

How does the jrnlrow payrollfieldnumber relate to the DefaultPayrollField table and the PayType table. Is the PayType table a new table in 2021?

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…

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

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…

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…

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.

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…

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.…

I have this error message accesing Sage50 via ODBC. Any know what means?

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?

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…