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