Vendor Minimums
-
Vendor Minimums
Posted by David Wiser on May 16, 2017 at 4:31 pm-
We have several vendors who have minimum order amounts, where we can’t submit purchase orders until the entire order exceeds this minimum. Ā We purchase several items from any individual vendor so using the minimum on the item card is not acceptable. Ā I haven’t found any standard NAV functionality which imposes vendor purchase minimums and was wondering how others may be dealing with this.
——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
—————————— -
Guy McKenzie
MemberMay 17, 2017 at 3:35 AM
I don’t have a technical solution for you but can advise what we do.
We have order cycles for different vendors such as weekly or monthly which mitigate many of these issues. However, they do still occur.
We then use extended texts to prompt against individual items. E.g. a widget has an moq per colour of 5,000 but a minimum qty of 50,000 against the item. We use a 5,000 moq on the item card but an extended text appears on the PO to advise of the higher MOQ. If the order meets the requirement, delete the extended text. If not, review the order.
Full automation would be nice but, the reality of this situation could be that, you need only 1 item but have not met the supplier moq, you need to either cancel the order or position excess stock.
Do you trust this commercial decision to be automated or the role of a skilled stock manager?——————————
814Guy McKenzie
SPS (Eu) Ltd
Blackpool
——————————
——————————————- -
There is no out of the box functionality. The mod would be quite easy. Add a field to the Vendor Card, then update the Purchase Order Release Code unit to check the Vendor card against the order total.
——————————
Andrew Good
President
Liberty Grove Software
Oakbrook Terrace IL
——————————
——————————————- -
Geovanny Fuentes
MemberMay 18, 2017 at 11:52 AM
I agree with him, custom coding is required. Not difficult at all.
But a confirmation message (YES or NO) to continue if it exceeds the Vendor new field “Min Amount”. This way they can still release the order if needed.
Good luck.——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————- -
To further add to Andrew’s suggestion, You would probably want the field from the Vendor Card to be populated on the Purchase Order so you could at least see if your buying the minimum dollar amount.
——————————
Gregory Alford
ERP Manager
Tri Star Metals LLC
Carol Stream IL
——————————
——————————————-
David Wiser replied 9 years ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Vendor Minimums’ is closed to new replies.