SQL Query Store - Jiwa 7

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.

•
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
•
BookIn Activation can sometimes result in an error - "Add failed. Duplicate key value supplied"

You‘re viewing this with anonymous access, so some content might be blocked.

/

SQL Query Store