0

Extract Data from NAV and insert into Comment

Jet Reports Historic Posts

May 18, 2012 09:48

None

Follow

Hi there,

Is there a way to instruct Jet to insert comments into a cell? i.e. I am going to pick up many dates for an item and within each of the dates (in the cell), there needs to be a comment which comes from the comments table.

e.g.

Item PO Number PO ETD Date PO ETA UK Date PO Expected Receipt Date
A PORD0001 01/06/2012 01/07/2012 07/07/2012

In the PO ETD Date, there could be a comment stating that the ETD was delayed due to factor A etc and The ETA UK Date could have a comment that it was delayed due to harsh weather etc and the Expected Receipt Date could have a comment that it was delayed due to clearance or customs etc. There can be multiple comment lines for each field as well.

If you need any more information, please let me know and thanks for the help.

michaellee

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts May 18, 2012 13:22

  There is a Table called "Sales Comment Line". The "No." field has invoice numbers or order numbers.
  
  You should be able to link to them and display the comments by invoice number in a table or report. Go for it!
  
  HTH! -John

• 0
  
  Jet Reports Historic Posts May 18, 2012 14:33

  Hi John,
  
  Thanks so much for the reply but I think that I may have not made clear the issue.
  
  I am quite confident that I will be able to link the comment table with the PO and have these displayed as a line on the excel sheet but the requirement is to have these comments placed into the "Comments" of an excel sheet.
  
  i.e. on the example I provided, if the Cell reference for the PO ETD Date was D5, the manual solution would be to right-click on the cell and select Insert Comment. The Comment Box will pop up for that Cell and the Comments pasted into the Comments box. I hope that I have made it clearer.

• 0
  
  Jet Reports Historic Posts May 18, 2012 17:16

  Hi Michael,
  
  There is currently no way to have Jet Reports insert results into the comment of an Excel cell. This could be submitted as a feature request, but it isn't currently possible.
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts May 21, 2012 15:24

  Michael,
  
  Now I understand, and Hughe seems to have gotten here before me.
  
  A work around might be to use a Pivot table to summarize all "field" comments. Collapse all comments to the individual "field", and only expand the field to view it's comments as needed.
  
  
  John