Payment Discounts - NPSBeograd/NPS-Support GitHub Wiki

🔶 Settings

The first step is to create a matrix that can later be defined for the customer or on the sales document. The creation of discount matrices is done through Customer Discount Groups.

image

It is possible to modify existing created matrices or to create a new one. To edit, click on Edit List (1) and enter the desired changes. To create a new matrix, select New (2), which opens a new window where you need to define a unique matrix code.

image

Once the matrix is created, it is necessary to define discounts by items for a specific period. Select the option Navigation -> Edit Payment Discounts.

image

For each item for which a discount is approved, it is necessary to enter the discount percentage in the appropriate column.

image

🔹 Export to Excel and Import from Excel Matrix

The Sales Payment Discount page, there are options to Export to Excel and Import from Excel. Users can quickly define discounts by period and then re-import the same exported Excel file after making changes and entering data.

image

🔹 Payment Terms

Payment terms are configured at the Payment Terms page, which is accessed through the search. A list of all defined payment terms opens. It is possible to edit existing terms by clicking on Edit List (1) or Home -> Edit (2). A new payment term is created by selecting the New (3) option.

image

By selecting New, a new row is created in the list, where you need to enter the Code, Calculation Date, Due Date (in the format 10D – ten days, etc.), and a Description. Payment terms are important as they are entered into the customer card.

image

🔹 Customer Setup

On the customer card for which discounts apply, it is necessary to select the Customer Discount Group, which represents the discount matrix for that customer.If a new matrix needs to be created, select the New option.

image

On the customer card, you also need to select the Payment Terms Code. In the Payments tab, choose one of the existing payment terms. If the desired payment term is not available, a new one can be created by selecting the New option.This field must be filled out as it is essential for calculating discounts.

image

🔶 Creating Sales Order

New document is created where it is essential to first select the customer for whom the order is being placed. By selecting a customer, all relevant fields previously filled in on the customer card (such as code, name, address, posting group, payment terms, etc.) are automatically populated. In the Due Dates tab, the dates for each defined payment discount are displayed. The condition for these dates to be printed is that the Payment Terms Code must be filled in.

image

The next step is to enter the rows, i.e., the items for sale. In the sales order rows, select the type of Item (1) and choose the desired item in the quantity field. By clicking on the three dots (2) in the Quantity field, a new window opens where the item can be selected.

image

Next, it is necessary to enter the quantity for that item in the sales order row. For each row, i.e., item entered in the sales order, the discount percentage can be seen based on the relevant payment discount.

image

After all rows have been entered and the document is ready, the delivery and invoicing of goods result in a posted sales invoice, and the created sales order disappears from the list. Posted invoices can be found through the search. Additionally, an entry is created in the customer ledger with the total invoice amount without discounts, as well as amounts depending on the applied payment discount and payment date.

🔶 Sales Credit Mamo

After the customer makes a payment and it is linked to the corresponding invoice, approvals are created to close the invoices for the amount of the discount received. The invoice is closed for the payment amount, but there remains a difference between the payment and the original invoice amount. Enter Create Pmt. Discount Cr. Memos in the search.

image

This process can be initiated for a specific customer, multiple customers, or a certain period by selecting the appropriate filters.

image

The created credit memo is on the Sales Credit Memos page.

image

The credit memo lines contain information about the related invoice and the corresponding amount. This action creates one credit memo per customer, which is why a single credit memo can include multiple invoices.

image

🔹 Manually Created Payment Discount Credit Memo

In cases where a payment discount credit memo is manually created for a posted sales invoice, it is necessary to mark that posted sales invoice as having received a payment discount, so the system does not include it in the automatic creation of payment discount credit memos. On the posted sales invoices, the Apply Discount action needs to be triggered.

image

image

This action checks the Subsequent Discount field on the posted sales invoice, indicating that a payment discount credit memo has been manually created for that invoice. As a result, the system will not consider it during the automatic creation of payment discount credit memos.

image

image

🔶 Payment Discounts Summary

The report can be generated for all customers or filtered by a specific customer. In the search, type Payment Discounts Summary.

image

image

The report provides information on planned and realized payment discounts for each customer. Data is available at the invoice level and as a summary for the customer.

image