Topic Options
#63969 - 05/22/20 09:47 AM Payables link to GL Post date is incorrect
Jason Offline
Adagio Fan

Registered: 02/01/18
Posts: 35
Loc: Forest Grove, OR
THe GL Post date field in AP Transactions, is showing the Document Date rather than the GL Post date. Please look at attachment for clarification. If the GL is POSTED on 5/21. It should show that in AP under 'Ledger Posting'

Let me know if I can clarify anything further.
Thank you,
Jason


Attachments
AP-GL Wrong Post Date.jpg (104 downloads)


Top
#63971 - 05/22/20 12:14 PM Re: Payables link to GL Post date is incorrect [Re: Jason]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Jason,

The Payables field "Ledger Posting Date" is the fiscal date you want the transaction posted to in the general ledger (in the case where you want the transaction posted to a fiscal period different than the document date).

The "Posted date" in Ledger is the actual date the transaction was posted by the user. This is useful when auditing a set of transactions and trying to reconstruct a sequence of steps.

So - these dates will not likely be the same.
_________________________
Andrew Bates

Top
#64307 - 07/01/20 10:37 AM Re: Payables link to GL Post date is incorrect [Re: Retired_Guy]
Jason Offline
Adagio Fan

Registered: 02/01/18
Posts: 35
Loc: Forest Grove, OR
Andrew,

We are not operating like perhaps most of your clients.
We don't use AP Posted Transaction dates for our financial reporting. We manually choose the periods to post our batches. We are trying to find a way to see what actual date a transaction was posted. Currently the transaction date is being used as the invoice date, which then populates the other fields: last activity date and GL post date.

The question then is, how do we know the actual date the invoice was posted and by whom. Is there a way we can do a gridview to see an audit view of user and time-frame perhaps?
Thank you,
Jason

Top
#64309 - 07/01/20 10:47 AM Re: Payables link to GL Post date is incorrect [Re: Jason]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Hi Jason

Assuming you are not using Adagio JobCost, you might want to try turning on the "Allow edit of accounting date" option in the Integration tab of Payables Company Profile. Read up on it and see if it will accomplish your goals.

If nothing else, it's another date field you can populate and report on.

Steve

Top
#64310 - 07/01/20 12:55 PM Re: Payables link to GL Post date is incorrect [Re: Jason]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Jason,

I believe that every transaction record in the Adagio core modules contains the USR/Date/Time that it was posted. GridView can be used to access and report on these fields.

But you might want to re-examine why you are not using the accounting date fields in Adagio the way they were intended.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
2 registered (Tanya_Belanger, 1 invisible), 93 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14471 Topics
70676 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30