I have discovered that it is impossible to filter by certain 'calculated' columns on the API, particularly on the sales_posted_transactions endpoint. The following API call with a filter to return only Sales Receipts works successfully... /v1/sale...
Guest
over 5 years ago
in Filtering
1
Idea Accepted - Gauging Support
Hi, I have identified an issue with the Nominal Transactions Report in Excel reporting when you pull this off the reports section for us as we have been with Sage just over 2 years so on this report it shows Current Year, Last Year 2 Year but when...
Export a single or selection of product group(s) prices
Currently to export a price file you can only export all the prices, it would be good to be able to select an individual or group of products groups to work on, similar to exporting stock items
Jamie Dennis
almost 10 years ago
in Stock
0
Idea Accepted - Gauging Support
Old Wish List Item 525 - Allow Importing of multiple cost prices on the Traceable Stock Opening Balance Import
The standard Traceable Opening Balance Import does not allow multiple cost prices for the same stock code, this is very troublesome and can cause a lot of additional manual work. I had a site that recently went live and had spent a long time prepa...
Guest
over 10 years ago
in Stock
0
Idea Accepted - Gauging Support
Ability to specify stock unit when importing stock items
When importing stock items the stock unit is currently drawn from the product group. As it isn't possible to change the stock unit it should be possible to specify this for each item in the import file.
Guest
almost 11 years ago
in Stock
0
Idea Accepted - Gauging Support
Import stock - for the system to pick up the nominal codes from the Product Group
When you import stock records, you have to enter the nominal codes for the item even though you're selecting the product group - which already has the nominal codes on. There should be a tick box at the least for it to use the standard Product Gro...
Guest
over 7 years ago
in Stock
0
Idea Accepted - Gauging Support
Financial Data Designer to have the same functionality as Amend Financial Layouts
eg Subtotals so that you can show Gross Profit, Operating Profit, EBIT, Net Profit etc Text lines to put spacing in the report At the moment you have manually add a total in the Pivot Table settings for Net Profit etc ...
Saeed Malik
over 7 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
Can you create a system so we can organise the excel reports - we currently have a long list of reports and it can be hard to find the one you want. A folder system would be useful.
Guest
almost 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
A report in excel that produces a one line summary of budget vs actuals for a specified month and YTD. The report should include totals and full department names to make it as useful as possible. As a school the majority of our internal management...
Guest
almost 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
