Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-216444 - Tonnage Tax|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-216444]
1. Convert origin Tonnage Tax Indicator into i21 Item
2. Insert TON unit of measure in i21 Ton Unit of Measure field. - The int # maybe different for all customers. We need to be able to mass apply.
_ (from comment below -use item unit measure)_
select * from agitmmst
where agitm_tontax_rpt_yn = 'Y'
!pastedImage_d104067_0.png!
End Goal
!pastedImage_d104067_1.png!
Ran query to update CV:
select distinct(agitm_no) from agitmmst
where agitm_tontax_rpt_yn = 'Y'
select ysnTonnageTax, * from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_tontax_rpt_yn = 'Y'
begin tran
update tblICItem
set ysnTonnageTax = 1
from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_tontax_rpt_yn = 'Y'
commit tran
select ysnTonnageTax, intTonnageTaxUOMId, * from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_tontax_rpt_yn = 'Y'
and intTonnageTaxUOMId is Null
begin tran
update tblICItem
set intTonnageTaxUOMId = 8144 --- this could be different next time and for each customer.
from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_tontax_rpt_yn = 'Y'
commit tran
|