calculation of outstanding.

[Former Member]

Hi Experts,

During calculation of outstanding which document type we take for calculation 1)RV 2)DZ 3)AB OR ALL.

We can see all this in fbl5n.

Urgent

Regards

Rahul

[Former Member · Accepted solution]

Hi all,

what is the document type for collection.

Regards

Rahul

[Former Member · Accepted solution]

Hello,

If you are asking about customer payment reciept, the it is DZ.

Regards,

SAM

[Former Member · Accepted solution]

Hi SAM,

then in fbl5n line item consist of outstanding or collection??

[jpfriends079 · Accepted solution]

Both items will be there collection & outstanding as well as normal items.

Outstanding/Overdue items will be supported with respective indicators either in bell icon or red thunder.

You can use Tcode S_ALR_87012178 for Customer Open Item Analysis(Overdue)

Regards

JP

[Former Member · Accepted solution]

Hi JP,

It will be very great full if you tell me in detail how customer outstanding is calculated in fbl5n. (With table and Feild names)

Regards

Rahul

[jpfriends079 · Accepted solution]

Calculation for Days overdue of the due items

Calculation: days in arrears = key date - due date for net payment

Following tables can be helpful.

TABLE	Desc
kna1	Data at the client level
KNB1	data on the company code level
knb4	payment Behavior
knb5	Dunning
KNKA	Customer master credit management: Central data
KNKK	Credit Control
KNC1	Traffic figures
knc3	special revenue
BSID	Offend items
BKPF	Accounting Document Header
BSEG	Accounting Document Segment

TABLE-FIELD	Desc
BSID-gjahr	current fiscal year
knb4-vzs01	days past due
KNKA-KLIMG	Total Limit
KNKA-Klim	Single Limit
KNKA-CURRKY	Currency
KNKA-DLAUS	last information
BSID-UMSKZ	revenue mark

For further information, you can refer code for program RFDOPR00.

Regards

JP

[Former Member · Accepted solution]

Hi JP,

I appreciate your solution.

Can you tell me during calculation of customer outstanding which type of document we have to consider like, DA,DR,SA,DZ,RV,AB ETC....

Regards

Rahul

[Former Member · Accepted solution]

Hello,

Check your billing document types for this. For customer invoice you may have one accoutnign document type (standard is RV), customer credit memo and debit memo you will have different accoutnig document type. Check the respective billing document type to find out the accountig documen type. The customer payment document type is DZ.

Comapre these documen types to find out the total outstanding.

Regards,

SAM

[jpfriends079 · Accepted solution]

As in standard, based on

- Document date

- Baseline date for payment

- Term of payment 1

- Term of payment 2

- Net term of payment

- Key date

Due date for net payment of the item: (baseline date for payment + net days) is calculated

This is done on following doc type

DA - Customer document

DG - Customer credit memo

DR - Customer invoice.

IC - Intercompany Posting

RV - Billing doc.transfer

Regards

JP

[Former Member]

Hello,

There are different accouting documents we use for different business transactions.

The document type RV is for accounting document created by SD invoice. Similarly for Document type DZ is stands for Customer Payment received.

When you create a billing document, normally it posts RV document type to accounting, bu it all depends upon the configuration.

FBL5N will show all the open items irrespective of the document types will be displayed.

Once the setoff happens for the open items, it will disappear from the report.

Regards,

SAM

[Former Member]

Hi

It depends on configuration which document type for FI is using. Generally RV will be maintained provided number range for billing document and RV is same, besides this where in copy control from delivery document to billing document ( LF -> F2 ) assignment same as billing then RV document is ok other wise ZRV or any Z fi dcoument type applicable.

So outstanding of ( if RV has to be properly evaluated )

Regards,

Veeresh

[Former Member]

Hi,

as per my knowledge Its RV.

Thanks,

Neo.

If helps.. Text Removed

Edited by: Lakshmipathi on Nov 29, 2011 12:16 PM Dont ask for points