Applying unapplied cash before posting

Sef

Sef

VIP Member
Hi all,

Here is a little teaser for all A/R experts:
1) Receive a payment from a customer and do not apply to an invoice. This creates an RU document (for eg 1000 AUD)
2) Exit Receipt entry (P03B102), but DO NOT post the batch
3) Re-enter P03B102, find the batch again and offset the unapplied cash against one or more invoices and accept.

Result: Invoices now show as paid, but unapplied cash remains. When inquiring on the payment the details show:
Amount applied = 1000
Amount unapplied = -1000

The issue does not occur, when the batch is posted before offsetting against invoices.

The A/R manual (in a round about way) says that unapplied cash must be posted before offsetting, but there is no way to ensure this is actually done.

*** Has anybody else encountered this issue?
*** What did you do to fix (modify) or prevent this. Did you choose a procedural solution or did you maybe apply a mod that prevents selection of unapplied and unposted amounts. Or is there maybe a setup we are missing?

Any help/feedback is greatly appreciated

Rgds,
 
Sorry, I forgot to include the specifics on the release level. We are using OW XE SP17.1 on NT with Oracle database.
 
Sef

This is a real pain. The problem is that the original batch is not used when
reallocating cash and you end up with two batches which will not post. We
have trained our AR users so that they post their batches directly after
they enter them. This keeps it reasonably tidy. There is the odd occasion
where they do go back in and reallocate the cash before the original batch
is posted. I do not have a fix for you, but I can tell you how to get the
two batches to post (hopefully without looking like a cowboy). You need to
go in to the database with SQL and change the batch number of the F03B14
record from the batch where they reallocated the cash to the original batch.
This will allow the original batch to post and the second batch will be
empty.

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K

Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT/Oracle, B732/A73 on AS400, B733 on NT
 
Re: RE: Applying unapplied cash before posting

Hi Marty and other A/R specialists (where are you all??)

I am not sure if your issue is the same as ours. At our end the same batch number is used when you offset before posting, whilst a new batch number is used when posting first. Also we don't experience any posting errors as such.

However when inquiring in the Customer Ledger (F03B11) we see a negative gross amount against the RU record in the event the RU batch is posted, but see a Positive open amount if the RU batch is not posted prior to offset.

Rgds, Sef
 
Back
Top