Click here to Skip to main content
15,445,641 members

Comments by Alexis Gaitan (Top 13 by date)

Alexis Gaitan 31-May-21 10:47am View     CRLF
need to get something like this, i need to subtract 6757.26 - 90.29 accountcode DocEntry PaymentCode OtherPaymentAmount CashAmount TotalAmount sapcreditcard FileName BPA_ProcessStatus ERP_PaymentProcessed CWM 332 1 NULL 6,666.97 6,666.97 NULL TX.1_20210515.xml N N CWM 332 6 8989.97 NULL 8989.97 1 TX.1_20210515.xml N N CWM 332 7 4514.5 NULL 4514.5 2 TX.1_20210515.xml N N
Alexis Gaitan 26-May-21 12:46pm View     CRLF
accountcode DocEntry PaymentCode OtherPaymentAmount CashAmount creditnoteamount TotalAmount sapcreditcard FileName BPA_ProcessStatus ERP_PaymentProcessed CWM 332 1 NULL 6757.26 NULL 6757.26 NULL TX.1_20210515.xml N N CWM 332 11 90.29 NULL 90.29 90.29 28 TX.1_20210515.xml N N CWM 332 6 8989.97 NULL NULL 8989.97 1 TX.1_20210515.xml N N CWM 332 7 4514.50 NULL NULL 4514.50 2 TX.1_20210515.xml N N i need to subtract the column cashamount with record paymentcode =1 and column creditnoteamount paymentcode = 11 and combine it in to one record
Alexis Gaitan 7-May-21 8:43am View    
nevermind i just got it from your query i made some modifications and works perfect, thank you very much
Alexis Gaitan 7-May-21 8:27am View    
I modified my question, as now i need yes or yes a cashamount and otherpayment columns, in order to integrate later with my systems.
Alexis Gaitan 7-May-21 8:13am View     CRLF
at least im needing this: accountcode DocEntry PaymentCode OtherPaymentAmount CashAmount sapcreditcard BPA_ProcessStatus ERP_PaymentProcessed CWM 238 1 NULL 0.29 NULL N N CWM 238 1 NULL 29.00 NULL N N CWM 238 1 NULL 29.58 NULL N N CWM 238 9 18.00 NULL 4 N N i edited my question so to show this expected result: accountcode DocEntry PaymentCode OtherPaymentAmount CashAmount sapcreditcard BPA_ProcessStatus ERP_PaymentProcessed CWM 238 1 NULL 58.87 NULL N N CWM 238 9 18.00 NULL 4 N N