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
0
votes
5 answers

Connection error accessing Sage Timberline Accounting with PHP and ODBC on Windows

I'm trying to connect to a Sage Timberline Accounting database on my Windows 2003 Server using PHP 5.3. I have PHP correctly installed with IIS as fastcgi. I have a system DSN setup in ODBC Manager and correctly configured for the Timberline…
Dale Weaver
  • 1
  • 1
  • 2
0
votes
1 answer

How to find relation in Sage 50 Databse v22 in mysql(Already Converted to mysql)

I am new to mysql and accounting, however, I have converted Sage 50 V22 database table to mysql via ODBC and but unable to find relation. There is no primary key selected. My project is to create similar application like Sage 50 but in PHP and…
Sheikh Jamil Ahmed
  • 1
  • 1
0
votes
0 answers

Sage50 SData POST to tradingaccountCustomerfeed

I am very new to Sage SDATA; so far I could read/write to various feeds using c#. I am trying to add phone number to tradingaccountCustomerfeed but failed. I could easily write to email, name, address fields etc. to this feed. I am not sure what am…
Khan Basher
  • 1
0
votes
1 answer

T SQL Orders & BOMS

Good Morning All, So I have two tables e.g. order_details and bom_details The tables are stored in a T SQL database on a 2008 Microsoft SQL Server order_details - Containing Orders - Example: +----------+-----------+-----+----------+ | order_no |…
bepster
  • 93
  • 1
  • 8
0
votes
2 answers

Sage 200, Sql joins - POPOrderReturn table and TransactionHistory table

I am trying to join POPOrderReturn table with TransactionHistory table but I cant find an obvsious link between the two. I am building Purchase Order tracker and wanted to include warehouse GRN number once the PO in booked in to the warehouse. We…
Paula
  • 1
  • 1
0
votes
2 answers

Sage One API returning 500 Internal Service Error when creating Payment Invoice

I'm having an issue when creating a "Purchase Invoice" in the Sage One API. No matter what changes I make to the data being passed in, I seem to get a 500 Internal Service Error, and no detailed response that contains any meaningful information. The…
Vin B.
  • 3
  • 3
0
votes
1 answer

running sage 300 ERP macro without triggering a login?

I use sage 300 erp heavily and am setting up some macros, the main issue is that they prompt me to sign in each time. If I want to run a task in the background each day on a schedule to print out a report to a directory, it requires me to babysit…
ADL
  • 185
  • 8
  • 19
0
votes
2 answers

Mark an order as "Full Payment" on Sage 200

I am inserting orders on Sage 200 through an application using the client side, C# and APIs. I would like to check the "Full payment" checkbox on the "Payment with order" tab. Currently, I am setting the PaymentType property, which is not…
Egidio Caprino
  • 1
  • 2
0
votes
1 answer

Creating a client Sage X3 from Web Services using PHP SOAP

I'm using SOAP PHP to create a client Sage X3 but my request SOAP failed. Here is my code : $xml=' CUS 2 …
TZviw
  • 3
  • 1
  • 4
0
votes
0 answers

Sage50 ODBC VBA String Multiple Companies

I am looking for help with a vba connection for Sage 50. There are 3 different companies that have different directory paths for the driver SageLine50v20. I can connect normally through the ODBC by changing the path manually for each company but I…
A P
  • 1
  • 2
0
votes
1 answer

ProvideX/Sage ODBC Driver with GROUP BY and Column Alias

Scenario: Sage 100 ERP ProvideX ODBC Driver (32 bit) Standard SQL statement containing a column alias and GROUP BY statement. Comments: We are using the PVX/Sage ODBC connector with a standard Sage 100 ERP environment. The driver is working…
vbnet3d
  • 1,151
  • 1
  • 19
  • 37
0
votes
1 answer

How to import invoice payment information into Sage 500/Mas 500

We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details, and offer customer payment through other means. Now I need to bring the payment…
David
  • 39
  • 5
0
votes
1 answer

Sage and PayPal shipping details

Does sage allow for the importing of PayPal shipping details once payments via PayPal are made? So the customer clients physical address to ship the product to - not just simply the email address by which they paid with PayPal.
Meg Huckstep
  • 11
  • 1
0
votes
2 answers

Sage 50 ODBC PHP encoding issues

I have setup the Sage Line 50 ODBC driver on my PC and am using XAMPP php server on the same machine to query the sage database with PHP. Here is some basic code to interrogate the Sales Ledger table:
James Stoddern
  • 397
  • 1
  • 5
  • 19
0
votes
1 answer

Error "unsupported_grant_type" when using the Sage One API

I'm using the Sage One API Php from Eddie Harrison (https://github.com/eddieharrison/sageone-api-php). I'm trying to do basic authentication with the API, however it returns the following error: string(35) "{"error":"unsupported_grant_type"} "…
mickburkejnr
  • 3,652
  • 12
  • 76
  • 109
1 2 3 4 5
6
7