Documentation
Spaces
Apps
Templates
Create
Jiwa 7
All content
Space settings
Shortcuts
REST API
REST API
This trigger is hidden
Webhooks
Webhooks
This trigger is hidden
Solutions in addition to the Service Releases
Solutions in addition to the Service Releases
This trigger is hidden
Plugins Store
Plugins Store
This trigger is hidden
Content
Results will update as you type.
Jiwa 7 User Guide
Plugins
REST API
Jiwa BI
Warehouse Management System
FAQs
Troubleshooting articles
•
Invalid column name 'ActiveLogin'
•
Fix assembly reference error in plugins when reported upon import
Reducing the size of the database
•
Pantry List may give error if sell price is 0.00 - Cannot divide by zero
•
Improve database performance
•
'Creditor warehouse not found' error reported when loading inventory in a newly upgraded 6.5.13 database
•
'Currency record not found' when running period rollover on Creditors
•
'Key already exists' error is reported opening a form e.g. EFT / Cheque Payments
•
Activating a transaction reports an error - '...unable to insert into GL_Ledger ...'
•
Ageing of transactions during Period Rollover can apply Period Rollover Date
•
All users are locked out of the system - how can this be corrected?
•
An error is reported when invoicing Import Costs in a Shipment - apportioned costs need to balance
•
Apportion and invoice import costs simultaneously before stock has been booked in creates an incorrect journal - 7.00.175
•
Archiving sales order data error - 'CREATE TABLE permission denied in database ...'
•
Archiving sales orders errors
•
Barcode scanner is dropping the first character when searching for sales order numbers
•
Bill Complete invoices repeat lines for every snapshot rather than consolidating on the last snapshot - 7.02.00.00 and 7.02.01.00
•
BMMGT010 - Bill of Materials Component WIP is not reporting components correctly where output > 1. Grouping by Work Orders is not available
Can I run V6 and V7 on the same server?
•
Cannot Connect to the SQL Server or Logon Failed
•
Cannot insert duplicate key row in object ....
•
Changes to the ledger account are not retained when entered in Write On or Write Off amount in Debtor Adjustment form
•
Copying a quote and changing the debtor before saving did not ask if prices were to be re-calculated
•
Creating a 7.00.175 to 7.02.01 databases under SQL2017 and higher errors 'Could not import package...'
•
Creating a new Jiwa database where Australian Dollar is not the local currencies sets both as Local
•
Creditor remittance email did not have tokens for FX values
•
Creditor Transaction Archiving fix to "String or binary data would be truncated".
•
CRM Dashboard - 'Hierarchical Chart Error - There must be at least one row and one numeric column and data must all be positive values'
•
CRM Dashboard "My Customer Invoices Overdue" displays incorrect data
•
CRM dashboard errors 'Execute permission was denied on the object 'RecIDList'
•
CRM Dashboard My Customers sales for Sales This Month are incorrect - 7.01.00, 7.02.00 and 7.02.01
•
CRMGT040 - Creditors Listing - Transaction Due Date Report - V 7.00.175.00 SR13, V 7.02.01 SR4
•
CRMGT041 - FX Creditors Listing - Transaction Due Date is ignoring the FX Creditor Only parameter
•
CRTRN011 and CRTRN012 reports for creditor sourced transactions are reporting incorrectly
•
Current month sales are not displayed in the Pantry List - 7.02.00 and 7.02.01
•
Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items
•
Customer Activities > Processed Sales tab takes a long time to load
•
Database Login dialog box for JiwaReports is loaded when trying to print any report
•
DB GL Reconciliation Report can give variance between Current Year Open + Current Year Movement and Next Year Open - 702.00 and 7.02.01
•
DBINF025 - Debtor Contact details does not display Secondary and Tertiary data - 7.00.175, 7.02.00, 7.02.01
•
DBINF025 - Debtor Contact Details Report
•
DBTRN010 - Debtor Transactions Report - 7.00.175, 7.02.00 and 7.02.01
•
Debtor Address Labels does not filter by Postcode
•
Debtor Child sales orders do not appear in the Parent / Head Office account - 7.00.175 SR10 and prior
•
Debtor Parent Price element is not being applied to child debtor accounts
•
Debtor Payment and Allocations screen display whole dollars only 7.00.175
•
Debtor Sales tab errors where the General Ledger periods are non standard 'Object reference not set ...' 7.00.175
•
Debtor System Template form will not load where there are no templates in a 7.02.01 database
•
Debtor System Templates errors with a Duplicate Field Name issue when using the same field name in different templates
•
Deleting a line on a sales order credit note errors on Total of SO_LineDetails.Quantity
•
Deleting warehouse back orders did not update the IN_OnBackOrder table - 7.02.00
•
EFT / Cheque batch does not activate and there is no error message - 7.00.157, 7.01.00 and 7.02.00
•
Emailing errors 'Operation unavailable (Exception from HRESULT ....GetActiveObject'
•
Emailing may report an error 'String or binary ...' in some cases
•
Error adding line to Warehouse Purchase Order "Could not find an inventory item with inventoryID of 'nnn'.
•
Error logging in to a newly upgraded database - duplicate key value supplied
•
Error performing a yearly roll-over in a Azure 7.00.157 database 'Master.dbo.SysProcess .. is not supported in this version of SQL'
•
Error reported saving changes to a sales order that quantities do not match
•
Error reporting when emailing from Jiwa - Operation aborted (Exception from HRESULT ...)
•
Error running any Jiwa report where Jiwa is installed locally
•
Errors are reported when managing the grid custom columns in search windows 'Width must be between -1 and 9999999'
•
Error when loading sales orders - Key not found. Drill to Source Order'
•
Error when opening Quotes - 'incorrect syntax near the keyword 'AND'
•
Error when opening sales order 'The added or subtracted value results in an unrepresentable date/time
•
Error when printing from a sales order to the screen - 'You do not have permissions ..'
•
EX GST Total is not always correct in the standard invoice report - 7.02.01
•
Exporting inventory with leading zeroes in the part number reads as a number
•
Find Stock from Other Sales Orders errors in a specific situation
•
Form slide bar to the right doesn't work
•
Freight is incorrectly included in the total for invoices for snapshots > 1 in version 7.01.00
•
General Ledger Listing with Source report prints #######
•
General Ledger posting to incorrect periods in 7.00.149
•
Generic Dashboard is slow to load and eventually reports a timeout error message
•
GLINF010 - Chart of Accounts displays all classifications
•
GLINF022 - General Ledger Listing with Source report is slow to return data
•
GLMGT200 - Profit & Loss errors Database Vendor Code: 468 Error
•
GLMGT200 - Profit and Loss this year comparative always reports the full year figures 7.00.175
•
GLMGT235 - Profit & Loss With Actuals, Budgets, Variance reported incorrect budget 2 and 3 information
•
GLMGT235 - Profit and Loss with Actuals, Budgets and Variances can error 'Database Vendor Code: 8114...'
•
GMGT022 - General Ledger Listing With Source report shows ##### where values exceed 999,999.00
•
Grouping using the standard Plugin Journals Created From Sales Orders - Group by Sign and Account is incorrect where different BAS codes apply - 7.00.175
•
GST code of Export Free (G2) was selected instead of No Code - what's an easy fix?
•
How can I restrict a Service Manager job to a warehouse or allow stock to be allocated from any warehouse
•
How does changing a part number impact reporting and historical data
•
How do I find out what tables are using the most space in the database
•
How do I find why the inventory is out of balance running the Inventory Reconciliation report
•
How do I stop the text in a search field from automatically being selected in a search window
•
How to change the serialised item on subsequent snapshots
IFS Smartfreight Plugin is not sending ChargeTo field to SmartFreight
•
Imported stock records don't appear in Transaction History or Inventory Quantity As At report
•
Importing sales orders via XML for child accounts is not updating the parent debtor record
•
Importing Staff Records from another database errors with 'Staff not found'
•
Import of inventory transactions errors 'Object reference not set to an instance of an object
ININF026 - In Stock by Bin was ignoring selected warehouses
•
Insert into SY_MenuItemReport error on upgrade to a later Version 7 release
•
Installing or un-installing Jiwa or a service release of Jiwa reports an issue with 'invalid digital signature'
•
Invalid filters in the Region Maintenance form - 7.02.00 and prior
•
Invalid inventory search filters for Category 3 and Category 4 corrected
•
Inventory->Order->On BackOrder tab shows blank Invoice numbers
•
Inventory > Orders > Used in Work Orders quantities are incorrect where Production Quantity > 1
Show more below
Blogs
Jiwa 7
/
Troubleshooting articles
/
Cannot Connect to the SQL Server or Logon Failed
Summarize
Cannot Connect to the SQL Server or Logon Failed
Scott Pearce
Mike Sheen
Owned by
Scott Pearce
Last updated:
Aug 09, 2022
by
Mike Sheen
8 min read
Loading data...
Scott Pearce
Mike Sheen