Mass Reopen & Release PO

nverma
Member Posts: 396
One of our customers, want a batch report that will reopen and release all Purchase Order.
I created a batch report with the Purchase Header dataitem and wrote the following code in OnAfterGetRecord
However, now when I run the report, I get error messages such as: There is no Tax Area Line within filter OR There is nothing to release.
In these special cases, I want the system to skip the Purchase Order and move to the next rather than erroring out. How can I accomplish this.
I tried putting the above code in IF statement, but that didnt work. I tried using GETLASTERRORTEXT function along with CLEARLASTERROR, but I didnt have much success either.
I created a batch report with the Purchase Header dataitem and wrote the following code in OnAfterGetRecord
ReleasePurchDoc.PerformManualReopen("Purchase Header"); ReleasePurchDoc.PerformManualRelease("Purchase Header");
However, now when I run the report, I get error messages such as: There is no Tax Area Line within filter OR There is nothing to release.
In these special cases, I want the system to skip the Purchase Order and move to the next rather than erroring out. How can I accomplish this.
I tried putting the above code in IF statement, but that didnt work. I tried using GETLASTERRORTEXT function along with CLEARLASTERROR, but I didnt have much success either.
0
Answers
-
I resolved the issue, but putting in quite a few checks in order to avoid running into error for really old PO's.0
-
You could have created a new CU, putting in the actual Reopen and Release calls into the OnRun trigger. Call the CU with if CU.run from your report. In this case you can also use Getlasterrortext to display the error in the printout of the report.Frank Dickschat
FD Consulting0
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