0

Retrieve Sum Qty

Jet Reports Historic Posts

June 07, 2016 03:39

None

Follow

Hi there,

Is it possible in Jet Express to retrieve sum qty from "Item Ledger Entry" table for certain item?
Column A = Item No. (User manually input Item No.)
Column B = Sum "Quantity" from "Item Ledger Entry" table (Using Jet Report Function)

Thanks,
Olwin

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts June 07, 2016 19:32

  Hello Olwin,
  
  Open the Table Builder.
  Add the Item table.
  Add the No. field from the "Fields" section and the "Quantity on Hand" from the "Flow Fields" section.
  Click on the Item table under the "Tables" section.
  Click "Add Filter".
  Where > No. > Equals > * > User Defined (checked).
  Finalize the report.
  When the end user refreshes the workbook a Report Options dialogue box will appear where they can enter the Item No(s). that they wish to filter on.
  
  Best regards,
  MWilson

• 0
  
  Jet Reports Historic Posts June 08, 2016 05:02

  Hi MWilson,
  
  Thanks for your response.
  But what I really need to sum is only ILE with certain criteria (Posting Date, Entry Type, etc), rather than sum all the ILE Quantity.
  
  Best Regards,
  Olwin

• 0
  
  Jet Reports Historic Posts June 08, 2016 16:27

  Hello Olwin,
  
  The only way that I am aware of how to do this is to write your report from the Item Ledger Entry table and bring back both Item No. and Quantity fields.
  In the filters section add Item No., Entry Type, and Posting Date.
  You will receive separate lines for each record but if you filter down either with the Jet Report Options or the Excel table filter you can use the 'Total' row to see the totals for each Item No. that you filter on.
  Beyond that, what you are looking to do would be accomplished with Jet Essentials, not Jet Express.
  
  Best regards,
  MWilson