Hi,
Just want to ask what would be the SQL code for the query showing the list of Purchase Order number and what is the corresponding delivery receipt number per vendor per item.
We are using SAP Business One 9.1
Thanks.
Hi Zal,Thanks for your response.This is the actual table that I need. The headers in blue is the above table and the green is the below table in SAP.Really appreciate the help as this will ease my reporting.Raymond
Thanks Zal. I thought there's a connection between the two separate modules.How about this one (apologies for having too many questions):How can I create a query combining the above and below table? Thanks again. Raymond
Hi Zal,Tried the code and there was an error.It says: "An expression of non-boolean type specified in a context where a condition is expected, near 'FOR' ".Please advise.Thanks.
Hi Zal,Thanks for your response.Will try this one. Also, since on your sample it indicates GRPO, can i change it to Delivery Note/Delivery Receipt Number?Thanks again.
