Report and manage
Several companies
See receivables, overdue, holds and open collections work of every company you may open in one list, and one customer's balance across all your companies.
updated: applies-to: 1.2.0.0
Follow collections across all the companies of your group without switching companies. Bitta Collections reads each company that you may open, with your own permissions, one company at a time. It only reads: nothing is written in another company.
Applies to: Bitta Collections 1.2 on Business Central online, version 28 or later.
Before you start
- You need the BAA COLL READ permission set (the Read set) in each company you want to see, plus read access to its customers and ledger entries. The group view never reads more than your permissions allow.
- The group view needs no license seat.
- To limit the companies, open Bitta Collections Setup, go to the Group View FastTab and enter a Group View Company Filter, for example
CRONUS*. Leave it blank for every company you may open. The current company is always included.
Group Overview
Search for Group Overview, or choose it in the navigation of the Collections and Credit role center. The page reads every company and shows one row per company.
| Field | What it shows |
|---|---|
| Company | The company that the row is about |
| Status | OK, No Access when you can't read the company, or Not Set Up when Bitta Collections isn't set up there |
| LCY Code | The local currency of the company |
| Balance, Overdue | Receivables and overdue as of the work date, in the company's local currency |
| Customers on Hold | Customers on credit hold |
| Open Work Items, Next Actions Due | Work on the company's worklist |
| Promises Due, Installments Due | Promises to pay and payment plan installments due by the work date |
| Open Disputes, Open Placements | Open disputes and accounts placed with an agency |
| Last Job Run | When the collections job last finished in the company |
| Status Text | Why a company could not be read |
A company that is Not Set Up shows its ledger figures only. A No Access row has no figures and is left out of the totals.
Totals per currency
Amounts are added up only per local currency, so amounts in different currencies are never added together. The rows at the end read Total USD, Total CAD and so on.
Companies without an LCY code are added up under Total (no currency code) when their local currency symbol and description agree. When they differ, each such company gets its own total row, named Total (no currency code): followed by the company name.
Open a company
Select a row and choose Open in Company. The company's collections worklist opens in a new browser tab. Choose Refresh to read every company again.
One customer across companies
The same customer often buys from several companies of a group. To see that customer everywhere:
- Give the customer the same Group Customer Key on the Collections FastTab of the customer card in each company.
- On the customer card, choose Collections > Group Balance.
Group Balance shows one row per company with Customer No., Matched By, Balance, Overdue, Oldest Days Overdue, On Credit Hold, Collector Name, Open Disputes, Open Promises, Active Plans and Open Placements. Choose Open in Company to open the customer card in that company in a new tab.
Customers are matched in this order:
| Matched By | When |
|---|---|
| Group Customer Key | The customer has a group customer key: customers with the same key match |
| VAT Registration No. | The customer has no key: customers without a key and with the same VAT registration number match |
| Same Customer | The customer has neither: it matches only itself |
Good to know
- Overdue counts invoices, finance charge memos, reminders and refunds.
- If an extension from another publisher raises an error while a company is read, that company shows No Access with the error, and the other companies are still read.
What's next
Find out what to check when something doesn't run: Troubleshooting.