Try going to Settings / Start Date and change the start date to before your first invoice. Does that work?
Yes. Manager ignores transactions before the start date, except for sales and purchase invoices, because that is how starting balances are set for Accounts receivable and Accounts payable. So if you had a medium raspberry on a sales invoice dated before your start date, but had one in inventory starting balance, the starting balance would have been applied to the earlier sales invoice. That would take your count to zero. The sale on 27 July could not have been completed until you made more jam with the 28 July production orders.
In Manager’s “mind,” assuming you are not using goods receipts and delivery orders, inventory is consumed the instant a sales invoice is created. So if you have a sales invoice prior to your start date, starting balance wasn’t 1, it was 0.
What start date do you have set?
23rd, the sale was invoiced on the 16th. all my product counts display off the starting balance of 1, but it sounds as if Manager could be assuming I have one less than is displayed…
I believe that is what is happening. Your single jar of medium raspberry was already sold. Your sale of RJM on the 27th wasn’t posted until the 28th because, according to your records, you didn’t have one in stock until then. So…not a bug, but an interesting artifact of transitioning to Manager from your old accounting methods.
As you enter starting balances for other products, I think what you’ll find is that everything shows on the correct date as long as you had more in stock than you had previously sold. But if you had other outstanding sales invoices, your counts will be off.
So what you should do is adjust starting balance quantities to reflect any invoiced but unpaid sales as of the start date.
Also worth noting is that if the sales invoice(s) dated prior to your start date were already paid off by the customer, it (they) should not be entered at all. Only unpaid invoices from before the start date should be entered.
Thanks to @dcVest for pointing us down the right track.
@Eagle5, I played around some more with your example and changing the Start Date will not correct the Summary / Inventory - cost. Because you are starting with Manager and bringing in some existing data, I don’t think there is an ideal solution. Here are the options:
-
Change the Starting balance
Qty on handfor RJM to 2. The problem with this is that you will have to find that extra RJM somewhere. You can not produce it later because you have told Manager you already have it in stock. -
Make a Production Order for one RJM dated the 16th. This will change the inventory levels for RJM and for the raw materials. I don’t know if that is a problem for you.
-
Change the date of the Sales Invoice from the 16th to 28/07/2017. Of course this means that this one invoice will not have the correct date.
From a usage point of view, all three ways will produce the correct dates in Summary / Inventory - cost. I’ll leave it to others to say which is the preferable way from an accounting perspective.
(I just saw @Tut’s reply, and will repeat part of it as a fourth option: If the invoice dated the 16th was paid before your Start Date, then just delete it.)
I changed the invoice date to the 23rd (my start date) and increased the starting balance quantity of everything on the invoice by 1. All transactions now display correctly.