I have found posts where people have pulled notes from the Sales Header table, but what does the Record ID look like for pulling from the Sales Invoice Header? I know for notes on the vendor card it is "Vendor: ######", so does the Record ID always reference the table. When does it have to reference the document type, like with the Sales Header?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi -
Sorry, but I don't think I quite understand the question.
I see from the report you attached that you are using an NL("Table") function to draw data form the "Cust. Ledger Entry", "Customer", "Detailed Cust. Ledg. Entry", and "Sales Invoice Header" tables.
What exactly do you mean by "Record ID"?
What is it that you are attempting to do? -
Jet Reports Historic Posts Hello
If I understand you correctly you try to pull out from the "Record Link" table the blob notes in field "Note" using the NL"BinaryText" function and you try to figure out how the Record ID looks like.
I normally either access the table or use the Jet Browser to see sample data from my database.
I use NAV 2013, in the "Record Link" table for the field "Record ID" I find that my notes and links for the posted Sales Invoices have the following layout: Sales Invoice Header: xxxx
For draft sales invoices (which is again the Sales Header table) the layout is like follows: Sales Header: Invoice,xxxx
Hope that helps.
Kind regards
Andrea
Please sign in to leave a comment.