Solved

How to reconcile or Apply different Vendor and Customer Invoices?

  • 24 August 2021
  • 3 replies
  • 276 views

Hi Guys, can you give me an idea how to apply an Customer AR Invoice to another Customer Payment document? although both customer does not have parent child relationship.

or how include Vendor/Customer ID in Journal entry document?

icon

Best answer by joshmclaughlin94 7 December 2022, 20:49

View original

3 replies

Userlevel 1
Badge

Hi Guys, can you give me an idea how to apply an Customer AR Invoice to another Customer Payment document? although both customer does not have parent child relationship.

or how include Vendor/Customer ID in Journal entry document?

Hi @RAM,

Do you have solution for this.

Thanks so much

Userlevel 2

Without a Parent/Child relationship, there will not be an option to link an invoice and payment between two, unrelated Customers.

 

To apply non-related customer documents together will require a workaround using a clearing account:

 

You can enter adjusting documents: 

Customer 1 with Payment:  Enter Debit memo. Use customer clearing account in place of revenue. Apply payment to Debit Memo to close both documents.

Customer 2 with Invoice: Enter Credit Memo. Use customer clearing account in place of revenue. Apply Credit Memo to Invoice to close both documents.

 

The only way to insert specific customer/vendor data on a Journal Transaction is by creating the source document from within the respective subledger. Not able to insert customer/vendor data on a manual Journal Transaction. GL batch must emanate from the AR or AP modules.

Why acumatica not allowed to reconcile the vendor with customer or vendor with different vendor account just like other ERP applications. Although acumatica also have control account for every master form and also includes it in the journal transaction form?

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved