RDLC report producing different results than classic

MrBill1962
Member Posts: 28
Hi all. I've produced a small mod that displays 2 UOM for Qty (optionally) and Unit Price (always). In classic it works perfectly. However, I get strange results when it is produced in RTC. I've seen code before with ISSERVICETEIR so apparently the results can be different but I've never understood why. In any case, I call a function from the SalesLineTemp in a blanket order or the PurchaseLineTemp of a PO (base reports) but it doesn't produce correct results in classic. My code for the PO is below although similar code in all the reports I've changed fail to produce the correct result in RTC in all instances.
GetAltUOMQtyPrice(PurchLine : Record "Purchase Line")
WITH PurchLine DO BEGIN
CLEAR(MFQty);
CLEAR(MFPrice);
IF Type <> Type::Item THEN
EXIT;
MFUnitPriceHeader := 'Unit Price MSF/MLF';
ItemUOM.SETRANGE("Item No.","No.");
ItemUOM.SETFILTER(Code,'%1|%2',InventorySetup."MSF Item UOM Code",InventorySetup."MLF Item UOM Code");
IF ItemUOM.FINDSET(FALSE) THEN BEGIN
ItemUOM.TESTFIELD("Qty. per Unit of Measure");
MFQty := Quantity / ItemUOM."Qty. per Unit of Measure";
MFPrice := ROUND(AmountExclInvDisc / MFQty,0.00001);
END;
END;
GetAltUOMQtyPrice(PurchLine : Record "Purchase Line")
WITH PurchLine DO BEGIN
CLEAR(MFQty);
CLEAR(MFPrice);
IF Type <> Type::Item THEN
EXIT;
MFUnitPriceHeader := 'Unit Price MSF/MLF';
ItemUOM.SETRANGE("Item No.","No.");
ItemUOM.SETFILTER(Code,'%1|%2',InventorySetup."MSF Item UOM Code",InventorySetup."MLF Item UOM Code");
IF ItemUOM.FINDSET(FALSE) THEN BEGIN
ItemUOM.TESTFIELD("Qty. per Unit of Measure");
MFQty := Quantity / ItemUOM."Qty. per Unit of Measure";
MFPrice := ROUND(AmountExclInvDisc / MFQty,0.00001);
END;
END;
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions