Approval Query for Receipt from production

[Former Member]

Hi experts,

I want to define an approval process for receipt from production.

The condition is below:

Only if it is " Receipt from production" then the goods receipt document should go to approval of quality.

If is any unplanned direct goods receipt then system should allow to add it straightly.

To do so, Please provide me the required query.

regards

Ravindran Srinivasan

[Former Member]

Hi Ravindran,

I once encounter same problem like this. And I found out that, unfortunately, approval procedure can't work on receipt from production document.

Yes, we all know that receipt from production and inventory goods receipt are actually same object type in SAP B1 and stored in same table. But, try it by yourself in your testing database, even if you apply the approval templates for goods receipt document, and you apply the condition as "always", you won't get prompted for approval if you try to add the receipt from production document.

However, I said this based on my experience with version prior to 8.81 and 8.82. But somehow I have a strong feeling that this issue still not yet realized by SAP.

Best Regards,

Hendry Wijaya

[Former Member]

Hi Ravindran,

You may try:

SELECT Distinct 'true'

FROM OIGN T0

WHERE T0.JrnlMemo LIKE 'Receipt%' AND T0.DocNum=$[OIGN.Docnum.number\]

[Former Member]

Dear Gordon,

Thanks for your reply.

While executing the query, system showing the following error message

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'OIGN.Docnum.number'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Service Contracts' (OCTR) (s) could not be prepared.

Do we have to skip the error message or do we have to rectify this ?

Kindly clarify us

Regards,

Ravindran Srinivasan

[Former Member]

Hi Ravindran.......

You can nt set approval for Receipt from Production Form.

But you can set the same for Goods Receipt which is altogether different from Receipt From Production.......

Regards,

Rahul