Stack Overflow
Stack Overflow

Questions tagged [sage-erp]

Sage enterprise and accounting software

Sage enterprise solutions http://na.sage.com/us/erp has a large suite of software including many database solutions. Sage city http://sagecity.na.sage.com/ is a good place for questions as well.

104 questions
7
votes
5 answers

Integrate Sage Line 50 with windows application

I have to integrate C# Windows application with Sage Line 50. (To send all invoice details from application to Sage). I searched on Google and most of the places it says to integrate Sage Line 50, we need to use Sage development kit (SDK). But it's…
mugzi
  • 809
  • 4
  • 16
  • 33
6
votes
2 answers

SSIS package works in Visual Studio, AND Command line but not in Agent

I have an SSIS package which I have developed on the server using VS. The package runs fine in Visual Studio, however when I add to a Job in SQL Server Agent the package fails. I am pulling data from SAGE Line 50 v19, so the ODBC driver is 32 bit.…
bp3849
  • 61
  • 1
  • 2
4
votes
1 answer

Sage 50 SData XML to JSON POST Request

My end goal is to push orders from a csv into Sage 50 using SData and Python Requests. I found a sippet of XML body schema (see below) to construct and push a sales order into Sage 50 using SData. I have successfully been able to push a sales order…
user2407147
  • 1,508
  • 2
  • 22
  • 40
4
votes
1 answer

Sync Sage 100 Data from an ODBC Data Source to a MySQL Database

I am trying to setup remote access to the data of Sage 100 Advanced ERP for use within a website running on a MySQL database. I only need to get inventory levels for products, so it's a read-only application. As I understand it, Sage 100 comes with…
Michael Yaeger
  • 756
  • 12
  • 32
3
votes
1 answer

ACCPAC Missing Method Exception

I have a ASP.NET Core 1.1 webserver running on full .NET 4.6.2. I am using the ACCPAC.Advantage.dll's (packaged in a custom NuGet bundle) to connect to a local Sage installation. Previously connections were successfully initiated and I was able to…
Jim Buck
  • 2,383
  • 23
  • 42
3
votes
1 answer

Parsing a time with the format HHMMSS00

I'm working with some data from multiple sources and one of these sources is a Sage ERP system. I am trying to reference two files in Sage in particular, an audit date and audit time (AUDTDATE and AUDTTIME). I need to parse this and store it as a…
James
  • 15,754
  • 12
  • 73
  • 91
3
votes
1 answer

Magento does not capture orders after payment

I am using Sage as the payment method (which shouldn't matter anyway). Sometimes my installation of magento (1.9.1.0) will take the payment but will not create a new order. So basically, the new customer is created, but no order is assigned! So I…
SamNewbie
  • 37
  • 1
  • 8
3
votes
4 answers

Sage 200 - Counter table instead of Identity columns - strange behaviour

I've recently been tasked with writing a Sage import tool that imports Quantity Price Break Discounts. The Sage 200 tables in question are: StockItem - Main Product Table StockItemDiscount - Main Discount Table StockItemQtyDiscBreak - Discount Qty…
HeavenCore
  • 7,533
  • 6
  • 47
  • 62
2
votes
0 answers

How to create IC Internal Usage entries from an external system in SAGE?

I'm building a business application to manage inventory requisitions. The application is a lightweight web interface used mainly by our internal employees to submit inventory requisitions. The requisitions will pass through a workflow of activities,…
mhadidg
  • 1,503
  • 17
  • 29
2
votes
0 answers

Sage One Api error while requesting through php

I am using https://github.com/eddieharrison/sageone-api-php for connecting to Sage one. The problem is after accessing the token key when i use the service like say get-ledger-accounts.php with the current access token that i get from sage page…
user3244020
  • 21
  • 2
2
votes
2 answers

Upgrading from Sage Pay 2.23 to 3.00

Upgrading from Sage Pay 2.23 to 3.00 I'm currently using Sage Pay Server PHP Kit Includes File in one of my projects, and as you may know, Sage Pay are deprecating API version 2.23 so I'm forced to upgrade to 3.00. The changelog of the file I'm…
Daniel Dewhurst
  • 2,533
  • 2
  • 21
  • 39
2
votes
1 answer

Could not add the table (

The following code works in Sage200. SELECT bcs.BomReference ,bcs.DateTimeCosted ,bcs.TotalCost FROM ( SELECT BomReference ,Max(DateTimeCosted) AS MaxDate FROM NDM_Sage200.dbo.BomCostSession BomCostSession GROUP BY…
Kris
  • 49
  • 2
  • 5
2
votes
2 answers

Sage 50 2014 SData issues

Hi I am having a bit of trouble with sdata. I have been able to see a schema using http://localhost:5493/sdata/accounts50/GCRM/-/$schema. When I try to view accounts etc, through something like the following…
user835440
  • 83
  • 2
  • 8
2
votes
1 answer

How to connect to Sage 100

I am developing a Windows Forms application which is required to connect to Sage 100 and get order information. I am using ASP.NET and SQL Server 2008. Is there a way to connect to the sage 100 database?
user2898676
  • 19
  • 1
  • 4
1
vote
1 answer

Sage Pay / Opayo Credential on File ERROR 3370 : The RelatedVPSTxId cannot be repeated (PHP/cURL solution)

QUESTION I get an ERROR 3370 from Sage Pay when trying to repeat transactions of type AUTHORISE (but not PAYMENT). I am using Server Integration with PHP/cURL. ANSWER This is most likely because you need to send CoF values during your initial…
Daniel Torridon
  • 11
  • 2
1
2 3 4 5 6 7