System Configuration

Overview

This section details the system configuration settings that are available in the Jiwa 7 modules. The purpose of the settings is to provide flexibility and to satisfy the requirements for all the different types of businesses who use this software.

There are default values for each setting and these should be reviewed in conjunction with your Jiwa Solution Provider to ensure the results you want are being achieved. System settings are established for the system as a whole and for individual Jiwa 7 modules. Some switches interact with switches in other modules and the combination affect the application in different ways. The settings can be modified as required and any changes can be viewed clicking Show Change Logs in the ribbon. 




When making changes to settings, all forms impacted by those changes should be closed. After applying the changes, it may be necessary to logout of Jiwa and back in again for the changes to be applied

Ledger Settings

In various sections of the system settings, certain ledger accounts are linked to a particular setting.  These ledgers determine where a certain transaction is posted when that setting is true.

Here is a summary of what's required:

Section

Ledger account

Description

Category

Section

Ledger account

Description

Category

Creditors

FXRoundingAccount

Rounding Account for FX Transactions

P&L - usually COGS

Landed Cost

ImportCostClearingAccount

Import Cost Clearing General Ledger Account

B/S - usually Current Asset

Purchase Invoicing

TaxRoundingAccount

PurchTaxLiabilityAccount

PurchTaxExpenseAccount

Account To Post Tax Adjustment (GST only)

General Ledger Account Code for Tax Rounding

General Ledger Account Code for Tax Rounding

P&L - usually COGS.

These 3 settings are often set to the same account

Service Manager

DefaultIncomeAccount

DefaultUnearnedIncomeAccount

Prepaid Labour Pack Earned Debit Account (Income)

Prepaid Labour Pack Earned Credit Account (Unearned Income)

P&L - usually Revenue

B/S - usually Current Liability

System

LedgerPurchInvRounding

Track and process rounding in the purchasing system

P&L - usually COGS

Warehouse Transfers

AddedCostAccount1

AddedCostAccount2

AddedCostAccount3

Account to post added cost 1

Account to post added cost 2

Account to post added cost 1

P&L - usually COGS but can also be Expenses

E.g. Freight, Insurance, Damages

Sections

The various system configuration settings are divided into sections. To see the settings that pertain to a particular area of the Jiwa system, choose the appropriate tab. 

 

Further, on each tab there is a grid - this grid can be searched for a particular setting by right-clicking on a column header and choosing "Search This Grid". 

Bank Reconciliation

Key

Default

Description

Key

Default

Description

CheckBankRecBalOnActivate

True

Determines whether the Bank Transaction Total must agree with the totals on the Bank Statement before the form will activate.

AllowGSTAmountOverrideForDirects

False

Determines if users can type in the tax amount for direct transactions. Use with caution as this could impact your BAS report if ticked and users change tax amounts.

AllowDocumentManipulationOnActivatedBankRec

False

Determines if documents can be added, removed, or modified on an activated bank reconciliation.

DirectTransactionDuplicateReferenceWarn

False

Warn if a direct transaction with a Reference that already exists on this bank reconciliation is entered.

BankStatementOpeningEditable

False

Allow editing of the Bank Reconciliation Bank Statement Opening Balance. When creating the first bank reconciliation for the system it may be necessary to enable this setting for you to enter in the first statement balance for the system.

IndependentPosting

False

Grouping or individual postings of Bank Reconciliation entries posted to General Ledger.

Cash Book

Key

Default

Description

Key

Default

Description

ReceiptsSuggestRemitNo

False

Sets this default check box to Ticked/Unticked when creating a new receipts form. Ticked – and the remittance number is inserted on saving – based on Batch number + line number – e.g. 0002-013.

ReceiptsInheritRef

False

Automatically inherits data from the row above that’s been entered in the fields Reference and Remark.

ReceiptsAutoSubTotal

False

Automatic sub-totalling of the bank totals based on the Remit No. field. Determines the journal posting to the bank account. Can be manually controlled when this box is unchecked by a left click in the column Bank Sub Total to sub-total up or down a line.

ReceiptsInheritPaymentType

False

Automatically inherits the payment type from the line above – field Payment Type. Data is set up in the form Maintain Payment Types.

PaymentsSuggestRemitNo

False

Sets this default check box to Ticked/Unticked when creating a new payments form. Ticked – and the remittance number is inserted on saving – based on Batch number + line number – e.g 0002-013.

PaymentsInheritRef

False

Automatically inherits data from the row above that’s been entered in the fields Reference and Remark.

PaymentsAutoSubTotal

True

Automatic sub-totalling of the bank totals based on the Remit No. field. Determines the journal posting to the bank account. Can be manually controlled when this box is unchecked by a left click in the column Bank Sub Total to sub-total up or down a line.

PaymentsInheritPaymentType

True

Automatically inherits the payment type from the line above – field Payment Type. Data is set up in the form Maintain Payment Types.

WarnOfDuplicateRemitNos

False

Displays a warning message where the same remittance number for the same creditor has been entered on another payment form.

UpdateDebtorBank

False

Determines whether debtor banking details in the Financial tab are automatically updated. A tick box at the end of each controls the updating of the debtor record.

PaymentsAutoActivateOn

False

Default the Auto Activate checkbox to ticked on the creation of a new Payments form. Checking this box will automatically update Creditors and General Ledger and close the form on saving.

ReceiptsAutoActivateOn

False

Default the Auto Activate checkbox to ticked on the creation of a new Receipts form. Checking this box will automatically update Creditors and General Ledger and close the form on saving.

JournalGrouping

False

Controls whether the ledger accounts from the grid are grouped on account number in the journal posting. The posting of the Bank ledger is determined by the values in the column Bank Sub Total.

SalesOrderPaymentProcessingAlternativeBankAccount



Alternative Bank Account to be used by Sales Order Processing when creating Cash Book Receipts for payments.

Creditor

Key

Default

Description

Key

Default

Description

DefaultPeriodType

Monthly

Upon creation of a new creditor. This default period type can be changed to 'weekly' or 'fortnightly' and 'monthly' by selecting from the drop down list.

LockAccountNo

True

Editing of the creditor account number is only allowed if this switch is turned off. It is not recommended to alter the account number once transactions have been entered in to a creditor account though it can be done if needed.

SuggestRemitNo

False

Automatic generation of the remittance number for a creditor transactions based on batch and line number of the transaction, otherwise the field is enabled for data entry. The form cannot be saved without data in this field.

JournalGrouping

True

Determines if the journal will sub-total by ledger account number and sign or create a posting (debit and credit) for every line of the input form – for both sides of the journal entry, in creditor sourced transactions only – i.e. Creditor Purchases, Creditor Credit Note etc.

MaxTransPerPage

20

Maximum number of lines allowed per cheque in creditor cheque printing.

AlternateRemittance

False

Use Alternate Remittance Report.

AutoFullPayChequePayments

True

Each creditor transaction is automatically paid in full when a new cheque payment is created.

ChqPayIncludeCrNotes

True

Unallocated credit notes are included on cheque payments for local creditors. The form will not save if the credit amount > total invoice amount for the creditor. Credits will be allocated against the oldest invoice(s) when activated.

DefaultChequePaymentType

EFT

Default Cheque Payment type for new Cheque Payments. This default can be changed to 'Cheque' if required.

ValidateABN

False

Validate the creditor ABN. This switch will issue a warning and the user can continue to enter data - 'Creditor has a blank or an invalid ABN number'.

WarnOfDuplicateInvNos

False

Warn of previous creditor purchases with this invoice no. for this creditor – applies only to Creditor Purchases.

RemoveZeroPaymentLines

True

When saving a new creditor cheque payments form, any line with zero payment against the transaction are removed on the save event.

RoundingAccForFXTransactions

 

Rounding account for foreign exchange transactions.

StoredProcForCreditorOrdersOnUnprocessedPurchasesGrid

usp_JIWA_Creditor_BuildGrid_OnUnProcessedPurchase

The stored procedure used to display the data on the Unprocessed Purchased form grid.

DefaultTradingStatus

Inactive

Upon creation of a new creditor. This default can be changed to 'Inactive' or 'Active' by selecting from the drop down list.

StoredProcForCreditorOrdersOnInvoicedOrdersGrid

usp_JIWA_Creditor_BuildGrid_On InvoicedOrder

The stored procedure used to display the data on the Invoiced Orders form grid.

StoredProcForCreditorOrdersOnProcessedPurchasesGrid

usp_JIWA_Creditor_BuildGrid_OnProcessedPurchase

The stored procedure used to display the data on the Processed Purchases form grid.

AutoSetAllocationDateToMostRecent

False

When checked, new allocations made will use the most recent date between the debit and the credit.

Debtor

Key

Default

Description

Key

Default

Description

DefaultPeriodType

Monthly

Default period type upon creation of a new debtor. This default can be changed to 'weekly' or 'fortnightly' by selecting from the drop-down list.

LockAccountNo

True

Editing of debtor account number only allowed if this switch is turned off. It is not recommended to alter the account number once transactions have been entered in to a debtor account.

SuggestRemitNo

False

An automatic generation of remittance number on debtor transactions if switch turned on, otherwise this field is enabled for data entry. The form will not save without data in this field.

AutoRepeatAcc

False

Auto repeat account check box for debtor invoices.

CustomPeriod1LengthDays

90

Number of days for the to use instead of the weekly period.

CustomPeriod2LengthDays

180

Number of days for the to use instead of the fortnightly period.

CustomPeriod3LengthDays

360

Number of days for the to use instead of the monthly period.

ShowOnlyUsersDebtors

False

When ticked, then the current user can only see debtors where they are attached as the staff member of a contact group.

ValidateABN

False

Validate the debtor ABN. This switch will issue a warning – the user can continue to enter date.

DebtorSalesDays

30

Details of the last number of days sales (processed) in debtors - Customer Activities > Processed Sales.

UseAltAccForBPAYReference

False

Use Debtors Alternate Account No. field to generate BPAY reference numbers (rather than the Account No. field).

AllowTransactionRemarkEdit

False

Allow edit of the Remark field in debtor transactions displayed on the Transactions tab of the Debtor Maintenance form.

ChildDebtorsUseChildGLAccounts

False

Any postings to the child debtors will use the GL accounts set up in the child account, not the parent account.

DefaultTradingStatus

Active

Default trading status for new debtors is set to active. This default can be changed to 'Inactive' in the Debtor Settings form.

Cat2Description

Category 2

The text to use in place of "category 1".

Cat3Description

Category 3

The text to use in place of "category 2".

Cat4Description

Category 4

The text to use in place of "category 3".

Cat1Description

Category 1

The text to use in place of "category 4".

Cat5Description

Category 5

The text to use in place of "category 5".

DebtorAllocationDateDefault

Login Date

Which date should be used as the date stamp for making an allocation - login date or machine date (the date of the server where the database resides).

StoredProcForDebtorOrdersonBackOrderGrid

usp_JIWA_Debtor_BuildGrid_BackOrders

Name of the stored procedure used to construct and populate the grid on the 'On Back Order' tab which appears on the 'Orders' tab of Debtor Maintenance.

StoredProcForDebtorOrdersOnUnprocessedSalesGrid

usp_JIWA_Debtor_BuildGrid_OnUnprocessedSales

Name of the stored procedure used to construct and populate the grid on the 'On Unprocessed Sales' tab which appears on the 'Orders' tab of Debtor Maintenance.

StoredProcForDebtorOrdersOnProcessedSalesGrid

usp_JIWA_Debtor_BuildGrid_OnProcessedSales

Name of the stored procedure used to construct and populate the grid on the 'On Processed Sales' tab which appears on the 'Orders' tab of Debtor Maintenance.

StoredProcForDebtorOrdersOnJobsGrid

usp_JIWA_Debtor_BuildGrid_OnJobs

Name of the stored procedure used to construct and populate the grid on the 'On Jobs' tab which appears on the 'Orders' tab of Debtor Maintenance.

StoredProcForDebtorOrderOnQuotesGrid

usp_JIWA_Debtor_BuildGrid_OnQuotes

Name of the stored procedure used to construct and populate the grid on the 'On Quotes' tab which appears on the 'Orders' tab of Debtor Maintenance.

StoredProcForDebtorOrdersOnServiceJobsGrid

usp_JIWA_Debtor_BuildGrid_OnServiceJobs

Name of the stored procedure used to construct and populate the grid on the 'Service Jobs' tab which appears on the 'Customer Activities' tab of Debtor Maintenance.

ContinueStatementBatchOnIndividualFailure

False

Tick this switch if the user wishes statement printing to continue if a single statement fails to print.

Ledger

Key

Default

Description

Key

Default

Description

SaveZeroTransactions

False

Allow the creation of a (non-local) journal set where the dollar value of the journal is 0.00.

BranchSegNo



The general ledger account number segment applicable to branching. A ledger mask is applied over the Profit & Loss accounts in the journal(s) created by Sales Order Processing. This setting works in conjunction with the setting BranchInvoicing in the Invoicing section. The Branch descriptions and ledger masking details are set up in System Settings->Branch Configuration.

Example:
Branch Segment = 3 (i.e. the third segment of the account code)
Cost of Goods account = 2500-100-00
Sales account = 2014-100-00 
Melbourne Branch = 03

Debit Cost of Goods 2500-100-03
Credit Sales Account 2014-100-03

WarehouseSegNo



General ledger account number segment applicable to warehousing. Warehouse masking is applied over the Balance Sheet accounts for purchase orders, goods received notes, purchase invoicing, stock and warehouse transfers, stock takes and sales order processing. It is also applied over the Profit & Loss accounts during Sales Order Processing. Details are set up in Inventory > Configuration > Warehouse Maintenance.

Example: 
Warehouse Segment = 2 (i.e. the second segment of the account code)
Inventory Account = 6200-000-00
Melbourne Warehouse = 300

Stock Transfer into Melbourne Warehouse
Debit Inventory 6200-300-00
Credit Write On (no masking)

Sales out of Melbourne Warehouse for the Melbourne Branch
Cost of Goods account = 2500-100-00
Sales account = 2014-100-00 
Melbourne Branch = 03

Debit Cost of Goods 2500-300-03
Credit Sales Account 2014-300-03
Credit Inventory 6200-300-00

TransCode1

Job No

The caption to use for the line level transaction code 1 lookup column in journal sets.

TransCode2

Group No

The caption to use for the line level transaction code 2 lookup column in journal sets.

StaffCode

Manager

The caption to use for the line level staff lookup column in journal sets.

SaveErroredSets

False

Controls whether journals to be saved from external forms (e.g. purchase orders) are done so without checking for data validity. This can result in errored journal sets. Where the setting is unticked, a message displays detailing the error and will not activate until the error has been corrected. E.g. - Period Lock for Year 2015, Date 23/05/2016, Period 11 May 16.

WarnWhenErroredSetsExist

True

Display a message when loading General Journals where errored journal sets exist in the database.

AllowBasCodeChange

False

Permit the BAS code ONLY to be changed on posted journals where the ledger period is NOT Globally locked.

Inventory

Key

Default

Description

Key

Default

Description

LockPartNo

True

Disabled changes to the Part Number field in the Inventory Maintenance record. Unitck this option if part number is to be changed BUT ensure this is done with advice from your Jiwa Solution Provider.

UseWriteOnOff

False

Post additional entries to the Write On / Write Off accounts when trasnferrring stock between two Part Numbers.

Sales/BudgetsIncTax

False

Sales and budget details for the Inventory to include the Tax Charged on Sales.

RRPLabel

RRP

Default form label used for RRP field.

Aux1Label

Version

Default form label used for Aux1 field.

Aux2Label

UPC

Default form label used for Aux2 field - general used to store the Bar Code or the Universal Product Code.

WeightLabel

Weight

Default form label used for Weight Label field. Any value in here is used in Purchase Orders and Sales Orders and is totalled to reflect the weight of the order for container size and courier charges.

CubicLabel

Cubic Size

Default form label used for Cubic Label field. Any value in here is used in Purchase Orders and Sales Orders and is totalled to reflect the cubic area of the order for container size and courier charges.

Category1

Product Type

Default Category 1 description as displayed in Inventory records. Categories can by used for searching and reporting purposes.

Category2

Purpose

Default Category 2 description as displayed in Inventory records. Categories can by used for searching and reporting purposes.

Category3

Material

Default Category 3 description as displayed in Inventory records. Categories can by used for searching and reporting purposes.

Category4

Finish

Default Category 4 description as displayed in Inventory records. Categories can by used for searching and reporting purposes.

Category5

Packaging

Default Category 5 description as displayed in Inventory records. Categories can by used for searching and reporting purposes.

StockTakeRowCountLimit

500

Default maximum number of rows to return when creating a Stock Take.

UpsellPrimaryCatNo

Category 1

Default primary Up-sell Category. Up-sell Products are set up in the Alternate->Up-sell Products tab and are used in Sales Orders to add additional items to a Sales Order or Quote - e.g. would you like fries or a coke with that? TheDisplayProductUpsellPopUp setting must be ticked and the Record Settings Display Product Up-sell Pop-Up selected in Sales Orders and Quotes for the form to display for product selection.

UpsellSecondaryCatNo

Category 2

Default secondary Up-sell Category. Up-sell Products are set up in the Alternate->Up-sell Products tab and are used in Sales Orders to add additional items to a Sales Order or Quote - e.g. would you like fries or a coke with that? TheDisplayProductUpsellPopUp setting must be ticked and the Record Settings Display Product Up-sell Pop-Up selected in Sales Orders and Quotes for the form to display for product selection.

BudgetUnitsAndDollarsAreTied

True

Any changes to the budget units apply changes to the budget value and vice-versa or not.

SecondaryCostLabel

Secondary Cost

Label caption as displayed in the Inventory Maintenance form. This field is not used in the standard application and must be updated by breakout or manually for use in custom reports etc.

DefaultMatrixProductUpdate

True

There is a default tick for all inventory items in the SizeColourStyle Matrix.

ShowBackOrdersForUnprocessedSalesOrders

False

Unprocessed Back Orders will not be shown in Inventory records unless the default is changed.

WarehouseSummaryStoredProcedureName

usp_JIWA_Warehouse_SOH_Summary

Default used to populate the Warehouse Summary tab of Inventory Maintenance.

StoredProcforInventoryOnBackOrderGrid

usp_JIWA_Inventory_BuildGrid_BackOrders

Default used to populate the grid 'On Back Order' in Inventory Maintenance.

StoredProcforInventoryOnOrderGrid

usp_JIWA_Inventory_BuildGridOnOrder_With_ Shipment_Info

Default used to obtain a list of Orders for the current Inventory item.

StoredProcforInventoryOnUnprocessedSalesOrdersGrid

usp_JIWA_InventoryBuildGrid_OnUnprocessedSalesOrders

Default used to obtain a list of Unprocessed Sales Orders that the current Inventory item appears on.

StoredProcForInventoryOnForwardSalesOrdersGrid

sp_JIWA_Inventory_BuildGrid_OnForwardSalesOrders

Default used to obtain a list of Forward Sales Orders that the current Inventory item appears on.

StoredProcforInventoryOnShipComplete SalesOrderGrid

usp_JIWA_Inventory_BuildGrid_OnShipCompleteSaelsOrders

Default used to obtain a list of Ship Complete Sales Orders that the current Inventory item appears on.

StoredProcforInventoryOnWIPGrid

usp_JIWA_InventoryBuildGrid_OnWIP

Default used to obtain a list of BOM batches which the current Inventory item appears as WIP.

StoredProcforInventoryTransactionHistoryGrid

usp_JIWA_Inventory _BuildGrid_TransactionHistory

Default used to obtain audit trail for the current Inventory item.

ManualRefreshForInventoryTransactionHistory

False

Switch on to allow the Transaction History to be manually updated by clicking the GO button.

StoredProcForFindingSerialNumbersOnSalesOrders

usp_JIWA_Inventory_FindSerialNumbersOnSalesOrders

Default used to obtain Serial Numbers that have been used on Sales Orders or Sales Order Credit Notes. The form that uses this stored procedure is Inventory->Serial Number Tracking.

Invoicing

Key

Default

Description

Key

Default

Description

DefaultInvoice

Wholesale

Default sales order type on creation of a new sales order. The invoice type, under WST mode, determined the calculation of sales tax. Under GST mode, the only use is to control sales order report printing.

InvoiceTypeDescription1

Tax Exclusive

Editable description For Wholesale Invoice Type.

InvoiceTypeDescription2

Tax Inclusive

Editable description For Retail Invoice Type.

AllowInvoiceTypeChange

True

Allow invoice type selection from list box on creation of a new sales order. The invoice type cannot be changed once a sales order has been saved.

DefaultBillType

Ship & Bill

The billing type of the invoice determines when invoicing and deliveries occur. The billing type can be changed at any time until the first snapshot has been processed. Changing to Ship Complete will prompt with: "Changing the Billing Type will automatically save the sales order. Do you want to proceed?".

For example:
Snapshot 2 – deliveries and invoice for 2,500 
Snapshot 1 – no deliveries and no invoice 

Ship Complete
Snapshot 2 - goods for 1,500 are delivered and customer is invoiced for 2,500
Snapshot 1 – goods for 1,000 are delivered BUT customer is NOT invoiced 

Bill Complete
Snapshot 2 - goods are delivered and customer is invoiced for 1,500 
Snapshot 1 – goods are delivered and customer is invoiced for 1,000 

Ship & Bill
Snapshot 2 - $1,500 
Snapshot 1 – $1,000

AllowBillingTypeChange

True

Allow billing type selection from list box.

DefaultOrderType

Invoice Order

The order type determines whether the sales order can be processed. Only type Invoice Order can be processed.

DefaultBOMode

Automatic

Back order mode controls whether back orders are delivered on subsequent snapshots via Process Back Orders (automatic) or via manual creation of a snapshot (manual). Manual back order mode can also be used to force stock onto back order where you don’t want to deliver stock. Back order mode can then be set to Automatic if required..

DoNotReadSOHLevelsForQuotes

True

Do not read stock levels for quotes - this can increase system performance by reducing the amount of information required about an inventory item.

BranchInvoicing

False

Facilitates branch/sales division selection on a sales order. Branch/sales division details are set up in System->Branch Configuration. Branch/sales division can be extended to the general ledger by defining theBranchSegNo system setting. Specific ledger details are also set in the Branch Configuration form.

UseInventorySalesLedgers

True

When ticked, the sales value posts to the Sales ledger account from the inventory record, otherwise the sales value posts to the Debtor Sales ledger account from the debtor record..

DefaultSalesPerson

True

Automatically attribute sales to the staff member attached to the default group for the debtor for which the sales order is being created. The default value can be overridden, however.

UsePicking

False

Displays an additional column in the sales order grid that requires a box to be ticked for each line with a delivery before the sales order is available for processing.

DefaultQuantity

1

Default ordered quantity displayed on a sales order when adding a new part number to the grid.

AllowPriceOverride

True

Allow manual price over-rides on selling price.

AllowTaxRateOverrides

True

Permit tax rates to be changed.

AllowInvoiceNumberOverride

True

Allows the user to input an invoice no. instead of relying on the system to auto-generate one..

CheckForDuplicateOrderNos

True

Checks for duplicate order numbers for that debtor and displays an warning message with the option to preview existing sales orders with the same (debtor) order number.

DocketNumHeader

D

The prefix preceding each snapshot number – i.e. 0593-D01.

CreditNoteHeader

 

Pre-fix, if required to indicate the form is a credit note – i.e. C059.

AllowAlternateDescriptions

Description field is editable

Allows the inventory description to be manually edited or selected from a search window from data entered in the Other Descriptions field displayed in the Other tab of the inventory record.

AllowManualPartNoEntry

True

Opens the field Part No in the sales order grid for manual entry of part numbers. An invalid part number will display the Inventory search window.

AllowNonInventoryItems

True

Permits the use of Non Inventory items. These items are entered into a sales orders by right clicking on the row header and selecting "Insert-Non Inventory Item" from the context menu.

DefaultExpirySortOrder

DateIn

The default sort order for available serialised / expiry date stock in the serial selection dialog.

PostingDateType

Initiated Date

This specific setting determines the posting date to the General Ledger and Debtors based on the field SO_History.RecordDate and works as follows:

Initiated Date - first snapshot, it is the date in the field Initiated Date. Snapshots greater than 1, it is the date that snapshot was created. 

Last Saved Date - the date the unprocessed snapshot was last modified and saved.

Date Processed - the server date the sales order is processed. 

User Defined Date - controlled via Plugins

The Totals tab displays fields with the appropriate dates for each snapshot i.e. Date Created, Date Last Saved, Date Posted and Date Processed

AllowInitDateEdit

True

Permits the field Initiated Date on a sales order to be edited.

AllowOtherOverrides

True

Enable editing of additional fields in the sales order grid – RRPrice, Units, EDIStoreLocationCode, EDIDCLocationCode, Classification, Cat1, Cat2, Cat3, Weight, Cubic, UserDefinedFloat1, UserDefinedFloat2, and UserDefinedFloat3.

AllowKitComponentOverride

True

Permit kit component quantities to be edited.

LineLinks

Contacts

Additional field for selection on a sales order – either selected from a Jiwa table or user defined table.

LinkSELECT



The SELECT Statement in the Contents cell when the LineLinks is set to User Defined (Sample: SELECT RECID, Description FROM MY_Table.

LinkTITLE

 

The title to give the search.

LinkDESC



The field to be displayed in the search screen. This is also the field that is shown in the sales order lines grid when a search result is selected.

LinkKEY

 

The search results are sorted by this field..

LinkID



This is the underlying RecID field that is stored against the sales order line for whichever search result is selected.

KitForeColour

000,000,255

Colour of sales order and quotes lines that are a kit header (RED,GREEN,BLUE)

ComponentsForeColour

255,000,255

Colour of kit component lines on sales orders and quotes (RED, GREEN, BLUE).

NonInventoryForeColour

000,125,000

Colour of Non-Inventory lines in sales orders and quotes. (RED,GREEN,BLUE).

KitRoundingForeColour

000,200,000

Colour kit rounding lines in sales orders and quotes (RED,GREEN,BLUE).

SalesInfoIncludesTax

True

The Sales figures in the Debtors Maintenance and Inventory Maintenance Sales Tab are to include tax.

UseZeroCreditLimit

False

Enabling this option applies a credit check and displays a warning message when saving a sales order if a debtor is exceeding their credit limit.

SalesInfoExcludesKits

Exclude Headers

Determines the value of kitted inventory items to be displayed as the Sales figures (Sales Tab in Debtors Maintenance and Inventory Maintenance).

AllowSaveToReserveOrderWhenDebtorOnHold

False

If a debtor is on hold and an attempt is made to save an Invoice OrderActive Order, or Forward Order, give the option to the user to either cancel the save or save as a Reserve Order instead.

AddFreightToAllSnapshots

False

Add freight to be charged on all snapshots with deliveries – applies to the billing type Ship & Bill only.

BatchGrouping

Normal

Determines how cash book receipt batches are created / appended to, when sales orders are processed with payment details entered in the Totals tab of the sales order – i.e. new batches created based on sales order warehouse or branch.

PostTendered

True

Post amount tendered on sales order to debtors as a payment.

BuildPaymentReferenceFromDebtor

True

Insert banking details from the Debtor Maintenance->Financial tab into sales order Total Tab when payments are entered in the Sales Order Total Tab.

IncludeValueOfBackOrdersInCreditLimitCheck

True

Include stock on back order when applying credit limit checks at sales order entry and saving stages.

ManualPrintSelection

True

Display printing selection window when saving.

PrintInvoicesWithZeroQuantityDel

False

Print sales order reports where quantity delivered=0.

EmailInvoicesWithZeroQuantityDel

False

Email sales order reports where quantity delivered=0.

InvoicesFromQuotesUseActivateDate

False

Sets the Initiated date of the invoice created from a quote using the Standard Orders Batch Processing form to be either:

  • Activated date

  • Date due

DefaultQuoteExpiryDays

30

Automatic calculation of expiry days for a quote.

AllowQuoteNumberOverride

False

Allow manually generated quote numbers.

DefaultPriceUpdating

False

Update quote prices to current pricing on batch activation when converting quotes to sales orders.

ShowOnlyUsersDebtors

False

Restricts a user to creating and viewing sales orders for only those debtors where the user is attached as a staff member of a group in the Main->Groups tab of the debtor record.

ValidateABN

False

Provides for validation of the debtors ABN when creating the sales order. Only a warning is displayed – the user can continue to enter data.

UseTaxExemption

False

Displays the Tax Exemption box populated with any data from the debtor record. Any information in this field will recalculate the tax by applying the first 0.00 rate found in the Supplies tab of the System Settings->Tax->Tax Configuration form..

PostNonPhysicalToCOGS

False

Post non-physical inventory items To inventory value and Cost Of Goods Sold.

CompensateTaxRounding

True

Adjust tax amounts to compensate for any rounding where line tax calculated does not equal the Total Ex. Tax * tax rate. Any tax variation is written into the last line where tax is charged on saving the sales order.

UseKitRoundingPart

True

Place Rounding differences on kits to a rounding part which is added to the end of the kit.

KitRoundingPart



Inventory Item used to absorb Kit rounding.

AllowForwardOrders

True

Allow Order Type of Forward Order to be used.

AllowActiveOrders

True

Allow Order Type of Active Order to be used.

Cartage3ToDebtorInsuranceLedger

False

When processing a sales order, post the Cartage 3 (Freight 2) to the Debtor Insurance ledger (as per Debtor Maintenance->Financials->Ledger Accounts).

UseDirectTaxIfSellPriceIncTax

False

Tax is direct tax only if the item is SellPriceIncTax.

CustomTabCaption

Custom

This is the label for the custom tab on Sales Order Entry and Quotes.

DiscountPercentDecimalPlaces

2

The number of decimal places the discount percent should be stored in sales orders and quotes.

DefaultSplitOrders

True

When creating a new Sales Order Delivery Line Batch, the Split Orders setting defaults to this value.

DefaultFlagSalesOrderForProcessing

True

When creating a new Sales Order Delivery Line Batch, the custom setting AutomaticallyProcessThisInvoice is set to this value.

DefaultSplitBackOrders

True

When creating a new Sales Order Delivery Line Batch, the Split Back-Orders setting defaults to this value.

FindStockIncludesPrintedInvoices

True

The Find Stock function of Sales Orders will include sales orders where the Invoice has been printed.

FindStockIncludesPrintedDelDocket

True

The Find Stock function of Sales Orders will include sales orders where the Delivery Docket has been printed.

FindStockIncludesPrintedPickSheets

True

The Find Stock function of Sales Orders will include sales orders where the Picking Sheet has been printed.

FindStockIncludesPrintedPackSlips

True

The Find Stock function of Sales Orders will include sales orders where the Packing Slip has been printed.

FindStockIncludesPrintedOther

True

The Find Stock function of Sales Orders will include sales orders where the Other print document type has been printed.

BackOrderProcessingFlagsInvoicesForProcessing

False

Back Order Processing will set the AutomaticallyProcessThisInvoiceFlag to TRUE for sales orders where deliveries are made.

RunSalesOrderProcesingAtConclusionOfBOProcessing

False

Run sales order processing at the conclusion of backorder processing.

SalesOrderProcesingOnlyIncludesOrdersFlaggedForProcessing

False

Sales order processing, when run by backorder processing, only processes invoices flagged for processing by the AutomaticallyProcessThisInvoice setting.

AllowDocumentManipulationOnClosedSalesOrder

False

Allow Documents to be modified on closed sales orders.

AllowDocumentManipulationOnProcessedSalesOrder

False

Allow Documents to be modified on processed sales orders.

AllowNoteManipulationOnProcessedSalesOrder

False

Allow Notes to be modified on processed sales orders.

AllowNoteManipulationOnClosedSalesOrder

False

AllowNoteManipulationOnClosedSalesOrder.

CopySalesOrderIncludesNotes

False

Copying a sales order copies Notes over as well.

CopySalesOrderIncludesDocuments

False

Copying a Sales Quote copies Document as well.

CopySalesQuoteIncludesNotes

False

Copying a Sales Quote copies Document as well.

CopySalesQuoteIncludesDocuments

False

Making Sales Order from quotes includes a Note.

MakeSalesOrderFromQuoteIncludesNotes

False

Making Sales Order from quotes includes a Note.

MakeSalesOrderFromQuoteIncludesDocuments

False

Making Sales Order from quote includes Documents.

SalesOrderProcesingOnlyIncludesOrdersWithBackOrders

False

Sales Order processing when run by Back-order processing only processes invoices which still have backorders.

UseApplicationLocking

False

A sales order must be explicitly "locked" by the user before they can edit it by clicking the "Edit Mode" button on the ribbon. Whilst the user has the sales order locked, no one else can modify the sales order.

DoNotReadSOHLevels

True

Do not read SOH Levels. This can improve system performance, but the downside is that the user cannot see the current stock levels for an item via the sales order screen.

DoNotReadSupplierInfo

True

Do not read supplier information. This can improve system performance, but the downside is that the user cannot see the supplier information for an item via the sales order screen.

CopySalesOrderToNewForm

False

Copy Sales order to a new instance of the form.

ShowHistoryStatus

False

Display the history status field on the sales order form.

DontApplyDebtorDiscounts

False

Suppress the discount prices with the debtor discount.

SalesDelProcessingDontPopulateDefaultRanges

False

Turn on to force the Sales Order Delivery Batch Processing form to not populate the ranges grid (may help in performance).

UsePaymentTypeBankAccounts

False

Use the bank account assigned to the payment type when processing sales order payments. When OFF, the system uses the debtor configured bank account.

ApplyWarehouseMaskToBankAccounts

False

Mask the bank account for the payment with the warehouse mask when processing sales order payments.

StoredProcForSalesOrderExport

usp_JIWA_SalesOrders_Export

Name of the stored procedure that is used for exporting Sales Orders.

SalesOrdersMoneyDecimalPlaces

2

Number of decimal places for money values.

StoredProcForSalesOrderExportWrite



Name of the stored procedure that is used for exporting Sales Orders - Write connection.

PostZeroValueInvoiceToDebtors

False

Post zero value invoice transactions to debtors when processing sales orders.

StoredProcForGettingActionsInSOBatchPrinting

usp_JIWA_SalesOrders_SOBatchPrintGetActions

The name of the stored procedure that is used for obtaining the Sales Order actions for batch printing/emailing.

WarnWhenSavingBackToBackSalesOrderWithLinesHavingNoDefaultSupplier

True

Warn the user when saving a back-to-back sales order if any items do not have a default supplier.

InitiatedDateBehaviourOnCopy

Original Order Initiated Date

Defines what the sales order initiated date should be set to when copying a sales order.

GetInvoiceLinesStoredProcedureName

usp_JIWA_SalesOrders_LineDeliveryList

Name of the stored procedure that is used to get the delivery processing candidates on the Sales Order Line Delivery Processing form.

GetForwardOrderSchedulingListStoredProcedureName

usp_JIWA_SalesOrders_ForwardOrderSchedulingList

Name of the stored procedure that is used to get the forward order scheduling candidates on the Forward Order Scheduling form.

DefaultIncludeForwardOrders

True

When creating a new Forward Order Scheduling batch, the Include Forward Orders setting defaults to this value.

DefaultIncludeOrders

True

When creating a new Forward Order Scheduling batch, the Include Orders setting defaults to this value.

DefaultIncludeInvoices

True

When creating a new Forward Order Scheduling batch, the Include Invoices setting defaults to this value.

DefaultIncludeActiveOrders

True

When creating a new Forward Order Scheduling batch, the Include Active Orders setting defaults to this value.

GetForwardOrderProcessingListStoredProcedureName

usp_JIWA_SalesOrders_ForwardOrderProcessingList

Name of the stored procedure that is used to get the forward order processing candidates on the Forward Order Processing form.

StoredProcForSalesOrderExportFindInvoices

usp_JIWA_SalesOrders_Export_FindInvoices

Name of the stored procedure that is used to get the export candidates on the Sales Order Export form.

Job Costing

Key

Default

Description

Key

Default

Description

UseJobCosting

True

This setting must be ticked, and the Jiwa licence registration code enabled for Job Costing for this module to operate.

JobCodeLength

3

Length of the job number.

CostCentreLength

3

Length of the cost centre number.

StageLength

3

Length of the stage number.

CodeSeparator

-

The character between the job code, cost centre and stage e.g. 100-200-100.

ReceiveGoodsAgainstJobWIP

True

When ticked, lines in the GRN grid attached to a job are directly allocated to the job on activating (back-order records where part number and job cost centre and stage match are automatically reduced). When un-ticked, stock is inserted into stock on hand.

Landed Cost

Key

Default

Description

Key

Default

Description

ImportCostClearingAccount



This account is the posting account for the Import Costs that are added to Shipment. When the shipment is complete, the balance in this account should be zero for that shipment.

UpdateLastCost

True

Length of the job number.

UpdateSupplierWarehouseCost

True

Update Supplier Warehouse Cost in the Supply tab of the inventory records.

ScanBoxCode

Incremental

Controls the behaviour of the Book In form when the scan box is used.

Purchase Invoicing

Key

Default

Description

Key

Default

Description

UseRounding

True

Posts any difference between the Qty * Unit Price + Tax and the sum of the line totals to the ledger account attached to the System setting LedgerPurchInvRounding.

UseInventoryPurchaseLedger

False

When ticked, the Purchase value posts to the Purchase ledger account from the Inventory record, otherwise the Purchase value posts to the Creditor Purchases ledger account from the creditor record.

UpdateLastCost

True

When ticked, saving a purchase invoice automatically updates the field Last Cost in the Prices tab of each inventory item on the form

UpdateSuppWHCost

True

Update the supplier warehouse cost in the supply tab of inventory.

TaxRoundingAccount

 

Amount to post entered in Adj field on the purchase invoice is posted to this account.

PurchTaxLiabilityAccount

 

Credit entry for the amount entered in Adj field on the purchase invoice is posted to this account.

PurchTaxExpenseAccount

 

Debit entry for the amount entered in Adj field on the purchase invoice is posted to this account.

TaxGridBeforeTaxHeading

Sub Total

Label description for Totals grid.

TaxGridTaxHeading

Tax

Label description for Totals grid.

TaxGridAdjHeading

Adj

Label description for Totals grid.

TaxGridTotalTaxHeading

Tax

Label description for Totals grid.

TaxGridAfterTaxHeading

Total

Label description for Totals grid.

ValidateABN

False

Warns if the supplier does not have a valid ABN number but still allows the form to be changed.

Purchase Orders

Key

Default

Description

Key

Default

Description

AllowAlternateDescriptions

True

Allows the Part Number description to be edited in the Purchase Order form.

LockExPrice

False

Disable the editing of the Tax Ex Price. This prevents the price from being changed.

UsesMultiB2BForcePlan

False

Provides and alternative way of reading sales order line data which may provide performance boosts in some cases.

UpdateSupplierCost

True

Update the supplier warehouse cost in the supply tab of inventory when setting a purchase order to a status of "Sent".

ValidateABN

False

Check that the Creditor has a valid A.B.N. number before saving a Purchase Order.

UseInTransitWarehouse

False

Default to using an in-transit warehouse when creating a purchase order on another warehouse.

AllowNoteManipulationOnClosedPurchaseOrder

False

Controls the ability to edit or add notes on purchase orders with a status of "Closed" or "Sent".

PrintToScreen

True

Controls whether the purchase order report prints directly to the printer or to the screen when the "Print" option is selected from the ribbon.

CustomLineQtyDecimalPlaces

0

Controls the number of decimal places to be used when ordering non-inventory items on a purchase order.

Goods Received Notes

Key

Default

Description

Key

Default

Description

UpdateLastCost

True

When ticked, saving a goods receipt note automatically updates the field Last Cost in the Prices tab of each inventory item received.

UpdateSuppWHCost

True

Ticking this setting updates the Home Cost and Foreign Cost fields in the Supply tab of each inventory item received for the supplier warehouse received from.

ValidateABN

True

Warns if the supplier does not have a valid A.B.N. number.

Service Manager

Key

Default

Description

Key

Default

Description

JobsWarehouse

 

When parts are used on a job, they are stored in this warehouse until they are processed. A warehouse must be defined here to be able to use Service Manager.

CustomerReturnsWarehouse

 

Customer returns are placed into this warehouse when processed.

PrepaidLabourPacksEnabled

True

Allow the use of prepaid labour in Service Manager. Prepaid labour packs can be defined in Service Manager->Prepaid Labour Packs.

DefaultPrepaidLabourPackRatio

.7

The default ratio to use for new prepaid labour packs. This dictates how much income is booked upon activation of the pack as opposed to how much is booked as the hours are actually used.

DefaultRateForPrepaidLabourPacks

100

The rate that should be used when creating a new prepaid labour pack.

PrepaidLabourPacksDefaultOverflowInventory

 

When there are no more prepaid labour pack hours left for a debtor, use this inventory item for the labour entry instead.

DefaultIncomeAccountRecID

 

The general ledger account to use as the prepaid labour pack earned debit account (income).

DefaultUnearnedIncomeAccountRecID

 

The general ledger account to use as the prepaid labour pack earned credit account (unearned income).

LockJobNumber

False

Disallow the editing of job numbers.

AllowLoggedDateEdit

False

Allow editing of job logged dates?

BillingTimeRounding

No Rounding

Round billing time to nearest...

SalesOrderLineCreationOrder

Add All Parts, Then All Labour

In what order should parts and labour be added to a sales order / credit note?

System

Key

Default

Description

Key

Default

Description

UseDoubleBuffering

True

Use Double Buffering for all controls on the form. Reduces flicker when resizing forms. Ignored and always treated as false for Terminal Services.

PostToGL

True

Post all journals from subsidiary ledgers into the general ledger.

UseCostofGoodsLedger

True

General ledger posting to determine cost of sales.

MoneyDecimalPlaces

2

Number of decimal places for money values.

BPAYBillerCode

 

BPAY Biller Code (Provided By BPAY).

CompanyName

Jiwa Financials Evaluation

Registered licensee of Jiwa.

CompanyPhone

 

Company Phone number.

CompanyFax

 

Company Fax number.

CompanyAddress1

 

Company Address 1.

CompanyAddress2

 

Company Address 2.

CompanyAddress3

 

Company Address 3.

CompanyAddress4

 

Company Address 4.

UseBackgroundColour

False

Use background colour.

CompanyEmail

 

Company Email Address

CompanyWebSite

 

Company Web Site Address

CompanyACN

 

Australian Company Number.

CompanyABN

 

Australian Business Number.

LedgerPurchInvRounding

 

Track and process rounding in the purchasing system.

HelpLocation

Location of the help files.

ForceInventorySelection

False

Force the selection of bin locations on inventory movements. The system setting in Invoicing tab 'GrabSOHfromDefaultBin' will over-ride this setting in sales orders only.

GroupedCaption2

Back to Back

Back to back caption for back to back set 2.

ABNFormat

 

Edit Mask for ABN Number.

BackgroundColour

 

Jiwa background colour (RED,GREEN,BLUE).

UseBackgroundPicture

True

Use background picture.

BackgroundPicture

LargeLogo.jpg

Jiwa background picture.

BackgroundPicturePosition

1

Jiwa background picture position.

UseOutlookForEmail

False

Should emails be sent using the Microsoft Outlook client.

SMTPServerAddress

 

Address of the SMTP server to use for sending emails (not applicable if UseOutlookForEmail is ticked).

SMTPRequiresSSL

False

Does the SMTP server require SSL (secure connection).

SMTPServerPortNumber

25

Port number to use when connecting to the SMTP server (not applicable if UseOutlookForEmail is ticked).

StoredProcForProcessBackOrders

usp_JIWA_GetBackOrderProcessList

Name of the stored procedure that is used to obtain backorders that should be fulfilled when running Process Back Orders.

ToDoPollInterval

0

Indicates how often to check for notifications in seconds (0 means no polling).

NotificationStickyWhenIdleSeconds

3

Notification popup becomes sticky after system idle for a number of seconds (-1 = always sticky, 0 = never sticky, >0 = idle seconds).

AllowContactDuplicateLogon

True

Allow duplicate logon code in contacts.

UserToDoOnly

True

Only show To-Do assigned to or assigned by current user.

DefaultTodoFilter

2

Show default To-Do filter.

HideInaccessibleFormsInMenu

True

Hide form menu items the user does not have permission to load.

LogApplicationEvents

False

Log events to the application event log.

ClientSetupPackageLocation

 

Location of the setup package for the Jiwa 7 client. This is used to automatically upgrade clients.

ReadRetriesOnDeadLock

5

Number of times to retry a read when a selected as a deadlock victim.