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
1
vote
2 answers

Sage One API Error

I am using the SageOne API PHP Library. It works fine, but I get an error if I try to use get or post. The error is, Only variables should be passed by reference sage.api.php on line 130 My get request code is $client = new SageOne(SAGE_CLIENT_ID,…
arcronis
  • 61
  • 1
  • 7
1
vote
3 answers

'Select' 2 pieces of info (XSLT file)

I am trying to link our Magento website with Sage 50 with a piece of software. We would like the customers first name and last name to go into the company field. Below are the 3 lines I assume I have to tweak:
Nathan Smith
  • 13
  • 2
1
vote
0 answers

Create XML (using XML Schema) with Scribe job: XML element must be omitted if specific attribute has value that does not fit the criteria

I have written a Scribe Insight job, which transfers data from Sage ERP MAS to XML file. It runs successfully. Now, one more requirement got added to the job. My current XML file looks like:
Vikram
  • 3,996
  • 8
  • 37
  • 58
1
vote
0 answers

Scribe: Not getting proper results

I am working on Sage ERP MAS 200 and Microsoft Dynamics CRM integration using Scribe. I have a chain of 5 Scribe jobs with which I am trying to compute various values and update/insert in CRM (Target): (1) Job 1: This job simply transfers all the…
Vikram
  • 3,996
  • 8
  • 37
  • 58
1
vote
0 answers

Scribe jobs not getting complete

I am working on Sage ERP MAS 200 and Microsoft Dynamics CRM integration using Scribe. When I trying to run a Scribe job, it is not getting completed. What is happening is: out of 3583 source rows, it processes 3580 rows and then the application…
Vikram
  • 3,996
  • 8
  • 37
  • 58
1
vote
1 answer

Convert "General" data type to Date

This might be a simple question, but I couldn't find a solution. I have an Excel Spreadsheet with a PostDate column whose value is: VLOOKUP(E2,upload!A:H,2,FALSE) and it shows as a Date. I'm using this spreadsheet as a data source, but my…
Anna
  • 538
  • 2
  • 4
  • 13
0
votes
2 answers

How do I integrate VisualFoxPro DB with Magento

I am an IA working on a Magento/VFP integration solution. Does anyone know if VisualFoxPro has a method by which Magento can read the VFP datadase? These DB calls will also need to integrate with SagePro and PayFlow
Kevin Woods
  • 1
  • 1
0
votes
0 answers

Find Sage table field

I’m trying to determine what Sage 300 database table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database. You get to it by…
NickSO
  • 33
  • 2
  • 6
0
votes
0 answers

Saved SQL Server Credentials in Excel 2016 Macro

I have several query connections that pull data from my Sage 2021 database. I consolidate the queries into one table, so whenever I need to get the most updated data, I have a macro that updates the queries, which leads to needing to type in my…
Garth Mars
  • 15
  • 6
0
votes
0 answers

Returning data via Sage API always results in unauthorised

I'm using the following code to try to return data for our warehouses via the Sage API. We're using Sage 200 standard (docs here). Every time I try to run the script it takes me to a 404 with an unauthorised error. The annoying thing is that if I…
Rob
  • 6,304
  • 24
  • 83
  • 189
0
votes
0 answers

Is there a way to export invoices from sage 200 evolution?

We need to export invoices/bills from sage 200 evolution and import it to other system. Is there an option to export invoices/bills from reporting or any other menu? Thanks,
Pooja
  • 575
  • 10
  • 28
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

Execute ACTION from STD on Sage X3

Using Sage X3 v12 (2021R3), I try to execute on a TRT the $APRES_CHOI action from STD and SPE. My process is the following : Object called ZDK, I'm opening an action AZDK1 that opening a custom selection popup (with screens and…
DamienAuvray
  • 45
  • 1
  • 7
0
votes
0 answers

Cypress testing Sage Authentication process

I'm attempting to test the Sage Authentication process with Cypress, but I am encountering this error after I login with my correct login details. Is there a way to fix this or is there an alternative someone can suggest? Thank you and have a nice…
SeraphimtheOnly
  • 1
0
votes
1 answer

Adding multiple Entries under Order Entry Sales Order Transactions

I came to a issue where I want to add multiple entries under a sales order transaction using the Sage Intacct developer API. Is it possible to modify your API to insert multiple entries under Sales order transaction on Sage Intacct?
Duncan
  • 9
  • 1
1 2
3
4 5 6 7