The Stock History is very difficult to work through, when looking for stock errors, because movements in and out are shown as positive numbers. Please either show Out movements as negatives numbers, or at least split in and out movements into 2 se...
Brenda Rawlings
over 2 years ago
in View Stock Item History
4
Idea Accepted - Gauging Support
More specific transaction type filters on View Stock Item History
On the View Stock Item History form, there is no way to filter by some specific transaction types such as sales order despatch and purchase order receipt. The only way to achieve this is to use 'All Goods In/Out' and set the account type to custom...
The Nominal Transaction table must have VAT Code/VAT Period ID fields against each NL Posting
When it comes to reconciling VAT Transactions for a submission period Vs Nominal posted transactions, there is no direct link between the two. It will be useful to have each transaction's VAT Code, VAT Type, VAT Period ID stored in Nominal Transac...
Rustum Khedkar
over 1 year ago
in Database
0
Idea Accepted - Gauging Support
Would be great (if possible) to see a running total of stock qty in the stock history screen. This would help users understand which movements have affected their stock levels.
Increase the Stock history default date range to more than 3 months
The stock history enquiry screen has a default date range of just 3 months. I realise that it can be customised and expanded but that only holds for each specific enquiry and the earlier date needs selecting every time. I am advised that the 3 mon...
On very rare occasions you may see duplicate URNs posted to the Sales Ledger due to environmental issues (deadlocks etc), this could possibly be prevented by setting a constraint on the SLPostedCustomerTran URN field field in the database to preve...
Tim Critchley
over 1 year ago
in Database
0
Idea Accepted - Gauging Support
Stock Item History BOM Build Record doesnt differentiate between Price and No Price records
Customers have asked if the BOM Build records could have a note against the BOM Build which is created once the build is completed with a cost price so they can easily differentiate between the lines with the unit cost without having to click into...
Ability to search POP and SOP for orders that contain specific stock items.
It would save a lot of time navigating, currently you have to go to Stock Levels to find the SOP/ POP numbers then go to the other modules to find the detail that&s not held within Stock Levels eg order discounts, document date etc
We create a number of reports in Sage based on data directly from SQL. We use the DateTimeCreated field in a number of tables to provide KPIs and time triggered reports. DateTimeCreated has always been generated from the Server time that SQL is ru...
Guest
over 8 years ago
in Database
1
Idea Accepted - Gauging Support
