1) Have Balance Ledgers always produce a report even if it's to say "No errors". It should also indicate if it was a Validate Only or a Validate and Fix. This is an audit trail and *may* be of use when discussing a problem with the Sage Support Team.
2) Report on the "temporary" stock item allocation table clearance - which items were cleared and what value was "allocated"
3) ONLY CLEAR THE TEMPORARY TABLE WHEN YOU ASK IT TO FIX, NOT WHEN YOU ASK IT TO VALIDATE-ONLY OR AT LEAST HAVE A TICK-BOX OPTION. AND ALWAYS PRODUCT A REPORT.
By way of detailed explanation, yesterday I was advised to run Balance Ledgers by Sage Support because a customer had some stock items that showed a Free Stock quantity that was wrong (too high) but when they went to adjust it using Write Off or Add Stock the free stock quantity shown was correct within that form (a lower value in this case). There were no SOP allocations or orders so something else had to be involved in the calculation.
I ran Balance Ledgers and asked it to Validate and Report, which it did and said "no errors" hence clicking the Print button didn't produce anything in the spooler. I then decided to check the stock item again before proceeding to run this again and ask it to "fix" any problems and to my amazement the stock item was now correct! However because there was no report I had no proof of what I had actually done (did I inadvertently choose the "correct errors" option?)
I spoke to Sage Support this morning and the explanation was that there is an "allocated stock" table that's used as a temporary table to allocate on the fly as orders are entered and that if the SQL database connection times out or the PC crashes for example then these entries can get left behind so "IT ALWAYS CLEARS THIS TABLE", which is why you should only run as a single user. All of which makes sense except that now the free stock on the item is the wrong, higher value. But, there is no trail of which items were "corrected" in this way by emptying the table. So now the customer has to go through all stock items and check them.
Guest
