Please make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet-
Navigation- Go to General Accounting Dashboard and select the data access set as shown below-
Click on Create Journal in Spreadsheet. The system will ask for login id and password to download the spreadsheet. We will get the following window. Input the journal details. In case the data access set is selected for ledger set, we need to select the appropriate ledger. The source highlighted will always remain as a spreadsheet.
Double click on the company box to get the accounts options
Select the code combination & click OK.
Select the valid code combinations for stationary account and click on OK.
Select the currency as GBP. Similarly repeat the above process for credit line-Cash in hand a/c.
Click on Submit button. We will get three options-
⦁ Save to Interface- It will just save the journal to the GL interface table.
⦁ Submit Journal Import- It will just save the journal to GL interface table and submit the journal import process.
⦁ Submit Journal Import and Posting- It will do everything and post the journal.
Click on Submit to finally run the selected process for the journal.
