Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Consolidate balances for account that is both customer and vendor

If a company is a customer and vendor, allow them to "pay" their AR invoices by using what you owe them on the AP side. Also consider netting the option to net the balances.

  • Guest
  • Nov 3 2014
  • Future consideration
  • Attach files
  • Shanmugam Pachapan commented
    01 Jul 15:09

    Most of our clients in trading and distribution need this functionality to contra the company account as customer & vendor. When will it be releases? We need this if possible.

  • Angelo Pickard commented
    July 22, 2019 09:12

    Is this feature going to be included anytime soon? The majority of our customers are asking for this feature

  • Gary Jensen commented
    June 05, 2019 16:03

    This is a great way to show the benefit of our business account function.  I would further suggest that we allow an existing customer / vendor to be combined when the ID'are different but it is the same record. For example a install comes from a legacy system where we do not have this function, they have a vendor record and and a customer record, we should allow them to change one or the other id to match.

  • Cosmin Antohe commented
    May 07, 2019 06:48

    May use an Cash Account (instead of an treasury GLAccount you may associate an accrual GLAccount) as an intermediate compensation account; You increase it closing the customer balance amount and decrease it when you close the Vendor liability. 

    Keep in mind that some transactions of this type may be restricted by law in some countries base on money laundering rules. Using the Cash Account may help identify this type of transactions more easy;

  • Sergey Vereshchagin commented
    August 15, 2017 08:20

    Was promised in 2009 if recall correctly, still not there...

  • Tim Rodman commented
    February 13, 2017 18:54

    This is known in some systems as a settlement process between Accounts Receivable and Accounts Payables. I'm mainly adding this comment to get Google to see the word "settlement" in case people search for it :)