Welcome, Guest. Please Login.
05/09/25 at 13:05:29
News:
Home Help Search Login


Pages: 1
Send Topic Print
MRP-G has same customer listed on all parts (Read 1626 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
MRP-G has same customer listed on all parts
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
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: MRP-G has same customer listed on all parts
Reply #1 - 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?
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: MRP-G has same customer listed on all parts
Reply #2 - 06/04/13 at 05:44:52
 
Lynn, anybody?  Is this the first time this has ever shown up?
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: MRP-G has same customer listed on all parts
Reply #3 - 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
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: MRP-G has same customer listed on all parts
Reply #4 - 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
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: MRP-G has same customer listed on all parts
Reply #5 - 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
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: MRP-G has same customer listed on all parts
Reply #6 - 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
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: MRP-G has same customer listed on all parts
Reply #7 - 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
Back to top
 
 

Val Feehan
  IP Logged
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
Re: MRP-G has same customer listed on all parts
Reply #8 - 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!
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print