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.
Show more above
•
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
•
ININF010 - Stock On Hand report has been adjusted so that the partno and description fields do not overlap
•
ININF028 - Stock on Hand by PartNo by Warehouse has been re-formatted
•
ININF041 - Stock on Hand with Allocations has been re-formatted
•
ININF066 - Inventory Quantity As At report has been re-formatted
•
ININF150 - Serial Number Tracking report has been updated to report all supported transaction types 7.02.00
•
INTRN010 - Inventory Stock Transfers report re-aligned
•
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
Show more below
Blogs
Jiwa 7
/
/
Inventory reports have been re-formatted for readability
/
ININF010 - Stock On Hand report has been adjusted so that the partno and description fields do not overlap
Summarize
ININF010 - Stock On Hand report has been adjusted so that the partno and description fields do not overlap
Julie Hanlon
Owned by
Julie Hanlon
Last updated:
Oct 24, 2019
1 min read
Loading data...
Refer to
https://service.jiwa.com.au/browse/DEV-7793
.
Updated report is attached for download.
{"serverDuration": 23, "requestCorrelationId": "9f659cb17cee45d38cc58a28e120465f"}