Documentation
Spaces
Apps
Templates
Create
Jiwa 7
All content
Blogs
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
Content
Jiwa 7 User Guide
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
•
Inventory Export to CSV errors when logging into an upgraded Jiwa database
•
Inventory field Description does not display all the information where there is a lengthy description - 7.02.00.00 and higher
•
Inventory Import creates new parts when "Update existing Inventory" has been ticked
•
Inventory On Order tab errors with "An error occurred when parsing EntityName."
•
Inventory Qty as At Report reports warehouse inwards incorrectly when In Transit is not used - 7.01.00 only
Inventory reports have been re-formatted for readability
•
Inventory transaction import errors when importing stock records with a Bin Location
•
JCMGT020 - Job Costing Actual Listing is not reporting all data types
•
JCMGT110 - Job Cost Actuals vs Budget Variance is not reporting actuals for creditor materials
•
Jiwa appears to drop its connection to a physical printer
•
Jiwa appears to freeze when using Search
•
Jiwa BI / QlikView is not displaying data beyond a certain year
•
Jiwa BI / QlikView model won't load data due to loops
•
Job Costing transactions are not appearing on the job after upgrading from 6.5.13 to 7.00.175
•
Journals created by activating a Cash Book Receipts batch is not grouping - 7.02.00.00 SR2
•
Journal Transaction scroll bar does not work and entering in large transactions becomes very difficult
•
LCINF020 - Inventory Booked in but Not Invoiced with a book in status
•
Licence expires for Jiwa Financials demonstration data 07.00.157.00 and 07.00.175.00
•
Loading a BOM gives error "Key already exists, key: x"
•
Loading and editing records in the Sell Prices form can be slow
•
Loading a new Job Costing job that has back orders errors 'Invalid row index:...get_item' - 7.02.00.00 SR3 only
•
Loading a purchase order errors for one user only - 'multi-part indentifer could not be found'
•
Loading a search window errors with 'An Error occured applying the Custom XML definition to the grid Default ...'
•
Loading Creditor Transaction batches may error with "Conversion from string %s to type decimal is not valid"
•
Loading Debtors Transactions in Debtors Maintenance is very slow
•
Loading Debtor System Template form errorsafter upgrade to 7.02.00 - could not load file or assembly...
•
Loading Inventory - Order - On Order tab can error with An error occurred while parsing EntityName Line 1 position 4735
•
Locating and correcting errored journal sets
•
Login fails for login SQL users
•
Make a Quote from Sales Order containing a kit and components with default prices of 0.00 errors - 7.02.00.00
•
Making Quote from a Sales Order errored if the sales order included a kitted item
•
Manually adding kits to a purchase order displays warning message
•
Manual Serial Numbers form does not work where there is more than 1 line on the sales order - 7.02.00
•
MNT12201 - Warehouse Transfer Detailed errors in 7.02.00
•
MNT12501 - Bill Maintenance report does not group sub-assemblies under correct input
•
MNT40001 Purchase Order report
•
MNT50001 - General Ledger account report does not report Next Year Open for Balance Sheet accounts but does for P&L accounts
•
MNT55001 - Cash Book Deposit Slip
•
Moving lines does not correctly update the Delivered Total on the original sales order - 7.00.175
•
New report INTRN065 - Stock Take History with Categories
•
Non-physical inventory items used in Job Costing now appear in Transaction History tab
•
No Valid Licence Available
•
Object reference not set ..DisplayShipmentLine error when loading the Shipment form
•
Opening an inventory items errors -'The value property cannot be set ...outside the range ...MinValue .. MaxValue ...'
•
Opening Debtor System Template form after update may error with "Could not load file or assembly 'JiwaApplication, Version=7.1.0.0"
•
Order > On Back Order tab does not display back orders from Warehouse Transfer Outwards batches - 7.00.175
•
Outlook gives warnings about a program accessing email address information or sending email on my behalf
•
Out of memory issues when activating a large stock-take, stock transfer or shipment bookin in Version 7.00.149 or 7.00.157
•
Part numbers added or modified in the POS form are not always visible in the Items Added grid
•
Part numbers changing on sales orders, quotes, purchase orders, shipments and bookins
•
Period lock incorrectly reported when posting into the last month of the financial year 7.00.149
•
Plugin Maintenance errors with 'Duplicate key value supplied' when loading
•
Plugin Scheduler Logs the error The transaction operation cannot be performed because there are pending requests working on this transaction
•
Plugin to implement the ability to 'Insert New Inventory Item' in a quote
•
Plugin to prevent 0.00 FX Amount transactions being saved where Amount > 0.00 - 7.00.175 only
•
POINF022 - Replenish ReOrder report ignored the criteria selection for 'BOM Parents?'
•
POINF022 Replenish Reorder Report - incorrect formula for UoM items - 7.02.00.00 and earlier only
•
POINF024 - Outstanding Warehouse Purchase Orders report Transfer field is too short
•
POS plugin updated to correct rounding variances when using the POS form - 7.02.01
•
Price Updates using the Import from Excel errors "Cannot create ActiveX component" error when selecting the Excel file
•
Process Back Orders is not fulfilling back orders on Warehouse Transfers - 7.00.175, 7.02.00, 7.02.01
•
Purchase Invoice first invoice in warehouse produces error - 7.00.157 and prior only
•
Purchase Order Line Not Found when opening GRN
•
Qlik Sales Comparison 1 is sorting in the wrong order
•
Qlikview Invoice Date limited to 31/12/2017
•
Qty on Shelf and Qty Available SOH values are not displaying in sales orders and quotes
•
Refreshing or scrolling through creditor records while in the Transactions tab can error 'New transaction not allowed due to other threads running'
•
REINF010 - Receival Slips Uninvoiced modified to include status - Activated, Not Activated and All
•
REINF010 - Receival Slips Uninvoiced report is including reversals - 7.00.175 and earlier
•
Re-order reports sometimes give an error 'Failed to retrieve data from the database' when running
•
Report errors 'Database Vendor Code:'
•
Report printing font size has changed since upgrading from an older version of Jiwa 7
•
Retained earnings account issues when upgrading from 6.5.13 to 7.00.xxx
•
Sales order, quote inventory or purchase order part numbers not matching the description
•
Sales Order and Quote User 1 to 3 fields appear to be set to Integer rather than Float
•
Sales order archiving errors 'There is already an object named AR_SO_History ....'
•
Sales order D02 creates the same journal and debtor transaction as D01 though no stock was delivered
•
Sales tab on debtor maintenance may take a long time to load
•
Saving a new record reports a duplicate key error
•
Saving changes to permissions in the sales order form errors 'Cannot insert duplicate key row ...SY_UserGroupPermissions...'
•
Script to un-age creditor transactions and allocations based on a supplied date
•
Script to un-age debtor transactions and allocations based on a supplied date
•
Scrolling debtor records errors "The value property .....'MinValue' and MaxValue' ....'
•
Search Window results jump when selected
•
Selecting the Inventory Order tab errors with 'Cannot access a disposed object ...WebBrowser'
•
Sending Emails using Outlook errors with "Could not load file or assembly 'Microsoft.Office.Interop.Outlook...'"
•
SMMGT090 - Inventory by Job report is not returning any data
•
SOINF082 - Sales Listing Report
•
SOMGT051 - Sales with COGS by Debtor displays no data when reporting by Branch - 7.02.01 and earlier
•
SOMGT051 - Sales with COGS by Debtor does not filter by Branch
•
SOMGT083 - Sales with COGS by Staff by Debtor Class by Prod Class reports credit notes correctly
•
Sorting on the Invoice No field in debtors Customer Activities > Unprocessed Sales Order is disabled
•
SQL Transaction Log growing exponentially
•
Standard invoice lists all the serial numbers invoiced rather then the serial number applicable to the delivery - D02 and higher
•
Supplier part no. not appearing on purchase order lines
•
Supplier Return Credit errors "Object reference not set to an instance of an object"
•
Text entered in a sales order is cleared on save - 7.02.00.00 SR3
•
The current Jiwa demonstration licences for 7.00.157 have expired
•
The customer price being imported via XML sales order import is being ignored
•
The global Search form is slow to load when looking for GRNs
•
The Global Search form results in error "Object reference not set to an instance of object"
•
The Kit header has a price and all components are delivered but the invoice total is 0.00
•
The quantity order on a purchase order is rounding up from 4 decimals to a whole number
•
Transaction History type Sales Order Outwards returns no data
•
Transaction log grows to a large size due to uncommitted insert to SY_LicenceUsages table
•
Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form
•
Unable to create a Demo database on SQL 2016
•
Unable to un-install Jiwa 7.00.175
•
Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory
•
UPC / bar-code (Aux2) field in inventory searches is now supported
•
Upgrading from 07.00.175 to 07.02.00 may appear to 'hang' at upgrade script 34163
•
Upgrading from an earlier version to Jiwa 7.00.175 or 7.01.00 may error with a DB_Notes issue on script 34114
•
Upgrading process for version 7.0.175 may timeout when running scripts 7.0.165.40 and 7.0.165.50
•
Use Value of Taxable Import box automatically ticked when creating a new shipment
•
Using custom columns and hiding every column will leave the user with no way to make further adjustments
•
Warehouse field was incorrectly disabled in the Move Lines to New Sales Order standard plugin - 7.00.175
•
Warehouse Summary grid Unprocessed Sales Orders to exclude unprocessed credit notes
•
When the Inventory Console plugin is enabled, loading two inventory maintenance forms can display incorrectly
•
Where Supply Order Units > 1 stock is being over-ordered using Replenish to Minimum Re-Order method
•
Why don't invoices print when running Process Back Orders
•
Work order inputs do not appear in the Inventory >Transaction History tab - 7.02.00 and 7.02.01
•
Yearly rollover hangs
•
What report can I use to track postings to an account for a defined Set Number range?
•
CRTRN050 - Outstanding Creditor Invoices includes creditor purchases - 7.02.01 and prior
•
When debtor is on hold, backorder processing may not fulfill backorders.
•
Jiwa fails to launch
•
DBMGT060 - Debtors Balance As At has been made faster
•
ININF066 - Inventory Quantity As At does not include Work Order inputs - 7.02.00 and 7.02.01
•
GLINF021 - General Ledger Transaction Listing (Add GL Account Description)
•
Invoicing Timesheets and writing off an amount is not showing in JCMGT070 - Job Cost Work in Progress
•
Divide by zero error when viewing creditor transactions 7.02.01 SR16
•
Intermittent errors emailing using Office 365 as an SMTP server
•
SQL Query Store
•
Isolating "String or binary data would be truncated" errors
How-to articles
Version History
Jiwa 7
/
Troubleshooting articles
Summarize
Troubleshooting articles
Mike Sheen
Owned by
Mike Sheen
Last updated:
Aug 22, 2016
Version comment
1 min read
Loading data...
Add troubleshooting article
Title
Creator
Modified
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
Archiving sales orders errors
Beth Blok
Nov 17, 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
Plugin to implement the ability to 'Insert New Inventory Item' in a quote
Beth Blok
Apr 27, 2023
Find more results
{"serverDuration": 13, "requestCorrelationId": "26ffb0c5d3644830a2e02388b5cd2e1d"}