Home Button  Buy Button 

Topic:   Automatic part price update from PO

By: ThomasPosted on: Apr 8 2021 at 05:04:10 AM
We have just discussed a commonly occuring thing here.

Often we update prices from suppliers in two places, the PO, and the corresponding supplier line on the part itself.

I seem to recall that the system asked whether it should update the underlying part price automatically, but I may be wrong.
Anyone know if this function is there, or some good easy 'MiniMRP' like practice?


By: MattPosted on: Apr 8 2021 at 05:14:03 AM
In the program setup there's an option/checkbox saying "Auto Update Detail Prices" (Most recent purchase price (received goods)

Now I don't use that option so I can't say what it does but it sounds like if that option is selected then it should do something with prices at the point that the PO is received. So, not when you create the PO but when the item is received from the supplier.

As I said. i don't use that option. Mayb try enabling it and see what it does.

By: ThomasPosted on: Apr 8 2021 at 05:28:34 AM
Thanks Matt, I'll give it a try! :-)

By: ThomasPosted on: Apr 8 2021 at 05:54:44 AM
Hhhmm, it does have an effect.
I'm getting a window saying something like: 'Unable to complete the command. Please try again later', when trying to receive goods.
Removing the "Auto Update Detail Prices' puts the system back to normal, and goods can be received.

Any idea, Support?

By: SupportPosted on: Apr 9 2021 at 02:38:47 AM
Thomas. Sounds like something's not working as expected. I'll check it out and get back to you ASAP.

By: SupportPosted on: Apr 9 2021 at 02:52:19 AM
Thomas. I think I've found something. What country are you in? Keyboard language?

By: SupportPosted on: Apr 9 2021 at 03:00:31 AM
Yes. There is a problem when the GoodsIn process tries to update prices when the user's Locale uses a comma as a decimal point.

This will be fixed today. If you download and install over the weekend or Monday that problem should be gone.

But please do tell us where you are and what language you're in so that we'll know if this is the problem or if there are others that we didn't spot yet.

By: ThomasPosted on: Apr 26 2021 at 08:18:08 AM
Sorry for the delay.

Yes, we are indeed using comma as the decimal point. We are located in Denmark, and use the standard Windows setting for DK.

I'll try the update at the first available moment.

By: GertPosted on: May 19 2021 at 06:59:05 AM
It looks that we have a similar problem with MRP PRO / MS SQL. We are located in The Netherlands and some users are using the decimal comma, some are using the decimal point. In the setup the 'Auto Update detail prices' is on. In the GRN we can not enter the item price - there is no such field. This must be done afterwards in the PO. These prices are mutilplied by the received qty to get the totals, no problem. So the system can calculate with these prices, they are stored somewhere, I think, but are not used to update the suppliers price in the components. These stay unchanged.

By: SupportPosted on: May 20 2021 at 03:36:32 AM
Hello Gert. I'm not sure I understand.

Is your problem that users can't edit prices in the GRN? and that editing a PO AFTER it has been received has no effect?

The price must be entered into the Purchase Order BEFORE processing the PO and before the receiving (GRN). Prices can not be edited in the GRN and editing prices in a PO after it has been received has no effect.

So, unless I have misunderstood the problem, the problem you describe is actually intentional. It's how the software is supposed to work.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Automatic part price update from PO

Enter the numbers.

Your name here is optional