Determining Post Date for A/R Invoice Vantage 8.03.403D

No problem I will send it directly to the email account listed here unless you want me to send to another one

--- On Wed, 7/29/09, halm180 <Mis@...> wrote:


From: halm180 <Mis@...>
Subject: [Vantage] Re: Determining Post Date for A/R Invoice Vantage 8.03.403D
To: vantage@yahoogroups.com
Date: Wednesday, July 29, 2009, 2:40 PM


Â



--- In vantage@yahoogroups .com, Mark Wagner <mjfw2003@.. .> wrote:
>
> Peter, I have done it in 904.504 but the tables really havent changed that much. I wont be able to get it to you until tomorrow but I can send you the BAQ if you like
>

Mark:
That would be much appreciated! Thank you.

Peter
Mis@...



















[Non-text portions of this message have been removed]
I am trying to create a BAQ Report that will show invoicing activity by Post Date, however, it is giving me fits. The only place that I can find the Post Date associated with an invoice is in the GLJrnDtl Table. Joining InvcHead to GLJrnDtl yields multiple records as GLJrnDtl seems to have booking records for each invoice line. Has anyone had any success in getting the Post Date for an A/R Invoice? Or does anyone have any other suggestions? Thank you for any and all feedback!

Sincerely,
Peter Dunbar
Halm Industries Co., Inc.
Peter, I have done it in 904.504 but the tables really havent changed that much. I wont be able to get it to you until tomorrow but I can send you the BAQ if you like

--- On Wed, 7/29/09, halm180 <Mis@...> wrote:


From: halm180 <Mis@...>
Subject: [Vantage] Determining Post Date for A/R Invoice Vantage 8.03.403D
To: vantage@yahoogroups.com
Date: Wednesday, July 29, 2009, 2:01 PM


Â



I am trying to create a BAQ Report that will show invoicing activity by Post Date, however, it is giving me fits. The only place that I can find the Post Date associated with an invoice is in the GLJrnDtl Table. Joining InvcHead to GLJrnDtl yields multiple records as GLJrnDtl seems to have booking records for each invoice line. Has anyone had any success in getting the Post Date for an A/R Invoice? Or does anyone have any other suggestions? Thank you for any and all feedback!

Sincerely,
Peter Dunbar
Halm Industries Co., Inc.



















[Non-text portions of this message have been removed]
--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> Peter, I have done it in 904.504 but the tables really havent changed that much. I wont be able to get it to you until tomorrow but I can send you the BAQ if you like
>

Mark:
That would be much appreciated! Thank you.

Peter
Mis@...