First, forgive me if this was previously addressed.
I have a lot of inventory items and a lot of transactions under each one. The issue I am having is not being able to verify that inventory write-offs haven’t been issued with Negative Quantity or Zero Value. As I have a lot of transactions it will take forever to check each inventory item and see all of its transactions. It can be done manually, but I will have to do it every month which will require more time than I have. There has been a lot of demand for stock zero warning which could have solved my issue. Till such a feature is implemented, can anyone be kind enough to guide me on how I can do such verification?
I am using Cloud Version on Mac, if that information is necessary.
I am really not fully familiar with how to do custom reposts, all the time I try doing for many propose including this one and the outcome most of the time is not what can serve my propose. So that’s why I end up in the forum requesting assistance and guide.
Your goal is not clear, @Drew_Mike. Are you referring to a negative quantity on the inventory write-off transaction form? If so, that would amount to a write-on, that is, an addition to stock. Or are you referring to a negative contribution to the quantity on hand? That would be a normal reduction due to a write-off. Whichever you mean, the value of the transaction will take place at the current average value.
That is entirely unnecessary. Just create an Inventory Quantity Summary for the time period in question. There is a column for Inventory Write-offs. In this report, normal write-offs show as negative, incorrect positive write-offs show as positive numbers. Both are according to their effect on closing balance:
Figures are clickable.
What accounts are you referring to on the P&L? Whether a positive or negative quantity is entered on an inventory write-off, the designated allocation account is adjusted according to the current average cost.
My issue is similar to what is showing in this photo, there is qty issued with no stock and hence the value affecting expense accounts is zero. Manager can’t calculate average value when the stock is zero.
So what I am looking for is to find any qty issued with Zero value, so I can look for the cause and adjust.
When I referred to P&L, I meant the expenses account which shows less operation cost than the actual cost for a particular division or the whole company.
It is impossible to tell what your screen shot is displaying, because you have cut off all column headers, bread crumbs, etc.
Yes, exactly as designed.
Making such adjustments would be a mistake. When you are in a backorder situation (quantity owned is negative), Manager catches up automatically when more units are acquired. If you make adjustments now, then buy more of the item later, then your financial statements will be off.
You have not been clear what this has to do with inventory write-offs, or why you are looking for negative write-offs with zero value. But understand, zero-valued inventory movements are normal, and Manager makes necessary entries automatically when more stock is available. This is why it is acceptable for businesses to sell units not yet in inventory.
I do not understand what you mean by this. What do divisions have to do with this? My question was what actual account name are you referring to, because inventory accounts are normally automatic.
