Report 299 + 499
Tintin25
Member Posts: 14
Hi all
Been searching around for a solution but can't seem to find one, and others have mentioned the same problem about report 299+499.
I'm using Nav 5.00 SP1 and a clean CRONUS db and have done the following:
Created 2 new Purchase Orders with the same vendor, each with 2 purchase lines and received the items (using both a simpel location and a WMS location)
Now I created a new Purchase Invoice with the above vendor and used the Get Receipt Lines under Function to do a "mass" invoice".
For now everything is fine but now I have 2 Purchase Orders which are fully received and invoiced so I run report 499 but nothing is happing - said in another way it dosn't delete the 2 Purchase Orders..???
Been searching around for a solution but can't seem to find one, and others have mentioned the same problem about report 299+499.
I'm using Nav 5.00 SP1 and a clean CRONUS db and have done the following:
Created 2 new Purchase Orders with the same vendor, each with 2 purchase lines and received the items (using both a simpel location and a WMS location)
Now I created a new Purchase Invoice with the above vendor and used the Get Receipt Lines under Function to do a "mass" invoice".
For now everything is fine but now I have 2 Purchase Orders which are fully received and invoiced so I run report 499 but nothing is happing - said in another way it dosn't delete the 2 Purchase Orders..???
0
Answers
-
Actiavate Debuger and find the reason :-k0
-
I seem to remember there's a bug in the standard NAV Report 499...
There's a piece of code in it that looks like this :PurchLine.CALCFIELDS("Qty. Assigned"); IF ((PurchLine."Qty. Assigned" = PurchLine."Quantity Invoiced") OR (PurchLine.Type <> PurchLine.Type::"Charge (Item)")) AND (PurchLine."Qty. Assigned" <> 0)Which should be changed toPurchLine.CALCFIELDS("Qty. Assigned"); IF (PurchLine."Qty. Assigned" = PurchLine."Quantity Invoiced") OR (PurchLine.Type <> PurchLine.Type::"Charge (Item)")0 -
MBerger wrote:I seem to remember there's a bug in the standard NAV Report 499...
There's a piece of code in it that looks like this :PurchLine.CALCFIELDS("Qty. Assigned"); IF ((PurchLine."Qty. Assigned" = PurchLine."Quantity Invoiced") OR (PurchLine.Type <> PurchLine.Type::"Charge (Item)")) AND (PurchLine."Qty. Assigned" <> 0)Which should be changed toPurchLine.CALCFIELDS("Qty. Assigned"); IF (PurchLine."Qty. Assigned" = PurchLine."Quantity Invoiced") OR (PurchLine.Type <> PurchLine.Type::"Charge (Item)")
Thx MBerger! works fine.
It strange if you go througt the old version af Nav. you can see that the same bug appear...0
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
