Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
how to write coding for blocking purchase invoice booking date prior to GRN booking date
shwetha
Member Posts: 7
HI,
In Nav 201, I am facing a problem in purchase bill booking. Means one of my team member has done the posting of purchase invoice in May month & GRN posted in june month. Need to block the posting dates. Hence request you to kindly support cal code validation on date.
In Nav 201, I am facing a problem in purchase bill booking. Means one of my team member has done the posting of purchase invoice in May month & GRN posted in june month. Need to block the posting dates. Hence request you to kindly support cal code validation on date.
0
Best Answer
-
Options
TallyHo
Member Posts: 383
Add something like this to CU90 and add key "Order No.","Posting Date" to purch receipt hdr:
Presuming you're invoicing from a PO. If you use get receipts from a purchase invoice.
Code needs to be different, on another place.
OnRun(VAR Rec : Record "Purchase Header")
IF Invoice THEN BEGIN
PurchRcptHdr.SETCURRENTKEY("Order No.","Posting Date");
PurchRcptHdr.SETRANGE("Order No.","No.");
IF PurchRcptHdr.FINDLAST THEN
IF PurchRcptHdr."Posting Date" > "Posting Date" THEN
ERROR('Receipt %1 has been posted on %2',PurchRcptHdr."no.",PurchRcptHdr."Posting Date");
END;
This makes it impossible to post your purchase invoice from a PO at a date preceeding the GRN.
Note, fixing this for per line invoicing and receiving needs more advanced C/AL coding.
5
Answers
Presuming you're invoicing from a PO. If you use get receipts from a purchase invoice.
Code needs to be different, on another place.
OnRun(VAR Rec : Record "Purchase Header")
IF Invoice THEN BEGIN
PurchRcptHdr.SETCURRENTKEY("Order No.","Posting Date");
PurchRcptHdr.SETRANGE("Order No.","No.");
IF PurchRcptHdr.FINDLAST THEN
IF PurchRcptHdr."Posting Date" > "Posting Date" THEN
ERROR('Receipt %1 has been posted on %2',PurchRcptHdr."no.",PurchRcptHdr."Posting Date");
END;
This makes it impossible to post your purchase invoice from a PO at a date preceeding the GRN.
Note, fixing this for per line invoicing and receiving needs more advanced C/AL coding.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!