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
Show more below
Blogs
Jiwa 7
/
Troubleshooting articles
Summarize
Troubleshooting articles
Mike Sheen
Owned by
Mike Sheen
Last updated:
Aug 22, 2016
Version comment
Loading data...
Add troubleshooting article
Title
Creator
Modified
SOINF082 - Sales Listing Report
Monica Holliday
Oct 24, 2024
Archiving sales orders errors
Beth Blok
Jun 12, 2024
Isolating "String or binary data would be truncated" errors
Mike Sheen
Mar 18, 2024
CRM Dashboard - 'Hierarchical Chart Error - There must be at least one row and one numeric column and data must all be positive values'
Beth Blok
Mar 04, 2024
Part numbers changing on sales orders, quotes, purchase orders, shipments and bookins
Beth Blok
Dec 11, 2023
Reducing the size of the database
Beth Blok
Dec 04, 2023
Emailing may report an error 'String or binary ...' in some cases
Beth Blok
Nov 08, 2023
Pantry List may give error if sell price is 0.00 - Cannot divide by zero
Julie Hanlon
Nov 06, 2023
Fix assembly reference error in plugins when reported upon import
Monica Holliday
Oct 15, 2023
Improve database performance
Max Avagliano
Sept 28, 2023
Work order inputs do not appear in the Inventory >Transaction History tab - 7.02.00 and 7.02.01
Beth Blok
Aug 31, 2023
ININF066 - Inventory Quantity As At does not include Work Order inputs - 7.02.00 and 7.02.01
Beth Blok
Aug 31, 2023
Creditor Transaction Archiving fix to "String or binary data would be truncated".
Beth Blok
Jul 14, 2023
Divide by zero error when viewing creditor transactions 7.02.01 SR16
Beth Blok
Jun 27, 2023
SOMGT110 - BackOrder Processing Report Improvements
Monica Holliday
May 25, 2023
Invoicing Timesheets and writing off an amount is not showing in JCMGT070 - Job Cost Work in Progress
Beth Blok
May 08, 2023
Database Login dialog box for JiwaReports is loaded when trying to print any report
Beth Blok
May 02, 2023
GLINF021 - General Ledger Transaction Listing (Add GL Account Description)
Monica Holliday
May 01, 2023
Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory
Beth Blok
Apr 27, 2023
Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form
Beth Blok
Apr 27, 2023
Find more results
{"serverDuration": 42, "requestCorrelationId": "45bd5d6a03d0406a9b0c8a8b7cdc1505"}