Share
ReportDear Experts
Can u help me by providing good links on Tutorials on making reports in Microsoft Dynamics Nav?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Dear Experts
Can u help me by providing good links on Tutorials on making reports in Microsoft Dynamics Nav?
*This post is locked for comments
Hello
Please find the output of the report
In this 3 field we need to add Customer filter . For example we need Customer wise (October Schedule, Balance Schedule and Despatched Quantity)
Customer Filter
No. Customer Part No. Description UOM October Schedule Balance Schedule Despatched Quantity Current Stock at Store In Transit Qty Must Be Despatch From - JSR/LKW
ALAB8341001-H B8341001 AIR BRAKE NOS 30 15 15 0 0 -15
ALAB8341001-HN B8341001 AIR BRAKE NOS 35 35 0 10 0 -25
ALABB0F05414-H B0F05414 B0F05414-SA OF MODULAR HOSE NOS 1 0 1 0 0 0
ALABB0F10003-H B0F10003 AIR PIPING KIT NOS 1 0 1 0 0 0
ALABB0F15803-HN B0F15803 B0F15803-SA OF HOSES LOOSE KIT NOS 75 55 20 0 0 -55
ALABB0F19101-HN B0F19101 B0F19101 NOS 150 0 150 0 0 0
ALABB0F27806-H B0F27806 MODULAR HOSE NOS 84 50 34 0 0 -50
ALABB0F27806-HN B0F27806 MODULAR HOSE NOS 55 55 0 21 50 16
ALABB0F31922-HN B0F31922 MODULAR HOSE NOS 195 75 120 0 40 -35
ALABB0F34701-H B0F34701 SA OF MODULAR HOSE KIT NOS 26 12 14 0 0 -12
ALABB0F34701-HN B0F34701 SA OF MODULAR HOSE KIT NOS 12 6 6 25 0 19
ALABB8334302-H B8334302 B8334302-MODULAR HOSE ASSEMBLY NOS 6 0 6 0 0 0
Hi Mpapreja,
Below links are very good:
Hello MAM,
Could you please help me out in Inventory Availability report. I want to filter the report customer wise .
The Customer filter should reflect on Monthly Schedule,Sale Quantity, Gross Requirement.
I am Sending you the following code please see if you can provide any solution to this
if you wants more details please ask.
-----------------CODE----------------------------------------------------------------------------------
OnInitReport()
OnPreReport()
ItemFilter := Item.GETFILTERS;
PeriodText := Item.GETFILTER("Date Filter");
OnPostReport()
Item - OnPreDataItem()
GetCurrentKey := CURRENTKEY;
Item - OnAfterGetRecord()
IF NOT UseStockkeepingUnit THEN BEGIN
IF "Reordering Policy" IN ["Reordering Policy"::Order,"Reordering Policy"::"Lot-for-Lot"] THEN
"Reorder Point" := 0;
CalcNeed(Item,GETFILTER("Location Filter"),GETFILTER("Variant Filter"),"Reorder Point");
END;
Item - OnPostDataItem()
Stockkeeping Unit - OnPreDataItem()
IF NOT UseStockkeepingUnit THEN
CurrReport.BREAK;
SKUPrintLoop := 0;
Stockkeeping Unit - OnAfterGetRecord()
SKUPrintLoop := SKUPrintLoop + 1;
IF "Reordering Policy" IN ["Reordering Policy"::Order,"Reordering Policy"::"Lot-for-Lot"] THEN
"Reorder Point" := 0;
CalcNeed(Item,"Location Code","Variant Code","Reorder Point");
Stockkeeping Unit - OnPostDataItem()
CalcNeed(Item : Record Item;LocationFilter : Text[250];VariantFilter : Text[250];ReorderPoint : Decimal)
WITH Item DO BEGIN
SETFILTER("Location Filter",LocationFilter);
SETFILTER("Variant Filter",VariantFilter);
SETRANGE("Date Filter",0D,WORKDATE);
CALCFIELDS(
"Qty. on Purch. Order",
"Qty. on Sales Order",
"Planning Receipt (Qty.)",
"Scheduled Receipt (Qty.)",
"Planned Order Receipt (Qty.)",
"Purch. Req. Receipt (Qty.)",
"Qty. in Transit",
"Trans. Ord. Receipt (Qty.)",
"Reserved Qty. on Inventory");
BackOrderQty :=
"Qty. on Purch. Order" + "Scheduled Receipt (Qty.)" + "Planned Order Receipt (Qty.)" +
"Qty. in Transit" + "Trans. Ord. Receipt (Qty.)" +
"Planning Receipt (Qty.)" + "Purch. Req. Receipt (Qty.)" + "Qty. on Sales Order";
WITH Item DO BEGIN
IF Item.GETFILTER("Date Filter") <> '' THEN
SETFILTER("Date Filter",PeriodText);
IF Item.GETFILTER("Location Filter") <> '' THEN
SETFILTER("Location Filter",Item.GETFILTER("Location Filter"));
//SETRANGE("Date Filter",0D,31129999D);
GrossRequirement :=
AvailToPromise.CalcGrossRequirement(Item) +
AvailToPromise.CalcOutboundReservations(Item);
ScheduledReceipt :=
AvailToPromise.CalcScheduledReceipt(Item) +
AvailToPromise.CalcInboundReservations(Item);
END;
CALCFIELDS(
Inventory,
"Planning Receipt (Qty.)",
"Planned Order Receipt (Qty.)",
"Purch. Req. Receipt (Qty.)");
ScheduledReceipt := ScheduledReceipt - "Planned Order Receipt (Qty.)";
PlannedOrderReceipt :=
"Planning Receipt (Qty.)" +
"Planned Order Receipt (Qty.)" +
"Purch. Req. Receipt (Qty.)";
//Sale Quantity//
WITH Item DO BEGIN
IF Item.GETFILTER("Date Filter") <> '' THEN
SETFILTER("Date Filter",PeriodText);
IF Item.GETFILTER("Location Filter") <> '' THEN
SETFILTER("Location Filter",Item.GETFILTER("Location Filter"));
CALCFIELDS("Sales (Qty.)");
END;
SaleQuantity := "Sales (Qty.)";
//Sale Quantity End//
ProjAvailBalance :=
Inventory +
PlannedOrderReceipt +
ScheduledReceipt -
GrossRequirement;
// Inventory
CurrentStock :=
Inventory;
//MonthlySchedule
MonthlySchedule := SaleQuantity + GrossRequirement;
Month := CALCDATE('CM');
InvtReorder := ProjAvailBalance < ReorderPoint;
END;
InitializeRequest(NewUseStockkeepingUnit : Boolean)
UseStockkeepingUnit := NewUseStockkeepingUnit;
Hi,
You can learn from Dynamics Learning portal, under the course
81067AE: Development Environment Introduction in Microsoft Dynamics NAV 2017 and Dynamics 365 - Module 8
or refer
msdn.microsoft.com/.../dd355370(v=nav.90).aspx
Hi,
You can refer the How Do I? video series on Microsoft PartnerSource and also check the below msdn link for the written steps on developing reports:
https://msdn.microsoft.com/en-us/library/dd338686(v=nav.90).aspx
Also you can check some of my blog links:
If you're a Microsoft Partner or a NAV Customer current on your enhancement plan, you can find report writing and other e-Learning resources at no extra cost from Microsoft PartnerSource (mbs.microsoft.com/PartnerSource) or Microsoft CustomerSource (mbs.microsoft.com/CustomerSource).
I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
