A/R Freight Reconcile for Multi-Site Companies

A/R Freight Reconcile for Multi-Site Companies

A Few thing about this query:
– Replace the ‘XXXX-XX-XX’ with a date range for a closing financial period.
– Replace the XXX and YYY with the Site ID’s of the sites you want to reconcile.

select locncode [Site], glpostdt [Posting Date], sopnumbe [Invoice] , orignumb [Original Order Number], docamnt [Order Total], frtamnt[Freight Amount]  from sop30200

where glpostdt between ‘XXXX-XX-XX’ and ‘XXXX-XX-XX’

and soptype = ‘3’ and voidstts = ‘0’

and locncode in (‘XXX’ , ‘YYY’)