Menu
▾
▴
#2668 negative Allocations Amount for AR Receipts
For contract16 we checked the following problems on Release 2.6.3 and 2.6.1.
If you create a payment through “Payment Selection (manual)” and select more than one sales invoice the generated payment (AR Receipt) will have a negative allocations amount.
To reproduce:
- Generate 2 or more sales invoices for same business partner with payment term immediate.
- Complete the invoices.
- Open “Payment Selection (Manual)”.
- Select the BP and refresh the window.
- Select 2 or more sales invoices from the list and process the payment selection.
- Open the created payment and check the Allocations-Tab. The amount is negative even if the document type of the payment is AR Receipt. The allocation on the sales invoice is also negative.
Regards,
Kai
Logged In: YES
user_id=1742483
Originator: NO
Just to add, if a single sales invoice is paid using the process described by Kai, then the payment works correctly and the allocation is a positive amount.
Problem is that the code goes 2 ways depending on if there are single or multiple invoices. The multiple invoice route check for a SO txn is not set correctly and so system believes that the sales invoices are purchase invoices.
Jeff
Logged In: YES
user_id=1705860
Originator: NO
Hi Kai,
How you choose AR Invoices in payment selection (Manual)?
Thanks,
Sabitha
Logged In: YES
user_id=1784380
Originator: YES
Hi Sabitha,
Below is an example how to set it up for Direct Debit.
You first create 2 or more AR Invoice with Payment Rule Direct Debit and Payment Term Immediate.
As GardenWorld has no Direct Debit Rules you have to create a new Bank Account Document for Direct Debit. Therefore select Window Bank, select Money Bank and go to tab Account and select Account No. 1234. Than create a new Bank Account Document record for Direct Debit.
No you can select this Payment Rule in Payment Selection (manual). The created AR Invoices should appear.
Regards,
Kai
Logged In: YES
user_id=329831
Originator: NO
could not replicate in 2.6.3 or the core code. Please make sure that you have set up separate banks and bank account info for the customer
Logged In: YES
user_id=329831
Originator: NO
*** Status set to PENDING *** If the issue solved, please CLOSE
this request - otherwise set the status back to OPEN (we only
check OPEN items). If there is no reaction within a week, the
system will automatically CLOSE it. To speed up response time,
you may want to consider a support agreement.
***
Logged In: YES
user_id=1784380
Originator: YES
I've tested it again with latest CoreMaint code. Everything is set up correctly. Would it otherwise work fine if you only select one invoice?
Again,
If you create a Payment for one AR Invoice and look at the Allocations tab of this payment, one record is created with the correct positive amount.
If you create a Payment for two or more AR Invoices and look at the Allocations tab of this payment, two or more records are created with the wrong negative amount.
Logged In: YES
user_id=1742483
Originator: NO
Hi,
To answer your question it works fine if there is only one sales invoice and one payment. The problem occurs when you make pay 2 or more sales invoices with one payment via Payment Selection (Manual). I have reproduced in 2.6.1 and Kai in 2.6.3.
To reproduce the steps in GardenWorld:
a) For Money Bank, in Bank > Account > Document create a new record with the Payment Rule of Direct Debit.
b) Find a BP (say Patio Fun) and add a Bank Account record.
c) Create 2 or more Sales Invoices for Patio Fun.
Set the Payment Rule to Direct Debit.
Complete the invoices.
d) In Payment Selection (Manual) select the Bank 2 or more of the invoices created above.
Process and create the Payment Selection record.
e) Payment Print/Export - export or print the payment selection.
f) Find the Payment record. Note it should be of the type "Receipt".
PROBLEMS
a) Check the payment allocations - it is set to "negative" values when they
should be positive
b) Check the Sales Invoice - even though a full payment the "Paid" flag on the
header is not set.
Reproduce the above for a single sales invoice and the payment allocation will be for a positive amount.
The problem is that in Payment Selection (Manual) for 2 or more invoices the system doesn't set the isSOTxn flag correctly, and thinks it is a PO transaction and hence puts the payment as negative.
Thanks
Jeff
Logged In: YES
user_id=329831
Originator: NO
could not replicate in 2.6.3 or the core code. Please make sure that you have set up separate banks and bank account info for the customer
Logged In: YES
user_id=329831
Originator: NO
*** Status set to PENDING *** If the issue solved, please CLOSE
this request - otherwise set the status back to OPEN (we only
check OPEN items). If there is no reaction within a week, the
system will automatically CLOSE it. To speed up response time,
you may want to consider a support agreement.
***
Logged In: YES
user_id=329831
Originator: NO
*** Reclassified as Bug ***
Logged In: YES
user_id=329831
Originator: NO
allocation is negative (this is incorrect)
The workaround is to go into payment allocations and offset the payment and invoice which display an open amount of 2 times the original because of the negative allocations
Logged In: YES
user_id=329831
Originator: NO
We are moving all Open Support Requests, Bugs and Feature Requests to Compiere Case Management. Please refer to the following link for information on creating new Support Requests.
http://www.compiere.com/support/community.php
Thank you