Experts,
I have created a project with 2 stages. Later we created an AR Down Payment invoice using the project code on row level and assigned this DP invoice to the stage.
However on the Stage window the amount of invoice does not appear.
Is t...
Hello Experts
SAP Hana provides very good Customer 360 advanced dashboard. We want to allow sales employee to use this report.
However each sales employee should view only his customer's dashboard, in current report the filter allows to select an...
Hello Krishna,You have to mention a separate GL in Revenue Clearing Account for under Admin--> Setup --> Financial --> Fixed Asset --> Account Determination so entry will be as follows after creation of 1. AR InvoiceCustomer A/c DrRevenue Clearing A/...
Hello Jose,I use below Query in Hana db to extract invoice payment date. Check if this helpsSELECT 'AR Invoice' as "TYPE",T1."DocNum" AS "Recpt No.",T1."CardName" AS "Customer Name", T3."DocNum" AS "Inv. No.",T3."DocDate" AS "Inv Date", T3."DocDueDa...
Hello Dect,This query needs to be rewritten as few things I noticed are different in Hana, like variable declared and syntax for difference between days is DAYS_BETWEEN(T1."CreateDate", NOW()) = 1.I suggest you create a basic query in Hana and built...