Quarter to Date

[pianosynth]

There is no Quarter to Date functionality in JD Edwards before release B9. Document 2903094 from the JDE KG details how to add this functionality through creating a Data Structure, BSFN, and DD Smart Field. I appear to have been successful in each of these steps, yet when I create a UBE to test this, I get a validation error...

/* CER ERROR #3027 : Invalid Behavior Template Id */
Function Name: S1_5_44
Function Description: ER for R56QTDTEST_+_S1_5_44
Section: S1 - Financial Reporting (F0901/F0902/F0006)
Event: 44 - Column Inclusion
/* */

I found document OTT-00-0033 on the KG (Financial Reports - Issues and Tips) which lead me to check the f9212 for the Smart Field DD definition and everything looks fine there. I tried JDEDEBUG, but all I get there is...
GRID: jdeGridGetQbeData - get row data failed[T:3e0 F:\b7\system\jdeuser\Jdegrid\gridrows.cpp Ln:696 Lv:LEVEL1]

I'm not sure what else to try or where else to look. Has anyone run into these issues trying to get a smart field to work? Any tips or hints would be very welcome.

B733.2, SP 15, Oracle 8.1.6, HP 9000
Win2K, Citrix 1.8, NFuse

 

[Joseph_Sadler]

We also had some problems with Smart Fields before, but were able to resolve
them.

1. Smart Field Column Headings and Description Print, but there is No Data
on the Report:
Verify the Automatic Accounting Instructions (AAIs) for all GLG items are
correctly defined in the AAIs.
If these are not defined correctly, data is not retrieved to print on the
report.
The most commonly missed AAIs are GLG11 - Beginning Other Income and GLG13-
Beginning Other Expenses.
These GLG items are required for data to print on Financial Reports.
They should be set up for company 00000 only.

2. The Report has Data, but there are No Smart Field Column Headings:
This occurs when the company has a Date Pattern Code that is not established
in the Column Headings for the report.
The Demo Data is only shipped with a value of R.
Go to Menu GH9141 - Advanced Report Setup, then select P83110 - Column
Headings.
If your company uses a fiscal date pattern other than the standard R, set
that date pattern up in P83110.

I don't think our second problem applies to your current issue,
but hopefully our first resolution can help you.
Joseph

 

[pianosynth]

Re: RE: Quarter to Date

Thanks for the tips, Joseph. Smart fields are working for us, though. It is just the one I am trying to create that is giving us problems. When I try to save the UBE I created for testing the Quarter to Date smart field is when I get the errors listed on my original post. Since this is the first Data structure, BSFN and Smart Field I have attempted to create, I was hoping somebody more experienced would know exactly what (if anything) I had done wrong.

B733.2, SP 15, Oracle 8.1.6, HP 9000
Win2K, Citrix 1.8, NFuse