1 Program Enhancements – 7.02.00.00
- 1.1 Bill of Materials
  - 1.1.1 Bill of Materials Import
- 1.2 Cashbook
  - 1.2.1 Importing
- 1.3 Creditors
- 1.4 Creditor Maintenance
- 1.5 Custom Field Support
- 1.6 Debtors
  - 1.6.1 Debtor Maintenance
  - 1.6.2 Debtor Specific Pricing
- 1.7 Demonstration Database
- 1.8 File Watcher
- 1.9 Goods Received Notes
- 1.10 General
- 1.11 Installation Process
- 1.12 Inventory Maintenance
  - 1.12.1 Component
  - 1.12.2 Selling Prices
  - 1.12.3 SOH
  - 1.12.4 Transaction History
- 1.13 Landed Cost
  - 1.13.1 Bookins
- 1.14 Licencing
- 1.15 Printing
- 1.16 REST API
  - 1.16.1 API Key Authentication
  - 1.16.2 Creditors
  - 1.16.3 Journal Sets
  - 1.16.4 Landed Cost
  - 1.16.5 Tax Rates
  - 1.16.6 Warehouse Transfers
  - 1.16.7 Webhooks
- 1.17 Sales Orders
  - 1.17.1 MNT30003 - Picking Sheet
  - 1.17.2 MNT30004 - Packing Slip
  - 1.17.3 MNT30005 - Order Confirmation
- 1.18 Search
- 1.19 Serial Number Tracking
- 1.20 SQL Logins
- 1.21 Staff Maintenance
- 1.22 List of Program Enhancements
2 Complete List of Changes

Program Enhancements – 7.02.00.00

Bill of Materials

Bill of Materials Import

A plugin has been included in the standard plugins that supports importing of Bill of Material maintenance records. Full details to implement are detailed in the plugin together with a sample import file.

Cashbook

Importing

A plugin, "Cashbook Bank CSV Import" is included but disabled which provides a framework for other plugins to add CSV import functionality. Another plugin, "Bendigo Bank Cashbook CSV Imports" uses this framework to allow importing from the Bendigo bank CSV formats (simple or extended). When both plugins are enabled, the Cash Book ribbon has a new drop-down tool in the Actions group - "CSV Import" - and the user can select either the "Bendigo Bank Simple" or "Bendigo Bank Extended" options.

Other plugins can extend the options - so other CSV formats can be added.

Samples used for testing the 2 Bendigo Bank imports are attached in the Documents tab of the Bendigo Bank Cashbook CSV Imports plugin .

Creditors

Creditor Maintenance

Custom field support has been implemented in the Creditor > Transactions tab in the credit and debit grids

Custom Field Support

Custom field support has been added to the following forms

Debtors

Debtor Maintenance

Debtor Specific Pricing

A standard plugin has been implemented that extends the Inventory CSV Import to allow debtor specific prices to be imported - sample file example below:

DebtorSpecificPriceRecID, PartNo, DebtorAccountNo, Source, Mode, Amount, UseQuantityBreak, Debtor Quantity Break , 1170, 1001, sellprice, Percentage, -5.25, true, 5 , 1170, 1001, lastcost, Percentage, 8.50, true, 6 78E5AD93EDC84A1DBF7A, 1171, 1001, rrp, Percentage, -10.00, true, 10 , 1171, 1001, p1, Percentage, -10.00, true, 15 , 1172, 1001, p1, None, 112.25, true, 20

Demonstration Database

The data in the demonstration database has been incremented by one year, with Current Year being 2018 (1 July 2017 to 30 June 2018) and Next Year being 2019 (1 July 2018 to 30 June 2019). Items that use serial numbers have SN included in the part numbers and some serialised items that appeared in the list when loading inventory in Part Number order have had SN added to the start of the part number e.g. SN1090-M1-SN, SN1090-M2-SN. All relevant inventory history has been updated.

File Watcher

The File Watcher journal import now includes the ability to import GST codes in the CSV file. A sample file Journal Set - With BAS Codes.csv is available in the directory C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Documentation and Samples\File Watcher Plugin\CSV

Goods Received Notes

A new Sort Order based on Received Date has been added to the GRN form and is the default sort order when opening the form i.e. the most recent GRN is the form displayed by default when loading this module. It was previously loaded in GRN number order.

Jiwa 7.02.00.00