The Posting Tables form is displayed when you select the Nominal posting table option from the SR Miscellaneous Options Menu.
At least two posting tables need to be created: one for New vehicles and one for Used vehicles. If the Chart of Accounts is set up for vehicle sales at Franchise, Model, Variant and Sale Type then it will be necessary to set up posting tables for each variant of each sale type.
Analysis codes must be set up prior to the creation of any posting tables as they will define what options are available.
The Sale Types are created in the Miscellaneous options menu Sales Types and the Franchise, Model and Variants are created in Franchise Data.
Usually, dealerships report on New vehicles at Model/Sale Type level.
In this case posting tables would need to be created for each Model within each sale type.
Tip: If 4 models existed in Franchise Data and 4 sale types existed then 16 posting tables for New vehicles would be required. However, if posting is only required at franchise level within each sale type, and only one franchise exists then only 4 posting tables need to be created.
If postings are not required at variant level then this field should be left blank and this posting table will then be used for all variants within the model/sale type. This applies to all fields, except for New/Used.
Click the Create button.
NewUsed: Enter 'N' for New or 'U' for Used vehicles.
Franchise: Enter the Franchise code.
Model: Enter the Model code.
Variant: Enter the Variant code.
Sale Type: Enter the Sale type code.
Tip: Click the
drop down or the
buttons to search anytime you see these options.
Main: Enter the cost centre used for sales and cost of sales, for each saleable item (e.g. List Price, Factory Options, Delivery). Enter the expense code for the sales, and the expense code for the cost of sales for each item. Enter the stock cost centre and expense code for each item. Depending on the system parameter for type of discounting a column may exist for the discount of each item.
There are 12 options included within this tab, each option will require a Cost Centre, Sales, Costs and also a Stock cost centre and expense code.
List Price, FFO's, Delivery, Cartax, Settlement, Overallowence, Discount and NRC Costs have pre defined analysis codes. Cartax 1 - 5 are definable within the Analysis codes
Consignment Liability: Enter the required account code, click the ellipsis button to search
Consignment Stock: Enter the required account code, click the ellipsis button to search
DFAs: As per the main tab, enter cost centres and expense codes for sales, cost of sales and stock. There are ten rows. These ten rows are linked to the Analysis codes which are created within Miscellaneous Options. These analysis codes are then held on dealer accessories in Franchise Data. Not all analysis codes have to be used.
Non-recoverables - Type N: As per the DFAs tab, enter cost centres and expense codes for sales, cost of sales and stock. These are also linked to theAnalysis codes which are linked to the non-recoverable costs in Franchise Data.
Non-recoverables - Type B: As per the Non-recoverables - Type N tab, enter cost centres and expense codes for sales, cost of sales and stock. These are also linked to the Analysis codes which are linked to the bonuses in Franchise Data.
Tip: Click the ellipsis button
When the posting table has been completed, click the Create button again to confirm the creation.
If posting tables already exist then it is easier to use the Copy option.
To do this, select the drop down menu's to locate the existing
posting table. Select New/Used, Franchise, Model (if required),
Variant (if required) and Sale Type.
The existing posting table will be displayed.
Select the Copy radio button and click the Create button. Modify the Franchise/Model/Variant/Sale Type as required and modify the cost centres and expense codes as required.
When complete click the Create button again to complete the creation.
It may be necessary to amend a posting table if the Chart of Accounts are modified.
To do this, locate the required posting table by using the drop downs
for New/Used, Franchise, Model, Variant and Sale Type.
The posting table will be displayed. Click the Amend button. Make changes as required. Click the Save button to confirm the changes.
As models go out of production and therefore will no longer be sold as New vehicles, the posting table can be deleted.
To do this, locate the required posting table by using the drop downs
for New/Used, Franchise, Model, Variant and Sale Type.
The posting table will be displayed. Click the Delete button. Click the second Delete button to confirm. The record will be deleted.
Warning: By deleting a set of posting tables any vehicles that are brought back into stock or credited for any reason will not be able to find the posting tables to make reverse postings. It may be prudent if a model goes out of production to not delete the posting tables but to just leave them, It may also have an impact on vehicle reconciliations running in the nominal ledger.
Use Customer address: Select the Use customer address radio button to set the address field to be the targets Home address.
Buttons:
Exit: Returns to the SR Miscellaneous Options Menu.
Help: Displays help on the current application in your default company browser.
Create: Click to create a new posting table either by the default radio button in blank which will create a blank table or by clicking the radio button Copy which will allow you to copy any existing set of posting tables.
Confirm: Will change to save when in amend or create mode.
Cancel: Will only be enabled when in amend or create mode.
Delete: Click to delete a pre loaded option.
Adhoc: Displays Adhoc enquiries. This can be used to find information held for the option you are currently using.
Message: Will only display a message when in amend or saving a record, e.g. Record secured when in amend mode.
Introduction to the editor function
