- Contents
- Index
- Search
Show results that include all search words
Adding a General Ledger (GL) Line
Security
Module access:
- Company Maintenance / Modules in Use / General Ledger
Form access:
- User Preferences / Menu Security / General Ledger
Where advanced security is in use:
Read:
- User Preferences / Privileges / General Ledger / GL Account Maintenance / All / Read ; or
- User Preferences / Privileges / General Ledger / GL Account Maintenance / Team / Read.
Add:
- User Preferences / Privileges / General Ledger / GL Account Maintenance / All / Add ; or
- User Preferences / Privileges / General Ledger / GL Account Maintenance / Team / Add.
Edit:
- User Preferences / Privileges / General Ledger / GL Account Maintenance / All / Change; or
- User Preferences / Privileges / General Ledger / GL Account Maintenance / Team / Change.
Delete:
- User Preferences / Privileges / General Ledger / GL Account Maintenance / All / Delete ; or
- User Preferences / Privileges / General Ledger / GL Account Maintenance / Team / Delete.
Post:
- User Preferences / Privileges / General Ledger / GL Account Maintenance / All / Post ; or
- User Preferences / Privileges / General Ledger / GL Account Maintenance / Team / Post.
For team access, the GL Account Maintenance / Assigned team must be one of the teams the user has access to.
Line type
Fields on the form display according to the Line type selected.
For general ledger the line type is ‘GL’.
The GL line type is used for items that do not form part of inventory but are included in the list of services provided by your company.
Company
Company defaults to the company that you are logged in to. This can be manually changed.
F9 or select
to choose another company. The list contains
only those companies that you have access to.
Account (GL)
On selecting Account, a composite search field displays where you can Search by number or Search by description.
F9 or selecting
from either search field displays the General Ledger
Account and Description.
If a partial GL Account number or description is entered, the field search will filter available results allowing a selection to be made.
[TAB] or [ENTER] off the search result to select.
Sub code
Provides the ability to create a grouping of GL or CR lines.
CR Lines are available for Leads and Quotes.
Quantity
The number of items required.
Must be greater than zero.
Unit price
Defaults to the actual rate entered for the item in GL Account Maintenance.
The price can be manually entered/changed.
If Tax is showing as:
- Inclusive - Price includes tax.
- Exclusive - Price excludes tax.
Discount
Because discount is not mandatory, [TAB] or [ENTER] off this field does not activate the drop list.
To enter a discount:
- F9 or select
to display the composite discount field
- enter either a discount % or amount.
- [TAB] or [ENTER] off the field to update the value and move to the next field.
Where a discount% is entered, this updates the discount amount and vice versa.
To update the discount rate on all lines:
- Right click on the Discount column header
- select Update all discounts
- enter a discount percentage
- select Apply.
The discount percentage for each line is updated to the new discount percent and totals recalculated.
Tax
F9 or select to change
a tax code selection.
Partially entering the tax code will filter the list to show items matching the string using the full path from left to right.
On [ENTER] the selected tax code is updated, and the focus will move to the Tax Type field.
Each option is highlighted as you scroll through the list.
After the selections have been made, the tax code, tax type, amount and percentage will display in the field.
Amount
Calculated as (Quantity x Price) - Discount, for the currently selected Item.
If Tax Type is:
- Inclusive – Amount includes tax.
- Exclusive – Amount excludes tax.
Cost
Defaults to zero. Enter a value if required.
Margin
Margin and Margin% are read-only fields updated when the Unit price / cost is maintained. These are calculated as follows:
- Margin = Retail - Cost
- Margin % = Margin $ / Retail $ x 100.
The option to Show Margin or Show Markup is set in CRM Module
Control / Sales / Quotes.
Narration
General text applicable to the specific line item.