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

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

keoma 32,727 on at

Like (0)

Report

RE: Calculate remaining amount with SQL

hi,

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

same question ...
ghada 480 on at

Like (0)

Report

RE: Calculate remaining amount with SQL

I use Navision 2009R2
ghada 480 on at

Like (0)

Report

RE: Calculate remaining amount with SQL

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
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: Calculate remaining amount with SQL

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

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans