Report 299 + 499

Tintin25Tintin25 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_cse06mohana_cse06 Member Posts: 5,504
  • MBergerMBerger 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)")
    
  • Tintin25Tintin25 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...
Sign In or Register to comment.