Ratakan

Informations :

Purchase Requisition Subtotal in no equal to total of line items

Link : https://community.dynamics.com/gp/f/32/t/221975







Solution by Query : 

Create Jobs with this Query : 

update a
set a.DOCAMNT = b.DOCAMNT
from
POP10200 a
inner join (select POPRequisitionNumber,CURNCYID,sum(EXTDCOST)+sum(FRTAMNT)+sum(TAXAMNT) as DOCAMNT from POP10210 
group by POPRequisitionNumber,CURNCYID) b on a.POPRequisitionNumber = b.POPRequisitionNumber
where a.DOCAMNT <> b.DOCAMNT





No comments