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
Ability to put nominal codes on hold if they are no longer to be used
To limit use of nominal code/CC/depts., there seems to be an ability to make inactive and disallow manual journal entries. However supplier transaction imports can still be posted to nominal code/CC/dept. combinations even if they are made inactiv...
Tracey Hoggart
over 2 years ago
in New/Amend Account
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
Further Identifier on nominal accounts to help with screen selections
I come across this regularly when implementing new sites that when it's a new nominal structure the staff don't tend to know the codes immediately and click on the drop downs be it in any of the available screens and get presented with the full no...
Guest
almost 6 years ago
in New/Amend Account
0
Idea Accepted - Gauging Support
Realigning NL Codes across numerous Sage200 companies for Reporting
Our set up is 20+ individual companies in Sage 200. Through the years the NL Codes for the numerous Individual Companies have become out of sync. My understanding of S200 is – When transactions have been assigned to a NL code the NL code cannot be...
Guest
over 2 years ago
in New/Amend Account
0
Idea Accepted - Gauging Support
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
This will assist support on the product, I needed to on several occasions try to find how data has got into the system when a customer is sure the data was not imported. It would be great if when a item is imported into sage via one of the standar...
Guest
over 10 years ago
in Database
0
Idea Accepted - Gauging Support
Add several Analysis Codes to Nominal Ledger Codes
If I could addseveral Analysis Codes to each Nominal Ledger Code I could further automate my reporting. Currently I report to several Directors using three separate classifications of the Nominal Codes. This is done in Excel. All the other modules...
Narrative field to exist in trader ledger transaction tables
To display the narrative on reports and layouts, e.g. Purchase Remittance, requires the inclusion of the NLPostedNominalTran/NLDeferred NominalTran/NLPendNominalTran table(s) (depending on system configuration) by joining on the UniqueReferenceNum...
Guest
over 7 years ago
in Database
0
Idea Accepted - Gauging Support
