It is very important to settle the inventory balance for an item

1

We have the Titanium Company for Marble and Granite. Our work depends on the quarter meter, the unit of measurement for items. For example, purchases are 100 square meters and sales are 120 square meters. Because this is the nature of marble, you get free quantities and sell in excess of quantities. The inventory here is a negative value - 20 square meters. We want to settle. The stock is actually zero currently in the field

2

Read the Guides about inventory write-offs.

3

@Tut, you just provided the ultimate solution to the issue …

However, there seems to be a mental blockage for many users – myself included, and that has to do with two things:

  1. The name Inventory Write-offs suggests that it’s just that. It stops people from using it to record excess quantities. Possibly a rename to Inventory Quantity Adjustments is better suited.

  2. Using negative to add and positive to take away is counterintuitive. I can think of few other more intuitive form designs, like:

  • Positive for write-ons and negative for write-offs
  • A dropdown to select the type of adjustment – ie. Write-on vs. Write-off
  • Two separate fields, one for writing-on and the other for writing-off.

I know this may seem like a purely cosmetic change but it will better fit the “form” (both literal and figurative) to the function.

4

@Ealfardan, you have basically resurrected a very old topic in the ideas category. I am pretty sure it’s still there.

1 Like
5

I can’t bet against you. Here it is:

1 Like
6

Sorry I didn’t have time to do the search.

7

The quantities in the system here = zero, but in the field there are 20 square meters. We also need an account for the adjustments ±, the inventory must not be written off. Other items, the quantity in the system is 20 square meters, but in the field there is zero.
You must add (the inventory settlement of the inventory with the actual cost or any price)

8

Everything you ask for is already possible, despite being split between two tabs: Inventory Writeoffs for reductions, Journal Entries for additions. The suggestion in ideas is about combining them, not adding a new functionality.

9

According to Guides yes for addition you have to use Journal Entry for Write-on but negative write-off is also working for write-ons. Dont know if it was like this from the start or it has been done recently but currently this method is working without the write-off transaction ending up in suspense.

10

I would suggest
1- Enter the extra qty (free qty you get on purchase) on separate line with unit price zero.
2- Write-ons either by Journal Entry or using Inventory Write-off Tab (which i am not sure if it will cause any issue in future)
3- Use production order for this purpose. When you received the item from Supplier create a production order with Finished item 20% more than the BOM item this way you will have actual qty of item on hand than what was mentioned on Purchase invoice.
4-Inventory Kits can also work for this but in last two suggestions you have to create separate items for Purchases and Sales of a single product.

1 Like