Skip to Content

Query for Business Partner Past dues in SAP Business one

Dear All,

If a customer has any past dues, then an approval process should trigger while creating new Sales order for that customer. I need a query that I can use to setup my approval process in SAP Business One on HANA...

Thanks,

RV

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 22 at 08:28 AM

    Hi,

    Please check the below:

    SELECT DISTINCT 'TRUE' 
    FROM OINV
    WHERE "CardCode" = $[ORDR.CardCode] AND DAYS_BETWEEN(CURRENT_DATE,"DocDueDate") < 0 AND "DocStatus" = 'O'

    Regards,

    Bala

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 22 at 01:37 PM

    Hi Bala,

    Thanks for the solution..I am getting syntax error, incorrect syntax near $. I am running this query in HANA db.

    Thanks for the help!

    RV

    Add comment
    10|10000 characters needed characters exceeded