Service Recall Campaign

Workshop Managers, I am quite sure that you receive Bulletins or information from the manufacturer should there be any important improvements required for a particular vehicle or model. In UNITS, there is a function called Recall Campaign which helps you to alert the Service Advisor at the point of opening the Repair Order.

This prompt will pop up if the vehicle selected has an applicable campaign.

You can then choose the applicable campaign (if there are more than one applicable).

In order for this to work, you need to set it up via Recall Campaign program in Service>Maintenance.
Refer to your Bulletin from the manufacturer and specify all the applicable VIN numbers and date range.

Note that this works best if the VIN numbers are correctly inputted against the Vehicle. Any slight difference will result in the system not recognising the VIN.

TIP: You should also setup a Jobcode which matches the Recall Campaign Code so that the job can automatically be loaded onto the Repair Order if selected. This makes it quicker to prepare the RO. The Job is loaded with all the information you set in Jobcode Maintenance and it is automatically marked as Warranty Type Job.

Vehicle Sale Reversal

If you have made a mistake when invoicing a vehicle, there is a utility called Stock Unit Sales Reversal Process. In other words, you can reverse/cancel the invoice by raising a Credit Note against it.

If the menu does not exist, you may have to add it via Menu Maintenance.

Specify the invoice number that you want to reverse.
Tick Purchase Flag Confirmation Box.
Press REVERSE SALES.

Follow the instructions and you should be able to print a Credit Note. All the GL Postings related to this invoice will be reversed.

NOTE
This should work quite smoothly if you haven't processed anything against the stock unit after you invoice. If you go to Stock Unit Maintenance for the stock, look at the Cost Transaction Tab. There shouldn't be any Ticked Boxes unser 'After Sale Indicator' Column. This column indicates whether there are any transactions done AFTER you Invoice the stock. In this case After Sale = After Invoice (not to be confused with Aftersales).

If you have any After Sale transactions against this stock, you will have to reverse those first before you are allowed to cancel the invoice.

For example, if you have processed a PO against the stock after invoicing, you need to cancel the PO before you are able to reverse. Another example (which is more common) is if you have issued a payment/cheque against the stock after it has been invoiced, you'll need to cancel the cheque first.

If all these doesn't work, there is actually a menu parameter which allows you to reverse sales with an After Sale transaction.
The parameter is {AllowWithAfterSaleTrans=Y}

If you take this approach, you may need to manually post journals to completely reverse any outstanding balances.

Contact me if you have difficulty to reverse any invoices.

Financial Year End Reset

For companies whose Financial Year ends on December 31st, you should have run the Financial Year End utility by now.

Commonly you want to wait for full audit is done and get the auditors to sign off your accounts before 'closing the year end'. With UNITS, you have full authority on your accounts and should comfortably  run this utility. All you need to do is make sure that you have specified the right company code and that the next year end date is correct. Press RUN and you are good to go. It doesn't take more than a few minutes (sometimes seconds).

What this program does is that it closes each GL account for the previous Financial Year. Depending on the account type, if it should carry forward balances, it will post a carry forward balance in the new Financial Year. For P&L types they will be posted against Retained Earnings. You should have a smooth carry over across the Financial Years. 

Should there be any Audit Adjustments required after you have run this utility, you can simply post GL Journals Type 'Last Year'. The system is smart enough to post into the previous year and at the same time post the correcting entry either on Retained Earnings or opening balances for the new Financial Year. 

So if you have entered into a new Financial Year, you should run this utility NOW!

Longer Character Fields in CONTACT Table

Some of you will be pleased that fields Name, Surname and Company in CONTACT Table now allow more characters.


•  Contact Company Name – extended to Char 150 (from 60)
•  Contact Name – extended to Char 150 (from 30)
•  Contact Surname – extended to Char 150 (from 30)

In addition to that, the following are also extended:
•  Payee Name – extended to Char 150
•  Payer Name – extended to Char 150

Malaysian Service Tax Rate Change

This posting is applicable to Malaysia only.

The Service Tax in Malaysia use to be 5%. With the recent increase to 6%, users can update the system to reflect accordingly by changing the figure in SysConfig Maintenance (normally in Utilities Menu).

All you need to do is to scroll down to Service Tax Percent and update the Value in Decimal to 6.0000.

Press SAVE and restart your system for the change to take effect.

Service Invoice Reversal

Previously if you make a mistake on a Service Invoice, it is quite a hassle to make a correction. You would have to go through a few steps in order to raise a Credit Note against it. It is even trickier if you have components of Parts, Labour and Others on the Service Invoice.

In Build2060, a new program is introduced to make it easier for you to raise the Credit Note. It is called Service Invoice Reversal. You will have to add this program to the respective user's menu.

All you have to do is to specify the Invoice number that you want to reverse and press REVERSE. All the respective postings will be reversed accordingly. You can then reinvoice with the right details.

Just as an added control/security, the reversal can only be done by an authorised person and furthermore, it requires authorisation from the person who has access to Credit Override Administration program.

Specify the Invoice Number, tick Authorise and press SAVE. The invoice is ready for reversal. Easy!

Rebuild GL Master File

Regular housekeeping is good for your health!

One of the utility that is recommended for you to run is Rebuild GL Master File from the General Ledger> Utilities menu. (Note that this should only be run by the Accountant or an authorised person).

Select a 'Year End Date' and click SAVE. You will see the progress bar showing you the rebuild status. Run for all the available Year End Date. 

Running this utility ensures that your GL reports are up-to-date and in balance so that you don't unnecessary heart-attack when you discover that your figures don't tally. You can run this any time of the day, any day in the year.

This exercise should not take more than 5 minutes and it is good practice to run this on a regular basis.

Options> Options

If you have users who leave their desks often for a long time, they may be at risk of someone using the system while they are still logged on. To minimise this risk, you can set so that the system auto disconnects within the specified period of time.

To do this, you can go to the Options> Options menu.

From the General Tab, you can specify the number of minutes that you allow the system to be idle before it disconnects itself. There are also a series of other settings that you can do from this tab.

While you are there, you can also go to the Background Tab. Here you can choose your favourite image to be the background of your system.

Have fun personalising your system!

Stock Unit Maintenance Status Logic

In Stock Unit Maintenance program, there is a Stock Status area which commonly shows 4 types of statuses.
On Quote, Pre Sold, Sold and Swapped Out. If you notice, these statuses are not on VHSTOCK table but rather a set of criteria which produces the statuses.

Here are the logics:

1. On Quote

It requires the stock number to be present in VHQUOTEUNIT table. (Provided that it hasn't been sold or status changed to order).

2. Pre Sold 

This stock number needs to be on VHQUOTEUNIT table AND there is a date in 'Original Order Date' field in VHQUOTE table against the same Quote number.

3. Sold

The 'Salesdate' and 'Sales Inv' fields in VHSTOCK are populated with the respective info.

4. Swapped Out

There is a value in the 'Swap Out Ref' field in the VHSTOCK table.

p/s If you don't access the Database Tables, this posting might not make any sense to you. Ask your System Admin for details.

GL Reconciliation Report

One of the key reports to look at, especially to make sure whether your GL and Subledger is balanced. It is recommended that this report is viewed every start of business day so that you can take immediate action should you find any imbalances.

Previously the report will just show imbalances (if any). Now, a new feature is added to enable you to see a more detailed list of transactions which could have caused the imbalance. All you need to do is to press the [...] button next to the imbalance amount. 

Creditor Journal Entry

Imagine a case where you have processed a Creditor Invoice for an amount. When the time comes for payment, you noticed that the amount entered is not valid. Could be to due to a wrong amount entry or maybe you have negotiated for a discount for whatever reason.

Previously, you will have to either put through another Invoice Entry to adjust for the variance or perhaps you cancel the entry and post another one for the correction.

Now in Build 2060 you have another option on how to make the correction. You can use a new program called Creditor Journal Entry. This program is similar to Debtor Journal Entry where you can make an adjustment posting to an existing transaction.

To make use of this, you will have to add the program to your menu via Menu Maintenance.

System Calendar

Here comes another new year and to those whose Financial Year ends on 31st December, it is advisable to check your System Calendar Settings. Go to Utilities>Syscalendar Maintenance.

Make sure that you have the appropriate Financial Year End setup to reflect the new Financial Year.

TIP: To save future woes, you can setup for the following 2 or 3 years in advance.

Welcome to the Blog

  

This blog is created out of my love for Excel and UNITS. I will be posting some interesting findings which should benefit all users. If you have things to share, send them to so that I can upload for you. Alternatively, you can use the 'comment' box to share your views.

Visit the pages frequently to check for new postings or you can register as a follower so that you will be informed each time a new post has been uploaded.

Happy blogging and Happy New Year 2011!

View latest entry here.

p/s UNITS is a product by Auto IT. If you are not a user, the entries will make no sense to you.