on 01-19-2005 4:44 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
10 | |
10 | |
5 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.