The Maintain Master Posting Table form is displayed when the Master posting table option is selected from the VS MISCELLANEOUS MENU.
VEHICLE TYPE
Once the program is selected from the menu, the user is required to enter a Vehicle type by selecting either of the two radio buttons:
New Vehicles
Used Vehicles
Once this has been defined, you will be presented with the first page of the new or used vehicle master posting table.
A cursor is positioned in the first column of the screen along side the first posting definition. There are twelve columns on the screen (excluding the cursor positioning one), which contain the following information:
Field Name: The name of the vehicle stockbook database field containing the value which is to be posted. The field name will be validated against the new or used vehicle stockbook data dictionary.
Oc(currence): In some cases, the field referenced in the first column will be of an 'occurs' nature, in which case the occurrence specified here will determine exactly which field value to post.
Date Field: The transaction posted to the nominal can be posted with an effective date taken from any of the date fields held in the vehicle stockbook database. The entry here specifies which date field to use. The field name will be validated against the new or used vehicle stockbook data dictionary.
Oc: The logic has been built in to the system that the date field itself may occur more than once. Currently no date does, so this column is skipped over.
S (accounts status): The posting is generated when the vehicle record reaches or passes a given accounts status. The entry here is the accounts status at which the posting should take place (normally A for Adoption or I for Invoiced).
T: This column will prompt you as to whether the debit posting is to a Balance sheer or Non balance sheet (profit & loss) account.
Debit Mne: This column will contain the posting mnemonic or 'label' to which the value will be debited. At this stage, in the master posting table, the definition is purely descriptive. The input here, and in the credit column, will build up the data dictionary for the detailed posting tables. If it is not already defined, the operator will be advised of the situation and prompted by way of a ring menu and offered the opportunity to Create-mnemonic including an up to 20-character description of what it is to be used for, or Continue, without creating a new mnemonic and re-input an existing one.
R: In this column you will be prompted as to whether the cost centre mask for the debit posting should be taken from the Physical location, the Buying location, the Selling location, or whether No cost centre mask should be used. It is normal that balance sheet postings would use the Physical location and profit & loss postings would use the Selling location, with the exception of vehicle write downs.
Suffix field: As well as updating the nominal ledger with the value, the transaction can also contain a suffix (usually the vehicle stock number) which is utilised to facilitate reconciliation of the nominal ledger accounts concerned. The entry here is the name of the VSB field to be used as a suffix.
Oc(currence): Once again, the suffix field may be of an 'occurs' type (for example the DEPREF, or deposit reference field, which occurs three times). If the suffix is an 'occurs' field then the specific occurrence to be used in this case should be entered here.
T: This column will prompt you as to whether the credit posting is to a Balance sheet or Non balance sheet (profit & loss) account.
Credit Mne: This column will contain the posting mnemonic or 'label' to which the value will be credited. At this stage, in the master posting table, the definition is purely descriptive. The input here, and in the debit column, will build up the data dictionary for the detailed posting tables. If it is not already defined, the operator will be advised of the situation and prompted by way of a ring menu and offered the opportunity to Create-mnemonic including an up to 20-character description of what it is to be used for, or Continue, without creating a new mnemonic and re-input an existing one.
R: In this column you will be prompted as to whether the cost centre mask for the credit posting should be taken from the Physical location, the Buying location, the Selling location, or whether No cost centre mask should be used.
Suffix field: As well as updating the nominal ledger with the credit value, the transaction can also contain a suffix (usually the vehicle stock number) which is utilised to facilitate reconciliation of the nominal ledger accounts concerned. The entry here is the name of the VSB field to be used as a suffix.
Oc(currence): Once again, the suffix field may be of an 'occurs' type (for example the DEPREF, or deposit reference field, which occurs three times). If the suffix is an 'occurs' field then the specific occurrence to be used in this case should be entered here.
Tip: To make any changes to the Master Posting Table simply left click your mouse, this will invoke a menu.
The menu will allow you to do the following:
Edit Line
Delete Line
Add Line
Copy Line
Tip: If any changes have been made, and they are required to be implemented, it is imperative to click the Save button.
Note: If any new posting mnemonics are created in this program, then all detailed posting tables will have to be amended to specify the account number(s) to which that posting should be made.
BUTTONS
Save: Saves all the changes you have made.
Cancel: Aborts any changes you have made.
Help: Displays help on the current application in your default company browser.
