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

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.

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.

DefaultPeriodType

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

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

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

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

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

AlternateRemittance

Use Alternate Remittance Report.

AutoFullPayChequePayments

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

ChqPayIncludeCrNotes

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

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

ValidateABN

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

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

RemoveZeroPaymentLines

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

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

DefaultTradingStatus

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

StoredProcForCreditorOrdersOnInvoicedOrdersGrid

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

StoredProcForCreditorOrdersOnProcessedPurchasesGrid

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

AutoSetAllocationDateToMostRecent

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

DefaultPeriodType

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

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

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

Auto repeat account check box for debtor invoices.

CustomPeriod1LengthDays

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

CustomPeriod2LengthDays

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

CustomPeriod3LengthDays

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

ShowOnlyUsersDebtors

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

ValidateABN

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

DebtorSalesDays

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

UseAltAccForBPAYReference

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

AllowTransactionRemarkEdit

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

ChildDebtorsUseChildGLAccounts

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

DefaultTradingStatus

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

Cat2Description

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

Cat3Description

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

Cat4Description

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

Cat1Description

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

Cat5Description

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

DebtorAllocationDateDefault

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

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

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

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

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

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

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

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

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.

LockPartNo

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

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

Sales/BudgetsIncTax

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

RRPLabel

Default form label used for RRP field.

Aux1Label

Default form label used for Aux1 field.

Aux2Label

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

WeightLabel

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

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

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

Category2

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

Category3

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

Category4

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

Category5

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

StockTakeRowCountLimit

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

UpsellPrimaryCatNo

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

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

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

SecondaryCostLabel

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

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

ShowBackOrdersForUnprocessedSalesOrders

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

WarehouseSummaryStoredProcedureName

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

StoredProcforInventoryOnBackOrderGrid

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

StoredProcforInventoryOnOrderGrid

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

StoredProcforInventoryOnUnprocessedSalesOrdersGrid

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

StoredProcForInventoryOnForwardSalesOrdersGrid

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

StoredProcforInventoryOnShipComplete SalesOrderGrid

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

StoredProcforInventoryOnWIPGrid

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

StoredProcforInventoryTransactionHistoryGrid

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

ManualRefreshForInventoryTransactionHistory

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

StoredProcForFindingSerialNumbersOnSalesOrders

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.

DefaultInvoice

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

Editable description For Wholesale Invoice Type.

InvoiceTypeDescription2

Editable description For Retail Invoice Type.

AllowInvoiceTypeChange

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

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

Allow billing type selection from list box.

DefaultOrderType

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

DefaultBOMode

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

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