Project

General

Profile

Tasks #5140

Need to remove Carton price

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

Status:
Closed
Priority:
Immediate
Assignee:
Shemil Ali
Start date:
12/23/2021
Due date:
% Done:

100%

Estimated time:
Spent time:
1.00 h

Description

As per the checking, found some items have Wrong Carton price and in PO the unit price is calculating by dividing from Carton price. In our case, we don't have Carton price concept, all our items have only unit price, and if system updates Carton price it should be the Unit price X Divide rate.

So kindly remove all wrong Carton price from " Dollar Price List".

Files

biggestuom_prices_dollar (1).csv (25.8 KB) biggestuom_prices_dollar (1).csv Rijas P, 12/23/2021 01:02 PM

History

#1

Updated by Mohamed Suhail about 3 years ago

  • Status changed from New to Resolved
  • Assignee changed from Mohamed Suhail to System Admins Team
  • % Done changed from 0 to 100

Rijas P wrote:

As per the checking, found some items have Wrong Carton price and in PO the unit price is calculating by dividing from Carton price. In our case, we don't have Carton price concept, all our items have only unit price, and if system updates Carton price it should be the Unit price X Divide rate.

So kindly remove all wrong Carton price from " Dollar Price List".

Deleted these prices from central and mini server. Cant connect to backup


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 486

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 486

@Admins, please run the same sql in backup when the connection is there

#2

Updated by Sharil Ali about 3 years ago

  • Assignee changed from System Admins Team to Anonymous

Santheer

Please do the needful.

Sharil

#3

Updated by Anonymous about 3 years ago

query has been ran on euro backup


eurobackup=# 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 486
eurobackup=# 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 0

#4

Updated by Noufal K about 3 years ago

  • Status changed from Resolved to Closed
#5

Updated by SHAIJAL EDAVANA 9 months ago

  • Assignee set to Shemil Ali
#6

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