How to get the current posting period

[Former Member]

Hi,

Is there any way to get the current posting period?

We have used the following query to get it...

SELECT T0.Code AS 'Period Code', T0.Name AS 'Period Name' FROM [dbo].[OFPR]

T0 where getdate() >= F_RefDate and getdate() <= T_Refdate FOR BROWSE

However, this query will not giving the correct output when the user changes the period to previous period. Is there any other way to get the default Posting period?

Thanks

Ajith

[former_member185703 · Accepted solution]

Hi Ajith,

Setting the "default posting period" to another period only affects the active SAP Business One application.

When you start a second "SAP Business One", you will find that the default period is set to the real current period. That's why the "default posting period" is not stored in the database.

In addition there's no way yet to get the information "directly".

I.e., currently you can only catch the appropriate event in SAP Business One on the "General Settings" form (form type "138")...

Please note: DI API does not yet support setting another period as "default posting period" - just in case this is the background of your question.

HTH,

Frank

PS:

Nevertheless there are postings that are allowed in case of postings to other periods:

• Not Active period *****

AR documents - block

AP documents - No block

Manual JE # - No block

Goods Receipt \ Goods Issue + Stock transfer + MRV (in 6.7 only) + Stock opening balances and update after counting # - No block

• Locked period *****

AR documents - block

AP documents - block

Manual JE # - block

Goods Receipt \ Goods Issue + Stock transfer + MRV (in 6.7 only) + Stock opening balances and update after counting - block