Project

General

Profile

Tasks #6206

PO price updating wrongly in Purchase order screen

Added by Rijas P almost 3 years ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
System Admins Team
Start date:
04/12/2022
Due date:
% Done:

80%

Estimated time:
Spent time:
0.25 h

Description

We have updated purchase price of Some items [Dollar Price list] PFA [Dollar price update.jpg] and after that added these items in PO screen and choose the biggest Uom then the PO price is showing wrong. PFA [PO screen.jpg].

In our case, we are updating the price only for smallest Uom, So even we choose the biggest uom the price should be "Smallest Uom price X Divide rate".

Please correct the biggest Uom price of all items and kindly provide a permanent fix.

Files

Dollar price.JPG (133 KB) Dollar price.JPG Rijas P, 04/12/2022 05:38 PM
PO screen.JPG (111 KB) PO screen.JPG Rijas P, 04/12/2022 05:39 PM

History

#1

Updated by Rijas P almost 3 years ago

Dear Suhail,

Could you please correct the Carton price of all items in dollar price list. Our purchase orders are pending due to this error.

#2

Updated by Mohamed Suhail almost 3 years ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 50

Rijas P wrote:

Dear Suhail,

Could you please correct the Carton price of all items in dollar price list. Our purchase orders are pending due to this error.

Deleted Carton prices of the items from Dollar pricelist

euro=# delete from m_productprice where c_uom_id=1000000 and m_pricelist_version_id in (select m_pricelist_version_id from m_pricelist_version where m_pricelist_id=1000003);
DELETE 236

eurobackup=# select count(*) from m_productprice where c_uom_id=1000000 and m_pricelist_version_id in (select m_pricelist_version_id from m_pricelist_version where m_pricelist_id=1000003);
count
-------
236

posiboltdb=# delete from m_productprice where c_uom_id=1000000 and m_pricelist_version_id in (select m_pricelist_version_id from m_pricelist_version where m_pricelist_id=1000003);
DELETE 236

#3

Updated by Rijas P almost 3 years ago

Dear Suhail,

As we discussed, could you please run a script daily basis to remove the Carton price from our server?.

#4

Updated by Mohamed Suhail almost 3 years ago

  • Assignee changed from Mohamed Suhail to System Admins Team
  • % Done changed from 50 to 80

Rijas P wrote:

Dear Suhail,

As we discussed, could you please run a script daily basis to remove the Carton price from our server?.

Admin team,
Please schedule the below script to run on every day 8 AM UAE time (on central , mini and backup server)


delete from m_productprice where c_uom_id=1000000 and m_pricelist_version_id in (select m_pricelist_version_id from m_pricelist_version where m_pricelist_id=1000003);

#5

Updated by Ahamed Danish almost 3 years ago

  • Assignee changed from System Admins Team to Ajin P

Ajin, 

         Please do the needful.

#6

Updated by Ajin P almost 3 years ago

noted.

#7

Updated by Ajin P almost 3 years ago

  • Status changed from In Progress to Resolved

crontab configured.

#8

Updated by Rijas P almost 3 years ago

  • Status changed from Resolved to Closed

Configured..

#9

Updated by Rijas P over 2 years ago

  • Assignee changed from Ajin P to Mohamed Suhail

Dear Suhail,

As we discussed, could you please run a script hourly basis to remove the Carton price from our server?.

#10

Updated by Mohamed Suhail over 2 years ago

  • Assignee changed from Mohamed Suhail to System Admins Team

Rijas P wrote:

Dear Suhail,

As we discussed, could you please run a script hourly basis to remove the Carton price from our server?.

Redmine Admin please do the needful
Change the existing script on a hourly interval
Are we running the same script on mini server also? If yes, please make the change there also

#11

Updated by Ahamed Danish over 2 years ago

Changed script running on euro central,mini and backup to run on hourly basis.

#12

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF