Project

General

Profile

Tasks #9987

Require all Items Biggest Uom Barcode details for Stock take purpose

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

Status:
Closed
Priority:
Immediate
Assignee:
Rijas P
Start date:
03/20/2023
Due date:
% Done:

100%

Estimated time:
Spent time:
0.50 h

Description

Dear Suhail,

Kindy share all the items barcode details and Biggest Uom and it's barcode details for Stock taking purpose.

Files

biggest_uom_barcodes.csv (687 KB) biggest_uom_barcodes.csv Mohamed Suhail, 03/20/2023 08:17 PM

History

#1

Updated by Mohamed Suhail almost 2 years ago

Rijas P wrote:

Dear Suhail,

Kindy share all the items barcode details and Biggest Uom and it's barcode details for Stock taking purpose.

PFA

euro=# copy (select mp.name,mp.upc barcode,mp.sku,cu.name biggestuom,cuc.upc biggestuom_barcode,cuc.dividerate from m_product mp join c_uom_conversion cuc on cuc.m_product_id = mp.m_product_id and cuc.c_uom_id=mp.c_uom_id join c_uom cu on cu.c_uom_id = cuc.c_uom_to_id where mp.ad_client_id =1000000 and mp.isactive='Y' and cuc.isactive='Y' order by 1,4) to '/tmp/biggest_uom_barcodes.csv' with delimiter ',' csv header;
COPY 15427

#2

Updated by Rijas P almost 2 years ago

  • Status changed from Resolved to Closed
#3

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