by scotstrong » Tue May 02, 2006 4:02 pm
AllanG:
According to your profile you are not in the dealership parts business, so I can understand why this might not make sense to you. The DMS system on the parts side basically only accounts for parts that show an on-hand quantity. There are many potential "in-process" items that the DMS system's "on-hand value" may not account for. "Work-in-process" is parts that are sold to repair orders and parts invoices that have not closed out yet and posted to the accounting journals. The DMS system will create a report and total for these; yet it has to be manually added to the "on-hand value" to compare to the accounting office value. "Used cores" are returned parts that have a core charge that have not yet been returned for the core credit; again this must be manually added to the "on-hand value". "Returns in process" are returns made to the manufacturer (or other vendor/supplier) that the store has not yet received credit for. Also, if the accounting office has received and posted any invoice for parts that have not yet come in (in transit); or if parts have arrived that the accounting office has not yet received the invoice to post; one must account for all of these as plus and minus adjustments to the accounting dept. and DMS parts "on-hand value".
Any and all of these situations happen virtually every month in almost every dealership; so you can begin to see that the reconciliation process can sometimes be more than a little cumbersome and time-consuming. As stated in previous posts, if there is a problem it is usually identified and resolved in the month that it occurred rather than waiting for a once-a-year complete physical inventory to reconcile the parts dept. figure with the accounting office figure. When there is a discrepancy, it is more often the result of human error rather than theft. Many parts depts. handle thousands of individual transactions per month. All it takes is for a couple of instances of a busy counter person juggling multiple tasks and numerous interruptions to forget to bill something out that was given out resulting in a discrepancy.
I have yet to see any method other than a partially manual process of adding and subtracting the "in-process" items to the DMS-generated numbers that can come up with an accurate reconciliation.
Hope this helps clarify a somtimes very murky situation.
Scot Strong