Need help with aging

[Former Member]

Hi,

I have this problem again. In aging, if the invoice is of a back date and the payment has been made later, the two dates can fall in different periods of aging. So for example, if aging is current, 30 days, 60 days, 90 days and over 90 days. For each customer, there are different open items and suppose the first invoice was made on April 15 2005 of $1000 and a payment of $500 dollars was made on June 22 2005, and another invoice was done on May 15 2005 and another payment was made on June 20 2005 for this invoice, these are two different amounts that would be due for this customer for different open items. Now can somebody help me with this. This scenario can be seen in the Current Balances FD05 or one of those transactions under accounting in the SAP menu.

Can somebody help me with the implementation of this calculation of amount concept?

Thanks & regards,

AM

[Former Member]

Te transaction that I mentioned is FD10N.

Need help with this. If anybody has any idea about this please let me know asap.

Thanks,

AM

[andreas_mann3]

Hi AM,

i can tell you what we do in Germany in that case:

-> in a Z-Program ,which selects open customer items ,

the field bldat in all invoices of the cusomer is set to the eldest (debit-) item

-> in your case: 15.04.05

-> the report is the base to depreciate accounts receivables

-> pls ask your account department

regards Andreas

[Former Member]

Hey Andreas,

Is there no other way to do this implementation? I tried to debug through the FD10N transaction but I couldn't follow everything. Can you suggest any function where I can check if its an invoice and its date or some other function or logic which may work? I need to code it somehow. The accounts department will not do anything about this.

Please let me know.

Thanks & regards,

AM

[andreas_mann3]

Hi AM,

-your question:...I can check if its an invoice and its date or some other function or logic which may work? ...

-> you'll find all data in bsid:

- invoice normally has Debit indicator (normally <b>S</b>)

- date is bldat or zfbdt

- fm is BAPI_AR_ACC_GETOPENITEMS

sorry , but your queries are confusing me :

you're talking from aging , fd10n, fd05 ,...

pls try to formulate more precise

regards Andreas

[Former Member]

Hi Andreas,

Thanks for your reply. In FD10N there is a table which pops up which lists the open items and details. When you view one of these entries and debug through it, you can view the program running behind it. That is what I was talking about. I don't know how to use function modules. Can you give me an example? How do I use a FM bapi? Also it will only give me a list of open items which can also come from bsid. but still please explain.

The fields that you have mentioned, I have looked at them already. But can't figure out a way to relate the date of invoice to a payment. That is the problem. Also can you tell me how to view the source code or program of a report for example, we have S_ALR_87012178 which does exactly what I have to do, so I wanted to take a look at the source of this to check the program running behind it.

Can you help?

Thanks,

AM

[andreas_mann3]

HI,

1) TA S_ALR_87012178 = RFDOPR10

-> you can get this info with system-status

2)example for fm:

REPORT zforum31 .

PARAMETERS: bukrs TYPE bapi3007_1-comp_code,
            kunnr TYPE bapi3007_1-customer,
            stida TYPE bapi3007-key_date DEFAULT sy-datum.

DATA ret TYPE bapireturn.
DATA itab TYPE TABLE OF bapi3007_2.

CALL FUNCTION 'BAPI_AR_ACC_GETOPENITEMS'
     EXPORTING
          companycode = bukrs
          customer    = kunnr
          keydate     = stida
     IMPORTING
          return      = ret
     TABLES
          lineitems   = itab.

3) relate the date of invoice to a payment...

> what do you mean with that statement ?

-> do you want to match invoice and payment ?

regards Andreas

Message was edited by: Andreas Mann

[Former Member]

Thanks for the reply, Andreas. I will try this.

Yes, I am talking about matching the invoice to payments. That was my earlier question too. The very first one.

Thanks,

AM

[andreas_mann3]

Hi AM,

-> for matching invoices with payments look at

TA FB05 / F-32 or report SAPF124

pls don't forget to reward points, if answers are useful to you

regards Andreas

[Former Member]

Hi,

I will definitely reward you with points. have done it before too.

Can you tell me the way to look at these reports? I can''t seem to be able to see the source of there the way I can see other source by debugging through them.

Thanks,

AM

[Former Member]

Another thing Andreas,

By TABLES

lineitems = itab.

what do you mean, the line items of the table that I want to write to a file? or what.

Please explain.

Thanks,

AM

[andreas_mann3]

Hi ,

you can execute the report - it works fine

itab is the output from the fm.

(here your open items of the customer)

regards Andreas

[Former Member]

Hey Andreas,

I was working through the report s_alr_87012178 (RFDP...10) and found two structures FAEDE and BSEGA. Have you used these? IF you have can you help me use these to implement aging or even if you have not, can you still help me with it?

Its very urgent. I need help man.

Thanks & regards,

AM