Friday, 29 March 2019

CANNOT RECONCILE DOCUMENT BELONGING TO DIFFERENT BRANCH

1.SELECT T1.[TransId], T0.[Debit], T0.[Credit], T0.[ShortName], T0.[BPLId] FROM JDT1 T0  INNER JOIN OJDT T1 ON T0.[TransId] = T1.[TransId] WHERE T1.[TransId] =317966

2.UPDATE JDT1 SET BPLD=3 WHERE TRANSID=317966



No comments :

Post a Comment