Technical Corner: JD Edwards EnterpriseOne jde

Showing posts with label JD Edwards EnterpriseOne jde. Show all posts

Tuesday, November 2, 2010

Not able to print checks JD Edwards xe e1 1world

My user submited a job using work with payment group(R04570) and checks are not visiable at automatic payment groups screen.

Solution: Sometime when job stuck in jobqueue or you kickoff from jd edwards because of citrix connection problem and you are running job locally. you are not able to see checks in P04571 program because its not yet created. but when you try to re-submit these batch again you are getting blank reports, because pay status is "Z" - means pending, so in order to print these checks you have to change pay status (RPPST) in F0411 from Z to A. after changing status you can create checks

Thursday, October 21, 2010

Error: Intercompany Out of Balance -JD Edwards EnterpriseOne, V-Batch

If you are not able to post V- Batch (voucher) getting following error, I fix these errors following way:-

Informational: Call From     : rKumar
Contact       :
Phone Number :
Tickler Date : 10/21/2010
Subject       : Error: Intercompany Out of Balance
Cause . . . . . Your intercompany settlements are out of balance for
this batch. The intercompany settlement method being used
is either '1', '2', or '3'. When using these methods of
intercompany settlements, transactions between companies are
allowed. The post will create intercompany settlements for out
of balance companies, but each document within the batch, as
well as the batch as a whole, must be in balance (debits equal
credits).

Resolution. . . Please clean up any out of balance entries and then Repost this batch.

First calculate total by using following queries and store in temp tables

select gldoc,sum(glaa)glaa into jde_rk.dbo.temp693431 from proddta.f0911 where glicu=694337 group by gldoc
select rpdoc,sum(rpag)rpag into jde_rk.dbo.tempRP693431 from proddta.f0411 where rpicu=694337 group by rpdoc

After that find exact document number which is causing out of balance
select * from jde_rk.dbo.temp693431
left outer join jde_rk.dbo.tempRP693431 on gldoc=rpdoc
where glaa<>rpag

Talk to finance department before update F0911 Data, you have to put difference and change F0911 record.

select glaa,* from proddta.f0911 where gldoc=506594.0 and glicu=694337
update proddta.f0911 set glaa=23322 where gldoc=506594.0 and glicu=694337

Error: Intercompany Out of Balance- JD Edwards EnterpriseOne

If you are not able to post V- Batch (voucher) getting following error, I fix these errors following way:-

Resolution. . . Please clean up any out of balance entries and then Repost this batch.

First calculate total by using following queries and store in temp tables

After that find exact document number which is causing out of balance
select * from jde_rk.dbo.temp693431
left outer join jde_rk.dbo.tempRP693431 on gldoc=rpdoc
where glaa<>rpag

Talk to finance department before update F0911 Data

select glaa,* from proddta.f0911 where gldoc=506594.0 and glicu=694337
update proddta.f0911 set glaa=23322 where gldoc=506594.0 and glicu=694337

Note:- JD Edwards not recomending to use SQL, use this method with your own risk. Before doing above Make backup of F0911 & F0902.

Tuesday, October 19, 2010

How to fix Double sales update in JD Edwards /Enterpriseone

This is I think a common problem in JD Edwards , if user is doing sales update, sometime they run wide open sales update, i mean with wrong data selection, If anyone is doing sale update without next status is equal to 620, then this will update your already updated orders. I fix double sales update following way:-

1. If there are 50/100 sales order then I will ask user to enter credit sales order with same quantity and do sales update.

2. if user by mistake updated more than 1000 orders also if they already posted IB and G batch(In our setup we hit cardex at the time of sales update )

a.Take backup F03b11,F4111,F0911,F0902,F4211,F41021

b. If the batches for the user did double sales update from P0011 screen.

c. Go at F03B11, and find all the sales order using batch no.(select rpdoc,rpsdoc,* from proddta.f03b11 where rpicu=111111)

d. Go at F4211 and update next status,last status.

e. delete that batch from F03b11.

f. find all the account # from F0911, select distinct glaid from proddta.f0911 where glicu=111111

g. delete batch from f0911.

h. use Repost program R099102 and update all the affected account.

Note: use this process if you are confident, with your own risk.