0

Blank Date returned using NL(Last)

Matthew Perren

August 29, 2017 13:16

Answered

Follow

 I'm trying to produce a list of items that have been receipted 11 months ago or earlier. 

I'm using rows to get an item no. list and I am using the formula below to get the last posting date of the last purchase receipt so that I can pivot the report and filter out the more recently receipted items.

=NL("Last","Item Ledger Entry","Posting Date","+Posting Date",NP("DateFilter",Options!C8,Today),"Item No.",C5,"Document Type","Purchase Receipt")

The date filter key is

Options!C8 is our go live date 01/11/11

Today is =NP("Eval","=today()")

The problem I'm having is that the list is generally OK but some items are showing no posting date even though there are plenty of purchase receipts in the item ledger.

Any thoughts?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis August 31, 2017 16:57

  Hi Matthew.

  If you take one of the item numbers for which the last posting date is showing up blank, and create a basic report for just that item number... something like this:

  =NL("Rows","Item Ledger Entry",,"Item No.","insert-item-number-here")

  and then use NF() functions to return posting date and document type for each record returned...

  Do you see anything suspicious about the results?

• 0
  
  Matthew Perren November 06, 2017 10:06

  Hi Harry

  Thanks for this. I've found the problem. We frequently receive samples of products which we use on our trade show stand. The stand has a customer no. When we return from the show the stock is put back onto the inventory using a sales return order. As this isn't a purchase receipt no date is returned because the formula doesn't ask for it. 

  In short it was our internal procedure and not a Jet of NAV issue at all!

  Thanks for your help, though. I wouldn't have found the problem without it!

  Cheers

  Matthew