Solutions in addition to the Service Releases

The following Troubleshooting and How To articles may also be of interest - they address issues which cannot be fixed by the installation of the service release, but contain information, scripts, reports or plugins to address other issues.

Archiving

• Archiving sales orders errors

• Creditor Transaction Archiving fix to "String or binary data would be truncated".

Back Order Processing

• SOMGT110 - BackOrder Processing Report Improvements

• When debtor is on hold, backorder processing may not fulfill backorders.

Bill of Materials

• Work order inputs do not appear in the Inventory >Transaction History tab - 7.02.00 and 7.02.01

Cash Book

• Allow plugins to set currency on Cash Book Transactions

Creditors

• Creditor Activities - Processed Orders Tab Uses Last Modified Date

• CRMGT040 - Creditors Listing - Transaction Due Date Report includes all valid transactions

• CRTRN011 and CRTRN012 reports for creditor sourced transactions are reporting incorrectly. 

• CRTRN050 - Outstanding Creditor Invoices includes creditor purchases

• Stored procedure usp_JIWA_Creditor_Update_Period_Balances is not calculating FXPeriod2, FXPeriod3 and FXPeriod4 correctly under some circumstances

Debtors

• Customer Activities tab - Processed and Unprocessed sales to include Job Costing invoices and non inventory items

• DBINF025 - Debtor Contact Details does not display Secondary and Tertiary data

• DBMGT060 - Debtors Balance As At has been made faster

• New report DBINF026 - Debtor Contact Export. For the purposes of marketing and bulk emailing, a simple report which extracts all the emails of the debtor contacts has been created.

• Emailing may report an error 'String or binary ...' in some cases

• Sales tab on debtor maintenance may take a long time to load

• Sorting on the Invoice No field in debtors Customer Activities > Unprocessed Sales Order is disabled.

General Ledger

• GLINF021 - General Ledger Transaction Listing (Add GL Account Description) - Jiwa 7

• New report GLINF023 - General Ledger Listing with Source by Set No criteria added

• GLMGT235 - Profit & Loss with Actuals, Budgets and Variance - 07.02.00 and 07.02.01

• Transactions to display BAS Code and allow drill direct to source

• Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form

General / System

• Ageing of transactions during Period Rollover can apply Period Rollover Date

• CRM Dashboard My Customers sales for Sales This Month are incorrect - 7.01.00, 7.02.00 and 7.02.01

• CRM Dashboard errors 'Execute permission was denied on the object 'RecIDList'

• Expanded Search Forms for Sales Orders, Quotes, Work Orders, POs and Jobs

• How to drill to forms from a report

• How do I re-size the row height in Notes

• https://jiwa.atlassian.net/wiki/x/_QgP

• https://jiwa.atlassian.net/wiki/x/BQCIBw

Inventory

• Deleting warehouse back orders did not update the IN_OnBackOrder table - 7.02.00

• ININF026 - In Stock by Bin was ignoring selected warehouses

• ININF030 - Inventory Slow Moving Products reports products that have sold recently

• ININF066 - Inventory Quantity As At does not include work order inputs - 7.02.00 and 7.02.01

• ININF055 - Inventory Reconciliation - Performance Improvement

• Invalid inventory search filters for Category 3 and Category 4 corrected

• Inventory reports have been re-formatted for readability

• New report INTRN065 - Stock Take History with Categories

• Warehouse Summary grid Unprocessed Sales Orders to exclude unprocessed credit notes

• Warehouse Summary SOH - Forecast Work Order Component WIP - Updated calculation for Fixed Quantities

• Additional Stock Take reports.

Job Costing

• JCMGT070 - Job Cost Work in Progress does not report time-sheet write offs when costs are invoiced

Landed Cost

• Use Value of Taxable Import box automatically ticked when creating a new shipment

Purchase Orders/Purchasing

• Changing the status of a purchase order to Closed when all lines are received/booked in

• POINF022 - Replenish ReOrder report ignored the criteria selection for 'BOM Parents?'

• Printing delivery notes in a purchase order report

Receiving

• 7.2.1.0 SR21 and above sites to add a PI filter to not show GRNs in the PI GRN grid search that are not fully invoiced:

• REINF010 - Receival Slips Uninvoiced modified to include status - Activated, Not Activated and All

• Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory

Reports

• SOMGT070 - Reserve Orders Delivered Not Invoiced - Value double up

• SOINF082 - Sales Listing Report. Report summary fixed.

• SOMGT083 - Sales with COGS by Staff by Debtor Class by Prod Class reports credit notes correctly

• Unit of Measure details added to Sales Orders, Quotes & Purchase orders Reports

Sales Orders

• Current month sales are not displayed in the Pantry List - 7.02.00 and 7.02.01

• EX GST Total is not always correct in the standard invoice report - 7.02.01

• Making Quote from a Sales Order errored if the sales order included a kitted item

• Plugin to implement the ability to 'Insert New Inventory Item' in a quote

• POS plugin updated to correct rounding variances when using the POS form - 7.02.01

• Standard invoice lists all the serial numbers invoiced rather then the serial number applicable to the delivery - D02 and higher

• https://jiwa.atlassian.net/wiki/x/MxYP