Auto cash matching

[peterban]

Hi Guys,
I need some help on the above.....

I am in the middle of a data take on - just before go live as it happens ! - and have discovered to my dismay that Auto Cash Matching does not seem to like matching CR/IN/Cash together under the same generic reference for U7.
We are using R03B50D for this generic match.

To make matters worse it seems to work on standalone !

Has anyone found this problem - and can you point us in the right direction to fix the problem !

Many thanks in advance!

Regards

Peter

 

[peterban]

Hi!
Heres another gem from JDE.

Cash, credits and cash can be matched using the generic reference (and R03B50D) but there are a few conditions: -

1) The cash upload has to have records to match the credits e.g. 100USD cash in with a 10USD credit must be written to the file as two lines
100USD Cash in to apply 110USD for the overall amount
0 USD Cash in to apply -10USD (Minus) for the credit
This leaves a net of 100

2) This is the kicker - the credit numbers MUST be lower than the invoice number otherwise you will be left with two records with balances (netting out on a full match), rather than all matched.

My standalone worked as I'd picked up credits with a DOC before my invoices.... :-(

I hope this helps some of you .....

Cheers

Peter