Why:
Account strings are used by Fusion to ensure that the correct information is posted to the finance system from sales transactions.
The contents of this file can vary by market to cater for the nominal ledger layout of 3rd Party Suppliers.
Note! Please ensure that
this layout has been discussed, designed and set up in conjunction with your
interface program provider and with Retail Systems VTC
personnel.
Where:
From the Control Master File view, select General Ledger Sales. This will open the General Ledger Sales window.
How to Setup the General Ledger Sales Table:
The screen displays existing Account Strings in summary format. The Branch Number is assumed automatically from the Branch Number entered through ‘Branch Security’ and is therefore not displayed.
The Account String is displayed in the format 3 P 00 01 0 (where 3 is the Customer Credit Type, P is the Department Origin, 00 is the Payment Code, 01 is the Account Code and 0 is the Product Code).
If the Department Code is used (Parameter 910 204 being enabled), this is also a component of the account string.
To create a new code XXXXXXXXXXXXXXXX then select the customer cash/credit code as set up on the ‘Cash/Credit Code table.
Select Department Origin. This code must be P, B, W, S, T, L, or M.
Select the Payment Code, as set up on the Payment Codes.
Select the Account Code, as set up on the Account Codes.
Select the Department Code (if applicable), as set up on the Department Codes.
Select the Product Code, as set up on the Product Codes.
Input the Sales Debit account from the Nominal Ledger (up to 20 characters). This is normally a Sales Ledger control account in the case of external transactions, a warranty claims control account in the case of warranty, and an expense account or stock account in the case of internal transactions.
Input the Sales Credit account from the Nominal Ledger, e.g. parts external sales account. Input the Costs Debit account from the Nominal Ledger, e.g. parts external cost-of-sale account. Input the Costs Credit account from the Nominal Ledger, e.g. parts stock account.
For Department of Origin S (vehicle sales) only, enter the Costs Accrual Account from the Nominal Ledger. Finally, input the required description & click ok to add the record to file.