Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Please reach out to your WorkBook administrator or your Consultant if you cannot find the module/menu.

ON THIS PAGE YOU WILL FIND:

Table of Contents
maxLevel2
minLevel2

...

AR / AP GROUP

From the menu AR/AP groups, click on the button (blue star) to add a new group in the upper grid.

  • Group code: the abbreviation or the code of this posting group. (E.g. DED EXT - use for the external debtors)

  • Description: a clear and short explanation of the group code

  • Debtor account: if this group is used on the debtor, select the relevant GL account that the debtor-related transaction will be posted to (If left blank, this code cannot be selected in the Debtor setup)

  • Creditor account: if this group is used on the creditor, select the relevant GL account that the creditor-related transaction will be posted to (If left blank, this code cannot be selected in the Creditor setup)

...

It’s possible to have a group that can be used for both Debtor and Creditor. Just simply define the GL accounts on both columns Debtor account and Creditor account.

...

Selecting the AR / AP group on Creditor

...

If the WorkBook personal expense feature will be used, it is a requirement to have a posting group defined for the employee creditor with a GL account set on the Creditor creditor account column.

...

REPORTING GROUPS

Besides the AR / AP group, there’s an option to assign the reporting group to the debtor and/or the creditor for reporting purposes (filtering and/or grouping).

...

  • Group number: enter a code or an abbreviation for the reporting group

  • Description: a short explanation of the group

  • Scope: select an option to define if this reporting group should be used on Debtor only, Creditor only, or it can be used on both Debtor and Creditors

...

Selecting the reporting group on Debtor

...

Selecting the reporting group on Creditor

...

Examples of WorkBook standard reports

Here’s a couple of reports that allow you to filter and/or group using the reporting groups.

...

...

Image Added

...

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel in ( "settings" , "finance-settings" , "vat-settingsdebtors" , "debtor-summary" , "debtor-list" , "debtor-navigation" , "debtor-structure" , "debtors" , "creditor-list" , "creditor-structure" , "creditors" , "creditors-navigation" , "creditors-summary" )creditors" ) and space = currentSpace ( ) and title !~ "\"AR-/-AP-Groups\""