![]() ![]() You can see a lot of differences between the two. Here is a second example of the report from above, but this one includes my custom MNSC field, right next to the standard MNS field. I have seen a few situations where a part can make it into the system without a LSD/LRD/SD, but these are few and far between, and can be dealt with on a case-by-case basis. I could argue this methodology either way, but this is the way I chose to do it.įor 99.9% of your parts, this methodology will calculate an accurate MNSC using an understandable process. I do this because if a part had a sales date that was a few years old, but then its received again, I assume that it’s either a special order for a customer, or that the dealership wants to give that item a second chance at life of on the showroom. If the Setup Date (SD) is a valid date then MNSC = Today’s Date – SDĪlso, if there is a valid date for the LSD and LRD fields, I’ll calculate 2 MNSC metrics and use the smaller of the 2.If the LRD is blank then look at the Setup Date for the part.If the Last Received Date (LRD) is populated with a valid date then MNSC = Today’s Date – LRD.If the LSD is blank then look at Last Received Date.Last Sold Date (LSD) populated with a valid date then MNSC = Today’s date – LSD.Here is the methodology I use, working down the list I’ve chosen to build a new Months No Sale Calculated (MNSC) field. As you can see, there are some items where the MNS field remains at 0 because those items have never sold, even though some of them were received in September of 2020. I included the parts from one supplier and the standard MNS field. ![]() Here is an example of a report I ran this morning. Their agreement was to pay dealer cost for all the stock that was 12 months or less no sale, and they didn’t understand how the system works. I once worked with a company that had overpaid $420,000 for current parts inventory by using the stock MNS field. ![]() Why is this a problem? Well, for dealers who measure and track obsolescence (in my case we consider a part to be obsolete when it has gone 12 months without a sale), the canned reports in Lightspeed will show that the inventory is a lot healthier than it actually is. In cases where you have a part that has been received, but never sold, the MNS field doesn’t increment (because there isn’t a last sold date), so the MNS field just remains at 0. The problem with their calculation is that MNS is calculated purely off the current date, and the last sold date for each item. I’m not going to say that Lightspeed EVO mis-calculates the Months No Sale (MNS) metric, I just don’t agree with their methodology. I do my best to not directly call out industry vendors (most of you do a good job of figuring out who I am talking about), but when it comes to DMS providers, it’s kind of tough to not use names. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |