NER Business function problem, not selcting records

[JDETECHIE]

[mad]Hi all,

I have created NER and it selcts records from F0902 and do Fetchnext.
The problem is it is not seelcting records, when i start debugging first time it is not selcting records when i re do agian it is secting records works fine.
What could be the reason, why it is not working first time ? why it works on second time.
Always passing parameters are same. secelction creiterai is perfect and have records.
JDE gurus help out, as i badly need this solutin

xe sp20, udate3, orcle 8.1,

 

[JMR]

Hey mad,

Could you post your code? It would help us 'see' what you're trying to explain. Thanks.

 

[JDETECHIE]

Here is the code
// ******************************************************************************
// Calculate Total Revenue
// ******************************************************************************
F0902.Select
BF mnCentury = TK Century
BF mnFiscalYear1 = TK Fiscal Year
BF szLedgerType = TK Ledger Type
BF szSubledger = TK Subledger - G/L
BF szCompany = TK Company
BF szCostCenter = TK Business Unit
F0902.Fetch Next
VA evt_mnRevenueAmount_AN01 <- TK Amount - Net Posting 01
VA evt_mnRevenueAmount_AN02 <- TK Amount - Net Posting 02
VA evt_mnRevenueAmount_AN03 <- TK Amount - Net Posting 03
VA evt_mnRevenueAmount_AN04 <- TK Amount - Net Posting 04
VA evt_mnRevenueAmount_AN05 <- TK Amount - Net Posting 05
VA evt_mnRevenueAmount_AN06 <- TK Amount - Net Posting 06
VA evt_mnRevenueAmount_AN07 <- TK Amount - Net Posting 07
VA evt_mnRevenueAmount_AN08 <- TK Amount - Net Posting 08
VA evt_mnRevenueAmount_AN09 <- TK Amount - Net Posting 09
VA evt_mnRevenueAmount_AN10 <- TK Amount - Net Posting 10
VA evt_mnRevenueAmount_AN11 <- TK Amount - Net Posting 11
VA evt_mnRevenueAmount_AN12 <- TK Amount - Net Posting 12
VA evt_szRevenueCostCenter <- TK Business Unit
VA evt_szRevenueObjectAccount_OBJ <- TK Object Account
While SV File_IO_Status is equal to CO SUCCESS
If VA evt_szRevenueObjectAccount_OBJ is equal to "4000-4999"
And VA evt_szRevenueCostCenter is equal to BF szCostCenter
VA evt_mnTotalRevenueAmount_AN01 = [VA evt_mnTotalRevenueAmount_AN01]+[VA evt_mnRevenueAmount_AN01]*-1
VA evt_mnTotalRevenueAmount_AN02 = [VA evt_mnTotalRevenueAmount_AN02]+[VA evt_mnRevenueAmount_AN02]*-1
VA evt_mnTotalRevenueAmount_AN03 = [VA evt_mnTotalRevenueAmount_AN03]+[VA evt_mnRevenueAmount_AN03]*-1
VA evt_mnTotalRevenueAmount_AN04 = [VA evt_mnTotalRevenueAmount_AN04]+[VA evt_mnRevenueAmount_AN04]*-1
VA evt_mnTotalRevenueAmount_AN05 = [VA evt_mnTotalRevenueAmount_AN05]+[VA evt_mnRevenueAmount_AN05]*-1
VA evt_mnTotalRevenueAmount_AN06 = [VA evt_mnTotalRevenueAmount_AN06]+[VA evt_mnRevenueAmount_AN06]*-1
VA evt_mnTotalRevenueAmount_AN07 = [VA evt_mnTotalRevenueAmount_AN07]+[VA evt_mnRevenueAmount_AN07]*-1
VA evt_mnTotalRevenueAmount_AN08 = [VA evt_mnTotalRevenueAmount_AN08]+[VA evt_mnRevenueAmount_AN08]*-1
VA evt_mnTotalRevenueAmount_AN09 = [VA evt_mnTotalRevenueAmount_AN09]+[VA evt_mnRevenueAmount_AN09]*-1
VA evt_mnTotalRevenueAmount_AN10 = [VA evt_mnTotalRevenueAmount_AN10]+[VA evt_mnRevenueAmount_AN10]*-1
VA evt_mnTotalRevenueAmount_AN11 = [VA evt_mnTotalRevenueAmount_AN11]+[VA evt_mnRevenueAmount_AN11]*-1
VA evt_mnTotalRevenueAmount_AN12 = [VA evt_mnTotalRevenueAmount_AN12]+[VA evt_mnRevenueAmount_AN12]*-1
//
VA evt_mnTotalRevenueAmount_AG = [VA evt_mnTotalRevenueAmount_AN01]+[VA evt_mnTotalRevenueAmount_AN02]+[VA evt_mnTotalRevenueAmount_AN03]+[VA evt_mnTotalRevenueAmount_AN04]+[VA evt_mnTotalRevenueAmount_AN05]+[VA evt_mnTotalRevenueAmount_AN06]+[VA evt_mnTotalRevenueAmount_AN07]+[VA evt_mnTotalRevenueAmount_AN08]+[VA evt_mnTotalRevenueAmount_AN09]+[VA evt_mnTotalRevenueAmount_AN10]+[VA evt_mnTotalRevenueAmount_AN11]+[VA evt_mnTotalRevenueAmount_AN12]
End If
F0902.Fetch Next
VA evt_mnRevenueAmount_AN01 <- TK Amount - Net Posting 01
VA evt_mnRevenueAmount_AN02 <- TK Amount - Net Posting 02
VA evt_mnRevenueAmount_AN03 <- TK Amount - Net Posting 03
VA evt_mnRevenueAmount_AN04 <- TK Amount - Net Posting 04
VA evt_mnRevenueAmount_AN05 <- TK Amount - Net Posting 05
VA evt_mnRevenueAmount_AN06 <- TK Amount - Net Posting 06
VA evt_mnRevenueAmount_AN07 <- TK Amount - Net Posting 07
VA evt_mnRevenueAmount_AN08 <- TK Amount - Net Posting 08
VA evt_mnRevenueAmount_AN09 <- TK Amount - Net Posting 09
VA evt_mnRevenueAmount_AN10 <- TK Amount - Net Posting 10
VA evt_mnRevenueAmount_AN11 <- TK Amount - Net Posting 11
VA evt_mnRevenueAmount_AN12 <- TK Amount - Net Posting 12
VA evt_szRevenueCostCenter <- TK Business Unit
VA evt_szRevenueObjectAccount_OBJ <- TK Object Account
End While
//

xe sp20. update3. orcle 8.1

 

[ronnet]

Just to make sure are you building the NER every time you make a change?

 

[JDETECHIE]

Every time iam rebuilding the business function, even though it is not working for first instance.

 

[srijde]

Hi,
If you are trying to get the Total revenue, there is a JDE BSFN that would do the same. Its B1000009 - Calculate Total Revenue.

Sriram.
OW XE SP 19, AS/400, Citrix server.

 

[Zoltan_Gyimesi]

Hi mr,

What about to initialize your totaling ER variables at the beginnings of the BSFN:

VA evt_mnTotalRevenueAmount_AN01 = 0
VA evt_mnTotalRevenueAmount_AN02 = 0
VA evt_mnTotalRevenueAmount_AN03 = 0
...etc.

Zoltán