Format a number with commas SQL Server

select format([Number], 'N0')

select format([Number], 'N2')
2 place of decimal ==> sql server 2012 and +




Aging Report using SQL-Server

declare @AdvanceDate datetime

set @AdvanceDate='02/29/2016'

--select DATEADD(DD,-90,@AdvanceDate)

select

ST, LOB,

case when  cast([Advance Date] as datetime)<DATEADD(DD,0,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-30,@AdvanceDate) then [Current Balance] else 0 end [Age30],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-30,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-60,@AdvanceDate) then [Current Balance] else 0 end [Age60],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-60,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-90,@AdvanceDate) then [Current Balance] else 0 end [Age90],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-90,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-120,@AdvanceDate) then [Current Balance] else 0 end [Age120],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-120,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-150,@AdvanceDate) then [Current Balance] else 0 end [Age150],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-150,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-180,@AdvanceDate) then [Current Balance] else 0 end [Age180],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-180,@AdvanceDate) and cast([Advance Date] as datetime)>=DATEADD(DD,-210,@AdvanceDate) then [Current Balance] else 0 end [Age210],

case when  cast([Advance Date] as datetime)<DATEADD(DD,-210,@AdvanceDate) then [Current Balance] else 0 end [Age>210]  into #temp11

--cast([Advance Date] as datetime)[Advance Date]

from #temp1 where  cast([Advance Date] as datetime)<=@AdvanceDate

select

ST,LOB,sum(Age30)Age30,    sum(Age60)Age60,     sum(Age90)Age90,     sum(Age120)Age120,       sum(Age150)Age150,   sum(Age180)Age180, sum(Age210)Age210,    sum([Age>210])[Age>210]

from  #temp11 group by st,[lob]

SQL For Account Balance fix -F0911 vs F0902

--drop table #temp902

select  GBAID,gbsbl,gbsblt,sum(gban01) Period_01  ,sum(gban02) Period_02 ,

sum(gban03) Period_03 ,sum(gban04) Period_04 ,sum(gban05) Period_05 ,sum(gban06) Period_06 ,sum(gban07) Period_07 ,

sum(gban08) Period_08 ,sum(gban09) Period_09 ,sum(gban10) Period_10 ,sum(gban11) Period_11 ,sum(gban12) Period_12 

,sum(gban13) Period_13

into #temp902 from proddta.f0902 where gbco='00600' and gbfy=15 and gblt='AA'

group by GBAID,gbsbl,gbsblt

--having sum(gban01)<>0

delete #temp902 where period_01=0 AND  period_02=0 AND  period_03=0 AND  period_04=0 AND  period_05=0 AND  period_06=0

 AND  period_07=0 AND  period_08=0 AND  period_09=0 AND  period_10=0 AND  period_11=0 AND  period_12=0  and Period_13=0

select glpn, GLAID,GLsbl,GLsblt,sum(GLAA) Amount into #temp1 from proddta.f0911 where glco='00600'  and glfy=15 

and gllt='AA'  and glpost='P'

group by GLAID,GLsbl,GLsblt,glpn

select glpn,GLAID,GLsbl,GLsblt,

case When glpn=1 then amount else 0 end Period_01,  

case When glpn=2 then amount else 0 end Period_02,  

case When glpn=3 then amount else 0 end Period_03,  

case When glpn=4 then amount else 0 end Period_04,  

case When glpn=5 then amount else 0 end Period_05,  

case When glpn=6 then amount else 0 end Period_06,  

case When glpn=7 then amount else 0 end Period_07,  

case When glpn=8 then amount else 0 end Period_08,  

case When glpn=9 then amount else 0 end Period_09,  

case When glpn=10 then amount else 0 end Period_10,  

case When glpn=11 then amount else 0 end Period_11,  

case When glpn=12 then amount else 0 end Period_12 ,

case When glpn=13 then amount else 0 end Period_13 

into #temp2

from #temp1

--drop table #temp3

select GLAID,GLsbl,GLsblt,

Sum(Period_01)Period_01,Sum(Period_02)Period_02,Sum(Period_03)Period_03,Sum(Period_04)Period_04,Sum(Period_05)Period_05,

Sum(Period_06)Period_06,Sum(Period_07)Period_07,Sum(Period_08)Period_08,Sum(Period_09)Period_09,Sum(Period_10)Period_10,

Sum(Period_11)Period_11,Sum(Period_12)Period_12,Sum(Period_13)Period_13 into #temp3

 from #temp2

 group by GLAID,GLsbl,GLsblt

 delete #temp3

 where period_01=0 AND  period_02=0 AND  period_03=0 AND  period_04=0 AND  period_05=0 AND  period_06=0

 AND  period_07=0 AND  period_08=0 AND  period_09=0 AND  period_10=0 AND  period_11=0 AND  period_12=0  and Period_13=0

-- declare @aid varchar(10)='10205217'

--select * from #temp902 where  gbaid=@aid and gbsbl='01424411'

--select * from #temp3 where  glaid=@aid and glsbl='01424411'

--select * from #temp902 order by 1,2,3

--select * from #temp3 order by 1,2,3

select GLAID,GLsbl,GLsblt,a.period_13,b.period_13 from #temp902 a

left outer join #temp3 b on GLAID=GBAID and GLsbl=GBSBL and GLsblt=gbsblt

where 

a.period_13<>b.period_13

Time out when paste 500+ lines in JD Edwards

Time out when try to paste 500+ lines in Journal Entries in JD Edwards 9.1.

 

xkcd is not a valid version for P4314 Error - JD Edwards

When I saw this error I cant believe this, I dont know how to fix , so I created this version xkcd  for P4314.

xkcd is not a valid version for P4314
	A form level error has occurred. Cause..... xkcd is not a valid version for P4314 application.  Resolution.... Specify the correct version for P4314 application in the corresponding processing option.
	ER Details:     Form   P0411B_W0411BA     Control Id   2     Control Title   Select     Event   Button clicked     Line No   22   BSFN Details:     Source File   b0400421.c     Source Line   125     Error ID   0011U

Run Stored Proc and insert data in a Table Without SSIS

--FL
INSERT into [tblpra_FL_cash]
Exec [ServerName].[OtherDatabase].dbo.spMonthlyCashTo820 'FL','01/01/2015','02/29/2016'

Z file check upload process JD Edwards

Z file check upload process


Listing of ER for Report: Report : Inventory Control Location (R550154A)

***********************************************************************
     GLOBALS: Variables (Global)
***********************************************************************
     rpt_DateEffective
     rpt_PhoneAreaCode1
     rpt_PhoneNumber
     rpt_LineNumberID
     rpt_NameGiven
     rpt_NameSurname
     rpt_FaxAreaCode1
     rpt_FaxNumber
     rpt_HubManagerCode1
     rpt_Country
     rpt_ZipCode_Num
     rpt_LenZipCade
     rpt_CustomerCode2
     rpt_AddressNumber_Closed
     rpt_DateClosed
     rpt_DateClosedGE
     rpt_GenericLong
     rpt_GenericLong_Out
     rpt_ReportCodeAddBook019
     rpt_DateBeginningEffective_1
     rpt_LedgType
     rpt_IdentifierShortItem_41021
     rpt_QtyOnHandPrimaryUn41021
     rpt_TotalPrimaryUn
     rpt_AmountUnitCost
     rpt_IndItemPrice
     rpt_TotaItemPrice

=======================================================================
     SECTION: Address Book Update [COLUMNAR SECTION] (S1)
=======================================================================
     OBJECT:  SECTION
     EVENT:  Initialize Section
-----------------------------------------------------------------------
     OPT: Using Defaults
0001 Get Input Output Env Handles
        SL LoginEnvironment -> BF szInputEnvironment
        VA rpt_GenericLong <- bf="" idinputenvhandle="" p="">        SL LoginEnvironment -> BF szOutputEnvironment
        VA rpt_GenericLong_Out <- bf="" idoutputenvhandle="" p="">        SL LoginEnvironment -> BF szLoginEnvironment
0002 Delete All Rows From Table
        "F550154" -> BF szTableName
        VA rpt_GenericLong_Out -> BF idOutputEnvHandle

-----------------------------------------------------------------------
     EVENT:  Do Section
-----------------------------------------------------------------------
     OPT: Using Defaults
0001 F0101 Get Effective Date
        BC Address Number (F0101)(AN8) -> BF mnAddressNumber
        VA rpt_DateEffective <- bf="" jddatebeginningeffective="" p="">0002 F0116 Get Next Effective Address
        BC Address Number (F0101)(AN8) -> BF mnAddressNumber
        VA rpt_DateEffective -> BF jdDateBeginningEffective
        RV Address1 <- bf="" p="" szaddressline1="">        RV ZIP <- bf="" p="" szzipcodepostal="">        RV City <- bf="" p="" szcity="">        RV State <- bf="" p="" szstate="">        VA rpt_Country <- bf="" p="" szcountry="">0003 F0115 Get Primary Phone Number
        BC Address Number (F0101)(AN8) -> BF mnAddressnumber
        VA rpt_PhoneNumber <- bf="" p="" szphonenumber="">        VA rpt_PhoneAreaCode1 <- bf="" p="" szphoneareacode1="">0004 If VA rpt_PhoneNumber is equal to
0005    RV PhoneNo = ""
0006 Else
0007    RV PhoneNo = concat(concat(rtrim([VA rpt_PhoneAreaCode1],' ')," - "),ltrim([VA rpt_PhoneNumber],' '))
0008 End If
0009 //
0010 VA rpt_NameGiven = ""
0011 VA rpt_NameSurname = ""
0012 VA rpt_LineNumberID = 0
0013 F0111.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0014 RV Fname = [VA rpt_NameGiven]
0015 RV Lname = [VA rpt_NameSurname]
0016 //
0017 VA rpt_NameGiven = ""
0018 VA rpt_NameSurname = ""
0019 F0111.Fetch Single
        BC Address Number - 1st (F0101)(AN81) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0020 RV An81_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0021 //
0022 VA rpt_NameGiven = ""
0023 VA rpt_NameSurname = ""
0024 F0111.Fetch Single
        BC Address Number - 2nd (F0101)(AN82) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0025 RV An82_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0026 //
0027 VA rpt_NameGiven = ""
0028 VA rpt_NameSurname = ""
0029 F0111.Fetch Single
        BC Address Number - 3rd (F0101)(AN83) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0030 RV An83_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0031 //
0032 VA rpt_NameGiven = ""
0033 VA rpt_NameSurname = ""
0034 F0111.Fetch Single
        BC Address Number - 4th (F0101)(AN84) =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0035 RV An84_Desc = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0036 //              CMC2
0037 F0301.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_CustomerCode2 <- 2="" code="" commission="" p="" tk="">0038 VA rpt_NameGiven = ""
0039 VA rpt_NameSurname = ""
0040 F0111.Fetch Single
        VA rpt_CustomerCode2 =  TK Address Number
        VA rpt_LineNumberID =  TK Who's Who Line Number - ID
        VA rpt_NameGiven <- -="" given="" name="" p="" tk="">        VA rpt_NameSurname <- -="" name="" p="" surname="" tk="">0041 RV CMC2 = concat(concat(rtrim([VA rpt_NameGiven],' '),"  "),ltrim([VA rpt_NameSurname],' '))
0042 //
0043 VA rpt_LineNumberID = 2
0044 F0115.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_LineNumberID =  TK Line Number ID - 5.0
        VA rpt_FaxAreaCode1 <- p="" phone="" prefix="" tk="">        VA rpt_FaxNumber <- number="" p="" phone="" tk="">0045 If VA rpt_FaxNumber is equal to
0046    RV FaxNo = ""
0047 Else
0048    RV FaxNo = concat(concat(rtrim([VA rpt_FaxAreaCode1],' ')," - "),ltrim([VA rpt_FaxNumber],' '))
0049 End If
0050 F0301.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_HubManagerCode1 <- 1="" code="" commission="" p="" tk="">0051 F0101 Get Alpha Name
        VA rpt_HubManagerCode1 -> BF mnAddressNumber
        RV HubManager <- bf="" p="" szaddressbookdescription="">0052 VA rpt_ZipCode_Num = [RV ZIP]
0053 VA rpt_LenZipCade = length([VA rpt_ZipCode_Num])
0054 If VA rpt_LenZipCade is equal to "4"
0055    RV ZIP = lpad([RV ZIP],'0',5)
0056 Else
0057 End If
0058 RV ZIP = lpad([RV ZIP],'0',5)
0059 //
0060 //
0061 //
0062 // Suppress Write
0063 //
0064 If RV State is equal to Or RV State is equal to "" Or RV State is equal to Or RV State is equal to
0065    Suppress Section Write
0066 End If
0067 If RV State is equal to "  ,AK,HI,PR"
0068    Suppress Section Write
0069 Else
0070 End If
0071 If VA rpt_Country is equal to "US"
0072 Else
0073    Suppress Section Write
0074 End If
0075 If RV Fname is equal to Or RV Fname is equal to "" Or RV Fname is equal to Or RV Fname is equal to ""
0076    Suppress Section Write
0077 End If
0078 //
0079 //
0080 // Date Closed
0081 //
0082 //
0083 VA rpt_DateClosedGE = ""
0084 F550155.Fetch Single
        BC Address Number (F0101)(AN8) =  TK Address Number
        VA rpt_DateClosed <- -="" date="" expired="" p="" tk="">0085 While SV File_IO_Status is equal to CO SUCCESS
0086    If VA rpt_DateClosed is greater than VA rpt_DateClosedGE
0087       VA rpt_DateClosedGE = VA rpt_DateClosed
0088    Else
0089       VA rpt_DateClosedGE = VA rpt_DateClosedGE
0090    End If
0091    F550155.Fetch Next
           BC Address Number (F0101)(AN8) <- address="" number="" p="" tk="">           VA rpt_DateClosed <- -="" date="" expired="" p="" tk="">0092 End While
0093 RV DateClosed = [VA rpt_DateClosedGE]
0094 //
0095 //
0096 // End Date Closed
0097 //
0098 //
0099 VA rpt_LedgType = "02"
0100 VA rpt_TotaItemPrice = 0
0101 VA rpt_IndItemPrice = 0
0102 VA rpt_AmountUnitCost = 0
0103 VA rpt_QtyOnHandPrimaryUn41021 = 0
0104 F41021.Fetch Single
        VA rpt_IdentifierShortItem_41021 <- -="" item="" number="" p="" short="" tk="">        BC Business Unit (F0101)(MCU) =  TK Business Unit
        VA rpt_QtyOnHandPrimaryUn41021 <- -="" hand="" on="" p="" primary="" quantity="" tk="" units="">0105 While SV File_IO_Status is equal to CO SUCCESS
0106    F4105.Fetch Single
           VA rpt_IdentifierShortItem_41021 =  TK Item Number - Short
           BC Business Unit (F0101)(MCU) =  TK Business Unit
           VA rpt_LedgType =  TK Cost Method
           VA rpt_AmountUnitCost <- -="" amount="" cost="" p="" tk="" unit="">0107    VA rpt_TotaItemPrice = [VA rpt_TotaItemPrice]+([VA rpt_AmountUnitCost]*[VA rpt_QtyOnHandPrimaryUn41021])
0108    F41021.Fetch Next
           VA rpt_IdentifierShortItem_41021 <- -="" item="" number="" p="" short="" tk="">           BC Business Unit (F0101)(MCU) <- business="" p="" tk="" unit="">           VA rpt_QtyOnHandPrimaryUn41021 <- -="" hand="" on="" p="" primary="" quantity="" tk="" units="">0109 End While
0110 //
0111 //
0112 //
0113 //
0114 //
0115 F550154.Insert
        BC Address Number (F0101)(AN8) -> TK Address Number
        BC Business Unit (F0101)(MCU) -> TK Business Unit
        BC Name - Alpha (F0101)(ALPH) -> TK Name - Alpha
        RV Fname -> TK Name - Given
        RV Lname -> TK Name - Surname
        RV HubManager -> TK Description
        RV Address1 -> TK Address Line 1
        RV City -> TK City
        RV State -> TK State
        RV ZIP -> TK Postal Code
        RV PhoneNo -> TK Phone Number
        BC Category Code - Address Book 29 (F0101)(AC29) -> TK Category Code - Address Book 29
        RV FaxNo -> TK Case Fax Number 4
        RV An81_Desc -> TK Address Line 2
        RV An82_Desc -> TK Address Line 3
        RV An83_Desc -> TK Address Line 4
        RV An84_Desc -> TK Address Line 5
        RV CMC2 -> TK Address Line 6
        RV DateClosed -> TK Date Audit File Future Use
        VA rpt_Country -> TK Country
        VA rpt_TotaItemPrice -> TK Amount - Extended Price
        VA rpt_DateClosed -> TK Date - Counted
0116 //
0117 //
0118 //

=======================================================================
     SECTION: Wf- Inv. Control Location [COLUMNAR SECTION] (S3)
=======================================================================
     OBJECT:  SECTION
     EVENT:  Do Section
-----------------------------------------------------------------------
     OPT: Using Defaults
0001 F0101.Fetch Single
        BC Address Number (F550154)(AN8) =  TK Address Number
        VA rpt_DateBeginningEffective_1 <- -="" beginning="" date="" effective="" p="" tk="">        VA rpt_ReportCodeAddBook019 <- -="" 19="" address="" book="" category="" code="" p="" tk="">0002 Get UDC Description (Obsolete)
        "01" -> BF szSystemCode
        "19" -> BF szUserDefinedCodes
        VA rpt_ReportCodeAddBook019 -> BF szUserDefinedCode
        RV AC19Desc <- bf="" p="" szdescription01="">0003 ! VA rpt_ReportCodeAddBook019 = ltrim([VA rpt_ReportCodeAddBook019],'')
0004 ! Get UDC
     !    "01" -> BF szSystemCode
     !    "19" -> BF szRecordTypeCode
     !    VA rpt_ReportCodeAddBook019 -> BF szUserDefinedCode
     !    RV AC19Desc <- bf="" p="" szdescription001="">0005 F0116.Fetch Single
        BC Address Number (F550154)(AN8) =  TK Address Number
        VA rpt_DateBeginningEffective_1 =  TK Date - Beginning Effective
        RV Add2 <- 2="" address="" line="" p="" tk="">0006 //
0007 RV Days = days_between([BC Date - Counted (F550154)(CNTJ)],[SL DateToday])

Wednesday February 17, 2016  08:43

Cancel a PO Line in JD Edwards

Cancel a PO Line in JD Edwards

1. Open P4310, and pull that order  

2.  after that Detail Revisions, 

3.  select the line to cancel and from row exit click on Cancel Line.

Purchase Order - Blankets Release Error JD Edwards 9.1

Purchase Order - Blankets Release Error JD Edwards 9.1

	Requested Date Is Not a Work Day
	Invalid Commodity Code
	Commodity Code has an invalid data dictionary value.

Upload multiple files using fileupload control in Asp Net c#

Upload multiple files using fileupload control in Asp Net

ASP.NET 4.5 brings many new desirable features to upgrade the functionality of previous versions.

Here I will discuss with you one of them, the feature of new the FileUpload control in ASP.NET 4.5. The FileUpload control in ASP.NET extends it's functionality by supporting the upload of multiple files at once.

Prior to this latest version, the FileUpload control only supported a single file at a time, but version ASP.NET version 4.5 solves this issue very well. 

Now, the FileUpload control is built to support HTML 5, therefore it is only supported in browsers supporting HTML5.For other browsers it will work like a normal file upload control in ASP.NET.

A new attribute that comes with the ASP.NET 4.5 FileUplaod control is that:

AllowMultiple: It takes either true or false.




http://www.c-sharpcorner.com/UploadFile/99bb20/upload-multiple-files-using-fileupload-control-in-Asp-Net-4/

Three continuous month and year in SQL Server

Three continuous month and year in SQL eg

Nov 2015
Dec 2015
Jan 2016


Select  left(DateName( month , DateAdd( month , Month(@FCashReceivedDate) , -32 ) ),3)  +' '+ cast(Year(@FCashReceivedDate)  as varchar(4))
Select  left(DateName( month , DateAdd( month , Month(@FCashReceivedDate) , -1 ) ),3)  +' '+ cast(Year(@FCashReceivedDate)  as varchar(4))
Select  left(DateName( month , DateAdd( month , Month(@FCashReceivedDate) , 0 ) ),3)  +' '+   cast(year(DATEADD(year,1,@FCashReceivedDate) ) as varchar(4))

JD Edwards EnterpriseOne Standalone Client Installation Guide

JD Edwards EnterpriseOne Standalone Client Installation Guide

http://docs.oracle.com/cd/E61420_01/EOISA/toc.htm

Import the data in "List of Values" oe list from Excel/Text file JD Edwards

it is not possible to import the data in "List of Values" Tab available in Data Selection. 

There is no work around because data selection is part of RDA spec and during run-time.. it create XML file.. based on manual input value.

Reference : in oracle support Doc ID 945646.1

RIS Vs ZJDE JD Edwards

What is the difference between RIS Versions and ZJDE versions?

 RIS versions are Rapid Start versions that Oracle has preconfigured specific data selection

 and processing options for. If you are on 8.11 SP1, there is a post installation job called Data Configuration Workbench that allows you to chose which country versions you want or if you don't want Rapid Start. 

Rapid Start essentially is a way to get up and running quickly with some data based on the country's needs. 

We provide versions (RIS) as well as a database with business data. If you don't want to use the RIS versions, 

that is fine and you can delete them. ZJDE is our standard versions. 

I would suggest using those unless you are familiar with Rapid Start. 

Source: Oracle Doc ID 945646.1.

Error Reversing Receipt - JD Edwards 9.1

We are in the process of upgrading from 8.10 to 9.1. In the new production environment - 9.1 , we are getting an error when we try to reverse receipt for an Item that has landed cost applied.

	Business Unit Number Invalid
	A form level error has occurred. CAUSE: This business unit number does not exist in the Business Unit Master file (F0006). RESOLUTION: Enter a valid business unit number or add the business unit number to the Business Unit Master file (F0006).
	ER Details:     Form   P43214_W43214A     Control Id   209     Control Title   Reverse Receipt     Event   Button clicked     Line No   363 BSFN Details:     Source File   b0000130.c     Source Line   169     Error ID   3091
	Distribution AAI Number 4385 Invalid
	A form level error has occurred. CAUSE : The Automatic Accounting Instruction (AAI) number 4385 used by this application is not defined in the Distribution/Manufacturing AAI table. RESOLUTION : Review the AAI that is not set up correctly using the Distribution/Manufacturing AAI maintenance application and set up or modify the required data. Check the information for Company LCRC , Order Type and GL CLass code .
	ER Details:     Form   P43214_W43214A     Control Id   209     Control Title   Reverse Receipt     Event   Button clicked     Line No   363 BSFN Details:     Source File   b4000350.c     Source Line   684     Error ID   029P
	Distribution AAI Number 4390 Invalid
	A form level error has occurred. CAUSE : The Automatic Accounting Instruction (AAI) number 4390 used by this application is not defined in the Distribution/Manufacturing AAI table. RESOLUTION : Review the AAI that is not set up correctly using the Distribution/Manufacturing AAI maintenance application and set up or modify the required data. Check the information for Company LCRC , Order Type and GL CLass code .
	ER Details:     Form   P43214_W43214A     Control Id   209     Control Title   Reverse Receipt     Event   Button clicked     Line No   363 BSFN Details:     Source File   b4000350.c     Source Line   684     Error ID   029P

So our functional guy stated working with Oracle, they where looking at log files etc......
    So after a week this issue become big, they wanted to go live but this one was stopping them to move forward.
He discussed this issue with me, He was running this P43214 from menu, I thought of taking a looking in this issue, First thing I did, saw the Processing Option, compare with other working environment , it was same no issue there.
  As I started my career as a developer, I dont like to run any program from menu, unless I am working with user. So as a troubleshooter I ran this application using fast path ... no result. So I decided to change something, I ask my functional guy to show me the step to duplicate this issue, He did also he created a PO with many many line and received it, and he gave me that PO#,
 I thought that let run this Application using other version, stranded JDE version, I used RIS0001, Its work like charm. My functional
guy surprised and said I had so much trouble with this and this was not the issue at all. 
   

So Whenever you upgrade JDE from 1 version to other dont believe on old environment version, always try with original version, if there is no customization in that program.

    
     Happy Troubleshooting........