ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> PO-A Last Cost for Vendor
http://www.istechforum.com/YaBB.pl?num=1071856638

Message started by benp on 12/19/03 at 09:57:18

Title: PO-A Last Cost for Vendor
Post by benp on 12/19/03 at 09:57:18

We often order the same item from multiple vendors depending on their stock at the time. Each vendor may have a different price for the item.

When entering a new PO on PO-A, it automatically grabs the last cost, regardless of the vendor. It would be helpful if it could distinguish between vendors and give the last cost for that vendor.

Title: Re: PO-A Last Cost for Vendor
Post by Lynn_Pantic on 12/19/03 at 10:22:05

You can enter vendor specific prices in PO-H

Title: Re: PO-A Last Cost for Vendor
Post by David Waldmann on 01/12/04 at 12:08:02

I, too, would like it to automatically pull in the last price you paid to that vendor.

Title: Re: PO-A Last Cost for Vendor
Post by Lynn_Pantic on 01/12/04 at 15:17:39

I was just going to say no can do because there is no place in the data table to store a Last Cost by vendor but I just thought of a way to do it! ;)

How about an SD-Q Default setting for "Auto-update vendor pricing with last cost?" If this is Y then the same data table used for PO-H would be updated when a PO is received (either create a new record or enter a new record if none exists for the item and vendor) UNLESS a record for the item and vendor already exists WITH quantity break pricing. Storing the info in that table means that nothing special has to be done in PO-A - the program already looks at that table first. And if items with quantity break pricing are skipped, you can still manually maintain the vendor pricing when they give quantity breaks but the others will be maintained automatically. How does that sound?

Title: Re: PO-A Last Cost for Vendor
Post by David Waldmann on 01/13/04 at 06:30:30

Works for me.

Title: Re: PO-A Last Cost for Vendor
Post by Lynn_Pantic on 01/29/04 at 20:21:42

OK, This capability is in the 1/30/04 update I am doing the final testing before uploading.