Why:

The General Ledger Other table is used by Fusion to ensure that the correct information is posted to the general ledger interface for Parts Freight, Parts Extra Costs, Discounts, Tax, Rounding Adjustments, Non-Productive Labour Costs, Workshop Claim Adjustments, Invoice Administration Charges and Used Vehicle Depreciation. General ledger codes for parts discount, workshop discount and sundry invoicing discount are defined in this table. However, codes for vehicle sales discount are defined in the General Ledger Sales option.

 

Where:

To be made available from the Control Master File view, via General Ledger Other.

 

How to Setup the General Ledger Other Codes:

 

Analysis Codes are set up in the format: xxxxxx 0 0 where xxxxxx is a code specific to the item to be analysed, 0 is the Department Code (if applicable) and 0 is the Product Code. Codes must be set up for each branch.

For used vehicle depreciation, codes are derived from the Vehicle Stock Type table.

For non-productive labour costs, codes are derived from the Non-Productive Codes table. Each code should be preceded by an ‘X’, for example XCLEN.

For workshop claim amendments, codes are derived from the Adjustment Interface Codes table. The debit account for claim adjustments should be the write-off account and the credit account the warranty debtors account. These accounts will be reversed automatically if the adjustment is for an overpayment.

The codes for all other items except parts and workshop discount are defined in the Fusion Parameter File.

Product code is obtained from the part for parts discount, from the vehicle for used vehicle depreciation, from the order header for claim adjustments or from the default parameter PRD 001 for all other types of postings.

Department code, if enabled, is obtained from the order header for parts and workshop orders. Vehicle admin department code comes from a default parameter FIN013. Department code for workshop claim adjustments and non-productive labour is obtained from a default parameter DEP001.

Parts and Workshop Discount:

The codes for parts and workshop discount are defined differently depending upon the level of discount analysis required. Front Counter Parts Discount:

 

Code Level	Code Format	Purpose / Description
3	PDISC	This is the lowest level of discount analysis and must be set up as a default. It will only be used if no higher level exists.
2	PD300	Where PD  = Counter Parts, 3  = Payment Method & 00 = Payment Code.
1	A01300	Where A = Counter Parts, 01 = Account Code, 3 = Payment Method & 00 = Payment Code.

 

Workshop Parts Discount:

 

Code Level	Code Format	Purpose / Description
3	PDISCB	This is the lowest level of discount analysis and must be set up as a default. It will only be used if no higher level exists.
2	PDB300	Where PDB = Workshop Parts, 3 = Payment Method & 00 = Payment Code.
1	B01300	Where B = Counter Parts, 01 = Account Code, 3 = Payment Method & 00 = Payment Code

 

Workshop Labour Discount:

 

Code Level	Code Format	Purpose / Description
3	WDISC	This is the only level of discount analysis and must be set up as a default.

 

Related Topics:

Account Codes.

Department Codes.

Payment Codes.

Payment Method.

Product Codes.

Tax.