If you post to the GL in batch can you get detail on financial details

Question Status

Suggested Answer
Nancy Cohen asked a question on 7 Dec 2017 11:40 AM

If you post to the GL in batch can you get detail on financial details, if so how can you see the details?

Reply
Suggested Answer
Béat Bucher responded on 7 Dec 2017 11:44 AM

Hi Nancy,

Are you trying to get the details by Account # or by Journal Entry # ?

Financial >> Inquiry >> Financial >> Detail

Financial >> Inquiry >> Financial >> Journal Entry Inquiry

The second one will return all the accounts touched by a journal entry, after which you could drill back to the transaction (depending  on the type).

Reply
Suggested Answer
Mariano Gomez responded on 7 Dec 2017 6:43 PM

That will depend greatly on two things: 1) That you are keeping transaction history, 2) and that your posting settings are set to create a journal per transaction and not by batch.

--

For No. 1, go to the General Ledger setup window (Financial > Setup > General Ledger) and make sure that you are maintaining history for Accounts and Transactions.

--

For No 2, go to the Posting Setup window (Administration > Setup > Posting > Posting). Select Series: Financial, Origin: General Ledger, then ensure that the Create Journal Entry Per option is set to Transaction.

Reply
Suggested Answer
Béat Bucher responded on 7 Dec 2017 11:44 AM

Hi Nancy,

Are you trying to get the details by Account # or by Journal Entry # ?

Financial >> Inquiry >> Financial >> Detail

Financial >> Inquiry >> Financial >> Journal Entry Inquiry

The second one will return all the accounts touched by a journal entry, after which you could drill back to the transaction (depending  on the type).

Reply
Suggested Answer
Mariano Gomez responded on 7 Dec 2017 6:43 PM

That will depend greatly on two things: 1) That you are keeping transaction history, 2) and that your posting settings are set to create a journal per transaction and not by batch.

--

For No. 1, go to the General Ledger setup window (Financial > Setup > General Ledger) and make sure that you are maintaining history for Accounts and Transactions.

--

For No 2, go to the Posting Setup window (Administration > Setup > Posting > Posting). Select Series: Financial, Origin: General Ledger, then ensure that the Create Journal Entry Per option is set to Transaction.

Reply