System Configuration
- 1 Overview
- 1.1 Ledger Settings
- 2 Sections
- 2.1 Bank Reconciliation
- 2.2 Cash Book
- 2.3 Creditor
- 2.4 Debtor
- 2.5 Ledger
- 2.6 Inventory
- 2.7 Invoicing
- 2.8 Job Costing
- 2.9 Landed Cost
- 2.10 Purchase Invoicing
- 2.11 Purchase Orders
- 2.12 Goods Received Notes
- 2.13 Service Manager
- 2.14 System
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 |
---|---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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. | |
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. | |
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 |
---|---|---|
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 |
---|---|---|
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?". |
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: 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 |
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 Order, Active 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:
|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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. |
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. |