Peak Software Telephone Number: 01625 428220

FOC Parts Supply

Creation date: 25/11/2019 14:36    Updated: 11/06/2020 08:32    foc parts parts issues parts supply warranty parts

As Peak does not currently have a Warranty program, most Skoda/Seat users will be reconciling the warranty via another option, possibly a spreadsheet. This should continue, allowing for a FOC amendment to the parts columns. 

Peak has received reams and reams of paper regarding the new FOC Warranty Parts system but, after much discussion, has determined that the majority of the changes are procedural and do not require many changes to the software.


This document sets out our recommendations for processing this new system and lists the changes we are making to the software to facilitate easier reconciliation.


There is no change to the Parts Ordering procedure.  Processing a Warranty Job, other than issuing parts at cost + handling charge, is also unchanged.  For users not utilising this function, the set up is detailed in the next section.


The Software includes:

  • An extra field in the Product Groups for GRNI (Goods Received Not Invoiced).  When goods are booked into stock in the parts module, the value will write to the Stock nominal (DR) and the GRNI nominal (CR). When the invoice is processed via the Purchase Ledger the value will write to GRNI (DR) to balance this account. Differences in the booking in value and invoice value should be dealt with as per your current procedure.
  • Ability to enter a narrative line on a sales ledger posting either in Misc. Postings or Receipts.
  • Nominal Ledger analysis on Miscellaneous Postings in the sales ledger, with narrative entry against each line.
  • Parts ‘Monthly Issues Analysis’ report to be amended to include all WIP parts issued and not invoiced, regardless of the date of issue.
  • Change to composite to encompass the new box code for the ‘Parts Warranty handling fee.
  • Purchase Order print to show values of Each cost and Total cost.

New Balance Sheet account codes for the Nominal Ledger are required for the following:

  • GRNI (Goods received not invoiced) – to be inserted into the parts product groups.
  • Warranty Credit Note Clearing Account
  • Warranty FOC Parts Clearing Account


Warranty Parts at Cost Setup

Go into Parts Management Parameters and into Amend Discount Codes. In here select the correct Franchise/s (Skoda/Seat) and then amend the Sales Discount Codes and set them to the percentage for cost plus mark up using the minus symbol. This will need to be done for all the Discount Codes under the relevant Franchise/s. 

Then to go into the Sales Ledger and into the Warranty Account. In Account Details change the Rep No to 81 and the Discount Code to whatever was set in the parts parameters, in this case B    
When you issue a part to this warranty account it will calculate the price at cost price plus mark up (% entered in the discount codes)

In the above example, any parts issued against this warranty account will be issued at cost plus 7.5%. The 7.5% is the handling charge allowed by the manufacture.

N.B.  This charge may vary and is not meant to be representative of the actual fee that Skoda or Seat may allow


Parts and Workshop Procedures

Parts Procedures

  • There is no change to the parts ordering system except a recommendation to print and keep the order as a record for possible value queries.
  • Issue warranty parts to workshop jobs at cost + handling fee.
  • Book parts in as normal.  DO NOT change the cost price of the FOC parts to zero.
  • As the value of the parts booked in will now write directly to the accounts, please ensure that the current cost price is entered correctly.
Accounts Notes
  • Parts issued to jobs at cost + fee, when invoiced the cost will be Cr from Stock and Dr to COS.  This will net a gross profit of the handling fee.  The Mechanical Warranty Sales and COS nominal codes (from the franchise product group) should be attached to the new composite box code.
  • Goods receipts will now write to the nominal ledger as Stock Dr / GRNI Cr.  When the invoice is posted against the purchase order as now, the transactions will be GRNI Dr / PL Creditors Cr.  Any differences between the cost at goods in and the invoice cost should be dealt with as per your current procedure, but should be posted to the Stock nominal account code.

Workshop Procedures

  • Process the warranty job as usual on the Peak System.  This invoice must include VAT.
  • Follow the Skoda/Seat instructions for processing your warranty claim.
Accounts Notes:
  • The Parts Issues Analysis report will now report WIP parts from the jobs file and not the parts movement file, thus reporting on all issued/not invoiced parts


 

Sales Ledger Procedures

Below are the procedures for clearing the warranty invoices raised by the workshop.  Many users currently contra the warranty credit notes from the purchase ledger to the sales ledger as a lump sum.  With the new FOC parts it will now be easier to reconcile if the credit notes are posted to the sales and purchase ledgers rather than doing the contra.  The new facility of a narrative line (20 characters) on miscellaneous postings and receipts will aid reconciliation. This narrative line will also transfer to the nominal ledger.

NOTE: The VAT content of all invoices and credit notes should be shown separately.


As an added feature the following will be transferred as the narrative on all sales ledger invoices:-

     a) Workshop Invoice           -        Job number/Registration Number

     b) Parts Invoice                    -        words ‘Parts Invoice’

     c) Vehicle Finance D.Note  -        Registration Number

     d) Vehicle Bonus D.Note    -        Registration Number

     Note:  These narratives will not at present transfer to the historical data file.

  • The warranty invoice will write from the workshop to the Warranty sales ledger account as normal.
  • When the Warranty Credit Note is received, post as a credit note to the Warranty sales ledger account.  For easier reconciliation, the credit note could be broken down into 1 credit note per claim/invoice.  The credit note(s) should be posted to the Warranty Clearing nominal code. Differences on invoice versus credit for labour, handling fee, sublet etc., should be dealt with at this stage.
  • When the Parts Sale Document is received, post the FOC parts entries as credit notes on the Warranty sales ledger account to the Parts FOC Clearing nominal code. Again individual entries will facilitate easier reconciliation.
  • Use zero receipt to clear completed entries.


Purchase Ledger Procedures

The Purchase Ledger supplier account for Skoda/Seat will now be used to post warranty credit notes and FOC parts credit notes.  This will make the monthly statement received from Skoda/Seat easier to reconcile.  As mentioned above in the Sales Ledger section, posting the Warranty Credit Note and Warranty FOC Parts Credit Notes should replace contras. 

NOTE: The VAT content of all invoices and credit notes should be shown separately.

  • Post the Warranty Credit Note on the Purchase Ledger as a Credit Note to the Warranty Clearing Account code.  It can be posted as a total goods amount but should show the VAT separately. 
  • When the Parts Sale Document is received enter the total net and VAT values. Post as per the old purchase invoice selecting the relevant orders.  The total gross goods value will post to the GRNI nominal account code.  Post any differences between the order value and the invoice value to the Stock nominal account code.  Then post the FOC Parts as a negative value to the FOC Parts Clearing nominal account code on the nominal analysis screen (known be most users as ‘the front screen’).  These two postings will give a net goods value excluding any FOC parts.  Complete the posting accepting the net VAT value (gross vat value – FOC parts credit vat value).  This will add the total net value to the supplier account on the purchase ledger.


Nominal Ledger Procedures

The addition of the new nominal codes for

  • Goods Received Not Invoiced Account – needs to be entered in the new field in product groups.  Note: if a nominal code is not entered into this field, the nominal posting will not take place, i.e the goods inwards will only write to the stock file and the Parts Supplier invoice posted to the Parts Stock nominal account
  • Warranty Clearing Account
  • FOC Parts Clearing Account

and the ability to enter narrative lines on the sales ledger postings, makes the reconciliation of the new Warranty FOC Parts procedure much easier.


The documentation received from Skoda/Seat should be utilised to help with the reconciliation task. These nominal account codes should be marked for ‘reconciliation’ to enable the accounts staff to easily trace unreconciled values.


A new Composite box code for Warranty Parts Handling Fee is to be introduced.  The Workshop Warranty Parts Sales and COS nominal codes should be attached to this new box code.  This change should not be actioned until the November composite is completed. New composite programs will be issued once we have ascertained where the new box code is to be positioned. These should not be copied on to your system until the November composite and nominal month end is completed.


The postings created by the various entries are as follows:-


Delivery of parts order value £1000


Nominal Description

DR

CR

Narrative

Parts Stock

1000.00


GRN  123456

GRNI


1000.00

GRN 123456

Note: The value (ex VAT) of any goods received but not invoiced prior to copying on the new programs associated with the new procedures, should be journalled as above.


Warranty Invoice – Sales Ledger

Nominal Description

DR

CR

Narrative

Warranty Labour Sales


45.00

Job No 000123

Wrnty Part Sales (incl Hand.Fee 5%)


105.00

Part Number

Warranty Parts COS

100.00


Part Number

Parts Stock


100.00

Part Number

VAT on Sales


26.25

Invoice Number

SL Debtors

176.25




Warranty Credit Note – Sales Ledger

Nominal Description

DR

CR

Narrative

Warranty Clearing (Labour)

45.00


User entry

Warranty Clearing (Hand.Fee)

5.00


User entry

VAT on Sales

8.75


Ref Number

SL Debtors


58.75


Note: Parts Sale £100 + VAT £17.50 not credited on warranty credit note.


Warranty Credit Note – Purchase Ledger

Nominal Description

DR

CR

Narrative

Warranty Clearing (Labour)


45.00

User entry

Warranty Clearing (Hand.Fee)


5.00

User entry

VAT on Purchase


8.75


PL Creditors

58.75



Note: this credit will be utilised, along with the parts invoices (sale document) and bonus contras, against the net Skoda/Seat monthly Debit or Credit from/to your bank.  It also clears the Warranty Clearing Account from the Warranty Credit Note posting done in the Sales Ledger.


Parts Sales Document – Sales Ledger

Nominal Description

DR

CR

Narrative

FOC Parts Clearing Account

100.00


User entry

VAT on Sales

17.50


Ref number

SL Debtors


117.50


Note: This clears the Parts sale £100 + VAT £17.50 not cleared on the Warranty C. Note on the Sales Ledger Warranty account.


Parts Sales Document – Purchase Ledger

Nominal Description

DR

CR

Narrative

GRNI

1000.00


Supplier Ref

FOC Parts Clearing Account


100.00

Supplier Ref

VAT on Purchase (net of £175 - £17.50

157.50



PL Creditors


1057.50


Note: This posting clears the GRNI nominal account and the FOC Parts Clearing nominal account



Reports

Items Awaiting Invoice

This report can be found in Parts, Reports, Orders, Purchase Orders, and lists all orders received but not yet invoiced.  It will, of course, only list parts received against a purchase order.  Therefore, all franchise parts ordered should be placed on a purchase order.

If there are any ‘old’ orders on this report i.e. orders where the invoice has not been posted against the order, these should be deleted.  A level 9 password in Parts Purchases is required to access this delete function and great care should be taken to ensure no current orders (received and not invoiced) are deleted.

Once the order file is cleansed, the report should match the GRNI value on the nominal and can be used to check source v nominal values.


Parts Issues Monthly Analysis

Found in Counter, End of Day, this report lists, among other things, the Mechanical WIP parts issued by retail, trade, internal and warranty. Currently it is calculated from ‘this months movements’ but is being changed to read the workshop job file and calculated all non-invoiced parts.

If the GRNI field is activated on the product group, this report is used to check stock valuation v stock nominal. The Goods Received Not Invoiced report value is no longer used in the stock v nominal value. The calculation now being

          Stock valuation + WIP Parts = Parts Stock nominal.

This calculation assumes that any adjustments done on the stock file have been journalled from Parts Stock in the balance sheet to Stock Adjustments in the P&L.


Files