After Invoice Post / Actual Invoice posting date

I found my answer. There is a table called GLJrnDtl that has the posted date
I'm new to writing BPM's and I hope some one can help me out or maybe enlighten me on what I might be missing.

I have a BAQ that I need to modify that looks at all the invoices for a invoice date range and then calculates the sales data and produces a report. Currently its done on monthly but we would like to run it daily. The problem is that invoice date can be backdated, which is OK, except BAQ looks at the invoice date as part of its search criteria and if the invoice is back dated to yesterday and posted today,when we search for all invoices posted today this invoice will not appear in the results. We would like to do a search on the actual date that the invoice was posted. 

First is there a actual posting date?  In another table? There is a "changed by date" in the InvcHead table but this can be changed after the invoice has been posted by another process like closing a job that is related to the invoice.

I have created a BPM that looks at the InvcHead table Update and will copy "today's" date to a ud field, but it doe not work when "Get Shipments" is used. I have tried running it Pre and Post. The code that I have been using is:

for each ttinvcHead where ttinvcHead.rowmod = 'A' or ttinvcHead.rowmod = 'U'.

assign ttinvcHead.Character01 = DCD-USERID.
assign ttinvcHead.Date01 = today.
assign ttinvcHead.Character02 = string(time, "HH:MM:SS").

end.
 
Any help will be greatly appreciated.

Dave


We are on Vantage 8.03.409c