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........

R04572 Check print Program not Kicking Manual Payment JD Edwards

Currently we are upgrading E8.10 to E9.1,We have an issue, check printing program not working for Manual payment, we tested all the set like F0417 version definition in P0413M, also 04/PP. no error all setup same as E810, also yes we have custom program for the check print , R5504572.
after intense investigation , I found in P0413M in print tab version defined as ZJDE0001, which is some how missing in our new  9.1.So I coded new print program version and define in P0413M , check started printing.

P0413M

JD Edwards EnterpriseOne Applications Multicurrency Processing - P0413M

A foreign currency payment is a payment that is in the foreign (transaction) currency of the voucher. You specify the foreign currency of a payment at the time you enter the payment. When you enter a foreign currency payment, these criteria must be met for the system to process the payment:

• The foreign currency of a payment must be the same as the transaction currency of the voucher.
• The base currency of the payment must be the same as the domestic (base) currency of the voucher.

https://docs.oracle.com/cd/E16582_01/doc.91/e15123/entermanforeignaltcurr.htm#EOAMP00153

Web client Exception Error JDE

This is some time error , intermittent , error try again and no error.

The test ID 882 of object 11 in section 14 conflicts with another report object and will be changed to a 1965.

The test ID 882 of object 11 in section 14 conflicts with another report object and will be changed to a 1965.


JD Edwards EnterpriseOne 9.1 

UBE Error during upgrade JD edwards EnterpriseOne 9.1

AD                       Tue Jan 05 22:51:24.472001 Jdb_ctl.c1947
JDB4100005 - Application code leaked 13 data pointers which were detected when freeing environment DV910 (EnvHandle 038B7E30) for user KUMARRAJ. Please refer to the debug log for details. If there are not enough details in the debug log to determine the cause, set DataPointerTracing=1 and Output=FILE in the [DEBUG] section of the JDE.INI and watch for this error message again. Or, set logDPLeaksAtSignoff=TRUE in the [DEBUG] section of the JDE.INI and look for JDB4100006 error messages. This message (JDB4100005) will only appear with debug tools code or when debug logging is turned on.

***** working on this************

UPDATE STATISTICS sql

USE AdventureWorks2012;
GO
UPDATE STATISTICS Sales.SalesOrderDetail;
GO

Alter Table add IDENTITY column SQL Server

ALTER TABLE GLSummarydelthis  ADD ID INT IDENTITY(1,1) NOT NULL

Current Date time default SQL Server Alter table

ALTER TABLE GLSummarydelthis ADD DateUpdate DATETIME NOT NULL DEFAULT (GETDATE());

Name Scope Conflict for xxxxxxx JD Edwards

Find this variable in Business function and fix'em.