#2668 negative Allocations Amount for AR Receipts

R2.6.3
closed
nobody
5
2007-12-11
2007-10-23
Kai Egbert
No

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

Discussion

  • contract16

    contract16 - 2007-10-23

    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

     
  • Kathy Pink

    Kathy Pink - 2007-10-24
    • assigned_to: kmpink --> nobody
     
  • sboda

    sboda - 2007-10-24

    Logged In: YES
    user_id=1705860
    Originator: NO

    Hi Kai,

    How you choose AR Invoices in payment selection (Manual)?

    Thanks,
    Sabitha

     
  • sboda

    sboda - 2007-10-24
    • status: open --> pending
     
  • Kai Egbert

    Kai Egbert - 2007-10-25

    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

     
  • Kai Egbert

    Kai Egbert - 2007-10-25
    • assigned_to: nobody --> sboda
    • status: pending --> open
     
  • Kathy Pink

    Kathy Pink - 2007-10-25
    • status: open --> pending
     
  • Kathy Pink

    Kathy Pink - 2007-10-25

    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

     
  • Kathy Pink

    Kathy Pink - 2007-10-25

    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.
    ***

     
  • Kai Egbert

    Kai Egbert - 2007-10-26
    • assigned_to: sboda --> kmpink
    • status: pending --> open
     
  • Kai Egbert

    Kai Egbert - 2007-10-26

    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.

     
  • contract16

    contract16 - 2007-10-26

    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

     
  • Kathy Pink

    Kathy Pink - 2007-10-26

    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

     
  • Kathy Pink

    Kathy Pink - 2007-10-26

    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.
    ***

     
  • Kathy Pink

    Kathy Pink - 2007-10-26
    • assigned_to: kmpink --> sboda
    • status: open --> pending
     
  • Kathy Pink

    Kathy Pink - 2007-10-26
    • assigned_to: sboda --> nobody
    • milestone: 746433 --> R2.6.3
    • status: pending --> open
     
  • Kathy Pink

    Kathy Pink - 2007-10-26

    Logged In: YES
    user_id=329831
    Originator: NO

    *** Reclassified as Bug ***

     
  • Kathy Pink

    Kathy Pink - 2007-10-26

    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

     
  • Kathy Pink

    Kathy Pink - 2007-10-26
    • labels: --> Allocation (Payment)
     
  • Kathy Pink

    Kathy Pink - 2007-12-11

    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

     
  • Kathy Pink

    Kathy Pink - 2007-12-11
    • status: open --> closed
     

Log in to post a comment.