Sales order - period closed error in open period

[mpow...@gmail.com]

Dear all, 

I have created a new client (Initial client setup process). In the new client, I can't prepare/complete my sales order due to error message: Order 50002: Grand Total=1500 - Period Closed.

I have double checked that period January 2016 is open across all base document types. I found the following warning/error messages in my log:

The error messages are:

16:48:06.141-----------> MPeriod.isOpen: Could not find DocBaseType for C_Order [33]

16:48:09.621-----------> MPeriod.isOpen: No Period for 2016-01-10 00:00:00.0 (SOO) [48]

16:48:09.623-----------> MWFActivity.run: MWFNode[184-(DocAuto),Action=DocumentAction=--] [48]

java.lang.Exception: @PeriodClosed@        at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:1047)

I checked table C_PERIODCONTROL and I can confirm that Base document type "SOO" is open for January 2016. 

Does anyone have an idea?

Cheers,

Michael

[Dirk Niemeyer]

Hi Michael,

please make sure that in your "Accounting Schema" the field "Automatic
Peiod Control" is deselected.

Regards,

Dirk Niemeyer

Am 10.01.2016 um 11:07 schrieb mpow...@gmail.com:
>
>
> Dear all,
>
> I have created a new client (Initial client setup process). In the new
> client, I can't prepare/complete my sales order due to error message: Order
> 50002: Grand Total=1500 - Period Closed.
> I have double checked that period January 2016 is open across all base
> document types. I found the following warning/error messages in my log:
>

> <https://lh3.googleusercontent.com/-Ahe-1vFzyBI/VpIq-YGMyaI/AAAAAAAABS0/09OWA4p154s/s1600/Error%2Blog.JPG>

[mpow...@gmail.com]

Thanks Dirk. 

Automatic period control was already deselected. Any other ideas as to what the issue could be?

[mpow...@gmail.com]

One more piece of information, I forgot to share:

I don't face this issue in the demo default client GardenWorld but only in my newly created client.

Cheers,

Michael

[Alejandro Guerra]

Can you check if the period 2016 was created??

[Fco. Javier Vannini Robelo]

Maybe the configuration for the C_Order document type you are using is different from that of the demo.idempiere instance ? So maybe you want to compare the two side by side.

I say this because you are being presented with the error :  "No DocBaseType for C_Order" and defining Document Base Type is a configuration of a document.

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/db97cd10-527d-4944-89d1-4a356a163e86%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Solutions Ocean.]

you might have incorrect date on your machine or on server, after that check history days also on accounting schema!

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CACejJZiAbQsndb04q8WMwGBi6uNtB4LyWic4X4sUi4_gkSwNgQ%40mail.gmail.com.

[mpow...@gmail.com]

Thanks Alejandro,

everything defined as it should be: Calendar, Year 2016, Period and Period Control for all Document base types.

[mpow...@gmail.com]

Thanks FJVR. That was also what I found suspicious and I verified that the document type and base document type configuration is the same.

I

[mpow...@gmail.com]

Thanks Kashif. System date/time on my windows machine is correct. History days are not specified because Automatic Period control is turned off.

Cheers,

Michael

[Carlos Antonio Ruiz Gómez]

Do you manage multiple calendars?

Is the organization from the order associated to a different calendar?

Regards,

Carlos Ruiz

On Sunday, 10 January 2016 11:07:41 UTC+1, mpowacht wrote:

Dear all, 

I have created a new client (Initial client setup process). In the new client, I can't prepare/complete my sales order due to error message: Order 50002: Grand Total=1500 - Period Closed.

I have double checked that period January 2016 is open across all base document types. I found the following warning/error messages in my log:

[redhuan d. oon]

If you go to the source code via i.e. Eclipse and put a break at MPeriod to see why it complains those two errors on DocBaseType and No Open Period. I suspect it is the answer given by Carlos about your calendar.

[mpow...@gmail.com]

Thanks Carlos, I have double checked that the organization in the sales order corresponds to the organization in the calendar. 

Please see screenshots attached...

Cheers,

Michael

[mpow...@gmail.com]

Hi Carlos, 

in furtherance to my reply below, I forgot to mention that for some reason in period control, the system automatically populates the organization with "*" even though calendar and periods are defined at organization level (not *).

Cheers,

Michael 

On Tuesday, January 12, 2016 at 8:39:33 PM UTC+7, Carlos Antonio Ruiz Gómez wrote:

[Michael Powacht]

Thanks Alejandro,

can you please look at the screenshots I posted below and verify if the setup is correct?

Cheers,

Michael

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/YFlhJy7tn8c/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.

[Carlos Antonio Ruiz Gomez]

Michael, I mean, go to window organization, tab organization info and check if the calendar field is filled there.



El 13/01/16 a las 03:57, mpow...@gmail.com escribió:

[mpow...@gmail.com]

THAT's IT!! You are right and it's working now, thanks so much Carlos!!!

Cheers,

Michael

[mpow...@gmail.com]

Thanks Redhuan, issue is solved. Calendar was missing in organization info.

Cheers,

Michael

[Dmitry Oxenenko]

I'm trying to complete a PO and am getting the same error as OP only I have read this thread and have selected my calendar in the Organization window. Does anyone have any ideas on what I could try next?

I also noticed that GardenWorld doesn't have this calendar field set to anything and yet you can complete documents.

[Victor Suárez]

Hi Dmitry

Is the period open for the date of the document? Check in Calendar Year and Period Windows.

Regards.

[naw]

Hi

May be you can share screenshot for better description to others

Thanks

On Tue, May 26, 2020 at 9:08 PM Dmitry Oxenenko <atomic...@gmail.com> wrote:

I'm trying to complete a PO and am getting the same error as OP only I have read this thread and have selected my calendar in the Organization window. Does anyone have any ideas on what I could try next?

I also noticed that GardenWorld doesn't have this calendar field set to anything and yet you can complete documents.

--

You received this message because you are subscribed to the Google Groups "iDempiere" group.

To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/ff266264-707a-4020-97b2-57cfdbd492c4%40googlegroups.com.

[Dmitry Oxenenko]

Hi Victor & yuanaw,

Yes, my document date is 27/12/2018 and the periods are open as per screenshot.

The only thing that I didn't do from this thread is what I'm kind of dreading i.e. setting up eclipse and then debugging. I am starting to think this is the only way forward as I'm totally out of ideas.

[Gaurav Sontakke]

Hi , 

Please check the accounting schema if the automatic period control is true. 

Regards

Gaurav

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/71d9568d-60fb-491d-9251-3f2589c23290%40googlegroups.com.

Be aware of your environmental responsibility: Before printing this e-mail, ask yourself whether you need a hard copy!

CONFIDENTIALITY INFORMATION AND DISCLAIMER: This Communication is for the exclusive use of the intended recipient (s) and shall not attach any liability on the originator or Designershaik Inc. W.L.L (DSI)/its Subsidiaries/its Group Companies. If you are the addressee, the contents of this email are intended for your use only and it shall not be forwarded to any third party, without first obtaining written authorisation from the originator or DSI/its Subsidiaries/its Group Companies. It may contain information which is confidential and legally privileged and the same shall not be used or dealt with by any third party in any manner whatsoever without the specific consent of DSI./its Subsidiaries/its Group Companies.

[Bilal Mujahid]

Could you please check did you setup multiple calender's in iDempiere. The same kind of error comes up period is opened everything looks fine but period close error pops up.

Could you please check which calendar you have selected in the organization window0->organization info window?

[Dmitry Oxenenko]

Thanks Gaurav, that was the problem. Now the document closes.

https://www.chuckboecking.com/idempiere-period-closed-error-resolve-period-closed/

Bilal, please note, GardenWorld doesn't have a calendar selected in the Organization Info window yet documents close just fine. In my case I tried selecting my calendar, but that didn't solve the issue.

Thanks for the help guys!