Cash Receipt date greater than Invoice date validation

Naveen_Kumaar_P · October 12, 2020, 5:54am

Hi,

Anyone knows how to do in cash receipt entry, Cash receipt date greater than Invoice date validation.

prash172 · October 12, 2020, 6:12am

@Naveen_Kumaar_P
Is my below understanding is correct ?

Invoice
InvoiceNum :0001
Invoice Date:12/10/2020

Cash Receipt
GroupID:- 001
Bank:- ABCD
Transaction Apply Date:- 11/10/2020.

This transaction should not be allowed, because the cash receipt transaction date is lesser than the Invoice date .

Arul · October 12, 2020, 1:10pm

Create a BPM in Cash Receipt Entry.

Naveen_Kumaar_P · October 13, 2020, 4:46am

@prash172 Ya correct. same thing or current period greater than means not allow.

Naveen_Kumaar_P · October 13, 2020, 4:47am

@Arul Tried not working, Can you tell which method have you done.

prash172 · October 13, 2020, 5:36am

@Naveen_Kumaar_P
In this case why don’t you make the transaction date filed as readonly

Naveen_Kumaar_P · October 13, 2020, 5:50am

@prash172

we need the transaction date changeable, a current period greater than the invoice period means not allow.

Back dated transaction they will do in cash receipt date. example 09th month,

Cash receipt date 13/10/2020

invoice date should not 01/11/2020

sorry, wrongly mentioned what I asked before.

prash172 · October 13, 2020, 7:55am

@Naveen_Kumaar_P
Try finding the method at “Retrieve” or “Apply” through trace.
My be the method is “Erp.CashRec.SelectInvoices”
BPM validation comparing Invoice date and transaction apply date.

Naveen_Kumaar_P · October 14, 2020, 4:38am

@prash172

Have you tried this, I’m not getting the output.

Can you help with this?

prash172 · October 14, 2020, 8:36am

@Naveen_Kumaar_P

I have not tried.

prash172 · October 20, 2020, 7:42am

@Naveen_Kumaar_P
In Transaction Data Directive in CashDtl Table, will work.

Naveen_Kumaar_P · October 21, 2020, 7:22am

@prash172 above data is working. Thanks.

need to change the condition.
If the cash receipt date is 21/10/2020 and the invoice date also in the same month 30/10/2020 this no need for validation. greater than that period means invoice date 01/11/2020 needs to validate. is it possible? Any idea.

Mark_Wonsil · October 21, 2020, 11:15am

Quick question: When would one ever receive cash in the future?

At least when following any generally accepted accounting practices.

Naveen_Kumaar_P · October 21, 2020, 11:20am

@Mark_Wonsil

Account users checking the report Within that period ok. they are checking period wise report not date wise only.

so within that period means we need this condition.

Mark_Wonsil · October 21, 2020, 11:26am

But in this case, it still works right? If it passes the day test then you’re not in a future period too. If cash was received at the end of a previous period but the current date is in the next period then this test works to prevent that cash from going to the end of the current month. Can you show a case where the current date test doesn’t work?

Naveen_Kumaar_P · October 21, 2020, 11:30am

this case not working. tried.

Mark_Wonsil · October 21, 2020, 11:34am

So what’s wrong is the Invoice Date? If you’re receiving cash before Invoicing then people usually will put that on account or in an Advance Payment on that order and then apply it later once invoiced.

I thought you were trying to apply cash in the future. Because if you could predict that, you’d make more money in banking than IT!

Mark_Wonsil · October 21, 2020, 1:21pm

Hello Kumaar,

Maybe it’s me. I can be pretty dense at times. Can you explain the business problem first to make sure we all understand the motivation then post some code so we can see what you’re trying.

Thanks,

Mark W.