BAQ: Where is the posted date of an invoice?

Yahoo Archive
1

Umh – you might have to go to the GLJrnDtl table.  Â

 

I could not find a posted date or system date on the Invoice Head or Detail.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of amyelainecarlson@...
Sent: Monday, February 17, 2014 7:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: BAQ: Where is the posted date of an invoice?

 

 

I am looking for the actual date that they invoice was posted, as the date the person went to Invoice > Post Invoice.

 

I know Invoice date and apply date can be changed.

 

Where is the system date? On the Invoice Head?

 

Appreciate all the help!

 

Amy

2
Hello,



I keep forgetting where to find the posted date of an invoice.



For us, there is a delay between when the invoice is created in AR
Invoice Entry and when we actually post the AR group, so invoice date
does not match the posted date.



I need to create a query that shows both the invoice date and the posted
date. What table has the posted date?



Thanks in advance.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
DId you ever figure this out?  I have the same problem trying to find a posted date for an invoice.
4

Apply date I think?



Sent from my Atari 600



-----Original Message-----

From: amyelainecarlson@… [amyelainecarlson@…]

Received: Monday, 17 Feb 2014, 7:10

To: vantage@yahoogroups.com [vantage@yahoogroups.com]

Subject: [Vantage] RE: BAQ: Where is the posted date of an invoice?



 

DId you ever figure this out?  I have the same problem trying to find a posted date for an invoice.

5

Apply Date can be changed as to what period you want it to go into.  I don't think that is it. 


6

The apply date is the date the invoice will post to….are you guys looking for the date it was actually posted?  If so then that should be the system date.

 

If you are on version 9.05…

 

Manasa

 

 

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of amyelainecarlson@...
Sent: Monday, February 17, 2014 7:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: BAQ: Where is the posted date of an invoice?

 

 

Apply Date can be changed as to what period you want it to go into.  I don't think that is it. 

 

7

When you create the group -Â the group has an invoice date which defaults to the Invoice.

 

The InvcHead has a field named InvoiceDate which can be different from the system date.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Monday, February 17, 2014 7:01 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RE: BAQ: Where is the posted date of an invoice?

 

 

The apply date is the date the invoice will post to….are you guys looking for the date it was actually posted?  If so then that should be the system date.

 

If you are on version 9.05…

 

Manasa

 

 

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of amyelainecarlson@...
Sent: Monday, February 17, 2014 7:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: BAQ: Where is the posted date of an invoice?

 

 

Apply Date can be changed as to what period you want it to go into.  I don't think that is it. 

 

8

I am looking for the actual date that they invoice was posted, as the date the person went to Invoice > Post Invoice.


I know Invoice date and apply date can be changed.


Where is the system date? On the Invoice Head?


Appreciate all the help!


Amy