How to Manage Vendor Contract Price in Dynamics GP

Take Microsoft Dynamics GP Purchase Orders further with the Trinity Vendor Price Management Module from Dynavistics. In this video, we show you how fast and easy you can compare vendor contracts and offers to get the lowest price every time.

Vendor Price Management Enhanced Functionality:

  • Single or multiple prices for purchased items
  • Quantity breaks dependent upon quantity purchased
  • Pricing on a Contract or Non-Contract basis
  • Specific date range prices

Vendor Price Management Benefits:

  • Reduced purchasing costs
  • Make better purchasing decisions
  • Reduced invoice matching errors
  • Improve vendor comparison

 

Vendor Price Management Transcription

Welcome to this video presentation from Dynavistics on the Trinity module Vendor Price Management. As we can see from the item vendor screen, Dynamics GP records the last known invoice cost for each item that has been purchased, across multiple vendors.

Vendor Price management Enhanced Functionality:

  • Single or multiple prices for purchased items
  • Quantity breaks dependent upon quantity purchased
  • Pricing on a Contract or Non-Contract basis
  • The facility to base purchase prices on specified date ranges so that prices will depend. upon when you make the purchase

 

This pricing information can then be viewed in Purchase Order creation via the generator and standard Purchase Order entry, where lookups allow you to compare, select and view current and future prices.

Here we are entering a Purchase Order for a Food vendor and specific product Z-102. The price of $13 will be drawn from a Vendor Price Contract. We can verify that by viewing the relevant price record.

For this next item, a pop-up screen will appear automatically as soon as we tab off the quantity. This is because we have chosen an option in set-up to see prices where there are quantity options or imminent price changes. In this case, we can see that there will be a special deal with a reduced price coming effective in 19 days’ time so we may choose to keep our order today to a minimum.

Similarly, for item Z-101 the pop screen appears because there are quantity breaks offering us a reduced unit prices for larger quantities.

This ability to record and utilize accurate prices helps us take advantage of upcoming price changes as well as and reducing potential errors down the line in the invoice matching process.

There is a comprehensive maintenance program that allows direct update of pricing records but workload can substantially reduced by using this import/export routine.

Here we are going to import Vendor prices.

We’ll select: the import option, the template ID, which controls the format of the file, and then the file itself. A preview screen allows us to view the price information prior to import. Prices imported can be future prices. They will cut in as appropriate. You can even have nested prices’- a price for whole year but a special price for one month within that.

An inquiry program will show comparative prices from different vendors for the same item.

From the drop down you will see options for price history and future prices.

The PO generator utilizes vendor prices and if it is set up to use the best price it will select the lowest priced vendor for the quantity ordered.

Against a Vendor, we can assign a target order threshold, typically weight or number of cases based on a specified unit of measure held against each product. And if required we can also store an ordering frequency. In addition, we can also assign a vendor grouping. Both these features can then be used in Purchase order generator.

We can raise purchase orders for vendors in the same group and we can check on supply minimum thresholds. The third Advanced Inventory Replenishment video explains this in more detail.

Vendor Price Management Benefits:

  • Reduced purchasing costs
  • Make better purchasing decisions
  • Reduced invoice matching errors
  • And improve vendor comparison

I hope you found this presentation interesting and if you would like to know more please schedule your free demonstration today. Thank you.

More on Trinity Distribution Module »


Interested in learning more?

Check out these product videos:
Purchase Order Demand Review

Purchase Order Generator

Account Receivable and Credit Collection Management