Program Enhancements – 7.01.000.00

...

Back-orders from Work Orders are now displayed in the On BackOrder tab under Inventory Maintenance.

Reports

Grouping option by Work Order has been added to the report BMMGT010 - Bill of Materials Component WIP so components allocated to WIP can be viewed by the work order they're attached to

...

• Can now elect to update debtors if they already exist
• Mappings can be saved as a named mapping set, and retrieved
• Plugins can alter or extend the import
• Contact names can now be included

 
An example file for a contact name import for an existing debtor with Account No "1001" is as follows:

AccountNo,Title,First Name,Surname,Contact Email,Contact Phone,Mobile,Primary Position
1001,Mr,Bill,Smoth,bills@example.com,0294090707,0414733222,Owner
1001,Ms,Sally,Smoth,sallys@example.com,0294090700,0414733223,Owner
1001,Mrs,Jill,Bottoms,bottoms@example.com,0294090709,0414733224,External Accountant Note(1)

Notes:

• An existing contact is identified by the email address field - when supplied, a contact is only updated if a contact email address for that debtor exists, otherwise the contact is inserted.

...

• In respect to delivery addresses, the delivery address Name field is used to identify existing delivery addresses - when supplied, a delivery address is only updated if a delivery address name exists for that debtor exists, otherwise the delivery address is inserted.

Export and Import to and from CSV

   Image Added

A new form and business logic has been provided to export debtors to a CSV file. The Debtor Import from CSV has been enhanced to allow updating of existing debtor records Image Removed

Maintenance

Groups

Item support has been added to the grid for Groups so that records can be dragged and re-organized as required.

...

We have added an index to TradingStatus column of DB_Main. Queries used by search windows for selecting a debtor may see improved performance as a result.

IF NOT EXISTS(SELECT * FROM sys.indexes WHERE Name = 'IX_DB_Main_DebtorID_AccountNo_Name')
CREATE NONCLUSTERED INDEX IX_DB_Main_DebtorID_AccountNo_Name ON DB_Main(TradingStatus) INCLUDE (DebtorID, AccountNo, Name)

Transaction Importing

Documentation for this utility has been updated and can be found in the directory C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Documentation and Samples\Importing\Debtors\Transactions

...

The speed when loading this form that has a large number of records has been significantly improved. A patch for 7.00.175 is available from https://docs.jiwa.com.au/display/J7UG/Loading+and+editing+records+in+the+Sell+Prices+form+can+be+slow

Transaction History

The Transaction Type field has been widened so all the Tranaction Types available are now fully displayed for selection.

...

The existing method of licencing was causing issues with transaction log growth. The licencing has changed to a per seat licence. Users are now explicitly attached to a licence by the customer - they now choose which Jiwa users are attached to which licences issued within the Licence maintenance form. Named user licences are now deprecated.

The licencing form has changed to provide a simple way of linking users to a licence. Only enabled users use a licence, and an easy method of disabling or enabling users via the licencing form has been provided.
Where there are licences for a previous version (upgraded database), it will attempt to attach licences to the same users as the previous version, ordering by username up until the number of CALs of the licence.
  Where there were no previous licences (new database), the active, enabled users are added in username order up until the number of CALs of the licence.

The Company Name has been added to the Licencing form together with a button to open a dialog to set the company name from there. Use the Import Licences icon to import the relevant licences if the company name has been changed.

...

The Jiwa 7 REST API is a restful web service providing a means to interact with the Jiwa database and business logic via HTTP verbs.
The bulk of the REST API is provided by a Jiwa plugin.  A windows service and web deployment package provide the mechanism to host the service, but the routes and the logic behind each route are defined in the plugin. Additional or alternative routes and logic can be provided by an additional plugin or plugins.

Full documentation on this feature can be found at https://docs.jiwa.com.au/display/J7UG/REST+API

...

The ability to search for Shipments and Shipment Bookins has been added to the search options.

Remember: You can create your own stored procedures and add to this form. You can also speed up the searching by un-ticking the options you don't use e.g. Service Manager, Supplier Returns, Contacts

...

The previous field Account is Enabled has been re-named to Active Staff Member, It is used to indicate if the staff member is an active employee.
A new field "Account Enabled" appears below "Active Staff Member" and this maps to a new field - HR_Staff.IsEnabled.
The licencing system now only counts licences for staff members where IsEnabled is set, and users can only log into the system if IsEnabled is set.

Supplier Returns

Requests, Shipping and Credits

...