| gl | accpacplexportsuppliercode | Nominates the field in fmsuppliers (i.e. any field in this table can be used) to use as the supplier code. Default is suppliercode. E.g. "account" may be used as an alias code. If set to "account" the 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 | jnlexportexcludepayruninvoicesflag | 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 | multicompanyexport_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 | myobexportbreakbyitem_flag | | pl=no,sl= yes,jnl =no |
| gl | myobexportcolastname_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 | myobslexportcustomerpo | Catch-e field used to populate the "Customer PO" field in MYOB Sales ledger invoices (e.g. 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,contractid,regno,clientorderno. | surname |
| gl | myobexportjob | Catch-e field used to populate "job" field in MYOB SL and PL export files. Valid fields are: contract = fmcontracts.contractid, finance = fmcontracts.financeref, supplier = fmcontracts.supplierreference, asset = fmcontracts.assetid | s:0:""; |
| gl | myobexportplsurnameindescriptionflag | | yes |
| gl | myobexportpltransactiondate | When the control value is set to ‘invoicedate’, items will be added into the PL export file using as the value for ‘Date’ and ‘Shipping Date’ in the PL export file where = ‘0’. When the control value is set to ‘posteddate’ the PL export file will use for ‘Date’ and ‘Shipping Date’ in the PL export file where = ‘0’. Note: This process is the same for items originating from fmmaintenance as invoice items or from plpayables as payments. | invoice_date |
| gl | myobexportsummarise_data | When both 'sl' and 'pl' are set to 'no', MYOB SL & 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) eg: 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 | myobslexportcardid | Field to used to populate the MYOB Card ID in Sales ledger exports. Allows posting to contract id or client code (default). | client_code |
| gl | plexportfinancereportingflag | This control is only applicable when you are exporting transactions to Xero 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 "G" 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 | slexportexcludepayruninvoicesflag | 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 | xeroexportslinvoicedateforpay_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. invoicedate - the export file will use to show as InvoiceDate (this is the same date as posteddate - the export file will use to show as InvoiceDate (this is the same date as | invoice_date |
| gl | xeroexportsltaxtype | 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 | xeroexportsummarise_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 | xeroplexportinvoicedateforreimbursement | Use this control to change the date that is used in Xero Purchases export files. This control only applies to claim reimbursements. I.e. where Contracts / Claim "Reimbursement" is checked. Using 'posteddate' can be helpful if you close out accounting periods in Xero and older claims have been recently processed. invoicedate - the export file will use as the InvoiceDate posted_date - the export file will use as the InvoiceDate | invoice_date |