Navigating Prepayments in Microsoft Dynamics NAV

by | Updated July 16, 2018 | 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

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

02sep12:00 pm12:30 pmBest Practices for Work Order Planning and Routing for Field Service Companies

09sep10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

09sep12:00 pm12:30 pmOverview of Microsoft Promotion for NAV and GP Clients

10sep11:00 am12:00 pmConfab with Stoneridge - Livestream - Field Service Comparisons

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

16sep12:00 pm12:30 pmHow to Upgrade to Dynamics 365 Finance and Operations: Examining Custom Code and ISV Implications

16sep2:00 pm2:30 pmScheduling and Dispatching for the Modern Field Service Company

23sep12:00 pm1:00 pmDynamics 365 Business Central Wave 2 Release Preview - An Overview of the Most Exciting New Features Coming in October

24sep11:00 am12:00 pmConfab with Stoneridge - Livestream - The Modern Workplace: Teams, Sharepoint, Outlook, Office, and AI Integration

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

30sep12:00 pm12:30 pmEmpowering Your Field Service Technicians with a Mobile Solution

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Orders

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X