Message Boards

Price of new supplier does update

thumbnail
Vinh Nguyen, modified 3 Years ago.

Price of new supplier does update

Post Date: 8/6/17 (Gold, 141 Posts) Recent Posts
Hi support team,
My customer had a problem when using QAD system. I am going to describe it in detail below:
+ In "Price List Browse" which has the C material, they used to buy it
from the A company.
+ Now, they have changed the supplier is the B company.
+ However, when creating a purchase order with the C material, the
material price of the B company hasn't updated, it still has been the
material price of the A company.
- My team checked their system and recognized that:
+The C material used Price List Table not GL cost ( but all different
materials in their system use GL cost)
+But My customer said that when entering a new price in "Price List Maintenance" it is not allowed to choose GL cost.
- I have two questions here are:
+ Is there a way to configure for PO be taken at Price List Table?
+ If not, what module can we adjust the GL Cost?
 
P/s: My mistakes. The title should be "Price of new supplier does not update"
thumbnail
Phill Norrey, modified 8 Years ago.

Re: Price of new supplier does update

Post Date: 8/6/17 (Yoda, 1010 Posts) Recent Posts

When you set up the initial price list for company A what name did you give it?  I suspect you left it blank which means that the next company will also see the same price.

Go to 1.10.2.1 and create a price list where the pricelist name = Supplier number

and the part = your part number, then use type M (MarkUp) and set min qty 1 % Markup = 0.

Then on the Supplier set the discount table to the supplier number to link the mark up table.

 

This should give you the results you need.

thumbnail
Vinh Nguyen, modified 6 Years ago.

Re: Price of new supplier does update

Post Date: 8/7/17 (Gold, 141 Posts) Recent Posts

Hi Phill,

I already have done all steps but it doesn't work. Could you remote to my PC and show me step by step to do this?

Besides that, my customer uses 2007 SE version and in their system uses type L.

 

thumbnail
Phill Norrey, modified 8 Years ago.

Re: Price of new supplier does update

Post Date: 8/7/17 (Yoda, 1010 Posts) Recent Posts

I would love to log in and help you but I would have to do it in the evening when I am at home.  I live in the US on EST time.  Where are you?

Looking at your screen shots the only thing you don't show is the settings on the supplier to show that the price list is linked to the Price List Table field.  But even without this being set up what does it say on the header screen of the PO for Price List?

BTW, Your screen shots are very small and very difficult to read.

thumbnail
Vinh Nguyen, modified 8 Years ago.

Re: Price of new supplier does update

Post Date: 8/8/17 (Gold, 141 Posts) Recent Posts

Hi Phill,

I am from Viet Nam. The header screen is my customer title system. Could we exchange through email? 

BTW, you can zoom the page to see clear screen shots.

 

thumbnail
Phill Norrey, modified 8 Years ago.

Re: Price of new supplier does update

Post Date: 8/8/17 (Yoda, 1010 Posts) Recent Posts

Iknow I can zoom, just made it an extra step so was letting you know.

my email address is [email protected] but what you are showing me is not the first screen of the PO Maintenance .  On the first screen of the header you will see in the middle two fields called Price Tbl and Disc Tbl (in your case, should say VS002UOV in the Price Table field (if your price table is a tyep L.  If it is any other code then it would link through the Discount Table)

If you want this to default automatically for any NEW orders then go to Supplier Maintenance and add the price tbl code to the Supplier Master.  Just because you called it the same as the supplier does not create an automatic link

 

Message place holder