Creation Wizard

Customer Account

Enter the account used for receivables postings. By default this is the first account from Customer Account in program parameters (Settings | Program | Administration Panel | Settings | Financials | General).

Accounts

Selection of one or more accounts for receivables.

Supplier Account 

Enter the supplier account, where we follow liabilities to suppliers. By default this is the first account from the Supplier Account in program parameters (Settings | Program | Administartion Panel | Settings | Financials | General).

Accounts

Selection of one or more accounts for suppliers.

Subjects

Report can be limited to a single partner. When field is blank the report will be prepared for all subjects.

Name 2

Report can be limited to a name 2 of subject.

Subject Type 

Report can be limited to specific subject type.

Department

Report can be limited to specific department.

Document

Report can be limited to a particular document.

Linked Doc.

Report can be limited to a particular link document.

Currency

Report can be made in foreign currency if postings are made in foreign currencies.

Currency Type

If posting is in foreign currency, the amounts in report can be in local currency or in foreign currency. We should choose the option: 

• In LCY
• In FCY

Outstanding Only

Merge Lines

• We select both fields if we want to prepare report for open documents in their outstanding amount.
• If one of fields or both fields are not selected, it displays the total amounts of the documents as it was posted (decreased for other debit postings with the same linked documents).

Include Set-Offs in Progress

Selected switch include also Set-Offs in Progress.

Convert To

In field select currency you want to convert data.

Due From

Report can be limited to the initial due date (from Journal Entry Items) of documents which we want to include in report.

Due To

Report can be limited to the final due date (from Journal Entry Items) of documents which we want to include in report.

Document From

Report can be limited to the initial Document date (from Journal Entry Items) of documents we want to include in report.

Document To 

Report can be limited to the final Document date (from Journal Entry Items) of documents we want to include in report.

Target Date From

Report can be limited to the initial Target Date (from Journal Entry Header) of documents we want to include in report.

Target Date To

Report can be limited to the final Target Date (from Journal Entry Header) of documents we want to include in report.

Include

Choose which receivables and payables we want to include in report. We can select one or both of the options:

• Credit Balance – list items where the balance of subject balance is Credit amount (ie we have more receivables than liabilities to it);
• Debit Balance – list items where the balance of subject balance is Debit amount (ie we have more liabilities than receivables to it);

Together with at least one of the first two options we select one of the options:

• Subject that are Both Customer and Supplier – lists only partners who are acting at the same time as customers and as suppliers;

• Balanced - shows all subjects with outstanding items.

Collect

By clicking on this button program gathers candidates according to criteria entered.

Create Set-Off

By clicking on this button creates one of more set-offs that have been marked in the table. Program responds with a message after successfully created documents.

Report

By clicking on this button report is created.

• 08D - Balance report of customers and suppliers
• 08C - Balance report of customers and suppliers