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
SOP Reprint Invoices - Add Button to Amend Customer Order Number
eg The customer order number is not known or is missed when the order is created. Once the invoice has been posted you cannot change the Customer Order Number, Some organisations will not pay invoices until a purchase order number is shown on an I...
Saeed Malik
over 10 years ago
in Reprint Invoice
0
Idea Accepted - Gauging Support
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
When reprinting invoices in SOP, you open the form select a single invoice to print and then it closes the form Can it either: 1) allow select of multiple invoices to print or 2) return to the reprint invoice form after printing the invoice
Guest
about 7 years ago
in Reprint Invoice
0
Idea Accepted - Gauging Support
SOP Reprint Invoices - Keep window open after printing
As you can only select an individual Invoice number / date / order number / customer account - if you need to reprint multiple invoices that do not have anything in common, it would be handy to keep the window open after printing an invoice so the...
Guest
almost 10 years ago
in Reprint Invoice
0
Idea Accepted - Gauging Support
Some method (probably an additional field on the SOPOrderReturnLine table) that would enable the tracking of items added via cross-selling on Sales Orders, and Quotations if cross-sell was enabled on there. This would then allow customers to analy...
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
lock the import ledger file transaction process in nominal ledger
sage will allow multiple users to import at same time which can end up in import imbalances (although added together they do balance) the client would like this process to be exclusive to 1 user to prevent this from happening
joanne scott
almost 4 years ago
in Locking
0
Idea Accepted - Gauging Support
