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.
How to Manage Vendor Contract Price in Dynamics GP
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 enhances this functionality much further by allowing:
This pricing information can then be viewed in Purchase Order creation via the generator and standard Purchase Order entry screens, 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 a 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 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 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 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 substantiality be 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 final import.
Prices imported can be future prices, and they will cut in as appropriate. You can even have nested prices - a price for the 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.
So, to conclude, Vendor Price Management allows you to better manage current and future supplier prices, thereby helping you to:
I hope you found this interesting and, if you would like to know more, please schedule your free demonstration today. Thank You.