web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Calculate remaining am...

Microsoft Dynamics NAV (Archived)

Calculate remaining amount with SQL

(0) Share

Report

Report

Posted on by ghada

480

Hi,

would u please tell me how can I calculate the remaining amount of each vendor ledger entry with SQL

thnks,

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

hi,

look at this site (MS Dynamics NAV Forum), many posts & comments about sql query.

sl-dynamics.blogspot.it/.../creating-sql-server-views-to-show.html

another post here:

NAV SQL Query

dynamicsuser.net/.../169062.aspx

Was this reply helpful? Yes No
ghada 480 on at

Like (0)

Report

I used this query to calculate the remaining amount but I get values different from the remaining amount in the report Vendor detail trial balance.

Can anyone explain me why? is there a missing codition?

thks

Was this reply helpful? Yes No
ghada 480 on at

Like (0)

Report

I use Navision 2009R2

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

hi,

have a look at community.dynamics.com/.../139721.aspx

same question ...

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans