Hi,
Check detect query in attachment to SAP Note 933476.
KR,
Jitin
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
Add a comment