Stock comprometido en negativo

[former_member325322]

Hola a todos

Tengo la siguiente pregunta.

Tenemos varios productos que figuran con un saldo negativo en el comprometido. Entiendo que el saldo comprometido en valor positivo significa que existen notas de venta (Ordenes de venta) para dichos productos, pero no logro explicarme ese dato en negativo.

Saludos

[former_member188440 · Accepted solution]

HOla Revisa esta nota a ver si te da una idea

Symptom
Summary:
When changing a partially delivered sales\purchase order by deleting or adding rows as described in the scenarios bellow (Described under 'Scenarios'), your database might be affected by one or more of the following issues (Described under 'Issue no. 1, 2, 3, 4'):
Issue No. 1:
The committed\on order quantity in the item master data for the delivered row (and in some cases also other rows) item is incorrect.
Issue No. 2:
The Orders Balances on the BP master data could display a negative\incorrect balance.
Issue no. 3:
The Open Items List report might show Negative\Incorrect amounts
Issue no. 4:
The Inventory status report can show differences between the summary and the detailed report (when using double click on the line no.)
Cause
Application error
Solution
The scenarios bellow will be fixed in a patch, please refer to the info.txt file on Service market Place to confirm.
Scenarios:
=====================================================================
Scenario 1:
==========
1. Create a Sales order with 2 rows for items with on hand quantity.
change quantities in rows e.g. row 1: quantity 4, row 2: quantity 6
2. Copy the sales order to a Delivery
(you can fully copy the sales order and then delete the first row,
or use customize and copy only the second row)
3. Add the Delivery
4. Go back to the Sales Order from step 1
5. Delete row 1
6. Click Update
7. Check Committed quantity for second row item
Actual: Committed quantity for the item is -4
Expected: Committed quantity for the item should be 0
Scenario 2:
==========
1. Create a Sales order with 2 rows for items with on hand quantity.
change quantities in rows e.g. row 1: quantity 4, row 2: quantity 6
2. Copy the sales order to a Delivery
(you can fully copy the sales order and then delete the Second row,
or use customize and copy only the first row)
3. Add the Delivery
4. Go back to the Sales Order from step 1
5. Add a new row before the delivered row (row 1) with quantity 5
6. Click Update
7. Check Committed quantity for First and second row items
Actual:
Committed quantity for row 1: 0
Committed quantity for row 2: -6
Committed quantity for row 3: 6 (correct)
Expected:
Committed quantity for row 1: 5
Committed quantity for row 2: 0
Committed quantity for row 3: 6
Note! This scenario only reproduces if there is a row after the
delivered row (the delivered row can not be the last row in the
document).
Same behavior will affect the On order quantity in case of purchase
order.
In order to identify items effected with scenarios above please run the attached query (In the attachment tab).
Attachment name: 0_Wrong_IsCommitted_OnOrdered.TXT
In some cases the query returns results although the data in the system are correct.
Here are some limitations which can cause incorrect value in the field calc_committed or calc_onorder.
1. Some time before item has changed from inventory to non-inventory or back (it was possible in the earlier version).
2. Some time before  warehoused has changed from Drop Ship to Regular or back (it was possible in the earlier version).
3. The query doesn't take into consideration the changes in the rounding for quantity field. If the difference between calc_committed and sys_committed or calc_onorder and sys_onorder is less than 0.05, there is usually no need to fix the database.
4. The query doesn't take into consideration negative quantity in the Reserve Invoice row.
If you find incorrect Committed or On Order quantity or Orders Balance on the BP Master Data, please contact your Support Center.
Other terms
negative committed quantity, wrong committed quantity, On order quantity, Open items list, Inventory status, stock status

[former_member299938]

buenos dias, yo tambien tengo ese mismo detalle, me apaceren ciertos articulos con valor negativo en la columna de COMPROMETIDO, revise si existian ordenes de ventas y no hay ninguna. Que puedo hacer?