This is not a question but a tip for those of you who are going to NAV 5 SP1 or NAV 2009…
In previous versions of NAV the posting date of a posted sales or purchases document was only availabe in the header table and not in the lines. E.g. the posting date of a sales invoice could only be found in Table 112 - Sales Invoice Header and not in Table 113 - Sales Invoice Line.
Well, in NAV 5 SP1 and NAV 2009 the posting date is also available in the lines tables. :D That's pretty nice isn't… no more linking to the header table if you want to list the invoiced items from a certain period of time.
Tables that contain the Posting date (I list both the Header and the Line table so that you may see which documents / tables are related:
ID Name
110 Sales Shipment Header
111 Sales Shipment Line
112 Sales Invoice Header
113 Sales Invoice Line
114 Sales Cr.Memo Header
115 Sales Cr.Memo Line
120 Purch. Rcpt. Header
121 Purch. Rcpt. Line
122 Purch. Inv. Header
123 Purch. Inv. Line
124 Purch. Cr. Memo Hdr.
125 Purch. Cr. Memo Line
0 comments
Please sign in to leave a comment.