Payment Document number in bnk_moni is not matching with generated XML EndtoEndID.

[Former Member]

Hello Guys,

We are planning to implement HR payroll payments (new payment method) for few banks so, I did few test payment for payroll through BCM for one bank.

The Payment medium is created in BCM and received by bank. But the Acknowledgement got failed at transaction level due to miss match of Payment document number in BNK_moni and XML EndtoEndId node.

In BNK_moni the payment document number in batch is showing just "2", instead of 10 digits "XXXXXXXXXX" document number.

For Vendor payments it is working fine. I can see the BNK_moni payment document number is matching with EndtoEndId in XML.

Could you please let me know where it went wrong. For HR payroll payments is it different process through BCM.

Regards,

Ethan.

[former_member229024]

Hi Ethan,

In BCM, the process is not different for any payment method. Double check the new payment method configurations like OBMP1/3, DMEE setup for ENDTOENDID (may be doc number+companycode+year), also if possible post the bnk_moni screen shot for the payment in issues.

Cheers,

[Former Member]

Hello Ravish,

Thank you for the reply.

Yes, You are right for vendor it is showing the clearing document number in this way "<EndToEndId>companycode+documentnumber+year</EndToEndId>.

Today I have identified that For Payroll it is showing differently <EndToEndId>Last four digits of vendor+sequence number</EndToEndId>

Also figured that the Name4 filed not populated any data for specific run ID and Identification in REGUH Table.

Do I need to change any thing in DME Rules to populate the Name4 Filed in REGUH. Because for other payment method it is working fine and populating the Name4 filed and also payment document number as "2".

I think for HR they are maintaining it differently like Name 4 as  "companycode+documentnumber+year" and payment document number as "1,2 etc"

Filed Name4 contains the Document number.

Could you please help me in identifying why it didn't populate any data in it.

Regards,

Ethan.

[Former Member]

I have a general question Ravish.

How does Payment document number and name 4 is generated in RUGUH table in sap when we run F110 or Payroll standard program.  ???

[former_member229024]

Hi Ethan,

The REG* tables are the standard sap tables which gets populated with the payment program data like REGUH- settlement data from f110, REGUP - processed items from F110 etc..

Cheers,

[Former Member]

Thank you Ravish,

Sorry was not feeling well these days and didn't get time to to reply you back.

My ticket is still open and I am working on it.

As I said you earlier, The EndToEndId in XML is the combination of <last four digits of vendor+sequence number +0> where as in Bnk_Moni (payment document number) it is just showing "1".

ACK which we received from bank will be compared with Bnk_moni (payment document number), as both are different it is failing there.

Finally the status is getting updated as Rejected by bank.

It would be great and helpful if any one can help me or provide your ideas on it.

Thank you,

Ethan.