Link báo cáo: https://reports.adcvn.com/reports/browse/Mat_Troi_Vang/SaleAdmin
Bước 1: Mở Navicat → ERP_User_View
Chạy Query đoạn code sau:
SELECT
DISTINCT OrganizationCode
,OrganizationId
,OrganizationName
,salesadmin
FROM
ADC_ADCSalesExt_Receipt_Done
UNION all
SELECT
OrganizationCode
,OrganizationId
,OrganizationName
,salesadmin
FROM dbo.ADCSaleExt_Organization
Bước 2: Thêm CN và user sale admin tương ứng
