can we do two condition in query (sq01)

[former_member625419]

HI Friends,

I had made customer ageing report from SQ01(Query),It's running fine in Qurey.It's document & amount is coming in the Diffrent & diffrent basket as per requirment (EG: 0-45 days, 46-60 days, 61-90 days etc....), but I have some qurey.

Eg:If customer Billing date+Payment term= Document date is coming in right basket.

Doc no :XXXXXX and payment term = 45 days, then it's coming in the 0-45 days basket, It's amount shown in report column "Amount DUE".if the DOC no:XXXXX is more than 45 days it's shown in 46-61days.

here My quesation if Document date+ payment term is more than 45 days, it's shown "Amount overdue" column. not in "Amount Due " Column , is it possible in query?

thanks

regards,

Rupang shah

[madhusoodanan_ramachandra]

Hi,

It is possible but it is advance level of query creation. You may need to define additional fields in SQ02 and write code to pick relevant values.

Recommended approach is to go with an ABAP development.

Best Regards,

Madhu