Page Comparison

...

...

...

...

...

...

...

...

...

Nastavenie mass invoicing of instalments with services

Mass Document Numbers

Mass Invoice/Credit Memo numeric series Numeric series for mass invoices/credit notes are set up in Contract with Service SetupSettings. The settings described in PD https://iao.atlassian.net/wiki/x/WYFSB and https://iao.atlassian.net/wiki/x/B4BJB Business Settings and PD Product.

In Contract with Service Settings, numeric hints are set for:

• Mass Invoice for PaymentsInstallments

• A manual posted credit memo for a payment from a payment calendar (a credit memo note that is posted immediately)

• Mass Payment Credit Memo

On the Financing Models screen, the following settings are set:

• Document numbering method

• Numeric series for manually manual posting of a payment from T.C.the Payment Register

Check for the difference between the payment calendar and invoice lines

...

When posting by batch task, the system checks the amount of the payment (individual fields) and the OneCore posting settingsPosting Settings. If it finds a difference (the posting settings are missing, or the posting settings are duplicated), it posts the difference to the set account in the Contract with Service Settings, as well as to the invoice lines. The amount of the payment in the payment calendar will be equal to the Total Value in the invoice.

Description inNastavení Business Setup .

Contract Dimension Value

Value Dimension 2 for a mass invoice that can contain multiple contracts.

...

The dimension value for Dimension 2 (Contract) is selected from the Dimension Values code listIf the dimension is set to customer

Ak je nastavená dimenzi na zákazníkovi.

At the same time, on the contract.

The Mass Task fulfills the 1st global dimension set on the customer when selecting the Invoicing Method Bulk for... (all mass invoicinginvoices).

Non-global dimensions are populated from the customer.

Setting Texts and Text Variables

A description of setting up the setting of text in to invoice lines is described in PD Financial settings in the section Standard Text And Extended Text and Standard Text Variables Standardní texty a rozšířené texty and Proměnné standardních textů

Customer Card

On the customer card, under the Customer option, the Invoice Sending Methods button sets how the system should send posted invoices in bulk , and what structured attachments should be attached.

The bulk task looks for the Payment value Payment in the Invoicing Type field, then automatically sends and suspends the invoice according to the set values. 

Detailed description in the  Address book Adresář .

Maturity date

On the customer card, on the Operative leasing tab, the following is set:

...

• Separately for a contract

  • During invoicing, one invoice is created separately for each contract and one payment

  • The system creates one invoice for one installment.

  • Invoice in header has flag Mass NO

  • There is a contract number in the dimension on the invoice header

  • In the payment calendar, in the Mass invoice after invoicing field, it will be NO

• Collectively for a contract

  • When During invoicing, one invoice is created for each contract, which can include multiple payments of the contract that fall within the period specified when the mass invoicing was started

• Collectively for Customer

  • Invoicing creates one invoice for each customer, which contains payments from all of that customer's contracts

• Collectively for a business location

  • During invoicing, the customer's contracts are accumulated in the invoice according to the customer's Business Place No. are accumulated in the invoice. This business location Number. This place of business is listed on the Financing Contract under the Customer tab. If the business location is not filled in on the contract, these contracts are accumulated in a separate invoice.  

• Collectively for Customer and Calc. Type (open/closed)

  • During invoicing, the customer's contracts are accumulated in the invoice according to the Calculation Type specified in the Financing Contract. The type of calculation is transferred from the Financing Product

• Collectively for a framework agreementFramework Agreement

  • the invoice accumulates the customer's contracts according to the Framework Agreement No., which are specified listed in the Financing Contract

...

Report/Automatic Invoice Sending Setup

The task Task after posting, if the when conditions are met , automatically sends invoices with attachments according to the settings. Detail description is in chapter https://iao.atlassian.net/wiki/x/ZYCsB .

Invoicing Task Post Financing Payments with Services

!!! When calculating the payment schedulecalendar, the system checks the completion of all posting groups in the payment calendars for of services, insurance, and customer (total payment calendar). If there is no posting group, the system will does not calculate the payment schedulecalendar, it will display a message to the User when activating the contract is activated or calculating the payment schedulecalendar is calculated. If the combination of posting groups for VAT calculation is not in the VAT posting setup, the system will not post the invoice, it will display a message to the User.

...

The task is located in the OneCore Role Center – Financing (All products) Role Center, on the Actions tab > Invoicing, but it can be searched through via the main search (magnifying glass in the top bar on the right).

The job handles contracts that:

• are marked Financing with

...

• Services = YES

This designation is transferred to the contract when it is created from the Financing Product Type

...

Contracts are not included in the task:

• A to which a change copy exists, or a the contract is a change copy.

• It is also not possible to charge from the Financing Contract Variant.

The selection of contracts included in processing may be further limited by the a user filter.

After running the Post Financing Instalments Payments (with services) job, the system opens a dialog window that has the Options and Advanced tabs and also contains filters on for the Customer, header and lines of the Financing Contract.

...

On the Options tab, you can enter the Posting Date and VAT Date that the task inserts into the invoice. When you run a job, the system prompts you to set a work working date that you can override.

Posting Date and VAT DAte are required fields, if they are not filled, task ends with an error messagea Datum DPH sú povinnéé pole, ak nebude plnia, úloha skončilí na chybovou mlášku.  

On the Filter: Financing Contract Lines tab, the user selects the period (Posting date of payments) that he wants to post (e.g. From 1.3.2022..31.3.2022). The User can enter a specific Posting date of the instalment Date (e.g. 1.3.2022) or a period "to until the date" (e.g. 31.03.22) or "from date" (e.g. 01.03.22..)

If the period is not specified, an error message will be is displayed when the task runsjob starts.

Optional fields:

On the Options tab, click the Print Invoices select Tlač faktur Select or post invoices should be pushed out at the same time when posting installments.

On the Filter: Customer tab, it is possible to you can filter contract payments for specific customers. The user can use the a preset filter for Customer No. and Payment Billing Method, but it is also possible to add other fields from the Customer Card to the filter.

On the Filter: Financing Contract Header tab, it is possible to filter specifically Financing Contracts. The user can use the apply a preset filter on to Financing Contract No., Calculation Type and Framework Contract Agreement No., but it is possible to add other fields from the Financing Contract to the filter.

The user has the option to start run the task:

• Via Through the planner , and namely:

  • The user fills in all mandatory filters in the dialog for entering the task

  • Subsequently, via Schedule n buttonIt will buildand builds:

  • Earliest Start Date/Time

  • after Confirm Confirmation OK, the system creates a record in Job Queue Entries that has the status of Ready and waits for the start time

• When a task starts, the system identifies that the task is not running on the user environment (by the user), it runs starts the background task. The task will be modified so that the questions:

  • Delete all change copies? - system conforms to YES

  • Do you want to start posting payments? - system conforms to YES

• and runs the invoicing job through the scheduler, so the executed tasks are no longer dependent on the user.

After Successful When the job is completed, the system writes a record of success to the Job Queue Log Entries, as well as and also writes the duration of the entire job.

...

The user has the option to interrupt Entering a job from the Job Queue Entries overview, list or from the card using the Set On Hold button. When the button is triggered, the status of the card in the Status field switches from Ready to On Hold in the Status field.

• On the user interface

After the starting invoicing starts, fill in the dialog window, confirm with the OK to open a window

Invoices the lines of the contract payment calendars corresponding to the specified period and filters, namely:

• Flirts Filters for the customer's contracts that have the flagflagged:

  • Financing with servicesServices=A,

  • Calculation variant=N,

  • Payment Calendar Is is Tax Document = A

• It goes through contract by contract and on each:

  • If det. the The contract status does not have a value of Yes in any of the fields Allow Posting from Payment from ThrGAC, Allow Posting of Increased Prepayment Posting, Allow Partial Credit Posting, the contract is skipped and not processed

    • flirts the lines of the given contract – the filter for the posting date was entered by the user during the launchat startup, then it is filtered to Type=Payment, Posted=No

    • If on the det. The contract status does not Allow Posting from GAthe Bill, so :

      • if Allow Down Payment Postingposting of increased payment in advance=Yes, then it will run the filter on contract lines to process only lines with flag Line with down payment=Yes

      • if Allow Partial Credit Posting=Yes, then it will run a filter on contract lines to process only lines with flag Partial Credit Memo = Yes

    • Row processing Processing :

      • Rows lines are posted directlystraight, there is no grouping in this branch

Individual Posting of a single line and buffer postings are logged into to the posting error log. Sending an e-mail with attachments is also logged separately.

...

When creating an invoice line, the system checks whether the combination Gen. Bus. Posting Group), Gen. Prod. Posting Group and is not blocked for the given invoice line. If the setting does not exist, then the error is written in the Posting Log and continues to the next contract.

• Filters the customer's contracts that have:

  • flag Financing with services=A,

  • Calculation variant=N,

  •  Payment calendar is tax documentTax Document=N,

  • Contract Status = Active, Change Copy, TerminatedTerminating, Settled 

• It goes through contract by contract and on each:

  • deletes the Change Copy, if it exists

  • If det. the The contract status does not have a value of Yes in any of the fields Allow Posting from Payment from ThrGAC, Allow Posting of Increased Prepayment Posting, Allow Partial Credit Posting, the contract is skipped and not processed

  • if the conditions for contract extension are met (Estimated termination end date<=first day of month of the entered Posting Date, the model has the flag Automatic Contract Renewal=Yes and the object has blank Object Return Date), it will call calls Contract Extension Function

    • Contract Extension Feature the last row in the Payment Calendar SPK is searched. It then checks the value on the Contract Extension contract card.

      • If it is NO, the system copies the last posted payment with the flag Contract Extension=NO,

      • If Contract Extension=YES is on the contract header, the system copies the last created payment with the Contract Extension=YES flag.

      • payment with the flag Contract Extension=NO,

      • If Contract Extension=YES is on the contract header, the system copies the last created payment with the Contract Extension=YES flag.

      • By a suitable combination of values entered into the Posting Date filters within the task dialog, this task only allows you to extend the contract without the need to post the first lines created in this way. For this separate extension, it is necessary to enter a date different from the Posting Date of the given GAC line to the Posting Date filter in the Financing Contract Line section.

...

flirts the lines of the given contract – the filter for the posting date was entered by the user

...

at startup, then it is filtered to Type=Payment, Posted=No

• if there is no Enable Posting from

  T&Cs

  Payment Register on the Det. Contract Status, then :

  • if Allow

    Down Payment Posting

    posting of increased payment in advance=Yes, then it will run the filter on contract lines to process only lines with flag Line with down payment=Yes

  • If

    it is

    the Allow Partial Credit Posting=Yes, so it

    runs the

    will run a filter on the contract lines to process only the lines with the flag Partial Credit=Yes

• Row

  processing

  Processing :

  • If the line has flag Recalculation Settlement=A or Partial Credit=A and at the same time Line Amount

    on Line

    < 0, the line is charged

    immediately

    equal to (just as if it were

    billed

    posted manually). Posting RS, PC line from the payment calendar see lower in the description.

  • If the previous point is not met, the values from the row are written to the buffer

  • If it's up to the customer in the Payment Billing Method=Separately for contracts, the buffer is

    charged

    posted immediately after filling with one line (an individual sales invoice is created), otherwise, the buffer is gradually filled with rows of all contracts of

    the

    a given customer and is charged by the buffer posting task only after all contracts of the given customer

    's contracts

    have passed.

  • When posting the buffer, the value of the field Method of invoicing payments from the Customer is taken into account. According to this value, grouping

    occurs

    takes place and one or more invoices are created, i.e. e.g. if the grouping of invoices per customer is set. The customer has 20 contracts that

    match

    fit the filter. The task gradually

    goes

    moves through 20 contracts, in case it finds out that the necessary settings (number series, dimensions, etc.) are missing for posting, it does not post any invoice and the failure is recorded in the Posting Log. If there is no setting for sending invoices, the system will post the invoice and the failure will be recorded in the Posting Log. 

  •  The invoice is created, the lines are filled in according to

    the

    OneCore Posting

    Setup

    Settings and posted. If set,

    they

    attachments will also

    generate attachments

    be generated after posting and

    send

    an email with them will be sent.

    • When filling lines into invoice lines, the system searches for posting in OneCore Posting Settings (

      https://iao.atlassian.net/wiki/x/UwBXB

      PD Finance Settings).

      • If is in the Service Contract

        Ak je v Contract with Service Settings field in the Check for Billing Invoicing Difference:

        NO

      • WELL (in Contract with Service

        Contract Setup

        Settings, in the Check for Billing Invoicing Difference field)

        • The system fills the invoice lines according to the OneCore

          posting settings

          Posting Settings for the given posting group. If the settings are missing, the invoice for the customer is not posted, the system writes the failure to the Posting Log and moves on to the next customer. 

      • YES, as well as the role of Post Financing Payment with service:

        • Rolls over contract payment calendars that match the filter specified in the dialog box when the task

          is run

          runs.

        • for

          For field group: No. 1 group:

          Principal

          principal,

          Interest

          interest The system

          looks

          searches for the corresponding line in OneCore Posting Settings. The sum of the found values from the payment calendar for group No. 1 must be equal to the prepared invoice line. If the difference is positive or negative, it will create an invoice line for group 1. The line will be filled in:

        • Account: from settings (same account for all groups)

        • VAT: from settings (same settings for all groups)

        • A value with a different value (positive or negative)

    • For field group: No. 2 group: insurance searches for the corresponding

      row

      line in OneCore Posting Settings. The sum of the found values from the payment calendar for group No. 2 must be equal to the prepared lines of the invoice

      lines

      . If the difference is positive or negative, the system creates an invoice line for group 2

      • The row will be filled in the same way as for group No. 1 flax with the difference value

    • For field group: No. 3 group– services searches for the corresponding line in

      the

      Posting

      setup

      Settings. The sum of the found values from the payment calendar for group No. 3 must be equal to the prepared invoice line. If the difference is positive or negative, the system creates an invoice line for group 3

      • The row will be filled in the same way as for group No. 1 flax with

        a

        the value difference. Vid example

        no

        No. 1 below.

  • During

    Processing Payments

    processing payments flagged with RS (non-calculation line), PC (partial credit note upon returning the vehicle) = YES :

    • If the amount is negative, the system checks in the Contract with Service Setup field Do not post credit memo from payment calendar,

      when it is

      ak je:

      • YES

        • The system creates

          a non-posted credit memoOriginal Invoice No. on the PC

          an unposted credit memo as described in Chapter II. 13.3

        • Original Invoice No. When a PC line is entered into the unposted credit memo line, the system fills it into the line

          of the unposted credit memo

          NO

      • WELL

        •  Creates a posted individual credit memo.

        • The numbering of the document is according to the settings on the Contract Model.

  • When creating a partial credit memo, the system populates the fields in the payment calendar – Applies to Document No. with the document with which the last payment was posted and the credit

    memo

    note is created from it.

  • The original document number will be filled into the header of the credit memo

    will be filled with the original document number

    , if it is a mass invoice (from which the PC line was created):

    • Closed, i.e. not open, the system will not fill in the Type and

      No.

      Number of Applies-to Document on Credit Memo

      document

      .

    • It is open, the system fills in the Type and number of the settlement document on the credit

      memo

      note.

    • When posting, the system checks: The sum of all items (principal, interest, insurance, services, VAT to principal, VAT interest, VAT insurance, VAT services) minus Amount including VAT = result must be 0.

      • If the sum is not 0, the system

        writes

        logs an error message: "Row balance is not settled LC No. ...: 10181113 Row type: Payment Regular number: 1910"

• After posting the invoice, the table on the Customer card checks the Customer's Invoice Sending Methodmethod of sending customer invoices, where it searches for Invoicing Type: Payment, Document Type: depending on whether it is an invoice or a credit note. Generates an external structured attachment and the name of the attachment from the given line, as long soon as it is specified

• After creating attachments, whether they are set on which is set to be sent to the customer to send, it takes into account the settings in the Invoicing Print Settings, where it searches for the a report for the document, the body of the mail, the email body, subject and the Job responsiibility.

• After posting, such as an aj after sending, success or failure is recorded in the Posting Log

• The system also changes the value of the Reference Date field in the contract header to the current system date.

• When the invoicing job endsis finished, the system opens a message about X successful and Y unsuccessful posting of invoices. You wish want to open the Posting Log. If you select Yes, the Posting Log opens will be opened with a filter on for the records created during the job run.

• After posting a the mass invoice for the payments, the system writes the following into the payment calendar:

  • Zúčtovací datum / Posting Date

  • Datum DPH / VAT Date

  • Datum splatnosti / Due Date

After sending, if ak on the customer card was set in the field Mass Sending Sale Documents = Mass Invoice isje:

• Invoice

  • On the

    • Document Status: Complete

    • Sending Status – - Mail: Sent

  • In the appendices

    • An attachment Attachment with an attachment type of Sales Invoice

    • Structured attachment if it has been , ak was set up on the customer card

...

Contract with Service Setup

...

Change Changing OC Posting Settings

...

If the system finds a difference, it will display a system message (when manually posting an installment from a the payment calendar)

Image Modified

The invoice has been posted.

The system also changes the value of the Reference Date field in the contract header to the current system date.

• Contracts that , which are in detailed status, which have in Tab. Detailed contract statuses in the Post YES Partial Credit Memo YES field (PC line).

In the function on Mass posting, it has been added - if det. The If the contract status has the flag Allow Posting from Payment Cal = N and Allow Down Payment Posting = A, the rows are will be filtered to those with the flag Down Payment = A. Similarly, the combination of Allow Posting from Payment Cal = N and Allow Posting Partial Credit = A will run the a filter on lines rows where Partial Credit Memo = A.

If it also finds contracts, the job searches looks for records matching the filter specified when the job was run.

Creates a posted individual credit memo that , which is numbered according to the settings on the Contract Modelmodel. Automatically It automatically sends according to the settings on the Customer card. When sending only for credit memos, it does not check the condition of filling in the External Order Number.

...

When sending, it takes into account the settings in the Invoicing Print Settings, where it searches for a the report for the document, email the body of the mail, the subject and the Job responsiibility.

Subsequently, he checks the table on the Customer card Method of sending customer invoices, where he searches for Invoicing Type: Payment, Document Type: depending on whether it is an invoice, or a credit note. Generates From the given line, when the specified one generates an external structured attachment and the name of the attachment from the given line, when it is specified. 

Once shipped, it has:

• Invoice

  • On the

    • Document Status: Complete

    • Sending Status – - Mail: Sent

  • In the appendices

    • An attachment Attachment with an attachment type of Sales Invoice

    • Structured attachment, ak bola nastavená na karty kartykarta zákazníka

• Credit note

  • On the

    • Document Status: Complete

    • Sending Status – Mail: Sent

  • In the appendices:

    • An attachment with an attachment type of Sales Credit Memo

    • Structured attachment if it has been , ak was set up on the customer card

An e-mail with an invoice and a separate credit note will be sent to the e-mail.

At the end of When the invoicing taskjob ends, the system opens a message about X successfully and Y unsuccessfully posted invoices. You wish want to open the Posting Log. If you select Yes, the Posting Log will open be opened with a filter for the records created during the job run.

...

The system writes the posting result to the Posting Error Log, which can be opened from the menu (Actions> Invoicing> Posting Error Log)

The log contains the following information: who started the task, method of invoicing payments, customer number, date and time of invoicing and result of invoicing (Success - the invoice was posted, Error - invoicing ended on an error and the invoice was not generated).

If bulk invoicing ended in with an error and an invoice wasn't was not generated, you need to fix the errors and rerun start invoicing again.

More detail description is in chapter https://iao.atlassian.net/wiki/x/NwKuB

...

For a more detailed description, see the chapter Posting Error Log.

Posted "Bulk" Sales Invoice for Payments 

If invoicing is successful, one or more posted Sales Invoices will be generated, depending on the customer's invoicing type that is has been set.

Filling in the individual fields on the invoice header depends on the invoicing method used.

If the instalments payments were invoiced "in bulk" (for a contract, for a customer, for a business location, for a type of calculation, for a framework agreement), the data is are filled in as follows: 

• Number

  • The invoice number is always assigned from the number series set in the Mass Invoice No. (3005) field. The invoice number will be written entered into the payment schedulecalendar. 

• Document Date

  • Workdate The Working date is used for the invoice issue. The work working date can be manually changed by the user in the My Settings window.

• Posting Date

  • The date is common for all payments included in the invoice, so the Posting date from the payment calendars cannot be used. Therefore, the task applies the Posting date specified by the user in the dialog box when the mass invoicing is run.

  • If the user has entered a date in the dialog window in a period that is already closed for posting, the task automatically shifts the Posting date to the first day of the open posted posting period. Posting Date Shift must be enabled in the OneCore Setup window, field Shift Posting Date of Sales Invoice To Open Period = YES.

  • The posting date in the payment calendar will be written.

• VAT Date

  • The VAT date specified by the user in the task dialog box is used. If the entered date falls within the already closed VAT period, it is not possible to issue an invoice. The user must either has to enter a different date or open the VAT period.

  • The VAT date in the payment calendar is not recordedwritten.

• Maturity date

  • The due date from payments in payment calendars is not applied (only when setting set on the customer card Invoice method: Separately for the contract), but the task calculates this date with the as standard function from the Document Date and the Payment Terms Code that is set up on the customer card.

  • The due date from the invoice is written to a line in the payment calendar.

• Reason Code

  • The reason code is completed added according to the settings in the Reason Code Setup window in Financing

...

Invoice Details Tab

At mass Invoicing , data from Customer cards, if applicable, from a master framework agreement, the information given stated in the Financing Contract does not apply. On the Invoice Details FastTab, these fields are include Payment Terms Code (has an effect on which affects the calculation of the Due Date), Payment Method Code, VAT Bus. Posting Group (has an impact on taxation) and Customer Posting Group (has an effect on the posting of the receivable)

Field Currency Code It is responsible for the currency of the contract. Only contracts in the same currency can be included in the invoice.

Afield Contract Code (Global Dimension 2) does not populate a specific contract, but the system uses the replacement dimension according to the Contract with Service Contract SetupSettings.

To press the invoice, the fields are field is filled in Invoice Print Type = Payment Typ tlače faktury = Installment. According to this type, the system selects Invoicing Printout Settings, described in Chapter II. Print and send saleable documents.   

In bulk invoicing, fields that are not visible to the user on the invoice are also filled in. This is an array of Mass invoicing and Customer Business Place No..

For mass invoicing, the Mass Invoicing invoicing field is set to Yes, and for separate individual invoicing for contracts, the value is set to No.

The customer's business location number is filled in only if mass invoicing for the customer's business locations places has passed. In this case, the common Business Place from the Financing Contracts is filled in this field.

...

Sums are transferred from the payment calendars schedules of the posted contract, as well as VAT Product Posting Groups.

...

The task according to the settings in OneCore Settings, the VAT Rounding Code field and the Rounding setting on the Contract Model and under according to the General Ledger Total Payment Setup creates rounding lines for the contract in the invoice lines.

...

When you post an invoice, a Customer Ledger Entry is created on the balance in the total amount of the invoice. In the Contract Code dimension, the dimension from the invoice header is populatedfilled in. At the same time, this receivable is marked Mass Invoicing = Yes.

...

After cancelling a payment (invoice), the following appears in the line of the payment calendar:

• Deletes Document No.

• If there was a mass invoice, so in the field Ak bola hromadná faktura, tak v poli Mass invoice = NO

• Posted = NO

• Cancel = YES

...

The task can be run via the scheduler. See chap. Invoicing task – Post financing payments with services.