Skip to Content

Blank payment type

Hello,

I'm running the flowing statement to receive sales report from customer checkout manager running on SQL server database, some of the sales transaction marked as NULL in payment type, how come the payment type is NULL?

select t0.OBJECTKEY, t0.id as 'DocNum', t2.EXTERNALID as 'ItemCode', t0.BUPAEXTERNALID as 'CardCode', t0.POS_SYSTEM_ID as 'PointOfSaleCode', t0.id as 'ReceiptCode', t4.ACADEMICTITLECODE as 'IntrntSite', t4.DATEOFBIRTH as 'Password', t4.S_COMBINEDNAME as 'CardName', t1.[DESCRIPTION] as 'Dscription', t2.PRODCATID as 'ItmsGrpNam', QUANTITYTYPECODENAME as 'unitMsr', t1.UNITGROSSAMOUNT as 'UnitPrice', t0.TOTALNETAMOUNT as 'DocTotal', cast(t0.BUSINESSTRANSACTIONDATE as time) as 'DocTime', t0.PERCENTAGEDISCOUNT as 'DiscPrcnt', t0.DISCOUNTAMOUNT as 'DiscSum', sum(t1.QUANTITY) as 'Quantity', case t3.PAYMENTFORMCODE when 02 then 'Credit' when 09 then 'Cash' else NULL end as 'Payment_type', t0.TOTALNETAMOUNT as 'SumApplied', cast(t0.BUSINESSTRANSACTIONDATE as date) as 'DocDate', t0.TOTALGROSSAMOUNT as 'TotalBeforeDiscountAndTax', t0.TOTALTAXAMOUNT as 'TotalTaxAmount' from [CCOS].[RECEIPT] t0 inner join [CCOS].[SALESITEM] t1 on t0.OBJECTKEY=t1.RECEIPT_OBJECTKEY left join [CCOS].MATERIAL t2 on t1.mat_key = t2.OBJECTKEY left join [CCOS].[PAYMENTITEM] t3 on t0.OBJECTKEY=t3.rec_key AND T3.STATUS = '2' left join [CCOS].[BUSINESSPARTNER] t4 on t0.BUPAEXTERNALID=t4.ID --where t0.POS_SYSTEM_ID='P001' --where t0.ID = 'NEW1100001132' group by t0.POS_SYSTEM_ID , t0.id , t1.[DESCRIPTION] , t1.UNITGROSSAMOUNT , t0.DISCOUNTAMOUNT , t0.TOTALGROSSAMOUNT , t0.TOTALTAXAMOUNT, t0.TOTALNETAMOUNT , t0.BUPAEXTERNALID, t2.EXTERNALID, t4.ACADEMICTITLECODE, t4.DATEOFBIRTH, t4.S_COMBINEDNAME, t2.PRODCATID, QUANTITYTYPECODENAME, t0.BUSINESSTRANSACTIONDATE, t0.PERCENTAGEDISCOUNT, PAYMENTFORMCODE, t0.OBJECTKEY order by docdate desc

Kind regards

Nir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 28, 2019 at 01:34 PM

    Hello Nir,

    In your statement you are saying:

    case t3.PAYMENTFORMCODE when 02 then 'Credit' when 09 then 'Cash' else NULL

    The PAYMENTFORMCODE = 20 (which corresponds to a payment by voucher) would then be shown as NULL.

    Hence, please check if the NULL results are of Payment method Voucher.

    Kind regards,

    Gunther

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2019 at 05:09 PM

    Hi Nir,

    Perhaps you can continue troubleshooting from the UI:

    1. What does one of the affected receipts look like in the SAP Customer Checkout manager (Receipts tile -> receipt details -> payment items)?
    2. What payment details are shown for this receipt in the SAP Customer Checkout (receipt search via magnifying glass -> display -> payment details)?

    Can you provide a few screenshots of the above?

    Kind regards,

    Gunther

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.