Stack Overflow
Stack Overflow

Questions tagged [sage50]

32 questions
3
votes
0 answers

"Unable to open company file" message returned (Sage 50 Canada)

We're developing a COM-aware .Net assembly that is used in a legacy VB6 app and keep getting the above message when opening a connection via SDKInstanceManager.Instance.OpenDatabase. When we call our method from inside another .Net assembly this…
MikeG001
  • 53
  • 4
1
vote
1 answer

Send invoice data to SAGE 50 Cloud on button click

I am currently working on a personal project that consists of a website which displays invoice information in a table, which is pulled from Firebase. I am using JavaScript to show the data in my table. This is how I'm populating my table: function…
Ding0
  • 305
  • 1
  • 10
1
vote
1 answer

How to Connect to Sage 50 ODBC Database with PHP

I'm attempting to export data from Sage 50 database. I have managed to create a connection to the database however whenever I perform a query I have the following error message. Warning: odbc_exec(): SQLColAttribute can't handle…
Mike Stow
  • 38
  • 6
0
votes
0 answers

How can I use a User Filtered Date to drive Calculations in Power BI

I am trying to create an Aged Creditors report in Power BI, using data from Sage 50. I have extracted Account_Ref, Date and Gross_Amount from the Audit_Split table, to which I can then apply a user filter for Date, which will give me the correct…
Chris Wildstone
  • 1
  • 1
0
votes
0 answers

Create Aged Reporting in Power BI using data from Sage 50 Accounts

I have a requirement to reproduce Sage 50 reporting in Power BI, but as I am not an accountant, or very familiar with Sage 50, the Aged Debtors and Creditors reports are proving difficult. I have reproduced them for the current date, but the method…
Chris Wildstone
  • 1
  • 1
0
votes
0 answers

Assembly not loaded in Asp.net WEB API, WCF except Windows Form Project

Today I am facing a strange issue, I need to create a web API in ASP.NET, which will retrieve data from the Sage 50 desktop. for this implementation, I am using Sage 50 SDK assembly Sage.Peachtree.API. Here is what I have written: public static…
MichangGo
  • 31
  • 1
  • 9
0
votes
1 answer

Setting the value of the SOPITEM. Text field using SDO v29

I'd like it confirmed that this is a bug, (and that hopefully Sage will fix it). I want to set the TEXT field of a special S3 line item when posting a SOPItem to a sales order (SalesRecord): From the docs: I have it all working fine as is, however…
8a9
  • 513
  • 5
  • 11
0
votes
0 answers

Add Departments to Nominal Leger

How can I add Departments to the Nominal Ledger report when it shows in Excel. I'm connecting via the ODBC connection to Sage 50, and using SQL but I cannot see any unique column to add a where clause or join between both.
DrewSmith
  • 47
  • 1
  • 6
0
votes
1 answer

Is there any method to connect SAGE 50 data to Power BI?

So i have my whole business data in SAGE 50 UK, i want to import the data (sales...) from SAGE 50 to Power BI desktop to create a dashboard but unfortunately Power BI doesn't support importing data directly from SAGE, is there any solid method to do…
Hamza B
  • 3
  • 3
0
votes
1 answer

Sage50 Canada SDK location

Does anyone know how to access the latest sage50 Canada version SDK? With the UK version it is included in the application files but I cannot locate the equivalent with the Canadian version.
Tim Bowers
  • 41
  • 3
0
votes
1 answer

How to pull email addresses from Sage50

Is there a way to pull all the email addresses ever entered from Sage50? I have tried report designer and csv export, to no avail. I can export a huge number of phone numbers, but would ideally like email addresses.
user14563189
0
votes
1 answer

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.PeachwServer.Application' - Sage SDK 2018 CreateCustomerDemo c#

I'm very new to Sage 50 SDK and when I try to run the sample c# code sample, I get the following error message. 'Save failed: Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.PeachwServer.Application'. This operation…
Shekinah Budhai
  • 77
  • 1
  • 2
  • 11
0
votes
1 answer

504 - Time out error while connect sage50 cloud accounts

When trying to login the TradingAccounts endpoint, I'm getting "Login Failed - The operation has timed out". I’m having issue to connect sage50 cloud application from my web application. I need to access data from sage50 cloud to web application. …
Letoncse
  • 702
  • 4
  • 15
  • 36
0
votes
1 answer

Sage50 OBDC [RECORD_DELETED] field isn't working

I am trying to import invoices from Sage 50 UK using MS access. The problem I am facing is that sometimes, the invoices on sage might have had a product on it before but, has since been removed. Unfortunately, using a select * query on…
Dan
  • 1
  • 2
0
votes
1 answer

How to transfer payment line into Sage 50?

I'm using sagecrmErp2008feeds to the integration with my application. I'm able to create SalesCredit and SalesInvoice data. But I would like to transfer payment data from my application to Sage50. Which feed Entry should I use for that for payment…
Letoncse
  • 702
  • 4
  • 15
  • 36
1
2 3