30
Client would like to have the unti cost on a purchase order default from the vendor/inventory item last cost. They order thousands of parts from several vendors and does not keep an updated price sheet from every vendor. She would like to have the system put in the last purchase cost when she chooses a vendor/item. Is there a table that stores this data or does anyone know of a 3rd party product that will handle this?
Thanks,
Jim Gross
*This post is locked for comments
Jim,
Take a look at KB article 849088:
849088 Cost default in Purchasing when using Last Cost in Purchasing Setup
mbs.microsoft.com/.../KBDisplay.aspx
I suspect if you set Default Unit Cost = Last Cost in PO Setup, the Last Cost for the VendorID/Item will be pulled from the VendItem table to provide the results you're describing.
Kind Regards,
Jennifer Spitler
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (