Issue in Clearing & Reset Clearing- FPMA & FP07

[muhammadfahad_raza]

Dear experts:

We are having issue during clearing process via FPMA, Following process is being used in our organization for partial clearing:

1- Business Partner is issued a billing invoice and same is updated in BP's billing document Reference header Field. BP makes the payment against the same reference number in the bank and Bank sends us bank statement on daily basis mentioning the Reference and amount only, so reference number is used for clearing open items. Sometimes, Payment is entered without mentioning the Reference number due to some missing information, So clearing happens on reference number or otherwise on Contract account level.Clearing Variants are Attached herewith:

clearing-variant-step-10.jpg

clearing-variant-step-20.jpg

Clearing works fine when Reference Number is used, If we do not maintain the reference number in any one of the billing or payment document, the clearing process creates an unbalanced clearing document with single line item. Kindly advise, where is the issue.

clearing-fpl9.jpg

clearing-document.jpg

Secondly, If I want to reset this unbalanced, clearing document, it asks to maintain main and sub values in posting area 1091. Kindly, advise, which main and sub values need to be maintained in this config.

[william_eastman]

Syed - I don't understand your statement about secondary clearing step. The system cannot/does not create an unbalanced clearing document.

[william_eastman]

Your picture of clearing document is a standard scenario. It shows that document 1000002426 cleared receivable 9000020539. I don't see an issue.

[muhammadfahad_raza]

Dear William,

Thanks for your response. Basically, the clearing should have happened between document types CR(5100002705) amounting PKR 78600 and YF (300000251) PKR 129200. But system done the clearing only for CR document type line item and created the new clearing document (CD)100002426 Amounting PKR 78600. The issue is in DFKKOP Table, the line items and amount against document Type YF are showing less and only for open items (129200 Minus 78600= 50600). The clearing document info I am unable to balance in DFKKOP. This wrong document allocation has lead to our inconsistent reporting issues. So, your expert advice is requested once again. Please, visit attachements.

dfkkop-line-items-for-bp.txt

cr-payment-document.jpg

[william_eastman]

Then it sounds like you have a reporting issue because the document is NOT incorrect. I would suggest you analyze the logic of the report with someone who understands how clearing works and what database updates occur. Only then would you get to a good solution.

[william_eastman]

Posting area 1091 is used for FPL9 - so you maintain it with transactions that will be used to provide users with info about what happened. Standard main transaction 0625 might be useful here -but you should check your system.