Skip to Content
-1

Vendor Report

Oct 12, 2017 at 10:06 PM

26

avatar image
Former Member

Hi Experts ,

I have a requirement to get the vendors due in next 20 days .

I created a SQ01 and created a extra fields .

I have got the day in arrear . If I look at FBL1N in I find that any item any which is days in arrear between 01 to -10 should be in report . if item not due in next 10 days then it should be in not due ,

I have created a field "Amount due in next 20 days " and coded as below

Clear AMOUNTDUEIN20DAYS.
IF DAYSINARREARS < 20 and DAYSINARREARS > 0.
move BSEG-DMBTR to AMOUNTDUEIN10DAYS.
endif.

And also defined the Days in Arrear

Clear DAYSINARREARS.
DAYSINARREARS = KEYDAT - DUEDAT.

Any help will be appreciated .

many Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
Oct 13, 2017 at 06:49 AM
0

If you want to get data similar to the detail FI reports FM, use same tool like FM ITEM_DERIVE_FIELDS or FM executed by this FM like DETERMINE_DUE_DATE.

Share
10 |10000 characters needed characters left characters exceeded