I'm trying to Restrict the updating Receipt after payment on posted Purchase Order ..
If the Invoice is already paid or Partially paid For the Purchase order,again same PO should not allow to post to receive.for this requirement I wrote below code
IF PurchaseHeader.Receive THEN BEGIN
PurInvHdrRec.SETRANGE("Order No.", PurchaseHeader."No.");
IF PurInvHdrRec.FINDSET THEN BEGIN
LineAmt := 0;
RemAmt := 0;
REPEAT
;
LineAmt += PurInvHdrRec.Amount;
RemAmt += PurInvHdrRec."Remaining Amount";
UNTIL (PurInvHdrRec.NEXT = 0);
PurInvHdrRec."Buy-from Vendor Name", PurInvHdrRec."Posting Description");
IF LineAmt <> RemAmt THEN
ERROR('You cannot receive more Items in this Purchase Order');
END;
END;
now my issue is the amount and remaining amount showing 0 for brief clarification pls find the attachment .and kindly help me out
IF PurchaseHeader.Receive THEN BEGIN
PurInvHdrRec.SETRANGE("Order No.", PurchaseHeader."No.");
IF PurInvHdrRec.FINDSET THEN BEGIN
LineAmt := 0;
RemAmt := 0;
REPEAT
;
LineAmt += PurInvHdrRec.Amount;
RemAmt += PurInvHdrRec."Remaining Amount";
UNTIL (PurInvHdrRec.NEXT = 0);
PurInvHdrRec."Buy-from Vendor Name", PurInvHdrRec."Posting Description");
IF LineAmt <> RemAmt THEN
ERROR('You cannot receive more Items in this Purchase Order');
END;
END;
now my issue is the amount and remaining amount showing 0 for brief clarification pls find the attachment .and kindly help me out
0
Best Answer
-
Amount and Remaining Amount are flowfields. Use CALCFIELDS before you can use them.
PurInvHdrRec.CALCFIELDS(Amount, "Remaining Amount"); LineAmt += PurInvHdrRec.Amount; RemAmt += PurInvHdrRec."Remaining Amount";
Another way to calculate your sum amount is to use CALCSUM.5
Answers
-
Amount and Remaining Amount are flowfields. Use CALCFIELDS before you can use them.
PurInvHdrRec.CALCFIELDS(Amount, "Remaining Amount"); LineAmt += PurInvHdrRec.Amount; RemAmt += PurInvHdrRec."Remaining Amount";
Another way to calculate your sum amount is to use CALCSUM.5 -
Thank You So much.Nabil Ji0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

