Contents
February 2023
Updated
by Caroline Buckland
Accounts Payable -(MGBC) - optional postings to General Ledger prior to authorisation
There is a new feature that allows you to defer postings to General Ledger for unauthorised Invoices, Credit Notes and Expense Claims that are entered through Accounts Payable.
If this new setting is utilised, then the postings to General Ledger will be deferred until the document is fully authorised.
The new optional feature is controlled by a new setting on Accounts Payable Company Controls.
To make use of this new feature please raise a support case with Advanced.
Upon full authorisation of the document the posting to General Ledger will always post to the period and year the transaction was originally entered, so may post to a close period. Reviewing any unauthorised documents should be part of the period end process.
Note: If you currently post the VAT element when logging Invoices and Credit notes, this will still apply as no authorisation is applied to the documents at this point.
Tax Reports available in csv format
Tax reports are now available to be emailed in CSV format. You have an option to send this to a nominated email address or you can retrieve the file from the File Management area on MyWorkplace.
The CSV files are the Tax Analysis Detail Reports for Accounts Payable and Accounts Receivable. All the existing VAT reports are available from the spool in TXT format.
AP Tax Analysis (GLC)
Access the following menus:
Main Menu>General Ledger>GL Processes>Period/Year End Close>Taxation Processes>AP VAT Analysis Reports.
To produce the report in CSV format, make and entry in the following fields.
• CSV Extract – flag to create the CSV file if no other options are entered the report will go the File Management area
• Email CSV – optional, flag to send to an email address
• Email Address – if the above flag is set, then enter an email address
If you are running this report for multiple companies a separate email and csv file will be produced for each.
All other fields are entered in the usual way. Once complete click submit followed by submit again.
The text file is available from the spool, if you entered an email this will arrive in your inbox in CSV format.
Systems Admin>Spool
If no email was entered the file can be located in File Management area.
Use the Download button to retrieve the file.
Example of the output below.
AR Tax Analysis (BS4)
Access the following menus.
Main Menu>General Ledger>GL Processes>Period/Year End Close>Taxation Processes>AR VAT Analysis Reports.
To produce the report in CSV format, make and entry in the following fields.
• CSV Extract – flag to create the CSV file, if no other options are entered the report will go the File Management area
• Email CSV – optional, flag to send to an email address
• Email Address – if the above flag is set, then enter an email address
All other fields are entered in the usual way. Once complete click submit the process followed by submit again.
The text file is available from the spool, if you entered an email this will arrive in your inbox in CSV format.
If no email was entered the file can be located in File Management area.
Use the Download button to retrieve the file.
Example of the output below.
