Accounts receivable list

In this procedure you can load information from the accounts receivable for different purposes. The data in the accounts receivable comes from invoices and payments linked to customers, postings, and vouchers.

You can use the information to reconcile unpaid invoices with the accounts receivable balance in the general ledger. You can check different things, for example payment status of invoices for a certain customer. You can display an age distributed accounts payable (age analysis). You can see postings of invoices and payments. With the different list types in the procedure, you decide what data to load to the list.

The list type determines the list that will be loaded and the settings that can be configured under the Selection tab.

Ledger – Detailed/Total

These lists display a detailed/total list of invoices with remaining amounts per a certain ledger date.

Payments

This list shows detailed information about invoices and the connected payment records.

Age analysis – Detailed/Total

These lists display a total or detailed age distributed ledger list per a certain ledger date. The list is based on age intervals of Invoice dates or Due dates. An age analysis based on due date shows how the invoices will become overdue according to different time intervals. An age analysis based on invoice dates shows when you invoiced according to different time intervals.

Reconciliation

This list is used to reconcile the balance (the remaining amount) of the ledger against the balance of the general ledger per a certain ledger date.

Reconciliation/day

This list type is used to reconcile the accounts receivable with general ledger transactions on day level. If there are any warnings they will be displayed under a separate tab. They will also have a link to the procedure in which you can perform the necessary actions.

Bookkeeping

This list shows how invoices and incoming payments are booked/recorded. The report only includes invoices and payments that have been entered in journals or are posted in the accounting.

The presentations determine how the selected list should be displayed/presented. For example if it should be presented as grouped or as total. There are some standard presentations included in the program.

In most procedures where you can load lists, it is possible to create your own presentations. This is done under Presentations in the backstage of the procedure in question. If you create your own presentation you can for example choose if it should have a drilldown function and a drilldown filterering.

You can select which columns the list should consist of, and for each of the columns you can configure grouping, sorting, aggregation, and if the column should be shown in chart form and if it should be printed. Additionally you can also make printout settings, chart settings, and settings regarding extra aggregation.

Read more about this in Presentations.

In a list procedure there is always a tab called Selection where you can select data records in different intervals from the database. The data records are then loaded by using the Load button in the toolbar of the procedure.

Under Selection rows in the backstage of the procedure, you can choose which selection rows that each list type should have, under the Selection tab in the procedure. In the List type field you select for which list type you want to customize the selection rows.

One table shows selection rows possible to select and one one table shows the selected selection rows. You can add, delete, or move selection rows by dragging and dropping the selection rows with your mouse pointer.

Using the Save button you save the selected selection rows.

Read more about this in the Selection topic.