HI Experts! i want to get query for Document No(Yellow one) but i don't know which table is including Doc No anyone know where is it?

Hi experts! i want to make this query works but i tried many different ways but still it do not work! and error said like this maybe After "THEN" Should be Column from Table? case when T1."Account" =42001000 AND T1."ProfitCode"= 409080...

Hi experts i want this code work i don't know how to use "OR" Fuction CASE WHEN T1."LineTotal"=0 THEN 0 ELSE (-1)*T0."DiscSum" OR CASE WHEN T0."CANCELED"='C' THEN T0.'DiscSum" ELSE T0."DiscSum" END AS "Discount Amount"

Hi experts i just made some Query for AR invoice with line item and AR Credit memo with Line item but AR and AR credit has same Colmum Example Customer Name or Doc Total but i want to (example) T0."DocNum" and T2."DocNum" in single line like ...

HI all i have code for Some Monthly sales analysis Report. i seen this on Useful SAP Business One Queries: Comparing Monthly Sales Across Multiple Years - ASUG but some point reason this code is not working seems getdata is strange do yo...