70
My client need to know when they post a batch from the payment journal, or at least be able to group together payment from the same batch
I checked the vendor ledger entries or Bank Account entries, but it doesn't seems to have a way to know when this entries was created and from which batch.
Any Ideas how can I have this information?
Thanks!
I
Siding with Rahul and Zhu that G/L registers are most reliable to get the needed information.
Adding more info. if you want to know from which batch is posted simple find the "Source Code" field.
Hi, I also recommend using the G/L Register. You can easily do the following filtering.
Alternatively, the method below should work as well.
New Posted General Journal page:
https://yzhums.com/1335/
Hope this helps.
Thanks.
ZHU
Hi Marilyn - There are 2 ways to achieve this
GL Entries
Navigate to General ledger entries for the particular payment entry you are locating and then you'll find these 3 fields to give the information you need:
1. Journal Batch Name : Giving you the batch name
2. Journal Template Name: Giving you the template name
3. Source Code: Giving you the information the type of payment/batch used. Optionally can be used
4. System Created At: This value is only populated when an entry in GL Entry page is created from a journal. The only way a GL Entry will be created from a journal is after the user pressess the "Post" button. Based on this D/T stamp you can decide when was the entry posted while "posting date" sheds light on the accounting date for the journal
G/L Register
1. Navigate to G/L Register. Find your payment document number and use the existing columns like "Creation Date" & "Creation Time" along with the "User ID" to decipher who posted an entry and when
2. You can also use Source code, Journal Batch name from the same page. Furthermore, you can navigate to different ledger entries from the same G/L Register
Hi,
I think you'll need to customize the payment journal page and add the new field to capture batch information when the "post" button is clicked so that you can group payments from the same batch and get the information you need..
Thanks for your answers, but this is not exactly what i'm looking for.
The posting date here is the posting date for the entry, but not necessarily the date of when they click the "post" button. Also the Source code says it's from the payment journal, but not from which batch in the payment journal.
the information is available on vendor ledger entry as below, is it what you are looking for? you could add user ID to the column as well. as long as you know who uses which batch, it is traceable.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (