Skip to main content
Solved

How to reconcile or Apply different Vendor and Customer Invoices?


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?

Best answer by joshmclaughlin94

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.

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img
  • Freshman I
  • 11 replies
  • December 5, 2022
Ram wrote:

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


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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings