Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Can anyone help me out I want to convert this Navision code to SQL
I want to create Customer receivable report.
CASE AgingBy OF
AgingBy::"Due Date":
PeriodIndex := GetPeriodIndex(CustLedgEntryEndingDate."Due Date");
AgingBy::"Posting Date":
PeriodIndex := GetPeriodIndex(CustLedgEntryEndingDate."Posting Date");
AgingBy::"Document Date":
BEGIN
IF CustLedgEntryEndingDate."Document Date" > EndingDate THEN BEGIN
CustLedgEntryEndingDate."Remaining Amount" := 0;
CustLedgEntryEndingDate."Remaining Amt. (LCY)" := 0;
CustLedgEntryEndingDate."Document Date" := CustLedgEntryEndingDate."Posting Date";
END;
PeriodIndex := GetPeriodIndex(CustLedgEntryEndingDate."Document Date");
END;
END;
Or
How to connect Navision front end to qlikview ?
Hi Vijay,
Paste following before your SQL statement in qlikview edit script.
tablename:
LOAD
* ;
SQL
Select