We’re currently updating our website to a new platform. We’re still operating as usual, but some pages may be under construction. Thank you for your patience.
Jiwa Training Centre

Journal Sets Searching Copying

In this article we will be looking at journal sets in Jiwa and how to;

  1. Use the search function on the menu ribbon to search for journal sets, and

  2. Copy General Ledger journal sets

Before proceeding it is recommend that you have read our article Journal Sets  

Searching for Journal Sets

All journal sets can be reviewed from the Journal Set form using the search and filter options.

From the menu ribbon click on the Search icon

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_11-27-45.jpg

This will bring up the Search Journal Sets form

The Select a Filter option on the menu ribbon can be used to restrict your search to a transaction source type

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_11-30-49.jpg

Using the description search field enter in a description for the transaction you are searching for.

In the following example we are looking for all journal sets created that relate to sales order 100451.

By setting the filter option to Sales Orders we have restricted our description search to sales orders only.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_11-38-42.jpg

Click on the journal set to be reviewed and then press Select & Close from the menu ribbon to load the journal into the Journal Set form

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_11-43-48.jpg

 

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_11-48-10.jpg

Copying Journal Sets

Copying journal sets can be useful for transactions that need to be processed on an irregular basis or where the amounts change from period to period.

These can include transactions such as;

  • Wages

  • Depreciation

  • Accruals

NOTE:  Only journal sets with a source type of LOCAL should be copied.
https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_11-54-35.jpg

Attempting to copy a journal set where the source is not local will not update the source ledger and will result in reconciliation issues between the sub ledger and related control accounts.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_12-12-41.jpg

Load the journal you want to copy into the Journal Set form From the menu ribbon select Copy

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_12-37-33.jpg

Update the description on the journal set

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_12-38-36.jpg

Set the required posting date and make any required changes to the journal set lines

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_12-40-30.jpg

When you are ready to post your journal set select Save from the menu ribbon

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-GL-Journal-Sets-Searching-Copying/2016-04-21_12-42-29.jpg