Failed to find DocNum

[mario_galeano]

When looking for a DocNum related to the "goods receipt" document, it does not appear in SAP, but in the corresponding table (OIGN) as well as its detail (IGN1)

[jitin_chawla]

Hi,

Check detect query in attachment to SAP Note 933476.

KR,

Jitin

[PierreBrothier]

Hi,

when you browse through the form, is the document displayed correctly ?

To see the search query done by B1 client, you could activate detailed log through help -> Support Desk -> Options logger

the log file is located under ProgramData\SAP\SAP Business One\Log\SAP Business One\<user>\BusinessOne

in the client.b1logger.xxxx, you will find the query. That could help a lot

this is the query that does the search

if the lines are based on type 202, the search returns nothing

SELECT COUNT(*)  FROM  "database"."OIGN" T0  WHERE T0."DocNum" = (10 )  
AND   NOT EXISTS (SELECT U0."DocEntry" FROM  "database"."IGN1" U0  
WHERE T0."DocEntry" = U0."DocEntry"  AND  U0."BaseType" = (202 )  ) 

202 is type production order. So, you should look into the production menu ->stock entry

[mario_galeano]

Hi pierre.brothier

By following the steps mentioned, check the path of the execution log of SAP Business One, where it does not show me the executed sql query and execute the query (I attach images), what could be another alternative to see why it is not finding the document?

[PierreBrothier]

Hi Mario,

you must choose a detailed log level

I have reproduced the case.

The goods receipt form exclude goods that are issued by production order.

You could retrieve it in production -> receipt from production

The two windows :