|
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 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.
midrange.com
