• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

June 2025 ACCA Exams

How was your exam? Comments & Instant poll >>

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for September 2025 exams.
Get your discount code >>

Sage – Additional & Hiding Columns

Additional & Hiding Columns

Sage has the ability to suppress columns which are not utilised, from the batch data entry window.  i.e. A/C, date, Ref, ex. Ref, N/C, dept, project ref, cost code, details, net, T/C & VAT.  These can be easily hidden by using the right mouse click option, then un-tick the column.  To show the column again just right mouse click and tick the option.
<h3>Some Columns explained:

A/C – partial entry will allow the active search pop up.  Or press F4 for main index.

The Date – influences which accounting month the transaction is posted to, which VAT return it appears on and the ageing of transactions.

Ref – Enter the invoice number, maximum of 30 characters for this field.

Details – is a 60 character field for additional information.  I the Active Search Popup feature is enabled it will show a list of previous entries.

T/C – the Tax code, this can be changed.

VAT – the VAT amount is calculated as soon as you enter the net amount, you can replace the automatic calculations with the value on the invoice where necessary.

For Example:

You are required to enter a supplier batch invoice.  On entering the batch area various columns that will not be used are displayed.  By moving your cursor to the “heading” line a drop down menu appears giving you the option to hide Ref, ex. Ref, N/C, dept, project ref, cost code, details. These are all options of “non critical” fields.
hiding_1

Sage tutorials are provided exclusively to OpenTuition.com by CBK Training, in Association with Complete Book-Keeping Ltd

** Book your Sage 50 Classroom Training – Ringwood **
Courses : Sage 50 : Credit Control : VAT : Sage Payroll Basics

Reader Interactions

Comments

  1. suzan says

    February 28, 2019 at 8:28 am

    can we add or delete rows and columns in cbe exam,f6?

    Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

Primary Sidebar

Donate

Donate

If you have benefited from OpenTuition please donate

Donate now

You can also “donate your time” and help out other students on the Students Forums

BPP

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in