Period and FY for any GL Date

Hi,

i want to write a UBE to run over F0911 for a particular company (CO). This
report will compare the FY and Period
on F0911 with Period,Year that i work out from the GL Date.

I am trying to use X0903B without much success.

can anyone give me some pointers

many thanks

Paul Watton
Senior Analyst
Ibstock Brick Ltd.
One World B7333(XE) , SP 20_Q1, Oracle 8.1.7.4 on Sun Solaris



-


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. It may contain confidential, legally priviledged or price-sensitive material.
Any disclosure, use or copying of the contents of this email
by anyone other than the recipient is prohibited and may be illegal.
If you have received this email in error please notify us by telephone on:
01530 257362
Please delete and destroy the message from your computer.


This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Here is a simple code how to get the priod and the FY for a given G/L date


DSDX0903B dsDX0903B = {0};

strncpy(dsDX0903B.szCompany, dsColsF0911.glco, sizeof(dsDX0903B.szCompany));
dsDX0903B.jdGLDate = dsColsF0911.gldgj;

jdeCallObject("F0008BGetFiscalYearPeriodNumber", NULL,
lpBhvrCom,lpVoid,
(LPVOID)&dsDX0903B,
(LPCALLMAP)NULL,
(int)0, (char *)NULL,
(char *)NULL,(int)0);


Perform the comparison here.

strcmp(&dsColsF0911.glfy ,&dsDX0903B.mnFiscalYear);
strcmp(&dsColsF0911.glpn ,&dsDX0903B.mnGLPeriodNumber);


Zack

Thanks Zack,

but unfortunately we do not use the F0008b file

Paul Watton
Senior Analyst
Ibstock Brick Ltd.
One World B7333(XE) , SP 20_Q1, Oracle 8.1.7.4 on Sun Solaris

I have used it and works fine
Here is what I passed to the BSFN
F0008B Get Fiscal Year Period Number
"05000" -> szCompany
PO jdDate -> jdGLDate
VA rpt_PeriodNumber <- mnGLPeriodNumber
VA rpt_Year <- mnFiscalYear
VA rpt_Century <- mnCentury
UNDEFINED X cErrorCode
"1" <> cFetchCompanyConstants
VA rpt_FiscalDatePattern <> cF0010FiscalDatePattern
VA rpt_BeginDate <> jdF0010FiscalYearBeginDate

Re: RE: Period and FY for any GL Date

IF you don't use the F0008B (52 Period) then u cannot use the BSFN u are using.
There is another one similar for F0008. You have to use that.

Re: RE: Period and FY for any GL Date

Hi Paul,

Why not make a file with a date as primary key, fiscal century, year and period, 4 digit year, month as text, month as number, day in month, day in week, holiday YN flag…
Populate file with data form the first DGJ to, for example, end of 2015. For 20 years it is approximately 7300 records.
It easy to fetch fiscal year and period, use in business view for sorting and level breaks, calculate number of working days between two dates…
Don’t forget to leave blank day if you are going to use file in business views.

Hope this helps,

Bojan.