General Ledger (GL)
General Ledger (GL)
The following global controls are available for the General Ledger Module.
Setup / Reference Data > gb_controls
Module | Name | Comment | Default Value |
gl | accpac_pl_export_supplier_code | Nominates the field in fm_suppliers (any field in this table can be used) to use as the supplier code. Default is supplier_code. For example: "account" may be used as an alias code. If set to "account" the account data is used as the vendor code in the General Ledger Export To AccPac. If the "account" data is blank then the supplier_code is used | account OR 0 |
gl | jnl_export_exclude_payrun_invoices_flag | This is set as 'yes' by default. You only need to change this if you are creating sales Journal accounting records. If this is updated to 'no', accounting Journal exports will be created for Pay Run invoices | yes |
gl | multi_company_export_flag | If this flag is set to "yes", you will be able to create MYOB export or Xero export for multiple companies and consequently, the "Export from General Ledger to MYOB" or "Export from General Ledger to Xero" screen will display an extra field with a drop down list of company names from gb_companies. Go to Company for more details | no |
gl | myob_export_break_by_item_flag | MYOB export break by item flag. PL: no, SL: yes, JNL: no | pl=no, sl=yes, jnl=no |
gl | myob_export_co_last_name_flag | In MYOB PL and SL export files the column 'Co./Last Name' will be blanked out when this control is set to 'no'. When set to 'yes' the client name will be reported in the SL export file and Supplier name will be reported in the PL export file | yes |
gl | myob_sl_export_customer_po | Catch-e field used to populate the "Customer PO" field in MYOB Sales ledger invoices (for example: driver surname to allow easy searching for invoices in MYOB). Refer to General Ledger Export To MYOB for further details. Valid entries are: none, surname, contract_id, reg_no, client_order_no | surname |
gl | myob_export_job | Catch-e field used to populate "job" field in MYOB SL and PL export files. Valid fields are: contract = fm_contracts.contract_id, finance = fm_contracts.finance_ref, supplier = fm_contracts.supplier_reference, asset = fm_contracts.asset_id | s:0:""; |
gl | myob_export_pl_surname_in_description_flag | MYOB export PL surname in description flag | yes |
gl | myob_export_pl_transaction_date | When the control value is set to 'invoice_date', items will be added into the PL export file using invoice_date as the value for 'Date' and 'Shipping Date' in the PL export file where posted_date = '0'. When the control value is set to 'posted_date' the PL export file will use posted_date for 'Date' and 'Shipping Date' in the PL export file where posted_date = '0'. Note: This process is the same for items originating from fm_maintenance as invoice items or from pl_payables as payments | invoice_date |
gl | myob_export_summarise_data | When both 'sl' and 'pl' are set to 'no', MYOB SL and PL export files are created with the multiple transaction lines that have been invoiced to the client or paid to the supplier. When set to 'yes', the SL export file is created by grouping same transactions to individual line(s) (for example: Where recharges are included in 'Combined' Billing, they will be itemised separately to the Lease Charges). The PL export file will group each transaction based on gl_code to one line | sl=no, pl=no |
gl | myob_sl_export_card_id | Field used to populate the MYOB Card ID in Sales ledger exports. Allows posting to contract_id or client_code (default) | client_code |
gl | pl_export_finance_reporting_flag | This control is only applicable when you are exporting transactions to Xero and you are using the "Payment Type" 'Finance - Principal and Interest'. When the flag is set to 'no' the export file will itemise the classes 'PRI' (Principal) and 'INT' (Interest). The class 'FIN' (Finance) is ignored. Contract Types / Payments "GST" must be set to 'N' for INT, PRI and FIN for the "Type" 'Finance - Principal And Interest'. Contracts / Payments: when a 'Finance - Principal And Interest' payment is saved, the GST setting is checked. If the 'FIN' class GST is populated, the record cannot be saved. You will see a validation message. Where the flag is set to 'yes' the export file will only include the 'FIN' class and if configured, will include GST | no |
gl | sl_export_exclude_payrun_invoices_flag | This is set as 'yes' by default. You only need to change this if you are creating Sales accounting records. If this is updated to 'no', accounting Sales exports will be created for Pay Run invoices | yes |
gl | xero_export_sl_invoice_date_for_pay_run | Use this control to change the date that is used in sales ledger exports using MYOB Purchases and Xero Purchases export files. This control only applies to pay run invoice transactions. invoice_date: the export file will use invoice_date to show as InvoiceDate. posted_date: the export file will use posted_date to show as InvoiceDate (this is the same date as invoice_date in most cases) | invoice_date |
gl | xero_export_sl_tax_type | Allows for the 'Tax Type' description in the Xero Sales export file to be modified if required. GST Non Zero: GST on Income, GST Zero: GST Free Income | |
gl | xero_export_summarise_data | Update the PL to 'yes' to summarise export data. Visit the General Ledger Export To Xero page for more details. The "SL" setting is not functional. SL: no, PL: no | |
gl | xero_pl_export_invoice_date_for_reimbursement | Use this control to change the date that is used in Xero Purchases export files. This control only applies to claim reimbursements (where Contracts / Claim "Reimbursement" is checked). Using 'posted_date' can be helpful if you close out accounting periods in Xero and older claims have been recently processed. invoice_date: the export file will use invoice_date as the InvoiceDate. posted_date: the export file will use posted_date as the InvoiceDate | invoice_date |
Quick Quotes (QQ)
The following global controls are available for the Quick Quotes Module.
Setup / Reference Data > gb_controls
Module | Name | Comment | Default Value |
admin_fees_per_month | Admin fees per month | 35 | |
ato_useful_life | ATO useful life for depreciation calculations | 8 | |
client_code_default | Indicates the default client code | WSQ | |
engine_cc | Engine cubic capacity default | 2500 | |
external_funds_rate | External funds rate | 0.0950 | |
fuel_cost_per_litre_net | Fuel cost per litre net | 1.2 | |
ignore_effective_date_flag | Indicates whether to use the quote effective date when populating default reg/CTP values | no | |
insurance_rate | Rate applied to depreciable value. Also used in the API GetQuoteFieldsWebService if the vehicle depreciable value exceeds the limits in qt_insurance_rates | 0.025 | |
interest_rate | Interest rate for lease calculations | 0.09 | |
lease_buy_interest_rate | Lease buy interest rate | 0.0950 | |
mail_to_for_calculator | Holds the email address that enquiries generated by a quoting calculator will be sent to | 0 | |
postcode_by_state_default | Holds a default postcode by state. NSW: 2000, VIC: 3000, QLD: 4000, ACT: 2600, TAS: 7000, SA: 5000, WA: 6000, NT: 0800 | ||
prestige_threshold | Prestige vehicle threshold price | 45000 | |
prestige_uplift | Prestige vehicle uplift factor | 1.5 | |
required_rate_of_return | Required rate of return | 0.1500 | |
residual_adjustment_per_1000km | Residual adjustment per 1000km | 0.0050 | |
tyre_replacement_cycle_kms | Tyre replacement cycle in kilometres | 40000 |