Contents

February 2023

Caroline Buckland 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

the information on how to preserve the formatting when opening the file is detailed in the email body.

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.

Note the information on how to preserve the formatting when opening the file is detailed in the email body

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.

Was this article useful?

April 2023

January 2023

Contact