0

Item and Item Ledger Entry Table Builder

Jeff Klinger

March 21, 2019 17:18

None

Follow

Hello,

New to Jet...

I used table builder to return all items in Inventory. I would like to add a field to the results using Item Ledger Entry to only return the last sales transaction date.

I am using Jet Professional 2019.

 

Thank you.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis March 21, 2019 17:31

  Hello Jeff -

  While extremely easy to do with a non-table report, the only NL(Table) solution that comes to mind would be to list ALL records from the ILE table and then use Excel's Pivot capabilities to whittle that down to just the data you want for your report.

  Edited by Harry Lewis March 21, 2019 17:31
• 0
  
  Jeff Klinger March 21, 2019 17:34

  Harry - I was thinking that. But the results coming back exceed Excel's range. I can easily limit the ILE results by doing just Document Type = Sales Invoice. Because that is what we are looking for in this case. When did the item last sell.

  My hope was that I could limit the rows returned in Table Builder by getting last posting date.

• 0
  
  Harry Lewis March 22, 2019 21:41

  Hello Jeff -

  Here's an example that lists records from a table where the Posting Date for the record has to match whatever the last posting date is for that particular item:

  =NL("Table","Item Ledger Entry",{"Entry No.","Item No.","Posting Date"},"+Item No.","*","Posting Date","=NL(""Last"",""Item Ledger Entry"",""Posting Date"",""Item No."",NF(,""Item No.""))")