Customer Enquiry

[Jeff73]

Hi List,

We created a new customer (AR) that we linked to an existing one: the new one is now the Parent and the old one the Child. I ran the AR Update... However, when I try to enquire on the new one thru the customer ledger inquiry, I get nothing and an error says nothing matched criteria. When I enquire on the Child (the old one), I do get records, so I'm sure at least those should pop up for the new parent.

Any ideas where to look?

Thanks,
J.

 

[John_Dickey]

The update program is date driven by the update date field in various files.
I cannot remember what date fields the A/R Update program is looking at, but
I think the drivers are the F0101 and F0150 records. I suspect your update
dates are such that the program does not realize it needs to update the
parent number in your F0311 records. Hope this makes some sense.

John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466

 

[Mike Dupaix]

Jeff,
Look at file F0311 and compare the customer number to the parent number. They will be the same. To change the parent, you'll need to run an updating WW or use some other editing tool.
Jeff73 <[email protected]> wrote:Hi List,We created a new customer (AR) that we linked to an existing one: the new one is now the Parent and the old one the Child. I ran the AR Update... However, when I try to enquire on the new one thru the customer ledger inquiry, I get nothing and an error says nothing matched criteria. When I enquire on the Child (the old one), I do get records, so I'm sure at least those should pop up for the new parent.Any ideas where to look?Thanks,J.
A7.3 Cume 11
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=50744
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World™ mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+


---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more


World, OW B733X and Xe

 

[Jeff73]

Re: RE: Customer Enquiry

Thanks John for your reply.

I actually enquired on F0311 records and the parent has been updated correctly. I'm running out of ideas...

J.

 

[John_Dickey]

RE: RE: Customer Enquiry

Well, maybe you have run across a program bug. The customer inquiry program
is a RPGSQL program - it actually builds an SQL statement that it executes
based on what information you fill in at the top of the screen (header
information). I would recommend going to JDE support at this point. You
could try debug, but I am not sure how that will work on the SQL stuff.
Setting your interactive job to log everything won't show the SQL statement
being executed, so that does not help. If the file data is correct, then
it has to be the program with the problem.

John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466