Custom logoCustom icon
Documentation
Templates

Jiwa 7

  • All content
  • Space settings
  • 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
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
    • •
      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
    • •