Code convert to SQL

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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;

How to connect Navision front end to qlikview ?

Re: Code convert to SQL

adamdavi3s — Thu, 01 Dec 2016 10:20:21 GMT

Anonymous — Thu, 01 Dec 2016 10:20:58 GMT

Hi Vijay,

Paste following before your SQL statement in qlikview edit script.

tablename:

LOAD

* ;

SQL

Select