How to know when I post a batch (when I actually click the action post on a payment journal batch)

(0) Share

Report

Posted on by MarilynG

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!

All responses (7)

Answers (2)

KasparsSemjonovs 3,916 Super User 2024 Season 2 on at

Like (1)

Report

RE: How to know when I post a batch (when I actually click the action post on a payment journal batch)

Siding with Rahul and Zhu that G/L registers are most reliable to get the needed information.
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to know when I post a batch (when I actually click the action post on a payment journal batch)

Adding more info. if you want to know from which batch is posted simple find the "Source Code" field.
Verified answer

YUN ZHU 73,171 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to know when I post a batch (when I actually click the action post on a payment journal batch)

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
Verified answer

NAV_with_Narang 2,234 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to know when I post a batch (when I actually click the action post on a payment journal batch)

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
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to know when I post a batch (when I actually click the action post on a payment journal batch)

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..
MarilynG 70 on at

Like (0)

Report

RE: How to know when I post a batch (when I actually click the action post on a payment journal batch)

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.
Jun Wang 7,433 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to know when I post a batch (when I actually click the action post on a payment journal batch)

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.