The append unmapped brings the back BUT the value is $0.00 and you cannot edit that column?
Presumably because the Item was neither Sold nor Purchased.
You should not be editing the Cost anyway. Only the Quantity.
Well I agree but once you APPEND Unmapped they come in as $0 as shown above. This screws up all reportsā¦
Then donāt do it. 
Hmm I see. Adjusting current inventory will spread the periodic cost. I mean if you sold 100 items and the cost is $10ā¦ when you adjust it to 110 items it will calculate 110 items sold for $10. I donāt know how weāll be able to handle this when we donāt know the cost (we didnāt sold in that period).
1 Like
Well the customer rang up not happy as he said āhalf his stock is missingā! The manual stock take list (he walked around and counted each item) was twice as long as the EOD report.
So how do you enter OR check the stock take physical against Samba EODā¦
Instead of editing eodā¦ creating a waste warehouse and moving wasted items there might be a better fit for you.
But you canāt create Inventory Transactions when the WP is closed. And you canāt see the EoD until the WP is closed.
So will need to print a Custom Report before closing WP?
Count Stock, and write down Physical next to Prediction.
Execute ātransferā Inventory Documents to move difference of Quantities to Waste Warehouse.
Close WP.
Doesnāt it make sense? It should happen before eod generates.
Humm OK.
I think Emre if you told the current developers that al they need was to keep creating this record you not have this problem:
You see it just stops at 237 - if it carried the cost along when you Append Unmapped items i.e. last known at 237 - it would all workā¦
The ID 264 is my solution by opening the WP and purchasing the new total with the cost (as only way to get the cost in).
I am finding that stock needs adjusting for a Bar for 80% of items mainly because there purchase orders are not up to date. Therefore I ave a custom report like you say Q BUT too many items need adjusting and they are not in the EOD inventory screenā¦
This is my problem.
1 Like
lolā¦ sorry it might not work as it appears on the database. You want zero quantity transactions with carried cost but I donāt know how it could affect overall cost calculation as zero quantity transactions are not expected.
1 Like
Ok then what was this button supposed to do?
Append Unmapped Items? Why was it there?
I think it was put there so quantities could be manually adjusted to physical stock after a stock count? And the button was to create a transaction record if there was no ālast period consumptionā.
That would be great BUT the cost comes in as Zero $0 - do you see now or have I confused youā¦
Hmm you can map inventory to a specific warehouse. That button is useful when you need to change that mapping. Well Iām having a little difficulty to remember the exact case but I remember I made some work to remove unnecessary items from eod listsā¦ due to a request.
2 Likes
Leftover from V2 ? 
probably that was not to display items (for example drinks) on specific warehouses (for example kitchen)
There might be more records in the Table, but you only selected TOP 1000 ā¦
Yes OK - it seems the best solution would be to use the list if they have a current transaction shown AND then purchase the remaining amount in.
It just seems something not quite right as the inventory reports start to not show stock as wellā¦
Yes I checked it has 109 records as the quantities change every 20 records then stop after the ones I have shownā¦ This would be the same for rest of stock about 40 itemsā¦
The reason why I thought ou had nailed it @QMcKay is how come we have records I have highlighted here where the stock was not consumed from period to period!
I know I am ranting but something is wrong - why did it just stop at 237ā¦ as this exampleā¦
How it does not show stock?