cancel
Showing results for 
Search instead for 
Did you mean: 

Goods Return from GRPO to backdate with error.

Former Member
0 Kudos

Dear all,

I've got a problem from copying Goods Return from GRPO to the backdate, for example, GRPO Posting Date is '2011-12-11' and Return Posting Date is '2011-11-11', the system threw the below error:

Reconciliation date must be on or after the last posting date for transactions selected for reconciliation [Message 3821-3]

I am using B1 8.82 PL00, the error never come before in older versions of B1.

Please help me,

Many thanks,

Doan

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

I'm having the same problem issuing an A/P Invoice based on the GRPO.

If the A/P Invoice is backdated (dated before the GRPO) the same message is issued and prevents the invoice from being saved.

It happens only on 8.82 PL00 (I've got a customer in Ramp-Up), it never happened before in previous B1 versions.

Any workaround for that?...this scenario really happens on my customer, he receives the GRPO and later he receives the A/P Invoice from the supplier dated a couple of days before...

Former Member
0 Kudos

Hi,

In your case, AP Invoice posting date should be later or on GRPO posting date and AP Invoice DocDate can be backdated.

Can AP Reserve Invoice be applied for your customer, that means AP comes first and GRPO comes later?

Thanks,

Doan

Former Member
0 Kudos

Hi Doan,

Thanks for your answer.

You're right, I can backdate the DocDate, but what matters is the posting date because of VAT reports.

This way, the VAT is due on a previous date, and now it cannot be issued correctly and VAT reports are all wrong.

This never happened before 8.82, why now?...

Regards,

Jorge

Former Member
0 Kudos

Dear Doan,

In your case, to backdate a Goods Return from GRPO is not logical. How could you possibly return any goods that was not received yet?

Thanks,

Gordon

Former Member
0 Kudos

Dear Gordon,

I try to correct the wrong one, in the past the customer did the return from the GRPO but forgot to change posting date of the return. The wrong process was: GRPO in Nov 2011 and Return in Dec 2011.

Thanks,

Doan

Former Member
0 Kudos

Oh, you just had typo in your first posting then.

However, after you posted the wrong document, the only remedy may be to create two standalone documents to reverse them. i.e. A GRPO same as Return date and a Return same as old GRPO date.

Former Member
0 Kudos

Hi!

I doubt this might be a new validation that would be included in 8.82

You try to put a stand alone Return (Click Copy to retun and just cut and paste the BP again without altering the row). Then Manually reconcill the Transaction to close that.

please test this in test environment.

Former Member
0 Kudos

Hi Thanga Raj.K,

I am using standard inventory valuation method so when I create a Return without basing on GRPO -> system just posts JE with standard cost value that differs from based GRPO carrying with variance amount.

That's why I am trying to create a return from GRPO.

Doan

Former Member
0 Kudos

Hi!

Have you tried posting the return.

Even in return it should post variance account, if your unit price differ's from the standared cost.

Former Member
0 Kudos

Hi!

Yes, it's right. Standalone return is not posting the variance. Then you should adjust the difference through JE.

Former Member
0 Kudos

Thanks all for your helps.

Doan

former_member541807
Active Contributor
0 Kudos

hi,

please check your Document settings. pls follow this path. Administration -->> System Initialization -->> Document Settings -->> General Tab. un-check the Check Box "Block Documents with Earlier Posting Date"

regards,

Fidel

Former Member
0 Kudos

Hi Fidel,

Unfortunately it did not work with 8.82 but worked well for 8.81, 8.80 and 2007 versions.

Thanks,

Doan