Hi all,
I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet.
My user setting:
…
Hi,
Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank.
Could someone share…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…
Hi,
I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…
In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"
What is this?
I write reports, and get client databases to work in. This is the first time…
Deductions for 1/1/2020 - How will you make a mass update to HRMS if you haven't been tracking deductions in HRMS?
We have HRMS and Timberline. We use a 3rd party for Benefits Open Enrollment and monthly maintenance and enrollment.
Every year we have…
Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…
Hi,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
Hi All,
I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…
Hi,
I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…
We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field.
The bulk of the record have the correct company ID, however many have either blanks or random company ID's
I have checked this at several…
Hi,
We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed.
1 Error found in Administrative Services.
Any ideas?
I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…
I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax:
Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True)
But I do not know how to capture the data you are going to select in a DataTable. I´m Working…
Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?
We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.
Hi Guys,
I am having an issue while updating Inventory Counts in SAGE300.
I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities.
Has someone successfully updated /C Physical Inventory…
Timeslips 2012
When using transport.xfr I get the following error message. I tried a DATA VERIFICATION on both machines and have NO errors. I can exchange clients and professionals but NOT tasks or expenses - tried each separately.
Any help would…
Hello,
I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…
I'm an admin for a law office and we use Timeslips 2008 for our billing. Only yesterday, when I went to edit a slip, I received the following error:
"Directory in use by earlier version of Paradox.(13314)
Area: Database
Code: 4
Address: Exception…