I am writing a query that shows some Contract information and also the Invoice Posting Date. The Contract Transactions table contains the Pre-Assigned Invoice Number and the Posting Date so I would think that I could use the Posting Date from the Contract Transactions. However, I’ve found a difference whereby the Posting Date on the Invoice Header is prior to the Posting Date as on the Contract Transactions. For example:
On the Contract Transaction…
|Contract||Preassigned inv||Posting Date|
And on the Sales Invoice…
|Sales Inv||Preassigned inv||Posting Date|
I really dont understand how this can be, unless of course the Posting Date field on the Contract Transaction is nothing to do with the Posting Date of the Invoice. Any feedback gratefully appreciated!
Thanks in advance