​Completed quantity is not updated in production order

[haseebbaig]

Completed quantity is not updated in production order after completed receipt from production in SAP Business One

[former_member698304]

Hi

I having the same issue

how you solve this?

[ANKIT_CHAUHAN]

Dear haseebbaig,

If your database is affected by this issue and the queries return results, please log a support incident with the component SBO-PP-PRO and provide a step-by-step scenario to help us reproduce the issue causing this data corruption.

Mention in the incident that the above mentioned query from the SAP Note 2674046 returns the result. You will get the database fix then.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[ANKIT_CHAUHAN]

Dear haseebbaig,

Kindly refer to the SAP Note 2674046 in this regards.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[haseebbaig]

Thanks, Ankit for your help, but I have no S-User id for reading this note if you answer here that's helpful for me.

[ANKIT_CHAUHAN]

Dear haseebbaig,

Does the following query return the result for you?

/* For SQL and HANA, Incorrect completed qty for product in Production Order */

Select w."DocEntry", w."DocNum", w."CmpltQty", sum(i."Quantity") IGN_Qty, sum(i."InvQty") IGN_InvQty
from OWOR w inner join IGN1 i on i."BaseType" = 202 and i."BaseEntry" = w."DocEntry" and w."ItemCode" = i."ItemCode" and i."TranType" = 'C'
where w."Type" in ('S', 'P')
group by w."DocEntry", w."DocNum", w."CmpltQty"
having sum(i."Quantity") <> w."CmpltQty" Order by w."DocEntry";

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[haseebbaig]

Thanks, ankit.chauhan1 that query results is accurate. But I want solution how to resolve this issue.