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!
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!
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.
Kate -
Here is another example (this one based on the Item table):