Create View in NAV SQL

(0) Share

Report

Posted on by Samer Baskhayroun

467

Can i create view in NAV SQL ? or it is not allowed

I will create view like this

SELECT "Customer No_","Initial Entry Due Date","Posting Date",
COUNT_BIG(*) "$Cnt", SUM("Amount") "SUM$Amount",
SUM("Amount (LCY)") "SUM$Amount (LCY)"
FROM [CRONUS International Ltd_$Detailed Cust_ Ledg_ Entry]
GROUP BY "Customer No_", "Initial Entry Due Date",
"Posting Date"

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

RE: Create View in NAV SQL

Yes, you can.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Create View in NAV SQL

You can create the views