Skip to content
+1-888-319-3663

COMMUNITY FORUM

Cash Reciepts – Invoice number is not correct need to clear apply amount to process as unapplied

Brenda Hopkins asked 3 years ago
 
I have a cash receipts import setup to apply to Invoices.  Now I need to Process if the invoice # is not in the file, I would like to have SC import as unapplied.  I did setup the SQL Validation but that only checks to see if the invoice is correct or not it does not give an option to clear the apply amount, this is what I believe I need to do to get this to work. Where can I do this at?
 
I setup a restriction on the Apply Transaction Node to only pull if the Apply to Amount is greater than 0.00.
 
Brenda replied 3 years ago

Patrick

My Invoice Number does not match and my amounts are greater than zero. How can I add a restriction that says if the ApplytoInvoice Number is not in the RM20101 table DO NOT APPLY. this is my problem.

Patrick Roth Staff replied 3 years ago

Then in your restriction, make a .net connection to your GP db and query the RM20101.

If it is there and the amounts are ok, return true. If the document is not there or the amounts aren’t ok (as above), return false and SC will skip that apply record.

Brenda replied 3 years ago

How would I do the .net connection?

Brenda Hopkins replied 3 years ago

Let me ask this another way. I did create the .net connection and this appears to be doing what it is supposed to do. BUT……If one Customer Check has 900 Invoices being paid and only one of those invoice #s are incorrect, I need the correct invoice #’s to apply and skip the one Invoice # that does not match. This is not happening, the entire customer check is being skipped with an error that the Invoice is missing. HELP me resolve this please.

Patrick Roth Staff replied 2 years ago

“..and this appears to be doing what it is supposed to do”

By that you mean what? Connect?

In your restriction on the RM Apply node, you should:
1. connect to sql
2. run a query on the RM20101 table and look for the invoice you are applying to
3. if you find it, in the restriction return true
4. if you do NOT find it, restriction should return false

if you do this, on “true” then SC will try to apply the invoice because YOU told it that the invoice exists

on “false” then SC will skip that apply record because YOU told SC to skip that record because the invoice does not exist

Answers
Patrick Roth Staff answered 3 years ago
“I setup a restriction on the Apply Transaction Node to only pull if the Apply to Amount is greater than 0.00.” That would be what you would do. set your restriction to return true if you are happy with the data (ie apply amount > 0 and invoice number <> “”)
If you would like to NOT apply this line, return false.

If you would like to submit an answer or comment, please sign in to the eOne portal.