ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> MRP-G has same customer listed on all parts
http://www.istechforum.com/YaBB.pl?num=1369763816

Message started by gtladmin on 05/28/13 at 10:56:56

Title: MRP-G has same customer listed on all parts
Post by gtladmin on 05/28/13 at 10:56:56

Walter just ran MR-G and says that for all items in the report, there is the same customer (and other customers). But this one customer shows up for every item, which is not correct.
How do we figure out why this is happening?

Val

Title: Re: MRP-G has same customer listed on all parts
Post by gtladmin on 05/29/13 at 13:50:42

Following up here - Walter wanted to know if anyone has seen this before. Here is a sample of his output
for MR-G:

Item No: xxx-OS-50K7 Type: R Vendor: vendorname
Desc: LED, 50000k, 7LM TYP, Name: customername1
Reord Lvl: 100000 Reord Amd:200000 Prod Class: LEDS Stock U/M: EA
Lead time: 60 On Hand: 296200.00 Exp Bufr: 10 Del Bufr: 10
MRP Beginning Balance: 296200..00 Exp Sens:0 Del Sens: 0

Req Date Fin Date Qty On-Hand Pegged to Prod Code Cust/Vend Name Cust Order Order No St Date action
05/17/13 00/00/00 500000.00 796200.00 customername1 12095 4/18/13 Review
06/12/13 00/00/00 -30000.00 766200.00 CUSTOMERNAME2 35064 12015 3/20/13 DELSENS
06/12/13 00/00/00 -60000.00 706200.00 CUSTOMERNAME2 35064 12015 3/20/13 DELSENS
07/26/13 00/00/00 -36000.00 670200.00 CUSTOMERNAME2 35064 12124 5/02/13 DELSENS
07/26/13 00/00/00 -54000.00 616200.00 CUSTOMERNAME2 35064 12124 5/02/13 DELSENS
08/30/13 00/00/00 -36000.00 580200.00 CUSTOMERNAME2 35064 12125 5/02/13 DELSENS
08/30/13 00/00/00 -54000.00 526200.00 CUSTOMERNAME2 35064 12125 5/02/13 DELSENS
09/27/13 00/00/00 -36000.00 490200.00 CUSTOMERNAME2 35064 12126 5/03/13 DELSENS
09/27/13 00/00/00 -54000.00 436200.00 CUSTOMERNAME2 35064 12126 5/03/12 DELSENS

The records showing for "CUSTOMERNAME2" he says are the ones that don't belong, and he does not know why they are showing up. Any ideas?

Title: Re: MRP-G has same customer listed on all parts
Post by gtladmin on 06/04/13 at 05:44:52

Lynn, anybody? Is this the first time this has ever shown up?

Title: Re: MRP-G has same customer listed on all parts
Post by gtladmin on 07/18/13 at 08:51:52

Revisiting this as it keeps coming up. The CUSTOMER2 that shows up throughout the MRP has never ordered any of the parts listed in the MRP report. The Customer Order number showing in MPRP is actually the Customer PO#, and in looking at Sales orders there is an order# referencing the cust po #35064 that is closed; there is also an order with a SO# of 0 just above the closed SO that references the same 35604. Could be an order was started and either cancelled out or maybe the user's system boinked out of Evo during entry.

Might that record be somehow be the cause of this customer showing up throughout the MRP reports? Is there any reason why I can't go into the orders table and find the record and delete it? Would I have to go into any other table and remove records to clear this issue up?

Val

Title: Re: MRP-G has same customer listed on all parts
Post by gtladmin on 07/19/13 at 09:25:44

Gee we only seem to have these weird issues..

Update: I determined the customer info getting inserted into the MRP reports is directly related to sales orders that are closed and the SO number is 0 (of which we have quite a few, these are not real orders, usually created when a sales person messes up on the data entry and cancels out or whatever they do when they've messed up). Three times I have gone into Maintain DB and removed the "offending" SO and when Walter re-runs the MRP, the next customer name from the next SO #0 in the listing is showing up in the MRP report. So, I guess I have to remove all the sales orders with the number 0. Is there a global way to do that?

Val

Title: Re: MRP-G has same customer listed on all parts
Post by Lynn_Pantic on 07/19/13 at 16:01:42

If you truly have records in BKARINV with the Order Number 0, make a back up copy of BKARINV. Then go to UT-A, program NZFNR, file BKARINV, action delete, and filter for BKAR.INV.SONUM = 0

Title: Re: MRP-G has same customer listed on all parts
Post by gtladmin on 07/23/13 at 08:59:51

Thanks, Lynn! I was actually just logging in to ask that very question! How timely! I will give that a shot
and see if this fixes the issue. Will post back here

update 12:13Pm: When I try to run the utility NZFNR.RUN, it pops up with this error message:
Error: You are not licensed to run this program. Pleas contact wee.istechsupoprt.com to purchase
a valid license.

We are running our current (renewed) Evo license.....

Val

Title: Re: MRP-G has same customer listed on all parts
Post by gtladmin on 07/24/13 at 09:00:42

Final update:

After getting the ability to use the NSFNR.RUN utility, I was able to clear out all the orders with a sales order number of 0. Walter re-ran the MRP and it is clean. So that works.

However, this will come back to us, I am sure, but at least I know how to fix it. Now to fix the cause of the sales orders numbered 0....

Thanks for the help!

Val

Title: Re: MRP-G has same customer listed on all parts
Post by Prier Products on 07/31/13 at 13:35:03

We have a very similiar thing happening, except in IN-A. Every part number we look up has a blank Customer code and the name of the customer. In the Customer Table this customer does exist, and does have a blank code (I'm guessing it's an old one). If we don't want to delete the Customer from the table, how do you recommend we fix it?

We do not have any Sales Orders with zero only or start with zero.

Thanks!