× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



How do you set the invoice numbers to be the BOL/Packlist numbers?  When BPCS 
was installed here about 6 years ago -- they set it up with using the ACR160 
Document Sequence Maintenance -- at each year end have to go in and update each 
prefix code.  We would really like to use the packlist/BOL as that is what most 
customers pay from rather than our invoice #.  How do we switch and what are 
the ramifications?

-----Original Message-----
From: bpcs-l-bounces+wbunch=wabashtech.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+wbunch=wabashtech.com@xxxxxxxxxxxx]On Behalf Of
bpcs-l-request@xxxxxxxxxxxx
Sent: Tuesday, March 08, 2005 9:14 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 3, Issue 55


Send BPCS-L mailing list submissions to
        bpcs-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
        bpcs-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        bpcs-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."


Today's Topics:

   1. RE: Invoice numbers - v. 405CD (Tom Sult)
   2. RE: Invoice numbers - v. 405CD (Moy, Bill)
   3. Re: Invoice numbers - v. 405CD (Al Mac)
   4. RE: Invoice numbers - v. 405CD (DeeDee Virgei)
   5. Re: Invoice numbers - v. 405CD (Al Mac)
   6. Re: ECM Special Charge Lines (Luczak Enterprises, Inc.)
   7. Re: ECM Special Charge Lines (Gina Algarotti)
   8. MRP calculation and Net Change versus Regenerative
      (Hans.G.LOEF@xxxxxxxxxxxxxxxx)


----------------------------------------------------------------------

message: 1
date: Mon, 7 Mar 2005 17:16:48 -0500
from: "Tom Sult" <Tom.Sult@xxxxxxxxxxxx>
subject: RE: [BPCS-L] Invoice numbers - v. 405CD

Roger,
Check and see if SIH records with a record ID of IX are retained; I was
able to account for all of my resupplys.

Tom
 

-----Original Message-----
From: bpcs-l-bounces+tom.sult=bwaycorp.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+tom.sult=bwaycorp.com@xxxxxxxxxxxx] On Behalf Of
Roger.Henady@xxxxxxxxxx
Sent: Monday, March 07, 2005 4:48 PM
To: SSA's BPCS ERP System
Subject: [BPCS-L] Invoice numbers - v. 405CD

The auditors have asked for a list of invoices.    They are testing the 
internal controls verifying the invoice sequence numbering.    I ran a 
query of SIH.    I'm missing Order type 9 - resupply orders.   They
don't 
affect sales  ---  no SIH record.       In ECH there is an invoice
number, 
   this is the last invoice against this order.    If multi-shippments 
were made on the resupply order - there is only one number retained. 

Any Ideas?

Roger Henady
Thorco Industries
--
This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a
message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.

Delivered-To: tom.sult@xxxxxxxxxxxx



------------------------------

message: 2
date: Mon, 7 Mar 2005 16:20:53 -0600 
from: "Moy, Bill" <bill.moy@xxxxxxxxxxxxxxxxxxxxxx>
subject: RE: [BPCS-L] Invoice numbers - v. 405CD

Roger,

        We are on 6.1 we do not use resuppy orders. Just a thought, using
system settings, our invoice number matches the packing slip number, if your
system does the same (my guess is yes, since your using invoice number when
billing is not effected). You can get the packing group number from the load
files LLH, LLL.

Bill Moy  

-----Original Message-----
From: Roger.Henady@xxxxxxxxxx [mailto:Roger.Henady@xxxxxxxxxx] 
Sent: Monday, March 07, 2005 3:48 PM
To: SSA's BPCS ERP System
Subject: [BPCS-L] Invoice numbers - v. 405CD

The auditors have asked for a list of invoices.    They are testing the 
internal controls verifying the invoice sequence numbering.    I ran a 
query of SIH.    I'm missing Order type 9 - resupply orders.   They don't 
affect sales  ---  no SIH record.       In ECH there is an invoice number, 
   this is the last invoice against this order.    If multi-shippments 
were made on the resupply order - there is only one number retained. 

Any Ideas?

Roger Henady
Thorco Industries
--
This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message
email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.

Delivered-To: bill.moy@xxxxxxxxxxxxxxxxxxxxxx


------------------------------

message: 3
date: Mon, 07 Mar 2005 16:26:33 -0600
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: Re: [BPCS-L] Invoice numbers - v. 405CD

We are also 405 CD ... we send out resupply orders the same way we ship 
customer orders, and this creates a "B" transaction in the ITH inventory 
history file.  You might take a look at whether there is info there that 
can help you ... for us, this happens BEFORE the Billing, when the invoice 
# would not yet exist, but it might be a way for you to get a report of 
resupply activity to supplement the invoice history requested by the auditors.

First off, you might inform the auditors that there is traffic through BPCS 
where there is no invoice involved, or the invoice # is "out of 
sequence"  as a normal practice... consider for example BIL600 billing 
adjustments, RMA credits, and as you noticed resupply orders are for 
inventory to be used INTERNALLY while Billing invoices are for sales to 
OUTSIDE customers, so there are no invoices for INTERNAL transfers ... it 
makes no sense to do a bill to yourself then have to pay it through A/P.

Will INV510 permit you to TRANSFER inventory between facilities without 
going through resupply orders?  Do the auditors need to know about 
inventory transfers between facilities?

When you looking at SIH and SIL also consider "special charges" as opposed 
to inventory shipped.

Data in ECH is unreliable for auditor tracking, considering that customer 
orders can "go away" any number of ways, some of them pretty rapidly after 
closure.  You might consider reviewing Customer Order Change Tracking software.

Second, inform the auditors that BPCS has fields in the system parameters 
to keep track of the last # used in various systems ... customer orders, 
shop orders, invoices, and so forth, and that there is a way to reset those 
#s, the intention being that perhaps at year end, or after a physical 
inventory, there is a need to restart at 1 if you not need to go thru all 
999,999 numbers available, but when a company does this, and still has 
history on the last time a number was assigned for a different purpose, 
there is all kinds of misleading results you can get.

We have a problem with shipping delivery ticket #s where we can end up with 
multiple shipments same tracking #, multiple invoices same tracking #, 
multiple tracking #s one invoice, other combinations.

There are opportunities for embezzlement that I am not going to spell out 
here.  If a person identifies themselves to me as an ERP auditor, and I am 
pretty sure they are for real, and not someone posing as one, then I can 
brief them on some of the areas where BPCS is particularly vulnerable to 
embezzlement, and what they can be looking for to see if a company has done 
a responsible job of protecting against that possibility.  This invoice # 
checking deal seems very superficial to me, like your auditors don't have a 
clue what is important.

Not that I do it, but it would be very easy for me to have the company send 
$ value stuff to the address of a confederate, and have the BPCS files say 
something entirely different, and if all auditors are doing is checking 
that the invoice #s have nothing missing in sequence and the $ adds up, 
then they would never catch me.  A company's safety lies in the honesty of 
its staff, not in the competence of using auditors who are not familiar 
with BPCS.

>The auditors have asked for a list of invoices.    They are testing the
>internal controls verifying the invoice sequence numbering.    I ran a
>query of SIH.    I'm missing Order type 9 - resupply orders.   They don't
>affect sales  ---  no SIH record.       In ECH there is an invoice number,
>    this is the last invoice against this order.    If multi-shippments
>were made on the resupply order - there is only one number retained.
>
>Any Ideas?
>
>Roger Henady
>Thorco Industries




------------------------------

message: 4
date: Mon, 7 Mar 2005 17:45:54 -0500
from: "DeeDee Virgei" <DeeDee.Virgei@xxxxxxxxxxxxxx>
subject: RE: [BPCS-L] Invoice numbers - v. 405CD

We've satisfied auditors in the past w/ copies of the invoices... We've 
customized BPCS billing, capturing the invoice spool files on a flat file that 
we sent out to burn on CD...  Every invoices # is then accounted for on the 
CDs.  I'm hoping this is good enough for our next audit coming up.  I know that 
times have changed w/ SOX...

Good luck.

DeeDee Virgei
Project Leader

Nelson Stud Welding, Inc. 

 -----Original Message-----
From:   bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx]  On Behalf Of 
Roger.Henady@xxxxxxxxxx
Sent:   Monday, March 07, 2005 4:48 PM
To:     SSA's BPCS ERP System
Subject:        [BPCS-L] Invoice numbers - v. 405CD

The auditors have asked for a list of invoices.    They are testing the 
internal controls verifying the invoice sequence numbering.    I ran a 
query of SIH.    I'm missing Order type 9 - resupply orders.   They don't 
affect sales  ---  no SIH record.       In ECH there is an invoice number, 
   this is the last invoice against this order.    If multi-shippments 
were made on the resupply order - there is only one number retained. 

Any Ideas?

Roger Henady
Thorco Industries
-- 
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: deedee.virgei@xxxxxxxxxxxxxx





------------------------------

message: 5
date: Mon, 07 Mar 2005 16:47:21 -0600
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: Re: [BPCS-L] Invoice numbers - v. 405CD

Another thought

If you are like us
(a) there are "B" transactions for shipments in which there is no 
corresponding SIL detail line because either it is a resupply order or it 
is a repair outside of BPCS ... for example "shipping made this mistake ... 
we did not REALLY ship this stuff to that customer ... please VOID the 
transaction before it gets billed"
(b) there are SIL transactions for billing shipments in which there is no 
corresponding "B" transaction ... for example the shipping printer was 
malfunctioning and they in a rush to get product out door, so they used a 
handwritten paperwork outside of BPCS ... be careful matching this since 
BIL600 creates a dummy customer "order" unrelated to the order on which the 
shipment "really" belonged.

Well IBM documents 3 ways that you can do MATCH and NO MATCH with 
query/400, and I figured out some other ways.

Anyhow with link type 3 you can list all records in primary file that have 
no match in secondary file ... so find something to link on such as date of 
transaction and customer order # and item # that got shipped, then you can 
get a list of "B" transactions that had no corresponding invoice, and 
invoices that had no corresponding "B" transaction (2 lists).

Also if you are like us and using auditors a bit smarter than I speculated 
in my last e-mail, there might be value in identifying "B" transactions 
whose data not agree with the subsequent invoices, because in our case we 
make a LOT of corrections between BPCS steps.

>We are also 405 CD ... we send out resupply orders the same way we ship 
>customer orders, and this creates a "B" transaction in the ITH inventory 
>history file.  You might take a look at whether there is info there that 
>can help you ... for us, this happens BEFORE the Billing, when the invoice 
># would not yet exist, but it might be a way for you to get a report of 
>resupply activity to supplement the invoice history requested by the auditors.




------------------------------

message: 6
date: Mon, 7 Mar 2005 17:24:58 -0500
from: "Luczak Enterprises, Inc." <luczakent@xxxxxxxxxxxxx>
subject: Re: [BPCS-L] ECM Special Charge Lines

ECM calls base BPCS objects so that if you are trying to enter a special line 
it should process it the same way as it would if you enter it manually. I 
believe in ORD700 you need a quantity on special items and I do know that 
typically I have entered a quantity with any special lines that I have posted 
with ECM, so try putting the quantity of 1 in OLQTYO and see if that helps you.

Regards,

Brian Luczak

Confidentiality Notice:  This email is intended only for the person or entity 
to which it is addressed and may contain information that is privileged, 
confidential or otherwise protected from disclosure and may contain information 
belonging to the sender that is legally privileged.  Dissemination, 
distribution or copying of this email or the information herein by anyone other 
than the intended recipient, or an employee or agent responsible for delivering 
the message to the intended recipient, is strictly prohibited. If you have 
received this email in error, please notify the sender immediately and then 
delete it. We have taken precautions to minimize the risk of transmitting 
software viruses, but we advise you to carry out your own virus checks on any 
attachment to this message.  We cannot accept liability for any loss or damage 
caused by software viruses.
  ----- Original Message ----- 
  From: Luczak Enterprises, Inc. 
  To: Luczak Enterprises 
  Sent: Monday, March 07, 2005 4:56 PM
  Subject: [BPCS-L] ECM Special Charge Lines


  date: Mon, 07 Mar 2005 12:57:23 -0500
  from: "Gina Algarotti" <Ginaa@xxxxxxxxxxxxxxx>
  subject: [BPCS-L] ECM Special Charge Lines

  I'm having some problems passing special lines thru ECM. 
  EDI is on version 3.2 release 1 and BPCS is Ver 6 release 2.
  I've been to the archive were I've found the fields that I should be using.

  OLPRM = *SPECIAL
  OLITN  = *BLANK
  OLVNI = *Blank
  OLID1 =  CHARGE
  OLQTO = 0
  OLOVP = 300
  OLRLK = BA

  I created another line with the same info as a product line except for the 
above fields. 
  It errors because the quantity is 0.  What am I missing? 

  Thanks in advance.





  **********************************************************************
  This email and any files transmitted with it are confidential and
  intended solely for the use of the individual or entity to whom they
  are addressed. If you have received this email in error please notify
  the system manager.

  This footnote also confirms that this email message has been swept by
  MIMEsweeper for the presence of computer viruses.

  www.mimesweeper.com
  **********************************************************************






------------------------------

message: 7
date: Tue, 08 Mar 2005 08:51:48 -0500
from: "Gina Algarotti" <Ginaa@xxxxxxxxxxxxxxx>
subject: Re: [BPCS-L] ECM Special Charge Lines

I've tried that. It comes back with "Invalid Item Number". 



thanks
Gina



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************




------------------------------

message: 8
date: Tue, 8 Mar 2005 15:01:46 +0100
from: Hans.G.LOEF@xxxxxxxxxxxxxxxx
subject: [BPCS-L] MRP calculation and Net Change versus Regenerative

We are running BPCS V 6.1 GA without any BMR but with a lot of own 
modifications but the MRP programs haven't been touched by this 
modifications.

We are (once more) intending to improve the MRP usage of our BPCS. In 
general the MRP works well if all parameter / conditions are properly set 
up.


First issue:
Currently we face the following issue. Our central sourcing dept. would 
like to use only annual purchase order for raw metals e.g. a huge quantity 
to supply the yearly demand in one PO line on one due date. 
I did some tests in our TRAINING environment and BPCS MRP is reacting as 
follows (depending on stock situation) if the 

PO is settled up for Jan 1st. the requirements are decreasing the PO 
quantity through the year, and there is no other MRP action.
PO is settled up for Dec. 31st. the projected on hand is going negative 
until the PO due date is reached, and there is also no other MRP action.

PO is settled up with PO line per period (weekly/monthly) the projected 
stock on hand will be balanced per due date of the PO lines, but there is 
no MRP message.

Following our expericend from shop order/planned order I was expecting 
that some MRP messages e.g. Cancel, De-expedite, Expedite, LT Violation, 
Past Due or Release.  But none of them came up after the MRP calculation 
run (MRP600) for the P.O. mentioned before.
-- the PO have been created via PUR152 as scheduled ones for raw material.

Secondly:
The difference between Net Change and Regenerative is that only items 
which need to be re-planned are treated during the Net Change. For me the 
result should be the same. If there is any need to change, the MRP will 
propose to act. The difference might be that "R" will crate new records in 
KFP/KMR and "N" will keep those which haven't any different order/demand 
situation as before and I guess that this is implicated by the Activity 
flag (see MRP300) or am I wrong.

Thanks for any tip/advice concerning the above.

rgds/mfg
Hans-Georg Loef
Impress
central MIS
Bahnhofstr. 16-17
56575 Weissenthurm
Phone: +49 (0)172 516 36 45
e-mail: hans.g.loef@xxxxxxxxxxxxxxxx

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Discover Impress on http://www.impressgroup.com
 
The  information  contained  in this e-mail and any attachments is 
strictly confidential  and  may be legally privileged.
It is intended solely for the use of the individual or entity to whom it 
is addressed. If you are not the named  addressee,
you are hereby notified that  it is prohibited and may be unlawful  to 
disclose, distribute, store, copy the information in 
any medium or usage for another purpose.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------

-- 
This is the SSA's BPCS ERP System (BPCS-L) digest list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.



End of BPCS-L Digest, Vol 3, Issue 55
*************************************
This is an e-mail from Wabash Technologies, Incorporated.  It is confidential 
to the ordinary user of the above e-mail address.  It may contain copyright 
and/or legally privileged information.  No other person may read, print, store, 
copy, forward, or act in reliance on it or its attachments.  If you received 
this in error, please e-mail to humanresources@xxxxxxxxxxxxxx



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.