/
Jiwa 7.02.00.00

Jiwa 7.02.00.00

Feb 28, 2023



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 . 

  •  

    • negative amounts - receipts are ignored when importing into a Cash book payment, and positive amounts - payments - are ignored when importing into a Cash book receipt.

    • Transactions outside the month of the Cash book date are ignored

    • If the cash book contains no transactions, then at the start of import the cash book date is set to the earliest date in the CSV

    • An MD5 hash of the CSV transaction is stored against the batch line - this is used to prevent duplicate transactions being imported - when a line is to be imported, the hash is computed and then a search performed to see if another batch for the same bank exists with the same hash - if so, then the line is skipped from import.



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

  •  

    • Creditors - Transactions tab, both debit and credit grids

    • Debtors - Transactions tab, both debit and credit grids

    • Landed Cost - Shipment Bookins



Debtors

Debtor Maintenance

  •  

    • Custom field support has been implemented in the Debtor > Transactions tab for both the debit and credit grids

    • The issue of memory not being released with repeated opening and closing of the Maintenance from has been addressed by improving the cleanup code of base maintenance userinterface class, and explicitly overriding the remove handlers method of this form. NOTE: Any plugins which add event handlers to either the debtor form or business logic and do not remove their handlers will cause the issue to still occur.

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.