Nacin prodaje i nabavke u dokumentima

Kada izmjenimo nacin prodaje ili nabavke u subjektima promjene se ne reflektuju na dukumentima prometa

select g.acWayOfSale, s.acWayOfSale
from tHE_Move g
inner join tPA_SetDocType d on g.acDocType = d.acDocType and d.acType = 'I'
inner join tHE_SetSubj s on g.acReceiver = s.acSubject
where g.acWayOfSale <> s.acWayOfSale

select g.acKey, g.acIssuer, g.acWayOfSale, s.acSuppSaleMet
from tHE_Move g
inner join tPA_SetDocType d on g.acDocType = d.acDocType and d.acType = 'P'
inner join tHE_SetSubj s on g.acIssuer = s.acSubject
where g.acWayOfSale <> s.acSuppSaleMet

select distinct g.acIssuer
from tHE_Move g
inner join tPA_SetDocType d on g.acDocType = d.acDocType and d.acType = 'P'
inner join tHE_SetSubj s on g.acIssuer = s.acSubject
where g.acWayOfSale <> s.acSuppSaleMet

---------

update g
set g.acWayOfSale = s.acSuppSaleMet
from tHE_Move g
inner join tPA_SetDocType d on g.acDocType = d.acDocType and d.acType = 'P'
inner join tHE_SetSubj s on g.acIssuer = s.acSubject
where g.acWayOfSale <> s.acSuppSaleMet