Topic: all required by dates have reset to 1st Jan 200
By: Guest
Posted on: Jan 31 2018 at 07:20:55 AM
Has anyone had a problem with required by dates disappearing from the database?
By: Support
Posted on: Jan 31 2018 at 01:42:03 PM
Do you mean the dates in your purchase orders? Or customer orders. Or both.
Is it the required by date of the whole order or the required by dates on individual lines on the order:
By: Guest
Posted on: Feb 1 2018 at 02:02:45 AM
It was on Purchase Orders, closed Purchase Orders. When you look at a closed Purchase order, instead of showing the required by date in the top section of the screen, the majority of the closed purchase orders have lost that box and it is now showing as a date required in the body of the order instead. It looks like the majority of the required by dates have defaulted to 01/01/2000
By: Support
Posted on: Feb 1 2018 at 03:27:04 AM
If you're seeing 01/01/2000 then I assume you are using something like MSAccess to look directly into the database tables.
Each purchase order has a requiredBy date for the whole order and, potentially, different RequitedBy dates for each item/row on the order. That's a lot of dates and many of them will not be used. If a date is not used then MiniMRP stores 01/01/2000 into the field in the database simply as a place holder.
That 01/01/2000 is what we'd call a red herring. It isn't the cause of your problem.
Your problem about seeing the date in the body of the order instead of at the top is a different problem. First though I will say that the database is not corrupt. It hasn't overwritten or corrupted any of your orders. It's just something in the way MiniMRP is displaying those orders.
It's a display error in the software - so the order in the database is correct it's just being displayed wrong on the screen.
It may be a glitch that's appeared in a recent update or maybe it's something that has always been there and you just never noticed before.
Either way we'll take a look and make sure it's fixed in the next update.
But don't do into the database and start poking about with dates. There's no problem in the database. It's just a display problem which we'll fix.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
