Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I 'm a beginner in navision and I need to calculate the remaining amount wich appears in the report Vendor detail trial balance with sql .
Can anyone help me please :(, thanks in advance
Are you creating this report from SQL (outside the NAV) ? (In NAV report, this is directly come from vendor ledger entry table)
If yes then, Remaining amount of Vendor ledger entry is flowfield and it comes from "Detailed Vendor Ledg. Entry" table. so you need to make table join between vendor ledger entry and Detailed Vendor Ledg. Entry table with Entry no.
If you want to pass the date filter in report then it also require to join the from and to date to the Detailed Vendor Ledg. Entry table and get the sum of the "Amount (LCY)" field and can put it on your report.
try the following sql statement:
SELECT v.[Posting Date],v.[Document Type],v.[Document No_],v.Description,v.[Currency Code],sum(d.[Amount]) as RemainingAmount
FROM [CRONUS AG$Vendor Ledger Entry] v
[CRONUS AG$Detailed Vendor Ledg_ Entry] d
on d.[Vendor Ledger Entry No_] = v.[Entry No_]
-- and d.[Posting Date] = DateFilter
where v.[Vendor No_] = '01254796' -- replace by your Vendor No.
group by v.[Posting Date],v.[Document Type],v.[Document No_],v.Description,v.[Currency Code]
Business Applications communities