Setup Example – Periodic Journal

  • The Periodic Journal is used to create month-end journals to clear the inventory accrual account and transfer the balance to stock on hand and purchases.

This page provides an example of a Transaction Type setup for Periodic Journals.

  • Description: Periodic Journal
  • Code: PER JNL
  • Entities: All

Settings (tab)

  • This section lists the compulsory and optional settings that can be used to customise Periodic Journals.
  • Settings with Default as part of the name, can be changed when capturing a transaction.
SettingDescriptionValueWhen Required
Accounting > Default – Credit AccountA dropdown list of all the created Accounts for users to select a default account.Inventory AccrualsAlways
Accounting > Credit TypeA dropdown list of Account Types for users to select one.

The options are:
– Customer
– Supplier
– Ledger
LedgerAlways
Accounting > Debit TypeA dropdown list of Account Types for users to select one.

The options are:
– Customer
– Supplier
– Ledger
LedgerAlways
Accounting > Enable AccountingA checkbox.

If checked, accounting is enabled.

If unchecked, transactions are created in the module and not posted to the Ledger.
Check the checkbox.Always
Accounting > PricingA dropdown list to select a pricing option:

– None
– Cost Price
– Sell Price
– Supplier Price
– Accounting
AccountingAlways
Defaults > Default – Data FilterThe default display when a list of transactions for the transaction type is viewed (e.g. This Month, Pending).Select an option from the dropdown list.The default value is Pending & Active.

Add this setting if you want a different default filter.
General > Reference LookupA field to type Reference lookup lists.Click the Value column. Type a reference one entry per line.

Check Auto Height to show the full list.
If you want to create a lookup list for the reference field.
Transaction Items > Enable Adding ItemsAllows users to specify which type of items can be added to a transaction.

The options are:

None: No items are added, only the header information is displayed. This option should be used sparingly and not for accounting transactions because there will be no fields for amounts.

All: Users may add items and custom items.

Custom: Users my only add custom items. Typically used for ledger transactions.

Items: Users may only add items. They may not add custom items. Typically used for Invoicing, credit and debit notes.

All the buttons to add items are still displayed. The features that are disabled return an error message if clicked.
CustomAlways

Statuses (tab)

  • You may create an unlimited number of Statuses.
  • However, there are only four Status Groups (Pending, Active, Complete, and Cancelled).
  • The first status should allow editing.
  • The final status should ideally not allow editing.
  • If the setting Accounting > Enable Accounting is checked, at least one status should have the Accounting column checked.
  • If Inventory is used, at least one status should have the Inventory column checked.
  • If editing is allowed when the inventory or accounting columns are checked, any accounting or inventory reports should be considered provisional.

Categories (tab)

  • Categories are used to sort records. 
  • The categories you choose should be meaningful to your business.
  • Using categories is optional but recommended.
  • Categories can be copied from another transaction type. The existing categories are replaced by the copied categories.

No Categories.


Copy Rules (tab)

  • Copy Rules determine the circumstances under which transactions may be copied.
  • Although there are two transactions involved in the copy, you only need to create one copy rule.
  • User access must be set for each copy rule.
  • You can automate copying transactions by selecting a Trigger status.
  • Columns that were hidden in the screenshot were left blank or unchecked.

Output Templates (tab)

  • Output templates are the forms you need to print, preview or email a transaction (e.g. invoices).
  • Default templates are included which will automatically include your company name, logo, and bank details as filled in on the Output tab of a registered Entity.
  • You may edit these templates to include or exclude information.
  • You may also create your own forms and templates from scratch.

No Templates.


Related Articles