Receivables/Payables
With a report to financial institutions, we can review:
- outstanding items and
- overdue outstanding items on the specific day in the past by suppliers and customers,
- debit transactions,
- credit transactions,
- debit balance and
- credit balance by customers and suppliers for the specific period in the past.
The settings are accessed from the menu Settings | Program | Document Types. The form opens the register of document types, where we go to the panel Financials | Reports – Financials | Receivable/Payables.
1. Toolbar
Toolbar enables various functionalities in the Document Type register.
2. Header
In the header of the form, enter the data necessary to enter the type of document. The created document type is defined with the following data:
|
ID
|
Enter any three-digit alphanumeric code of the type document in the field.
|
|
Short name
|
In the field, enter any short name of the type document that is printed on reports.
|
|
Name
|
Enter the descriptive name of the document type in the field.
|
|
Record Only
|
The field is marked in yellow if it is a record type documents.
|
|
Group
|
Each type document can be assigned a group and thereby group it in the menu.
|
|
Link to LT/LX menu
|
The setting of the field is mainly intended for accounting services whose users of LT/LX programs connect via hosting to the database on which the accounting service also works, as well as independent users of LT/LX versions.
 |
HINT
Read more detailed instructions and field descriptions in chapter Link to LT/LX menu.
|
|
|
Classification
|
Select the document type classification from the drop-down list. We have created classifications in the form Classification Scheme.
|
3. Accounts Receivable/Payable
In this section enter the display type.
|
Customer Accounts
|
Enter customer accounts separated by semicolons when entering multiple accounts.
|
|
Supplier Accounts
|
Enter supplier accounts separated by semicolons when entering multiple accounts.
|
|
Show For customers
|
Enter a number to show the records in the overview for the Receivables tab. A value of -1 means 'for all buyers'. A value of 10 means ten customers.
|
|
Show For Suppliers
|
Enter a number to show the records in the overview for the Accounts Payable tab. A value of -1 means 'for all suppliers'. A value of 5 means 5 suppliers.
|
|
Sum for others (customers)
|
If the value -1 is not entered in the Show for customers field, a separate item with the sum of other buyers (Sum of others) can be displayed by ticking this radio button.
|
|
Sum for others (suppliers)
|
If the value -1 is not entered in the Show for Suppliers field, a separate item with the sum of other buyers (Sum of others) can be displayed by ticking this radio button.
|
|
Sort customers; Sort suppliers
|
Select the sorting option from the drop-down menu. The options are sort by balance descending and sort by balance ascending.
|
hint
Example 1: Show for 10 customers and sort by balance descending; tick on sort by outstanding receivables due: The display gives the ten most debtor customers according to the outstanding receivables due at the date of the review.
Example 2: Show for 10 customers and sort by balance descending; tick on debit turnover for the last 6 months: In the display we get the ten biggest customers by debit turnover for the last 6 months.
|
|
|
Sort by
|
The display can be sorted according to two of the records (display mode) in tab Receivables and tab Payables. This is ticked. The column will be grayed in report.
|
|
Receivables
|
This setting is connected to setting Sort By. If check box is on Sort By and Receivables, means that row in display mode (in this case Debit transaction) will be primarily sorted by Descending in tab Receivables.
|
|
Payables
|
This setting is connected to setting Sort By. If check box is on Sort By and Payables, means that row in display mode (in this case Credit transaction) will be primarily sorted by Descending in tab Payables.
|
|
Display Mode
|
From drop down menu choose: Outstanding items, Overdue Outstanding Items, Debit Transactions, Credit Transactions, Debit Balance or Credit Balance. This options form columns in the report.
|
|
Interval
|
We choose time interval from drop down menu (month, day, quarter).
|
|
No.
|
Enter the number of units for display (ex. -3 with interval month in column Debit and Credit transactions and also debit and credit balance means 3 months in the past from the date of the report).
For a more detailed overview of the turnovers we recommend using the interval Day.
|
|
Use Date
|
We choose the option from drop down menu:
- Document Date
- Due Date
- Target Date (from journal entry header)
 |
WARNING
Setting Use date has impact only on Debit and Credit transactions and Debit and Credit Balance. It does not impact on outstanding items or overdue outstanding items.
|
|
|
Show share for payables
|
Program shows percentage in grid for selected data in report
|
|
Show share for receivables
|
Program shows percentage in grid for selected data in report
|
4. Notes
In this tab you may enter and edit notes of which text can be displayed at the bottom of document type. You can create pre-prepared notes templates in the Document Texts.
5. Permissions
On the Permissions tab, we set authorizations to one or more users at the same time.