Receiving error message General SQL error [microsoft][SQL Native Client][SQL Server]LRM15 when posting a reversing journal.
In FMS click on:
1. Tools -> Define Financial Years -> Update Next Year’s Structures
2. Choose each tab in turn and copy to new year – especially the template tab and this will stop the error message.
kb821
Reviewed 03/01/2018
How useful was this article?
Click on a star to rate it!
Average rating / 5. Vote count:
No votes so far! Be the first to rate this post.
This will make a permanent link so items will not fail on suspense………
FMS PROCESSES REQUIRED FOR CHANGING FROM CENTRAL TO LOCAL PAYMENTS Tools>General Ledger Setup>ledger codes Add bank acct (usually BK01) Add petty cash (usually PC02) Tools>Books> Cheque Books – add Order books – add LPS one Petty Cash books – add LPS one Tools>Non-Invoiced Income Parameters Change from Central to Local Tools>Define VAT Periods Set up…
When trying to access Payroll2FMS you will see the following window as your licence will have expired on 30th September. Enter the details exactly as shown in the email that you have been sent. All details are case sensitive. Once the details have been entered click on “Validate Licence” and the “Licence Code is Invalid” should…
If a cheque is cancelled then the corresponding invoice should either be cancelled as well or a new cheque issued depending on the situation. Ensure that all outstanding invoices have been processed via the Cheque or BACS routines – try adding a new run to flag up any remaining. If the invoices need paying or…
Fatal Error generated when accessing areas of FMS This is usually a permissions issue where the user does not have create/write permissions for the directory path where the FMS SQL database is located eg: c:\program files\sims\fmssql or the user does not have permissions to the LOCKDIR directory containing the PDOXUSRS.NET file. TO RECTIFY Make sure…
Setup the Bank Account Go to Tools>General Ledger Setup>Tab 5 Ledger Codes (if you have not already defined your bank account then you should create one now) Enter the Account Name, Sort Code and Account Number details. Account Code – only numbers can be entered here and the field defaults to 0. You should accept…