This shows you the differences between two versions of the page.
— |
en:mr_aru_laek_ennustus [2022/09/28 14:04] (current) triinp created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Receipt Forecast ====== | ||
+ | |||
+ | The report shows confirmed invoices with a balance (either fully/partially unpaid or overpaid) according to the selected conditions. | ||
+ | |||
+ | =====1. Filters===== | ||
+ | |||
+ | ***Customer** - customer code on the invoice | ||
+ | ***Class** - customer class on the invoice. Can be a colon separated range. Also considers the additional field class. | ||
+ | ***Overdue at least** - only those invoices that are at least the selected number of days past due. | ||
+ | ***and not more than** - only those invoices that are no more than the selected number of days past due | ||
+ | ***Customer** datafield - it is possible to filter the report according to additional parameters set on the customer card. For example: | ||
+ | {{:et:triinp20220728-111606.png}} \\ | ||
+ | (Picture 1) | ||
+ | ***Due date to** - unpaid invoices until the selected time | ||
+ | ***Object** - object on invoice | ||
+ | ***Sum from** - an empty option shows all unpaid sums, filling in with a number does not show unpaid sums smaller than the number. | ||
+ | ***until** - an empty option shows all unpaid sums, filling in with a number does not show unpaid sums larger than the number. | ||
+ | ***Range** - document number range, for example if invoices are made with several different range, it is possible to select only unpaid invoices of one range | ||
+ | *option **Invoice salesman** - according to the option, whether only invoices with the selected salesman or **Customer salesman** - only those invoices with a customer whose customer card has a selected salesman. | ||
+ | * **Type** - invoice type (options you can set yourself) | ||
+ | * **Subtotal** - unpaid sums are shown as grouped | ||
+ | * ** //Customer//** - by customers | ||
+ | * ** //Class//** - by classes | ||
+ | * ** //Salesman//** - according to the salesman on the invoice | ||
+ | * **Show** - | ||
+ | * ** //all//** - all unpaid invoices | ||
+ | * ** //without receipt//** - invoices that have not even been partially received | ||
+ | * **Status** - invoice status (options you can set yourself) | ||
+ | |||
+ | |||
+ | ===== 2. Options ===== | ||
+ | |||
+ | *summary - unpaid sums are shown grouped into a 15-day period. The link opens the receipt forecast for the given day range. | ||
+ | *Prepayments - adds prepayments to the report, which reduces the amount of unpaid invoices. | ||
+ | |||
+ | {{:et:triinp20220728-130727.png}} | ||
+ | |||
+ | |||
+ | ===== 3. Links ===== | ||
+ | |||
+ | *payment schedule - opens the customer's payment schedule | ||
+ | |||
+ | {{:et:triinp20220728-130959.png}} | ||
+ | |||
+ | |||
+ | ===== 4. Fine-tuning ===== | ||
+ | |||
+ | ***Setting{{:mustand:kristinak:peenh22lestus_ikoon.png?|}}** - option to choose your own personal settings. | ||
+ | |||
+ | * **Show header Object** - invoice header object | ||
+ | * **Show header Project** - invoice header project | ||
+ | * **Comment** - invoice comment | ||
+ | * **Show customer Order** - | ||
+ | * **Show customer order no** - | ||
+ | * **Orders are included by** - options No, Prepayment, Payment graph | ||
+ | * **Currency ** - by default EUR | ||
+ | |||
+ | |||
+ | ===== 5. Buttons ===== | ||
+ | |||
+ | ***Excel {{:mustand:kristinak:excel_ikoon.png?|}}**(shortcut F12 or Alt+E) – options with Supplier information (as in the report), as a table (allows to combine report information in columns). | ||
+ | ***Save the report {{:mustand:kristinak:aruanne_ikoon.png?|}}**(shortcut Alt+A) – Save the report in the user menu with a name of your choice. | ||
+ | ***CREATE RECEIPT** - makes a payment to the selected invoices | ||
+ | |||
+ | {{:et:triinp20220728-132720.png}} \\ | ||
+ | (Picture 2) | ||
+ | |||
+ | ***Mail** - if you have a mass emailing module, you can send emails to customers. It is possible to prepare printouts to send to customers. | ||
+ | ***Print** - printing the report | ||
+ | ***REPORT** - creates a report based on the given parameters | ||
+ | |||
+ | ===== 6. Examples ===== | ||
+ | |||
+ | ==== 6.1. Example - subtotal by customers with prepayments ==== | ||
+ | |||
+ | {{:et:triinp20220728-135435.png}} | ||
+ | |||
+ | |||
+ | ==== 6.2. Example - netting with prepayment ==== | ||
+ | |||
+ | The client has a prepayment and unpaid sales invoices | ||
+ | {{:et:triinp20220728-140343.png}} | ||
+ | |||
+ | To make a netting, write the sum as the amount to be paid in advance so that the netting goes to zero | ||
+ | {{:et:triinp20220728-140920.png}} | ||
+ | |||
+ | Press CREATE RECEIPT | ||
+ | {{:et:triinp20220728-141003.png}} | ||
+ | |||
+ | When saving, advance payments are distributed according to the EtteID | ||
+ | {{:et:triinp20220728-141301.png}} | ||
+ | |||
+ | The financial transaction is created after confirmation | ||
+ | {{:et:triinp20220728-142028.png}} |