Xilnex Can not start new cafe POS transaction after EOD

Hi, there

    Xilnex allow multiple EOD in a day where you can start new sales and then close it and then start over again. What if after doing EOD, (cash declaration, EOD) , you can not start cafe POS transaction, you might have pending sale order in cafe POS.  

All you need to do is to open up sales history, and then void particular sales order as shown above screenshot. 

Let's say you start on new calendar day, but you might have 1 pending sale on yesterday. You have to void that order from sales history before you can complete the EOD process.

note: before you can have this function, pls make sure it's turn on.

Hope that helps..

TQ

 

Xilnex POS ensure core data app is on

Hi, there.

  For those who had run Xilnex POS system. You might sometimes get this error when cafe POS user enter dine in / take away screen. It would display

 " ensure core data app is on " It's been common that local POS 's IP would change in some scenarios. If it did, you may need to revise fire order app 's 

configuration file for the IP change. And then change the IP in xilnex system configuration screen.  

   How to check you current IP ?  You may just type in "ipconfig /all " in command prompt.  

After setting the new IP into system configuration screen, you may restart the fire order / core data app and xilnex.

 You should be able to enter  cafe POS screen. Hope that helps...

Installing activeX / media object into E1 JDE webclinet....

Required Internet Explorer ActiveX Options

If the following options still do not allow for the activeX control to install, then it may be an issue with the user / group profile in Windows.  Try creating a new user account in Windows with admin permissions and see if it can install.  

In the Internet Explorer options:

1. Select the Security tab
2. Highlight "Local Intranet"
3. Select Custom Level.  ActiveX controls and plug-ins (should have the following settings)
   • Allow previously unused ActiveX controls to run without prompting - enable
   • Allow Scriplets - enable
   • Automatic prompting for ActiveX controls - enable
   • Binary and script behaviors - disable
   • Display video and animation on a webpage that does not use external media player - disable
   • Download signed activeX controls - enable (if using non-Windows admin change to Prompt to be certain to get the Windows admin login prompt)
   • Download unsigned activeX controls - disable
   • Initialize and script ActiveX controls not marked as safe for scripting - disable
   • Only allow approved domains to use activeX without prompting - disable
   • Run ActiveX controls and plug-ins - enable
   • Script ActiveX controls marked safe for scripting - enable
4. After confirming the settings are correct, click OK > General tab > Click on Settings next to the Delete button > click on View Objects
5. Right click or highlight and delete / remove any activeX controls that begin with jde. Will probably see two sets of files for ocx and inf (if file extensions are turned on).  
6. Once these are removed, close the window 
7. Click on View Files, if this folder has anything in it, do a Ctrl-A to select all and then delete
8. Once these are removed, close the window
9. click OK twice to get out of the Internet Options.
10. Exit all IE browsers
11. Launch a new browser
12. Log into E1 and try again 
13. If it still fails, try running with ‘Enable Protected Mode’ turned off and add the E1 URL to the Local Intranet Trusted Sites.  Restart the browser and try again.

If above failed,  pls try manually register ocx file as guided below :  (see attached for ocx file)

Manually Registering Files

For XE and ERP 8.0, the ActiveX controls are jdeexpimp.ocx and jdewebctls.ocx. For EnterpriseOne 8.9 the ActiveX controls are jdeexpimpU.ocx and jdewebctlsU.ocx. They are found in the webclient.war\axctls in the .cab files. You can extract the ocx files, distribute them, and use the DOS command "regsvr32" and the OCX file name to register the controls.  

If you are using a 64-bit version of Windows and get an error trying to register to system32, move the files to the C:\Windows\SysWOW64 and register them there and they will work correctly.

For example:
regsvr32 c:\windows\system32\jdeexpimp.ocx

For systems that will access both Xe/ERP 8.0 and E1 8.x/9.0, you should distribute and register both sets of OCX files.

E900 how to implement Global Password Policy in JDE

Hi, Global Password Policy is a set of criterion used by security server to validate user'spassword upon JDE login.

Eg.. limit of daily password change, password length, number of numeric and alphabet used, and etc..

In order to run this policy,  I would suggest you to start off with E1 client as below :  (because by doing in fat client would require security cache reset)

1. Go to GH9052 , right click on user security for the values . Enter required criteria for all your users. Eg, password length 8

With this setting, it would update F98owsec.sceuser = 01 for those users created in this table

2. After this, user may still login using their old password policy until they go for password change in system option in E1 web or user option in Fat client. Then, it would follow the new policy set above.

How about making all users to take effect upon their next login ?
1. You may open P98owsec\form\revise all and tick the option "Force Immediate  Password Change"

2. Otherwise, you may manipulate sql as below :

by doing so, it would update to F98owsec.scsecf3 = 01 ...The user will be prompted to change password according to the current global password policy when he or she log in to JDE...
after the password change, the F98owsec.scsecf3 = 01 will be reset back to 0...

note: In JDE rule,  new password  must not be same as previous 10 old password

Hope that helps...

Thanks

some rules of setting up Approval Route Code in P43008

Each document type Eg OS, OP can have same approval route code
Each approver can be budget type or monetary type.  If the budget approver field is left blank in P43008, then it would be considered this PO is bypassing the budget approver.
Below is the monetary approver showing the rules of the entry:

How does E1 fat client's local database work ?

Hi, what is local db used on fat client ? 

According to Oracle, You can access the Data from DB Server by bypassing the Security Server but you will not be run any jobs on the Server.

For the second query the same scenario applies, user will be able to fetch the data but will not be able to run the UBEs.

The prime purpose of local database is used to store the specs locally. Local Database must be started before you try to login to either FAT or Deployment server, or else the login will fail irrespective of the fact whether Security Server is turned on or off.

This database is used when a developer executes any HTML or web application locally.

The information is populated to a local copy of the HTML serialized object tables (F989999 and F989998).

This enables the developers to examine code prior to checking that code in.

This database also serves to contain a copy of the Central Object information on a fat client (as of 8.12 Central Objects

moved to an XML format instead of the old TAM format). In this way the fat client uses the copy of Central Objects contained locally to execute the EnterpriseOne code.

Changing the Object Owner Password Post E1 Install

If there is a need to change the object owner passwords after EnterpriseOne is installed and running, that is done at the database level.  We still recommend adding the [DSPWD] (as described above) to the Deployment Server JDE.INI in case of a future install or upgrade to EnterpriseOne.  

For SSE or OEE Local Database

SSE (SQL Server Express)

• The EnterpriseOne install delivers the 'sa' user account on a workstation install and the 'sa' AND jde accounts on the Deployment Server install.
• The 'sa' user account will always use an encrypted password.
• To encrypt the 'sa' user password, use ReconfigureMSDE.exe.  The exe will generate an encrypted password based on the disk volume where the local DB is installed.  
• If logging into E1 (and SSE), it will use the sa account and the generated/encrypted password.  If you are logging into the SSE (outside of E1) using the SQL Management Tool, you will need to run ReconfigureMSDE.exe to set the password to a known value (e.g., "admin").  Then, when you are ready to run E1 again, you will need to run ReconfigureMSDE.exe again to set the password to a generated/encrypted value.
• The 'sa' user password should not be changed.
• The local database name is JDESSELocal.
• There are no local schemas.
• E1 does not use JDE to connect to the local database, it uses the sa account. 
• Important!  SSE is supported through EnterpriseOne 9.0.  EnterpriseOne 9.1 and above application release does not support SSE.  Check the Certifications page for details.

OEE (Oracle Enterpise Edition)

• The EnterpriseOne install delivers the system and JDE user accounts.
• The system user account will always use an encrypted password.
• To encrypt the system user password, ReconfigureMSDE.exe is used.  The exe will generate an encrypted password based on the disk volume where the local DB is installed.
• The system user password cannot be changed.  This password is generated on the fly by EnterpriseOne.
• The local database name is E1Local.
• Tablespaces (schemas) are delivered in OEE.  The tablespaces are (Ex: SPEC_910, JDEPLAN910, JDECTL910, JDEDD910, JDSYS910, JDEVL910, JDEOL910 and JDEData910).
• E1 does not use these DB owners to connect to the local database. 
• The passwords for the tablespaces (schemas) and JDE user can be changed using the sqlplus command.
• E1Local is installed with a setting in x:\oracle\E1local\network\admin\sqlnet.ora -- SQLNET.AUTHENTICATION_SERVICES=(NONE) -- which prevents any user on any machine from connecting to the local database using Windows permissions.

Hope that's clear..

JDE Enterprise server's processes

Jdenet_n is a network listener process.When E1 Services are started on enterprise server, a parent JDENET_n process is initiated. In Enterprise One, requests from a client or server to a server are handled through JDENET_n processes to communicate the request between different types of kernels. This parent process initiates other child processes which are called kernel (JDENET_k) processes.

Metadata Kernel: Processes XML spec access requests. The way that business functions process on the server has changed with release 8.12 and tools release 8.96. This is due to the change from TAM spec to XML spec files. The metadata kernel changes XML into C structures that will be readable by the call object kernel.

SMC Logging: Management Kernel is used .

We may refer various kernel log in enterprise server log folder Eg..jde_PID.log 

metadata kernel  is using jdenet_k.exe   

scheduler kernel  is using jdenet_k.exe

security kernel is using jdenet_k.exe

queue kernel is using jdenet_k.exe

ube kernel is using jdenet_k.exe

COK is using jdenet_k.exe

package kernel is using jdenet_k.exe

workflow kernel  is using jdenet_k.exe

saw kernel is using jdenet_k.exe

manangement kernel is using jdenet_k.exe

Each of them has its own role and functionality. You may open up these logs and trouble-shoot based on the error stated inside.

How to check why payment voucher failed to be reversed - MOVEX

GLS200 VOUCHER display option 18 for reversal
GLS900 voucher reversal
When there is failure like this, it is included in payment proposal

Change its FPLEDG.EPPYST  to 0 

EPPYST = PAYMENT STATUS

You may strdfu or sql to change the field above

Hope that helps.

How to handle mms100 order with status 15/15

Whenever the MMS100 distribution order become status 15/15, the order can not be open or processed with message "order is locked - status is 15/15",

In order to clear this status, we need to enter 14 (rcal)  as below:

How to trouble-shoot suspense account in GLS037 or in GLS210

Hi, there.
Every ERP system has their own account rule setup. This is the setup where it shows what the account code will be pointed to from the customer invoice or vendor payment voucher.
In MOVEX, it's used in CRS395. Let's take this example from customer order

Above has an error where the account is pointing to 99993 OI suspense instead of account code 51201 .
In order to identify the error, we have to look at the existing 7 dimensions used in the gls037..
One of the dimensions is not met in crs395 , it would fall into suspense account.

If we look into this CO 's customer code, its customer group is defined as 120...

So, we need to open up CRS395 \ OI event for the option 11 exception

Go to its exception (opt11) and walk through the priority screen for the correct account code, Say 51201 PTS local sales...Once found the 51201, you have to check if the customer group was already defined under this CO's customer? If not, add the customer group into it..

If the 120 customer group is defined, the CO's account code will be captured as 99993 as exception.

Hope that helps..


note: Error found in gls037 could be the entries not balance or the account is in suspense account..

JDE GL Batch not approved for posting

Hi, there could be 2 things that cause this error..

 1.Try to set status from P (pending) to A (approved). It's located in P0011 row exit menu

 IF the error still persist after done so. Eg, out of balance

 2. The system displays this error when you have Batch Management Approval turned on in the General Accounting Constants and you have not set up your user id as an approver for the user associated with the batch you are trying to post. Access the Batch Approval Constants (P00241) and set up your user id as an approver for the user id associated with the batch.


  Hope that helps...

MOVEX - How to renew SO series and SO invoice series no if the running no is out?

steps :

1. Open up CRS165 for SO series and then MFS165
2. How to identify their series code ? Pls open up SOS010 for their respective code

3.Once identified, go to CRS165 to change the SO series no by refering to SO series '4'
   If for invoice series no, pls take 'U' and then go to MFS165

4. In MFS165, say the current invoice running no is used up and shown as below :
   Pls change to new series no as highlighted

note: If the above new series no is occupied, pls use another set which has no conflict.

5. As for the CRS165, pls do the same as what is shown in MFS165 but do refer to  '4'


TQ

MOVEX - How to extend Journal entry number

Hi, when doing gls100..there are sometimes the voucher no is exceeded with the following message:
All you can do is to open up CRS400 and CRS410 to add new series number as below :

MOVEX - how to create system calendar

Hi, below are the steps on how to create system calendar?
System calendar is used to set the duration of the priods defined in the MOVEX.
Eg, DO processing will stop on particular Satursday if not ticked


1. Goto crs900 and copy exising fiscal year Eg, 2018 check if it has the DO option being ticked..
 

2. Once defined all the requirements, you may go to back crs900 and hit F13 3 times. It will generate calendar year based on the year range.

After this CRS900, you need to open up CRS910 for creating a new set of  the set of years that you just created in CRS900.

Voucher no being 00000 or blank in the SO invoice

This could be the SOS980 SO invoice restart processing is not completed and halted in there.
All you can do is to go to AS400 RPG screen, hit the "WA" to find those LCKW lcoked jobs and then end the locked job.

Last step is to rerun the SO980 jobs.

That's it.

TQ

MOVEX - how to add new year SO invoice series no

Hi, wondering how to add new series number for service invoice ?

Here are the steps :
1.Check out SOS010 service order type for the series number used  Eg..301 order type
2. Then go to MFS165 for new year running number by duplicating last year for current year
3.Once done, you may generate invoice on sos180 for the new calendar year ..

MOVEX - How to hide and unhide certain field in program

Hi, there.
In order to cater for this requirement, you have to create records in SES100 and SES010 respectively.
Below are the simple steps :

Say your want to grant access to particular user for access right..Like not editable

SES200 : Define field control on program

SES100 :  Define field group

SES010 : Define who can have the right ...

SES010 : Define its right....

Hope that helps...cheer!

* Table MITMAS item master
* Table MITMPR item pricing : Purchase Price : PUPR

How to identify which table being used by the object in MOVEX

Hi, there.

One thing to trouble-shoot the MOVEX application and data integrity in MOVEX.  We have to identify what are the tables being used by the MOVEX application.
For example, GLS037 screen

1. Open the GLS037,
2. Enter " Shift + ESC " to activate the command line
3. Enter 14 "display open file "
4. It shows a list of tables used in the screen
5. RUNQRY *n table (library table) to see which table is containing the data that you wanted to locate

JDE E910 how to add userID into standard R90351 User Taskview Report

Hi, you may use below steps for the task.

F95921 Table will be used to list out users assigned under roles. Please follow the steps to customize R90351 report

1. Create a copy of V9005A object like V56XXXX in OMW. Insert into project and then select it and select COPY.
     Open the V56xxxxx in design mode - Start Business View Design Aid

. Add F95921 table and create simple join on F9005.VARNAME= F95921.FRROLE

3. Create a Copy of R90351 object and open in design mode. Eg R5690351..

4. Reselect newly created business view (Refer #2) for ":Role Header Section" and perform event rule validation to 
ensure code is updated (you may run the report once to ensure output)

5. Select F95921.TOROLE column from business view list and place right after Role ID to display

6. you may select "Print On Change Only" property from Advance Tab for "Role ID"

Hope steps will help to change your code accordingly

Thanks

JDE E910_TR9.1.3.4 svrpkgbuild.log - What does it mean by this ?

Sun Aug 09 17:25:47  -  Copy successful

Sun Aug 09 17:25:47  -  Package deployed.

Sun Aug 09 17:25:48  - 

Sun Aug 09 17:25:48  -  Finalizing SO deploy on server MYJDEAPP.

Sun Aug 09 17:25:48  -  Process ID\Thread ID: 6936\6796

Sun Aug 09 17:25:48  -  Machine type retrieved OS = INTEL; Ver = 6.1

Sun Aug 09 17:25:48  -  Server initialized now sending message back to the build machine.

Sun Aug 09 17:25:48  -  Message sent.

Sun Aug 09 17:25:48  -  Clearing UBE specs.

Sun Aug 09 17:25:55  -  Persistant UBE cache deleted.

Sun Aug 09 17:25:55  - 

Sun Aug 09 17:25:55  -  Unlocking the server after Normal Package Deploy.

Sun Aug 09 17:25:55  -  Unlock server after Normal Deploy.

Sun Aug 09 17:25:55  -  Metadata kernel unlocked.

Sun Aug 09 17:25:55  -  UBE subsystem unlocked.

Sun Aug 09 17:25:55  -  Kernels unlocked.

Sun Aug 09 17:25:55  -  Server unlocked and ready for business.

Sun Aug 09 17:25:55  - 

Sun Aug 09 17:25:55  -  Transferring the SvrPkgBuild.log to the Deployment server.

According to Oracle :

The SvrPkgBuild.log file is unique for each Package (Full or Update). When the build happens on the Enterprise server, this file is created and all the activities are written in this log file. This includes the package build completion.

Now when you deploy this package, the information about locking / copying / unlocking and deployment status (Success / Failure) is written in this same log. There is no separate log file to mention about deployment process. The same file is updated, even if deployment is done from a non-build machine. Example, you built the package from Machine A, but deployed from Machine B. The deployment related lines are written on the same log file.

If the R98825D pdf and the SvrPkgBuild.log mentions success about the deployment, you can consider the deployment to be successful. It is not important if the deployment was done from the build machine or a different machine.

Hope that helps..