Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Payment Run - allocation does not work
05-03-2013, 01:39 AM,
#1
Payment Run - allocation does not work
Hi guys

I have a production installation with a glitch in payment allocation for my suppliers. If I choose Payables > Payment Run Report > Print and Process Payments the actual allocation of payments does not properly work. Some of the payments do not show the allocation details, i.e. which invoices were covered by the particular payment. The system marks both payment and invoice/s as allocated but there is no link between the allocations and when the next time the same supplier has a due invoice the payment report will show the old paid invoice with the zero value plus all new due invoices. I guess it is a result of the broken link in allocations.

I've done a test in demo to simulate this problem:
After selecting Payment Run Report (suppliers in Pounds, 31/05/2013, GBP Account) system has processed payments into the respective 2 suppliers' accounts:

http://www.weberp.org/weberp/SupplierAll...ocTrans=21

http://www.weberp.org/weberp/SupplierAll...ocTrans=22

However, the last link is ok as allocation info is available in suppliers account, the first one is not. If you open http://www.weberp.org/weberp/SupplierAll...ocTrans=21 it will show 95.25 left to allocate, nothing to allocate to and the actual payment and invoice for CRUISE were marked as allocated.

Any ideas on why allocation does not work in some cases?

Many thanks
Kosta


Reply
05-10-2013, 05:39 PM,
#2
RE: Payment Run - allocation does not work
Can it be added to the bug tracker and fixed in the next release?

Thanks
Kosta
Reply
10-17-2017, 08:40 AM,
#3
RE: Payment Run - allocation does not work
I have just spotted the behavior described above, regarding the allocation of payments to supplier invoices following payment runs.
It affects my production and development installations running webERP 4.14.1.

On PaymentAllocations.php I receive this message:
WARNING Message Report : There may be a problem retrieving the information. No data is returned

On SuppWhereAlloc.php I receive this message:
INFORMATION Message : There are no allocations made against this transaction

In database table suppallocs, there are many allocations missing. When comparing the allocations in the database to a Payment Run Report PDF, it appears that only the allocations for invoices belonging to the last supplier (alphabetically) on the report are posted to the database.

PaymentAllocations.php and SuppWhereAlloc.ph appear to function correctly for transactions which have been correctly posted to suppallocs.

Could this be an issue in SuppPaymentRun.php, following thru into PDFPaymentRun_PymtFooter.php ???

Does anyone else see this behaviour?

Andy.



https://www.linkedin.com/in/andrewcouling
Reply
10-18-2017, 10:13 AM,
#4
RE: Payment Run - allocation does not work
Dear all,

Yes. It's should be fixed. Thank you for your reporting.

Best regards!
Exson
Reply
02-21-2018, 09:18 PM,
#5
RE: Payment Run - allocation does not work
Just bumping this thread.
Is anyone willing to take a look at this?
I think it goes beyond my capability and knowledge of the system.

In addition to fixing the bug, I wonder if we would need a script to fix-up the suppallocs db table where entries are potentially missing as a consequence of the bug.

Andy.
https://www.linkedin.com/in/andrewcouling
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)