應收應付款沖銷
單頭裡面有事業處(AD_DeptOrg_ID) 必須修正
依據付款單號(C_Payment_ID )
UPDATE C_AllocaHead SET AD_DeptOrg_ID=1000058 -- C_Payment_ID,Ref_Payment_ID, ValutaDate
WHERE C_Payment_ID IN
(SELECT C_Payment_ID FROM C_Payment
WHERE DateTrx BETWEEN TO_DATE('2019/10/01','YYYY/mm/dd') AND TO_DATE('2019/12/31','YYYY/mm/dd')
AND C_BankAccount_ID IN
( SELECT C_BankAccount_ID FROM C_BankAccount
WHERE C_Bank_ID IN
(SELECT C_Bank_ID FROM C_Bank
WHERE RoutingNo IN ('1103.502','1101.405現金-SO','1103.503','1102.409現金SH-(SO)','1103.509','1103.508')
)
)
)
SELECT * FROM C_Allocation
應收應付款沖銷
單身裡面有事業處(AD_DeptOrg_ID) 必須修正
依據付款單號(C_Payment_ID )
UPDATE C_Allocation SET AD_DeptOrg_ID=1000058 -- C_Payment_ID,Ref_Payment_ID, ValutaDate
WHERE C_Payment_ID IN
(SELECT C_Payment_ID FROM C_Payment
WHERE DateTrx BETWEEN TO_DATE('2019/10/01','YYYY/mm/dd') AND TO_DATE('2019/12/31','YYYY/mm/dd')
AND C_BankAccount_ID IN
( SELECT C_BankAccount_ID FROM C_BankAccount
WHERE C_Bank_ID IN
(SELECT C_Bank_ID FROM C_Bank
WHERE RoutingNo IN ('1103.502','1101.405現金-SO','1103.503','1102.409現金SH-(SO)','1103.509','1103.508')
)
)
)
