Hello, I have a client in EU that needs to hire a developer for an integration with Sage50 Accountant and other versions in the US. Can anyone help me?
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…
I have written an application to post general journals to SAGE 50 using data from a point of sale application. The program works fine on the server where the company files are located but when we moved the application to a workstation where the accounting…
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…
Hello everyone
I am wondering if it is possible to share information between these 2 Sage products. A customer uses Sage Intacct and I would like to know if it is possible for these 2 to interact. For example if in Sage 50 I register invoices or purchases…
I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00.
Here is an example of…
Hi, All wise and mighty sage pros!
I am an integrations developer and have been for over 30 years. Having worked with MANY api's I don't think my question will be so much a challenge but rather just details I don't yet know ;)
I have had many…
I've found how to get a list of the Accounting Periods through the SDK (Using .net API). Is there a place to find the current period so I'm not entering or updating records from an accounting period?
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…
Hello and good day to all.
I'm looking for a way to access SAGE 50 endpoints for purchase orders, invoice. inventory etc through our front-end system built in Rails. The ideal solution would be through an API which I couldn't find any suitable yet.…
The company account is accessible through the desktop Sage 50 US Edition just fine. When we try to access through our app that uses Sage API to access it gives the following message. ANyone knows what the issue is?
WIndows 2012 Server R2
Sage 50…
var companyId = GetCompany();
try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId);
This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
Hi,
We are trying to build up an application using the Sage SDK to create invoices in the Sage 50. In our testing , we found that the Sage SDK is prompting for the user to give permission every time (even if it is same company file that we gave permissions…
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…
Is there any possibility to access lists available on Vendors Defaults from SDK ?
I just want to get Payment Methods - as I have seen even in example it was hard coded to Master Card and I haven't found any object which could give me acces to that.
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…
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
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?
Wondering if anyone has experience with an integrator or service that could help me pull real time data out of Sage 50? For example, a high-level goal would be to display an open orders report compiling new sales orders as they are entered and pulling…
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…