An email was just sent to confirm your subscription. Please find the email now and click 'Confirm Follow' to start subscribing.


You have already subscribed to this site. Please check your inbox.
You can manage your preferences at

Prepayments for Accounts Payable in Microsoft Dynamics NAV: Part III

October 31, 2018 | New View Strategies

In the previous installments (Part I and Part II), we discussed setting up the Vendor, creating the Purchase Order, making payment and discussed the impact to warehousing. For the final installment, we’ll walk through the final step for Prepayment processing.

Once the inventory has been received, the final step to clear the prepayment out of the Prepayment account (13510). To do this, a final Purchase Invoice must be processed, even if the prepayment required was 100% of the total. There are two ways to process a purchase invoice. Below, we’ll walk through the process to get receipt lines from the purchase invoice.

Once the header has been created, go to the Lines fast tab. Select Functions \ Get Receipt Lines. A box will open with any receipts open for the Vendor. The Purchase Order number will not show directly on the Get Receipt Lines page, but by looking at the drop-down box in the Document No. field, additional information such as the PO number is available to view. Select the lines to bring into the Purchase Invoice.

Excel Picture

When the receipt lines are pulled into the Purchase Invoice, the corresponding Receipt No. will be brought in the preceding line as a description. At this point, there is no indication that the prepayment will be deducted. To verify this, look at the Preview Posting option on the Action ribbon.

Excel Picture

Once posted, the prepayment line can be seen in the Posted Purchase Invoice, as well as the Prepayment Account.

Excel Picture.png

The prepayment fields on the Purchase Order is updated through each step of the process. Below, line one shows that the item has been received and final payment made. Line two indicates the prepayment has been made and will be deducted when the next Purchase Invoice is processed.

Excel Picture.png

They are not without some headaches, though. Occasionally, glitches in the process do occur. Despite that, there is great functionality that can be gained with by prepayments in NAV, which can provide a way to easily track and systematically manage those Vendors that require prepayment for ordering purposes.

Subscribe to our RSS Feed

Subscribe to Blog Updates

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1 other subscriber

You can unsubscribe at any time. To view our Privacy Policy click here.

Leave a Reply

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

The experts at New View Strategies are experienced Dynamics NAV and Business Central trainers and business process consultants who have walked in your shoes as former Corporate Controllers, Directors of IT, and Solution Architects, and believe increased utilization of your business systems is critical to the continued success of your company.
Subscribe to our newsletter and keep up to date with classes, special registration discounts, and other NVS news

You can unsubscribe at any time. To view our Privacy Policy click here.

| Website Proudly Designed by Phoenix3 Marketing
Call Us!
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram