Report 299 + 499

Tintin25
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..???

Answers

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
  • MBerger
    MBerger Member Posts: 413
    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 to
    PurchLine.CALCFIELDS("Qty. Assigned");
    IF (PurchLine."Qty. Assigned" = PurchLine."Quantity Invoiced") OR
       (PurchLine.Type <> PurchLine.Type::"Charge (Item)")
    
  • Tintin25
    Tintin25 Member Posts: 14
    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 to
    PurchLine.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...