Create a new Custom RDLC Report layout:

Many reports in Microsoft Dynamics NAV 2015 are based on RDLC. In previous versions of NAV users had not been able to customize RDLC based reports. In Microsoft Dynamics NAV 2015 the platform changes to support tenant-specific custom Word layouts. Reports in NAV 2015 can now be edited in Report Builder.

Create a new Custom RDLC Report layout

Select Sales Invoice Report 1306 from ‘Report Layout Selection’ page

Department/Administration/IT/Administration/Reports/Report Layout Selection

Find Report 1306: Sales – Invoice. The RDLC is currently the selected layout.

Select the Function ‘Custom Layouts’ in the Ribbon

image

Create new ‘Custom RDLC Report layout’ based on Sales Invoice Report 1306

Select New and then select ‘Insert RDLC Layout’

image

We can now give it a description

image

In the example below I have given it a description ‘My custom RDLC Report’

image

Edit the RDLC Report layout

We can now edit the RDLC Report layout. Select ‘Edit Layout’

image

The report builder open in Microsoft SQL Server Report Builder

image

Once the report opened we can edit the report. Cosmetic changes can be done and in my example below I have done the following changes:

· ‘Customer Address’ fields changed to Red and Bold

· ‘VAT Registration No.’ changed to Bold

· Remove the field ‘Company Giro No.’

· Moved the Company Bank Name one field lower

· Changed the background colour where the field is empty

· Changed the background colour for the columns to light blue

image

The report changes had been completed and we can now save the changes.

image

We can also select to save the report changes by selecting ‘Yes’ on the next warning message to import the changes into Microsoft Dynamics NAV 2015.

image

 

Test the new custom RDLC Report layout

The report can now be tested and made active. The changes can now be verified when selecting the function ‘Run Report’. Note that the report is still inactive and will not be available for the users.

clip_image002

Select Preview

clip_image004

I can now see all the changes that I have made to the report in the report builder BUT the changes is not yet visible on the actual documents.

image

Make the new Custom RDLC Report active

Once the report had been tested and all the changes are completed, the changes can be implemented. I am now back on my Report Layout Selection Page and I select Custom Layout in the field ‘Selected Layout’

clip_image008

The Custom Report Layouts Page opens and I can see my custom report layout. I select OKclip_image010

When the page close I can now see that my report layout is the selected layout.

clip_image012

When printing a Sales Invoice, the report changes will be effective in the live database.

clip_image014

Microsoft Dynamics NAV is a business management solution from Microsoft that is quick to deploy, easy to use, and has the power to support your business ambitions. Please do not hesitate to contact Technology Management for more information.

How to configure and use background posting in Microsoft Dynamics 2015

In previous versions of Microsoft Dynamics NAV, multiple users could only process one Sales Order at a time and this caused delays when multiple users posts Sales Orders at at the same time. In Microsoft Dynamics NAV 2015, Job Queues are an affective tool to schedule the running of business processes in the background. By setting a background posting routine, postings can be placed in a queue for processing in the background.

Alternatively you may want to schedule postings for hours when it is convenient for your company. It may make sense in your business to run certain routines at a quiet time or after office hours.

Job Queues in Microsoft Dynamics NAV 2015 enable you to specify, request, and control when certain processes are run, such as the processing of a report or executing a codeunit. You can enter your requests for the execution of a report or a codeunit in the Job queue entries page. When the report or codeunit finishes, Microsoft Dynamics NAV 2015 records the event in the Job Queue Log Entries page. You can then use, for example, Job Queues with email logging so that it requests regular entries in this table. Microsoft Dynamics NAV 2015 also inserts a record into the Job Queue Log Entry table to record that it has processed a Job Queue Log Entry.

In Microsoft Dynamics NAV 2015 both Sales and Purchases can be setup to schedule background posting for the following documents:

Sales Order, Sales Invoice, Sales Credit Memos, Sales Return Order

Purchase Order, Purchase Invoice, Purchase Credit Memos, Purchase Return Order

 

Both Post and Post and Print can be setup individually. Remember also to setup printers on the NAS Service machine.

 

Setting up Background Posting in Sales and Purchase Setup

  •  You can activate Sales Document posting by selecting the Post with Job Queue 

  • To ensure that you have a dedicated Job Queue for the sales background posting you can provide a Job Queue Category Code. This routes the posting to the correct Job Queue

  • The same applies for Post and Print. It is also setup when you select Post & Print with Job Queue checkbox.

  • The posting will create with a priority of 1000.

  • The Priority Field is used to determine the order of processing the Job Queue Entries. By setting this to 1000 it is easier to allow other jobs to get to the front of the queue

  • Activate the Notify on Success checkbox if you want the user that post’s the documents to be notified about the state of posting.

  • There will be a notification attached to the posted document as well as a notification in the ‘My Notifications Part’ in the Role Center

  • The same steps can be applied to the Purchases & Payables Setup Page

    clip_image002[4]

Figure 1 Sales & Receivables Setup

Setting up a Job Queue

The next step is to setup a Job Queue to run the background posting.

  • In a Job Queue Card you create a new dedicated Job Queue.
  • The Job Queue Category Filter resembles the filter set on the background posting setup. So this Job Queue will only run Job Queue entries with the category SalesPost
  • In the NAS Settings FastTab it is possible to choose which NAS Service which the Job Queue must run on. If we do not select a NAS Service, the Job Queue will run on the same server.
  • When the Job Queue has been started from this session by clicking Start Job Queue action the remaining fields in the General FastTab shows the status of the Job Queue.
  • Now the Application had been configured and it is possible to start posting.

NOTE: The NAS Server has to be restarted to pick up a new post job queue.

clip_image004[4]

Figure 2 Job Queue

Using Background Posting through Posting Documents and Notes

In the next step we will see how the background posting changes the behaviour of the user experience.

  • Posting a Sales Order will create a Job queue entry to be run on the dedicated job queue
  • This will execute the posting routine and if required send a document to a printer
  •  There is a feasible difference in the posting routine since the background posting will notify a user that the order has been sent for posting instead of showing the actual posting steps

clip_image006[4]clip_image008[4] 

Figure 3 Posting confirmation

In the Sales order list it is possible to see the state of posting showing the Job Queue Status field. The list page will show the status of posting.

clip_image010[4]

Figure 4 Sales Order List

If Notification is turned on, it is very useful to add the notes FactBox as well. This is really valuable in cases where the posting for some reason doesn’t finish.

clip_image012[4] clip_image014[4]

Figure 5 Job Queue Notification

In this case there is nothing to post

clip_image016[4]

Figure 6 Sales Order List

Monitoring Background Posting through ‘Find Error Messages’ and ‘Use the My Job Queue Part’

  • It is also possible to see that there is something wrong in the posting on the Role Center.
  • The My Notifications part shows any errors related to the posting.

clip_image018[4]

Figure 7 Notifications on Role Center

  • The same error can be on the found under ‘My Job Queue’ Part

clip_image020[4]

Figure 8 Customize the Role Center

The same error can be on the found under ‘My Job Queue’ Part. Any job queue errors will be readable from the entry in the job queue. Failing Job Queue entries will be displayed in red.

clip_image022[4]

Figure 9 Error Message

Microsoft Dynamics NAV 2015 is a business management solution from Microsoft that is quick to deploy, easy to use, and has the power to support your business ambitions. Please do not hesitate to contact Technology Management for more information.

Set Item Sales Prices and Discounts in Microsoft Dynamics NAV 2015

The Small Business Role Center in Microsoft Dynamics NAV 2015 enable you to use NAV on a very simplified way. A number of pages in Microsoft Dynamics NAV 2015 have been simplified and selected features are redesigned to align with simpler business processes, but the base is still standard NAV. The simplified features are not available from any of the other role centers.

In this blog we are going to setup Sales and Discount prices on an item for the calculation of prices in sales order(s). This is very useful when different price lists are used for your customer base.

 

1.    Sales Prices and Sales Discount on the item card

Departments/Sales & Marketing/Inventory & Pricing/Items

Select Item 1000, and then, on the Home tab in the Manage Group, choose ‘Edit’.

clip_image002

Figure 1: Item Card Ribbon

In the Item Card Window, on the ‘Sales Prices and Line Discounts’ FastTab, create a new line. Add the following detail and then select the ‘OK’ button

Field

1 Price

2 Price

3 Discount

Line Type

Sales Price

Sales Price

Sales Line Discount

Sales Type

Customer

Customer

All Customers

Sales Code

10000

10000

 

Type

Item

Item

Item Disc. Group

Code

1000

1000

A

Unit of Measure

PCS

PCS

 

Minimum Quantity

 

100

5

Unit Price

35.00

25.00

 

Line Discount %

   

15.00

clip_image004

Figure 2: Item Card

2.    Create a new Sales Order

Departments/Sales & Marketing/Order Processing/Sales Orders

Create the sales order with the details below:

Header:

Field

Sell-to Customer No.

10000

Document Date

10/01/16

Order Date

10/01/16

Lines:

Field

1 Price

2 Price

3 Discount

4 Discount

Type

Item

Item

Item

Item

Code

1000

1000

1000

1000

Location Code

Blue

Blue

Blue

Blue

Quantity

10

     

Unit of Measure

PCS

PCS

PCS

PCS

clip_image006

Figure 3: Sales Order

The calculated price on:

  • Sales Line 1 is £35.00 with 5% discount. These figures are calculated taking into the date, the quantity, the Sales Price and the discount %. The price on the sales order is determined by line 2 and 4 highlighted in yellow.
  • Sales Line 2 is £35.00 with 15% discount. These figures are calculated taking into the date, the quantity, the Sales Price and the discount %. The price on the sales order is determined by line 2 and 3 highlighted in yellow.
  • The calculated price on Sales Line 1 is £25.00 with 15% discount. These figures are calculated taking into the date, the quantity, the Sales Price and the discount %. The price on the sales order is determined by line 1 and 4 highlighted in yellow.

clip_image008

Figure 4: Sales Order and Item Card

3. Sales Prices and Sales Discount on the item card

In the Item Card Window, on the ‘Sales Prices and Line Discounts’ FastTab, create a new line. Add the following detail and then select the ‘OK’ button

Field

1 Price

2 Price

3 Discount

Line Type

Sales Price

Sales Price

Sales Line Discount

Sales Type

Customer

Customer

All Customers

Sales Code

10000

10000

 

Type

Item

Item

Item Disc. Group

Code

1000

1000

A

Unit of Measure

PCS

PACK

 

Unit Price

20.00

6.00

 

Line Discount %

   

20.00

Starting Date

01/01/16

 

01/01/16

Ending Date

29/02/16

 

29/02/16

clip_image010

Figure 5: Item Card

4.     Create a new Sales Order

Departments/Sales & Marketing/Order Processing/Sales Orders

Creat
e the sales order with the details below:

Header:

Field

Sell-to Customer No.

10000

Document Date

15/02/16

Order Date

15/02/16

Lines:

Field

Line 1

Line 2

Line 3

Type

Item

Item

Item

Code

1000

1000

1000

Location Code

Blue

Blue

Blue

Quantity

7

8

1

Unit of Measure

PCS

PCS

PACK

clip_image012

Figure 6: Sales Order


Sales Lines: The calculated price on Sales Line 1 is £20.00 with 15% discount. See Item Card Line 1 in highlighted in blue

The calculated price on Sales Line 2 is £20.00 with 20% discount. See Item Card Line 1 in highlighted in yellow

The calculated price on Sales Line 3 is £6.00. See Item Card Line 1 in highlighted in green

clip_image014

Figure 7: Sales Order and Item Card

Microsoft Dynamics NAV is a business management solution from Microsoft that is quick to deploy, easy to use, and has the power to support your business ambitions. Please do not hesitate to contact Technology Management for more information.

Suggest Vendor Payments in Microsoft Dynamics NAV 2015

The ‘Suggest Vendor Payments’ batch job in Microsoft Dynamics NAV 2015 is a very useful feature. The creation of entries in the Payment Journal will list all the outstanding invoices based on the filtering criteria entered by the user. In NAV 2015 we have now more options than ever before.

The Document Date is what controls the calculations of Payments. The ‘Suggest Vendor Payments’ batch job can be used to process open vendor ledger entries. These are entries that result from posting invoices, finance charge memos, credit memos, and payments. The batch job creates a payment suggestion as lines in a payment journal. Only vendor entries that are not marked ‘On Hold’ are included in the batch job. The batch job can be run in such a way as to include payments for which it is possible to obtain a discount.

Departments/Financial Management/Cash Management/Payment Journals

In this blog I am going to show how dates can be used in the batch job. We are going to look at the following suggestions:

  1. Suggest Vendor Payments with the same Posting Date
  2. Suggest Vendor payments with the Due Date as Posting Date
  3. Suggest Vendor Payments with Due Date offset.

Sug Vend Pmt 1

Figure 1 Suggest vendor Payments Batch job

1.    Suggest Vendor Payments with the same posting date

If the user enters a ‘Posting Date’ different to the date entered on the ‘Due Date’ field, the ‘Posting Date’ of the batch job will be used as the ‘Posting date’ on the payment journal lines created from this batch job.

clip_image002

Figure 2 Suggest vendor Payments – Same Date

  • Enter the ‘Last Payment Date’ and ‘Posting Date’.
  • The ‘Last Payment Date’ is the latest payment date that can appear on the vendor ledger entries to be included in the batch job. Only entries that have a due date or a payment discount date either before or on this date will be included. If the payment date is earlier than the system date, a warning will be displayed.
  • Enter the date that will appear as the ‘Posting Date’ on the lines that the batch job inserts in the payment journal
  • Starting Document No.: The batch job automatically fills in this field with the next available number in the number series for the journal batch that is linked to the payment journal. When you run the batch job, this is the document number that appears on the first payment journal line. NB: It is strongly recommended that you do not complete this number manually as this number will be the number when navigating the history of the payment made
  • The ‘Bal. Account Type’ and the ‘Bal. Account No.’ are the balancing account type and no. which are selected on the Payment Batch. If these fields are not completed on the Payment Journal Batch, it is can be completed on the ‘Suggest Vendor Payment’ Batch.
  • · When selecting Ok, the following warning message will be displayed:

clip_image004

Figure 3 Confirmation message

Because the ‘Last Payment Date’ and ‘Posting Date’ are not the same, the following confirmation warning will give the user the choice of showing the entries as follows:

clip_image006

Figure 4 Warning message

Yes: All the open entries up to the date selected in the ‘Last Payment Date’ field on the ‘Suggest Vendor Payment’ batch job will be created in the payment journal lines

  • When selecting Yes, the ‘Vendor Ledger Entries’ opens and the entries can now be selected.

clip_image008

Figure 5 Payment Journal

No: Only open entries up to the date selected in the ‘Posting Date’ field on the ‘Suggest Vendor Payment’ batch job will be created in the payment journal lines

  • The ‘Posting Date’ will be the same as the ‘Posting Date’ field on the ‘Suggest Vendor Payment’ batch job
  • If entries are overdue, the message ‘Posting Date will cause an overdue payment’ will be displayed on the bottom of the Payment Journal.

clip_image010

Figure 6 Payment Journal

2.   Suggest Vendor Payments with Due Date as Posting Date

When the field ‘Calculate Posting date from Applies-to-Doc. Due Date’ on the Suggest Vendor Payment batch Job is selected, the ‘Posting Date’ on the Payment Journal will be copied fro
m the ‘Due Date’ of the Open entry. When the open entry is overdue, the Workdate will be used as the Payment Date

clip_image012

Figure 7 Suggest vendor payments – Due date

Options

· Enter the ‘Last Payment Date’ and ‘Posting Date’.

  • The ‘Last Payment Date’ is the latest payment date that can appear on the vendor ledger entries to be included in the batch job. Only entries that have a due date or a payment discount date either before or on this date will be included. If the payment date is earlier than the system date, a warning will be displayed.
  • Enter the date that will appear as the ‘Posting Date’ on the lines that the batch job inserts in the payment journal/
  • Starting Document No.: The batch job automatically fills in this field with the next available number in the number series for the journal batch that is linked to the payment journal. When you run the batch job, this is the document number that appears on the first payment journal line. NB: It is strongly recommended that you do not complete this number manually as this number will be the number when navigating the history of the payment made
  • The ‘Calculate Posting Date from ‘Applies-to-Doc. Due Date Offset’ field is used to calculate the Posting date from the applied entries Due Date.
  • The ‘Bal. Account Type’ and the ‘Bal. Account No.’ are the balancing account type and no. which are selected on the Payment Batch. If these fields are not completed on the Payment Journal Batch, it is can be completed on the ‘Suggest Vendor Payment’ Batch.

clip_image014

Figure 8 Payment Journal

3.    Suggest Vendor Payments with Due Date Offset

When the field ‘Calculate Posting date from Applies-to-Doc. Due Date’ on the Suggest Vendor Payment batch Job is selected, the ‘Posting Date’ on the Payment Journal will be copied from the ‘Due Date’ of the Open entry.

We can base the ‘Posting Date’ on the Due Date plus or minus in the Applies-to-Doc. Due Date Offset’ field

When the open entry is overdue, the Workdate will be used as the Payment Date

clip_image016

Figure 9 Suggest vendor payments

Options

  • Enter the ‘Last Payment Date’ and ‘Posting Date’.
  • The ‘Last Payment Date’ is the latest payment date that can appear on the vendor ledger entries to be included in the batch job. Only entries that have a due date or a payment discount date either before or on this date will be included. If the payment date is earlier than the system date, a warning will be displayed.
  • Enter the date that will appear as the ‘Posting Date’ on the lines that the batch job inserts in the payment journal
  • Starting Document No.: The batch job automatically fills in this field with the next available number in the number series for the journal batch that is linked to the payment journal. When you run the batch job, this is the document number that appears on the first payment journal line. NB: It is strongly recommended that you do not complete this number manually as this number will be the number when navigating the history of the payment made
  • The ‘Calculate Posting Date from ‘Applies-to-Doc. Due Date Offset’ field is used to calculate the Posting date from the applied entries Due Date.
  • Enter a date formula of ‘+3D’ OR ‘-2D’ in the ‘Applies-to-Doc. Due Date Offset’ field
  • The ‘Bal. Account Type’ and the ‘Bal. Account No.’ are the balancing account type and no. which are selected on the Payment Batch. If these fields are not completed on the Payment Journal Batch, it is can be completed on the ‘Suggest Vendor Payment’ Batch.

 

Below is two scenario’s:

In this example the Posting Date is calculated from the Due Date +5 days

Options

clip_image018

Figure 10 Suggest vendor payments – Due date

clip_image020

Figure 11 Payment Journal

In this example the Posting Date is calculated from the Due Date -2 days

clip_image022

Figure 12 Suggest vendor payments – Due date

clip_image024

Figure 13 Payment Journal

Microsoft Dynamics NAV is a business management solution from Microsoft that is quick to deploy, easy to use, and has the power to support your business ambitions. Please do not hesitate to contact Technology Management for more information.

Receive Customer payments with Payment Registration in Microsoft Dynamics NAV 2015

I am very excited to share with you the new version of Microsoft Dynamics NAV 2015 which is now available worldwide. Microsoft Dynamics NAV 2015 offers significant new capabilities to help small and midsized organizations grow their businesses in a mobile-first, cloud-first world.

Microsoft Dynamics NAV 2015 also helps customers collect cash faster and spend less time managing it with new capabilities for automated account reconciliation. These enhancements include payment reconciliations and bank account reconciliations right within Microsoft Dynamics NAV.

The Payment Registration functionality is a unique method of handling customer receipts without creating entries through the Cash Receipt Journal. This functionality is designed to support users in tasks involved in balancing internal accounts by using actual cash figures to ensure effective collection from customers.

 

Department/Financial Management/Cash Management/Payment Registration

In this blog I am going to show how dates can be used in the batch job. Let’s discuss the following points:

How to:

· Setup Payment Registration

· Change the amount received or date received

· Different options to search for a document.

· Lump Payment – cover multiple invoices for one customer with a single payment

· Finance charge for overdue amounts

· Handling Payment Discounts

Payment Registration Setup

Before we start, we need to setup the defaults Journal Template information in the Payment Registration Setup. If the field Automatically Fill Date Received is selected, the work date will be used as the default date.

Payment Registration-1

Figure 1 Payment Registration Setup

Payment Registration

  • The fields ‘Payment Made’, ‘Date Received’, and ‘Amount Received’ reflects the actual cash situation before the payments are posted and only these fields can be modified.

Payment Registration - 2

Figure 2 Payment Registration

  • All sales business documents are supported, such as orders, invoices, credit memos, and finance charge memos. Both partially posted and fully posted documents are included.
  • The Description field indicates what kind of document the line represents.

Payment Registration - 3

Figure 3 Payment Registration

  • The Details button in the ribbon (Navigate Tab/Details) is used to view detailed information about a specific document as well as the related payment.

Payment Registration - 4

Figure 4 Payment Registration Ribbon

  • The balance of the payments posted to the balancing account is shown in the Posted Balance field. The Un-posted Balance field shows the amount that exists on un-posted journal lines with the same balancing account. The Total Balance field shows the sum of the posted and un-posted amounts for the balancing account.

Payment Registration - 5

Figure 5 Payment Registration Totals

  • If multiple balancing accounts for the payments is used, the balancing can be changed in the Setup (Ribbon/Navigate/Setup). You can also specify if the Date Received field is filled in when the Payment Made check box is selected.

Payment Registration - 6

Figure 6 Payment Registration Ribbon – Setup

  • If payments are made in the bank, but the related document is not represented by a line in the Payment Registration window, typically because it is not posted, then you can use a special search function to find the document.

Payment Registration - 7

Figure 7 Payment Registration Ribbon – Search and Find

  • If a payment is late and you want to issue a finance charge to the document, you can choose the Finance Charge Memo button to initiate this process immediately.

Payment Registration - 8

Figure 8 Payment Registration Ribbon – Finance Charge Memo

Change the ‘Amount Received’ or ‘Date Received’

The Payment Registration window shows all open customer ledger entries. In common situations you only have to mark the entries, post and then you are done.

  • The entry can be marked in the Payment Made field.
  • If the date received is different to the date in the Date Received the date can be changed to the correct date.
  • Select the function in the ribbon Post Payments to post the entry or entries. The amount can also be changed in the field Amount Received.
  • The Date Received displays the date that the payment was made in the bank and it is possible to post entries with different dates.
  • The Date Received field in combination with the payment discount date on the document is also used to automatically check whether the customer is eligible or not for an early payment discount.

Payment Registration - 9

Figure 9 Payment Registration Ribbon – Post Payments

Different options to search for a document

  • The FIND function in the Ribbon is used to search for entries in the Payment Registration window. If you are on the column and select FIND, the values for that particular column will be included in the search.
  • It is also possible to select the drill-down button to search in for values in any of the columns within the Payment Registration Window.

Payment Registration - 10

Figure 10 Find in Edit

  • In my example below I will put my find a value of ‘103013’ in the Description column. The cursor will find the first line which contains this value OR part of this value AND the Find in Edit window will display how many results were found. It this case there is only one match.

Payment Registration - 11

Figure 10 Find in Edit

  • Sometimes a customer pays an amount for a sales order which has not been posted. In this case we can use the Search Document function to search for the un-posted document and post it so that it will appear in my Payment Registration window.
  • In the example below, I use the Search Document function to search for document ‘104008’. The Search Result window opens and shows all documents found. In the example below I found an un-posted Sales Order. From here I can directly ‘Navigate’ to the Sales Order and ‘Post’ it. Back on the Payment Registration, I will click ‘Refresh’ and then I will find the Posted Sales Invoice on the bottom of the list.

Payment Registration - 12

Figure 11 Document Search

  • Furthermore we have the option Search Customer which opens the Customer List. From here you can filter on the specific Customer or in case there is no open document, you can mark the Customer and then choose Sales Journal to post the payment directly to the Customer

Payment Registration - 13

Figure 12 Document Search

Lump Payment – cover multiple invoices for one customer with a single payment

  • With the Lump payments we can cover multiple invoices for one customer with one single payment.
  • In the field Payment Registration, mark the invoices and then select the function ‘Post as Lump Payment’. Instead of one payment per document, you will now get one payment for multiple documents.
  • You can now look up the customer ledger entries by selecting Search Customer and you will see that one payment has been created for all four invoices.

Payment Registration - 14

Figure 12 Ribbon – Post as Lump Payment

Finance Charge memos for overdue amounts

  • When an invoice is marked in the Payment Made field, and the date received is after the due date, a message will be shown on the bottom of the page.
  • A Finance Charge Memo can be created directly from the Payment Registration window by selecting the Finance Charge Memo Function.

Payment Registration - 15

Figure 13 Ribbon – Suggest Finance Charge

  • This page is pre-filled with the customer information when we select the Name field. We can now use the ‘Suggest Fin. Charge Memo Lines’ action to generate charge lines for this customer.
  • Back on the Payment Registration window, when selecting the Refresh function, the new Finance Charge Memo will be updated on the bottom of the list.

Handling Payment Discounts

  • When a payment is received, within the payment discount period, the deducted amount will automatically be added and the invoice and the payment will be fully applied and closed after posting the payment.

Payment Registration - 17

Figure 14 Payment Discount

  • When entering a deducted amount after the payment discount period a warning message will be displayed at the bottom of the page. In case the payment is posted, it will be registered as partial payment and the invoice will remain open.

Payment Registration - 18

Figure 15 Payment Discount Warning

  • If you want to accept the late payment discount, you can easily change the payment discount date, either directly in the Payment Registration or in the detail section.

Payment Registration - 19

Figure 16 Detail

  • When changing the date, the warning message disappears and the remaining amount becomes the payment discount. After posting both the invoice and the payment will be fully applied and then closed.

Microsoft Dynamics NAV is a business management solution from Microsoft that is quick to deploy, easy to use, and has the power to support your business ambitions. Please do not hesitate to contact Technology Management for more information.