0

Notes - Binary text

Kate Austin

January 29, 2019 10:39

None

Follow

Hi,

 

I am trying to get notes from the sales documents, but  when I am using the Binary text with the Link Record table, but I am not sure how to link it to Sales invoice Header.

Can you please help.

 

Thank you!

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis January 29, 2019 15:49

  Hi Kate -

  The trick is knowing how to format the filter on the Record ID field in the Record Link table.

  Here is the definition of the Record Link table:

  

  In my database, I occasionally have Notes in the Sales Header table.  These are stored as binary text in that Record Link table.

  Here is an example of how I might extract Sales Header records and get the corresponding Notes:

  

  (you should be able to right-click the image and open a larger version)

  In cell E5 is the No. field from my Sales Header.

  In cell J5 is the Document Type field from my Sales Header.

  K5 contains the name of the table, followed by a colon and space, then the Document Type, a comma and space, and then the No.

  for example: Sales Header: Order, S120619

  

  This forms the Record ID for my Record Link table.

  I copy that to column C (where I can use it in the functions on have on the next line of my report).

  In cell C6, I extract the Link ID that corresponds to however many Notes are tied to the record in my Sales Header

  In cell F6, I extract the Binary Text from the Note field based on the Link ID and Record ID

  I hope that helps get you pointed in the right direction.

  Edited by Harry Lewis January 29, 2019 17:40
• 0
  
  Harry Lewis January 29, 2019 17:39

  Kate -

  Here is another example (this one based on the Item table):