MYOB Advanced tips and tricks: restricted use of control accounts, correcting SO invoices

MYOB Advanced tips and tricks: October 2020

MYOB Advanced Tips and Tricks

MYOB Advanced has plenty of shortcuts, and lots of options, to make your work a breeze. This month we look at the restricted use of control accounts, and the ability to cancel and correct an SO invoice.

Tip #1. Restricted use of control accounts

Having reconciled and balanced accounts is vital to accurate financial reporting. Posting directly to the General Ledger Control Accounts can cause imbalances between sub-ledgers and their respective balance sheets accounts. Introduced in Release 2020.3, MYOB Advanced (powered by Acumatica) now provides the ability to restrict direct postings of transactions such as journal entries to control accounts.

Impacts of restricting control accounts

By enabling the use of the restrictions, control accounts can be set against the following sub-ledgers: Accounts Payable, Accounts Receivable, Fixed Assets, Inventory, Taxes (GST), Purchase Orders (Receipts), Sales Orders (Shipments).

Establishing a control account has two impacts:

  1. Removes the opportunity for manual data entry directly into the account and reduces error rates.
  2. Prevents using the account as a default for fields related to sub-ledgers. For example, the Sales or Expense accounts set in the Accounts Receivable or Accounts Payable master record.

Two new columns are added to the Chart of accounts Screen to further display and customize the account restrictions.

Alongside each General Ledger account, you can select the related sub-ledger Module, marking it as a control account.  As per the example below, we have selected the “AR” control, to align with the Accounts Receivable General Ledger Account.

The “Allow Manual Entry” checkbox determines if users are able to post entries directly to this account.  Clearing the box will prevent users from creating entries to this account. 

Checking this box will allow users to post transactions, although they will still receive a warning.  It is recommended to uncheck this box once any necessary adjustments have been made.

We recommend enabling the use of ledger control accounts to help prevent sub-ledger imbalances.

Tip #2. Correcting SO invoices

Previous versions of MYOB Advanced provided no ability to make changes to SO invoices that had already been released. SO invoices could also not be cancelled. Release 2020.3 introduced new actions that provide the ability to cancel and correct existing SO invoices with the ‘Open’ or ‘Closed’ status.

Cancelling invoices

A Cancel Invoice action has been added to the Invoices screen (SO303000):

When a user clicks this action, the system creates an SO credit memo on the same screen in the full amount of the invoice being cancelled. In the created credit memo, the user can change the date, posting period, and description – all of which are copied from the original SO invoice.

In the cancelled invoice, on the Financial Details tab of the Invoices screen (SO303000), the Correction Document field shows the reference number of the cancellation credit memo that was prepared for this invoice but have not yet been released. This reference number is a link a user can click to view the cancellation credit memo.

More information

If you require assistance in setting up these features, please contact our Support Team via email, or call 0800 436774.

5 good reasons to choose Enprise

Reason 1: Gold standard service and support. 

Reason 2: Cloud options for every piece of software we sell.

Reason 3: The largest MYOB Advanced and MYOB Exo partner in Australasia, with dedicated sales, implementation & support teams.

Reason 4: A wide range of proven companion products from trusted partners. 

Reason 5: With Enprise, you get MYOB Exo from the people that invented it. 

More Information

For more information, contact us.
One of our consultants can call or visit you to discuss your needs.

MYOB Advanced Platinum Partner & MYOB Exo Platinum Partner logos - Enprise

Enprise MYOB Awards strip 2016-2021, 1200

Contact or Subscribe

Complete the form below and one of our consultants will contact you to discuss your needs.
You can also subscribe to our email newsletter to stay up-to-date on industry news.

The 'First name' field is required
The 'Last name' field is required
Please enter a valid Email address
by: