Hi there, I trust you are well.
I have opened the Sage 200 Evolution Data Dictionary before, but for some reason it is now not responding when attempting to connect to the database.
There are no errors.
Sage 50 is not allowing me to go in new year and shows the message to check the data integrity through Advance database check. While following the message, it shows the message "sage 50 database verification tool has found a problem in your company file…
Is there a support email for sage if we are using Sage Accounting? Or are we stuck using the forums? I've purchased Sage Accounting / Cloud, but the migration tool is not compatible with CAB files. I have emailed '[email protected]' but received no…
Hi there,
I searched and couldn't quite find what I was looking for.
I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue…
Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…
The most important way to protect your sensitive information is to use passwords and user security in Sage BusinessWorks.
When deciding who should have access to your program it is important to ensure that they also are only having access to the information…
Good day any information on the Task will be much appreciated
What ever this task is, is very resource resource driven and customers are not happy.
Customers computers become very solo, till the point where it's unusable and the keep needing to…
When Errors occur in the Sage Database, if these cannot be repaired then the only viable option is to restore to the last valid Backup. However, the users have to first Print out any Data that they have entered into Sage since the last valid Backup and…
Allow ODBC connection or connection via sage report designer to the table that holds the data of reocurring invoices, including frequency, value, start date, invoice item lines etc. This would allow us to audit the reocurring invoices setup in our software…
Good day, I am trying to create some PowerBI reports using the data from the Sage 50c Pastel Partner Data. Although there are some methods that allow me to do this by exporting data manually. I am looking for an automated solution. I have managed to set…
There is a difference between these two fields and is hugely important and not apparent. Found using the "Customer Transaction History" report and adding fields.
The "Sales Rep ID" is the Invoice Fact. The "Sales Representative ID" is the lookup to…
it would be nice if 3rd party applications hitting a deadlock on Sage Data through SDO, would get an error back stating what data file is locked by which workstation and the date/time of lock creation, instead of just "hanging forever" or until lock is…
So I had entered a credit note in error then had to create an invoice to pay that credit note and not sure if we had deleted the credit note but it is no longer showing in our system. Problem is that in Sage the cheque is showing as having paid $12,000…
Your preparation of your payroll for submission will ensure that your employee records and certificates have been validated and financial values have been reconciled.
Certain payroll information is used when exporting the IRP5 files and errors can arise…
Hi there
Is it possible to set up an external query / database connection (ODBC/SQL/Web Query), so that I can automatically import & refresh my custom Excel reporting using my Sage Business Online Accounting data?
I am currently exporting as csv…
Hi, I know SequenceNo counts up if a duplicate record is generated on the same day but I am not sure what fields exactly need to be used.
Is it just SalesOrderNo, WTNumber, WTStep, RecordType, and TransactionDate? Or is it the rest of the fields as…
my AR outstanding today is $396,2029.27 on the data integrity screen the AR balance says it is $41,975.09 , the unpaid invoices says $396,029.27 that is exactly what is outstanding, how do I fix this, no journal entries have been made to change anyth…
Hi all,
On the GL Journal Entry screen, entry number finder, there are Customer / Vendor Number and Customer / Vendor Name column, which is related to GLJEH table, CUSTVEND column. I check on it and found that there is no value in this column.
I would…
I recently ran into a Company Data issue, one instance worked with Remote Data Access in offline mode causing data entries to become out of sync. Once connectivity was restored we used the upload this instance's data in the hopes of keeping live changes…
I have used Sage accounts for more than twenty years. About a week or so ago I was told that Sage would be denying us access to all of our records (hundreds of thousands of items) unless we agreed to start paying them a monthly fee of what started at…
Hi,
We have just migrated to Sage V28 hosted on our server within our head office, we run a business management system written in VB.NET that sits on remote PC's, in days gone by we have periodically copied data from sage into an identical data structure…
Error retrieving data for an estimate.
Error:
"Error Staging Data
No data was returned by Sage Estimating.
This could be caused if the estimate you selected is currently open (locked) in Sage Estimating. Close the estimate and then try again…
My company wants to utilize Remote Data Access 24/7 to enable employees to work from home.
However, when creating test transactions with the company shared, it takes 10+ seconds for the transaction to save. Does anyone else have a similar experience…
To protect your accounts data it's important to run the Check Data option and back up your data on a regular basis. If your Check data shows any errors, you must repair your data before continuing to process.
A dedicated support hub has been added to…
Is Auto Entry the only compatible program with Sage for scanning documents, receipts, invoices etc? I am looking to see if Sage has a section already included in the membership package that includes a scanning function for easy uploads that’s free of…
