Payment

Tejaswini

Hi Experts,

I want to combine the vendor payment records into one
In that for vendor account no. 10000 the amount field should be 3000 which is the sum of two records amount and it should show one record of vendor 10000 instead of two

Same as for 20000 also

while exporting electronic payments into a file , the vendor payments should be consolidated in Gen. Journal Line

please suggest me to achieve this

Kishorm

Hi, You should combine them on the journal by ticking the "summarise by vendor" option on the "suggest vendor payments" batch job.

Tejaswini

yes, I tick that option but it didn't show the result

When I want to check in Gen. Journal Line it should show only one record as

For vendor 10000 - amount should be 3000
For Vendor 20000-amount should be 7000

please suggest me the code for it

Kishorm

That should work as that is exactly what that option is for.

What options are you entering when running the suggest vendor payments?

Also try in a clean CRONUS database - it could be that someone has made changes to the batch report.

Tejaswini

Thank you.