Ratakan

Informations :

Showing List Data can be Void on the "Void Historical Payables Transactions Window "



select 
VENDORID as 'Vendor ID',
VCHRNMBR as 'Voucher Number',
DOCNUMBR as 'Document Number',
PONUMBER as 'PO Number',
case DOCTYPE when  1 then 'Invoice'
when 2 then 'Finance Charge'
when 3 then 'Misc Charge'
when 4 then 'Return'
when 5 then 'Credit Memo'
when 6 then 'Payment'
else ''
end 'Document Type',
DOCAMNT as 'Document Amount'
from PM30200 
where CURTRXAM = 0
AND DOCTYPE BETWEEN 4 AND 6

No comments