Get UDC JD Edwards

Simplest way to get UDC value...

 

Get UDC
   "06" -> BF szSystemCode
   "PS" -> BF szRecordTypeCode
   VA rpt_PASTUDC_P -> BF szUserDefinedCode
   RV PayStatusH <- BF szDescription001

Excel counts columns Count With Letters Extension

Should you need to count as Excel counts columns, then look at Zeltera's "Count with Letters".
His routines can be extended to convert an Integer to an Excel Column or an Excel Column to an integer. A long time ago, I wrote two very simple, inefficient loop wrappers around Zeltera's core code to do just that. Here I present a way to calculate a result, so as to reduce the loop to no more than 26 passes.
 
 
http://www.codeproject.com/KB/cs/CountWithLettersExtn.aspx

Script Performance Automatic with Custom Templates -Visual Studio 2010

Script Performance Automatic with Custom Templates

 you can easily take an existing project with your preferred tweaks, and turn it into a custom project template.In part 2, I'll show you how you can also tweak the behavior of the New Item templates, so that scripts for things like validation also end up in the desired spot. Finalliy, in part 3, I'll show you how to customize the default template for your preferred project type.

http://devhammer.net/blog/make-script-performance-automatic-with-custom-templates-in-visual-studio-2010

RB Batch Partial posted in GL

RB Batch Partial posted in GL:-  My accounting Depatment complain about one particular line missing in GL.
I Ran sql on F03b13 , F03b14 I found POST field was blank and that particular entry missing from F0911.
I went to P0011 batch post screen and change that RB batch From Post status to Approve and ran posting program R9801 again.
after that particular line posted correctly in GL.
 
 
 
 

Filtering an ASP.NET GridView control with jQuery

GridView wired to some sample data. For demo simplicity I'm using an XMLDataSource and reading from an XML file in my App_Data directory.
 
 
http://www.msjoe.com/2011/06/filtering-an-asp-net-gridview-control-with-jquery/

HTML5 Support for the Visual Studio 2010 Editor

 HTML5 Support for the Visual Studio 2010 Editor

HTML5 moves fast, and this update will aim to keep up with it. It adds support to Visual Studio and the editor for HTML5, CSS3 and new JavaScript features. The goal is perhaps an update every quarter or so as new features or elements emerge.  We want ASP.NET web developers to always be able to use the latest standards, as well as being able to choose from existing standards. Remember that you can use HTML5 today along with JavaScript libraries like Modernizr that allow you to create pages that work across nearly all browsers, including old crappy ones.

http://www.hanselman.com/blog/AnnouncingTheWebStandardsUpdateHTML5SupportForTheVisualStudio2010Editor.aspx

How to create csv/text file in jd edwards enterpriseone

How to create csv/text file in jd edwards enterpriseone

 

1. use business function to open a text file in Report header Open Flat File

2. write lines in main logic section , may be multiple times using:- Write One Line To Flat File
3. you can close file using BF Close Flat File, in report footer section.

Date Conversion to DD/MM/YYYY JD Edwards Developer Tools

Date Conversion to DD/MM/YYYY JD Edwards without using Business Function :-

 

VA rpt_AlphaSpecData10_DT = concat(concat(concat(lpad(date_day([BC Date - Terminated (F060116) (DT)]),"0",2),'/'),concat(lpad(date_month([BC Date - Terminated (F060116) (DT)]),"0",2),'/')),date_year([BC Date - Terminated (F060116) (DT)]))
Convert String to Date

Logged voucher JDE

1. You can enter an AP vouhcer called a logged voucher when you receive an invoice from a supplier. In standard JDE, it uses ZJDE0008 version of P0411, which has a proper MBF version attached to it. JDE creates a document type PL.
2. You can pay the same using normal payment process of P0413M.
3. After some time when you get the delivery of material, you enter a purchase receipt using P4312.
4. Thereafter you can select and redistribute your previously entered PL voucher and carry out a 3-way match with the purchase receipt using Voucher JE Redistribution program P042002.

http://www.jdelist.com/ubb/showflat.php?Cat=&Number=113301&page=332&view=expanded&sb=10&o=&vc=1

.rpd file not visible dashboard OBIEE

Created .rpd file but how do I connect in OBIEE Answers?

 

http://forums.oracle.com/forums/thread.jspa?threadID=2195099&tstart=45

--
Rajeev Kumar