Navigating Prepayments in Microsoft Dynamics NAV

By Jack Ries | July 12, 2018

Navigating prepayments in microsoft dynamics nav

Handling prepayments is an important step in both purchasing and sales. In this blog post, I will show you the process of navigating prepayments in Microsoft Dynamics NAV. I will use ambiguous language in my steps below since the steps are identical from both the purchasing and sales perspectives.

Setup

Before creating an order, you must setup the posting account for prepayments in General Posting Setup. The relevant columns are “Purch. Prepayments Account” and “Sales Prepayments Account”. Additionally, there is a field in both the Purchase & Payables Setup and Sales & Receivables Setup for “Check Prepmt. When Posting”. Check this box if you want a warning message shown when you receive or invoice an order that has an unpaid prepayment amount.

Navigating Prepayments

Order

After setting up an order with the relevant vendor and item information, open the Prepayment fast tab. Here you can specify prepayment invoice document-specific information such as Payment Terms, Due Date, Discount %, etc. You are only able to post at most one prepayment invoice per line. In the “Prepayment %” field, put in the percentage amount of the total amount for the prepayment invoice. You will be asked to update the lines. Click Yes. This step is not necessary but allows a quick way to fill multiple lines with the same Prepayment % amount.

Move to the lines section. Make visible the following columns if they are not already:

Prepayment % – Specifies the prepayment percentage to use to calculate the prepayment amount for the line.

Prepmt. Line Amount Excl. Tax – Specifies the prepayment amount of the line if a prepayment percentage is specified for the line.

Prepmt. Amt. Inv. Excl. Tax – Specifies the prepayment amount that has already been invoiced for this line.

Prepmt Amt to Deduct Excl. Tax – Specifies the prepayment amount that has already been deducted from ordinary invoices posted for this order line.

Prepmt Amt Deducted Excl. Tax – Specifies the prepayment amount that has already been deducted from ordinary invoices posted for this order line.

Once a Prepayment % or Prepmt. Line Amount Excl. Tax value has been specified, you are ready to post the prepayment invoice. Go to the ACTIONS tab, move to the Posting grouping, click the Prepayment icon, and click Post Prepayment Invoice.

Navigating Prepayments

After Posting the Prepayment Invoice

Before we view the posted invoice, you will see the status of the order change to Pending Prepayment. At this point, you are able to post the rest of your order as is. You can add quantity to the line but must create another prepayment invoice such that the added prepayment columns are satisfied. You may also add another line at this point with its own prepayment terms if you wish.

Go to the NAVIGATE tab, move to the Documents grouping, and click the Prepayments button. Here you will see all the prepayments associated with this order. Double click on the document to view. Here we see the invoice with a line item set to the G/L Account from the General Posting Setup. We are able to make a payment on this invoice as we would a regular invoice.

Posting a Prepayment Credit Memo

In the event that we wish to correct the Prepayment Invoice we posted, we must create a prepayment credit memo. Go to the order, enter in a value for Vendor Cr. Memo No. in the Prepayment fast tab, go to ACTIONS, click the prepayment icon, and click Post Prepayment Credit Memo. You are able to do this regardless if any previously posted prepayment invoices have been paid or not.

Full Invoice

If you have created a posted prepayment invoice, you may fully invoice your order when ready. Once posted, the invoice lines will show the amount from the posted prepayment invoice being taken out of the total since it has already been accounted for. From a purchasing point of view, when it is time to pay for both the prepayment and actual invoice, both will appear. The prepayment invoice will show its specified amount, and the final invoice will contain the total minus the prepayment amount.

Related Posts

Recommended Reading:

5.27.22 Dynamics GP

How to Run Drop Ship Sales in Dynamics GP

Need to Invoice the Customer before you get the invoice from the vendor? This The freight forwarder has contacted you […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Protecting G/L Accounts From Being Deleted

There are a lot of exciting New Features in Dynamics 365 Business Central 2022 Wave 1 Release to get excited […]

Read the Article
5.25.22 Financials

Rounding Numbers in Power Automate

  If you’ve ever tried to round numbers in Power Automate, you have probably already run into the issue there […]

Read the Article

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X