Back to connectors… Back to Sage 300...

Overapply A/R Cash Receipt (3 replies)

Zev Kizelnik
7 years ago
Zev Kizelnik 7 years ago

1. is it possible to overapply AR receipt?

2. Is it possible to somehow create an unapplied cash receipt when the doc number does not exist

I need to deal with the following errors

“3/7/2017 11:44:50 BJFRRKPH 11022 1140 - Invalid input. Specified amount is greater than the balance owing on the document. Cannot apply. “

“3/7/2017 11:44:49 BJFRRKPH 11022 BARHUN - 03/03/17 - CCB - 679.00 1020 - Invalid input. Document 732619 does not exist for this customer. “

Support
7 years ago
Support 7 years ago

Zev, unfortunately there is no way to over apply a receipt...this is part of the views.

You would need to perform a lookup to determine the balance, then apply only that amount to a document.

You can however have a balance left on a receipt document, so if you document total is greater than the total of allocations, then this should work.

D Dunn
7 years ago
D Dunn 7 years ago

In theory you could Map a calculated column that would take receipt amount less document balance to give you the amount to apply and create the receipt batch that way.  Any over applied amounts could go through a filter to create another batch.

Presumably you could also use Aggregate to create a new record to import into the same receipt batch along the same lines.  e.g. Create a calculated column, create a new record for over applied payments so that they came in as a 'new' calculated record in the same record set.

6 years ago
D Dunn 6 years ago

Closed due to inactivity.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close