AP question: PAYR table

[former_member857785]

Good Morning

I am not seeing any of my electronic payments on this table. I see all my checks but not my eft or wires. I understand the process is the check run and once the checks are cut, then there is the posting. We are in testing phase and my guess is because the actual interface didn't occur or posting to the payable for eft and wires, I am not seeing those on the PAYR report.

What could be the problem?

Points will be awarded.

THank you

[Former Member · Accepted solution]

I may be wrong but as far as I know, table PAYR only provides accounting payments based on checks.

Elias

[former_member857785 · Accepted solution]

Thank you Elias, that is what I am seeing

why? and what am I supposed to use to see EFT/ Wires?

Thanks!

[Former Member · Accepted solution]

Hi,

Normally, for EFTs, there will not be any checks. You can find the details of the payment(if it has run properly) in REGUP/REGUH tables.

If you want to generate dummy checks for EFTs, you can create cheque lots for the EFT payment methods. Once you do this, you will be able to see it in PAYR table.

Please revert for any clarificaton.

Thanks and Regards,

Anit

[former_member857785 · Accepted solution]

Thanks Anit-

Question, if this is true, I have a requirement where the business needs a report to show all payments including checks and electronic, I will not be able to use just the PAYR table but the other two? Is there a report out there I could use to generate?

thanks!

[Former Member · Accepted solution]

Wire transfers are normally output to a file layout which is bank specific.

Elias

[Former Member · Accepted solution]

Hi,

Suggest you to create dummy check nos for the EFT paymeny methods. This way the entries will get updated in the PAYR table and you can take report from the table. For ex - in India, the check numbers are 6 digits. We created check lots with 7-8 digits to distinguish between Checks and EFTs.

Please revert for any clarifications.

Thanks and Regards,

Anit

[former_member857785 · Accepted solution]

Thanks Anit and Elias,

In REGUP/ REGUH, what would be the best method in determining the electronic payments when there may be multiple payment runs for the same invoice?

Points awarded

[Former Member · Accepted solution]

Hi,

In the REGUP table, you have two document numbers - VBLNR which is the payment document number and BELNR which is the document against which the payment has been done (invoice).

You also have field for payment method in this table.

Hope this helps.

Thanks and Regards,

Anit

[Former Member · Accepted solution]

hi Anit,

could you advice how to configure dummy check for a EFT run?

thanks a lot

Keqin