Can't delete customer master

SULLY1

VIP Member
Can\'t delete customer master

I'm not sure if this is the correct forum to post this question but here goes.

We have an address book record type VG that has a customer master record also. It is a valid supplier but not customer. We can't delete this record using P03013. Any ideas.

Patty
 
Re: Can\'t delete customer master

Patty,

I don't think the tech forum is the right place BUT make sure there is no open a/r for the ab#.....

Gene
 
Re: Can\'t delete customer master

Patty, If there are any AR records, these must be deleted before you can delete the customer master records. Check F03B11 and F0312.

SULLY1 <[email protected]> wrote:I'm not sure if this is the correct forum to post this question but here goes.We have an address book record type VG that has a customer master record also. It is a valid supplier but not customer. We can't delete this record using P03013. Any ideas. Patty
XE/SP18.1/One-off SP.18_E1/U5 Unix HP900, Oracle 8.1.7
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=53846
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE 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!?
The New Yahoo! Search - Faster. Easier. Bingo.


World, OW B733X and Xe
 
Re: Can\'t delete customer master

There are no open balances. In fact there are no records in F03B* tables.
 
RE: Can\'t delete customer master

check that the customer does not exist in any of these files:

f0010
f0150
f0311
f03b11
f03b14
f0411
f08901
f0902
f0911
f1501b
f03b29
f1797
f4102
f4211
f4311
f4801
f4013
f4201

§
 
Re: RE: Can\'t delete customer master

Thanks for the reply. JDE said you can't delete the customer if it has AP activity. I have asked them to enter a SAR to allow deletion of the customer master record F0301 if there are no associated AR records.

Patty
 
Back
Top