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
•
Delete documents attached to Quotes based on criteria
•
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