NAV5.0 - SQL Server - SIFT

shibily

Hi All,
I am trying to write a Stored procedure where i need to access the Cust.ledger entry table. Here i want to take the Amount field , but it is not accessible here beacuse it is a Sum index field. Is there any method to take the values of the Amount field through SQL query?

Thanks in advance
Shibily

kapamarou

Use the SQL View.

shibily

kapamarou wrote:

Use the SQL View.

Hi,
I tried with the SQL View DBNAME$Cust_ Ledger Entry$VSIFT$1 . However i could not find the amount field here. I got only a few other fields.

Thanks,
Shibily

kapamarou

That's because the amount field is itself a flowfield. You will find it in the Detailed Customer Ledger Entry SQL View...

shibily

kapamarou wrote:

That's because the amount field is itself a flowfield. You will find it in the Detailed Customer Ledger Entry SQL View...

Thank you kapamarou

kapamarou