Dear All,

I face a problem in the purchase order. When, after inserting the header of any purchse order, we inserting the line. In the Purchase order lines we inserting the Item Code, the price of that item automatically takes from the item master, if there any price variance, we rectify manually in the base.price field. But we wants to freeze this field.

We wants that the purchse price pick only from item master, no one can change that price (means the curson jumps from that field to the next field).

But, we wants for changing authorisation to few members for necessary changing.

So, everyone request to please provide any suitable solution for this problem.

Please help me.

Thanks & regards

Dksharma

Hello DinsehSharme,
In Baan it is possible to give permissions by field for certain users, this can be the solution to your problem. You can avoid that certain users touch a field. In tools you have this option.

Maintain Table Field Authorizations {ttaad4133m000} to be precise..

sk

Dear All,

As per your suggestion I check the same field, but there was not restriction was made on that field.

for your reference the PO line Print Screen is attached.

Please see the xls file and give me some solution.

thanks & regards

dksharma

Dk,
Go to session Maintain Table Field Authorizations {ttaad4133m000} and then insert the username for whom you want to restrict the price field and choose the company number or all the companies depending on your setup. Next enter the field name "tdpur041.pric" in the space alloted for it and against it select authorization as "Read". Save the entry & click on Special menu and run "Convert To Runtime Data Dictionary" to commit the changes.

The user will not be able to change the price thereafter in session Maintain Purchase Order Lines {tdpur4102s000}..

sk

Dear Sir,

But we wants that the price of any item can not enter manually in the PO line.

As per your guideline i process the same in the system, but result is not as desired. Because, when we inserting the line the cursor is go on the BASE.PRICE field, the user easily can change the price.

We wants the price of that item should be pickup from the item master (latest price).

Please suggest what to be done.

Thanks & Regards

Dksharma

Are we both referring to the same version of baan (Baan4c4)? If yes, then are we referring to the same field in purchase order lines, "Price" ? If the answer to both the questions are Yes...then the price field would neither be updatable nor the cursor would stop at that field after having done everything i had mentioned in my steps...

If we are not talking about the same version or field, please do provide the correct details..

sk

Sir,

Yes, We are using the same version.

dk

Dear Mr. Dinesh,

Have you resolved the problem of blocking the updation of base.price field in the PO line session. We want to do the same in our organization.

base.price is not a table field. Therefore we cann't use the ttaad4133m000 session.


Thanks
Nilesh

Dear DKS,

The principle of what Sukesh75 states is correct.

All you need to do is determine which fields in which tables people can or cannot update.
I think you need to consider locking off the item master price as well as the purchase order price, otherwise the purchase order can still be updated by changing the item master price.

I cannot find a field Called "base price" on my Maintain Purchase Order Lines screen (tdsls4102s000). Perhaps you have a different parameter set?

You could create a report that shows the price level. If not = "item", then you know the user has modified the price.