Correct amount validation in payment lot

[Former Member]

As per my knowledge while uploading the items in payment lot , if user made a mistake in putting amount or contract account and post the payment lot then we receive the status of payment lot is 4. In order to smoothen the the process we need to run return lot. My client needs validation of amount matching before posting the payment lot so that he can avoide return lot process. Experts please advice

[AmlanBanerjee]

Hi Ozair,

What is the reference that you are thinking for matching the amount before posting?

I don't think it can be outstanding receivable against the customer account as the payment can be a over payment or an under payment apart from an exact match.

The reconciliation that you are talking about has to happen outside SAP, until and unless there is some feed coming into SAP.

Can you be more specific about your requirement.

Thanks,

Amlan

[Former Member]

Hi Amlan,

I appreciate your quick reply. Actually my client does not allow posting partial payments or over payments ( they are restricted from their parent company). Their collectors receive the complete amount of the bill and the end users updated in payment ( through an upload). They are trying to avoid human error before posting the payment lot as the number of entries are very high per user. They are thinking of a validation check of receiving payment if payment is equal to the outstanding receivable of a contract account or not. Let me know if more explanation  is required.

[Former Member]

Hi ,

       I think you have build that logic into your upload program , which uploads payment file into sap directory (T-code -AL11) before it is posted in sap through FPB3.

                                                                                            you have to find the open items of ca and show it against the payment received for reconciliation process.

                                                               OR

                                                                          you have to add BAR-CODE to the bill that is sent to the customer , and your collector needs to implement (in what ever software they use ) ,that payment is not accepted ,unless payment amount is equal to amount in BAR-CODE of bill.

[Former Member]

Hi Santrupta,

Actually I made an upload of change payment lot with the help of my ABAPER. End users ( who interact with Collector) download the receivables from one custom report and the upload through payment lot change. The items in payment lot updated but do not verify the amount until they post the payment lot. I hope it is clear now.  

[Former Member]

Hi ,

       Would like to know how you upload your payment file which you receive from your collectors into sap .

          My guess is that you have created an custom interface to upload the file into sap directory ,and you provide this path of directory  in FPB3 to post it into CA and bank accounts .

   Can you explain how you do it in your system.

[AmlanBanerjee]

Hi Ozair,

When you are uploading through the payment lot change, add in a extra functionality, where in for each contract account it will trigger the FM FKK_ACCOUNT_BALANCE_COMPUTE.

Once done, if the export parameter E_SUM_OPENITEMS of the FM is not matching with the amount against the contract account in the file, then delete that record from further processing.

You can write a log for the unprocessed records and then check it manually.

Once the above check is done, only then proceed forward to post the payment lot.

The only scenario, I am thinking-off will not be catered with the above logic is;say there are two outstanding invoices-$ 50 and $200..Customer make a payment for 200 and not the 50. Then it be a mismatch and will have to be checked manually.Is this a valid scenario in you Business context?

Hope it helps...

Thanks,

Amlan

[Former Member]

Hi,

As I understand, you want to check the amount being posted thru Payment lot against the open item for the Contract Account.

Please use Event 242 to perform this check. This event will be called for every item in the payment lot.

Use FM FKK_ACCOUNT_BALANCE_COMPUTE to get the open items amount and compare with the amount coming from the file thru Payment Lot. In case of miss match through a error message. This error message put the line item to post processing required. The user will be able to analyze and make change required and process the item.

Please check the event 243 which will be called while adding an Item to the payment lot.

If you do not want to post processing, then the validation needs to be done before the Payment Lot process.

Thanks,

Rajessh