Christy Poole
ACS SYAN BPCS SUPPORT
Tel: 01952 607000 - Fax: 01952 677278 - DDI: 01952 607008
EMAIL: christy.poole@xxxxxxxxxx - WEB: Www.syan.co.uk - www.acs-inc.com
ACS SYAN - The Specialists in IT Outsourcing and Server Solutions
ACS Syan, Hortonwood 37, Telford, Shropshire, TF1 7GT
.
----- Forwarded by Christy Poole/Telford/Syan Ltd on 24/04/2009 15:00
-----
Christy Poole/Telford/Syan Ltd
24/04/2009 07:22
To
bpcs-l@xxxxxxxxxxxx
cc
bpcs-l@xxxxxxxxxxxx, bpcs-l-bounces+christy.poole=syan.co.uk@xxxxxxxxxxxx
Subject
Re: Old Records in BBL
Hi
We had to look at cleaning up some ZL BBLs but wanted to understand how
they had occurred first. In our caase the majority were not special
lines.
This may not apply to you but I proved and tested the following in the
situation we had (I had contacted Infor to ask what could create ZL BBLs
but was advised that although the issue had been reported before to them,
no one had ever found a reason/scenario - I advised them of mine for
future reference) :
The BBL's (in my case) were set to ZL as a result of an RMS contract being
made inactive before the whole of the order was completed and invoiced.
The Sales Organisation Parent also gets blanked out on BBL and the lines
in ECL get set as though they have been deleted when in fact in my testing
they have been shipped and were just waiting invoicing..... so had LQORD,
LQSHP etc. populated. When the RMS contract is made inactive it then
deletes the lines regardless of the processing already on them. In our
case these lines had not been invoiced.......... The site concerned had
been using financial orders when they realised (in some cases) that
invoices had not been created but had not reported it as an issue to us...
There is a BMR - BMR63318 - though we will just using the workaround
making sure that no RMS contracts are deleted without the whole order
being complete.
Hope that helps someone, it might not be your scenario for ZL's on BBL but
it one I have tested and proven (we are on V6.1.00).
Regards
Christy
Christy Poole
ACS SYAN BPCS SUPPORT
Tel: 01952 607000 - Fax: 01952 677278 - DDI: 01952 607008
EMAIL: christy.poole@xxxxxxxxxx - WEB: Www.syan.co.uk - www.acs-inc.com
ACS SYAN - The Specialists in IT Outsourcing and Server Solutions
ACS Syan, Hortonwood 37, Telford, Shropshire, TF1 7GT
.
bpcs-l-request@xxxxxxxxxxxx
Sent by: bpcs-l-bounces+christy.poole=syan.co.uk@xxxxxxxxxxxx
23/04/2009 18:00
Please respond to
bpcs-l@xxxxxxxxxxxx
To
bpcs-l@xxxxxxxxxxxx
cc
Subject
BPCS-L Digest, Vol 7, Issue 50
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..."
*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. Old Records in BBL (THarteau@xxxxxxxxxxxxxxxxxx)
2. Re: Old Records in BBL (Salamone, Frank)
3. Re: Old Records in BBL (Dan Sweeney)
4. Re: Old Records in BBL (Roger.Henady@xxxxxxxxxx)
----------------------------------------------------------------------
message: 1
date: Thu, 23 Apr 2009 08:23:06 -0500
from: THarteau@xxxxxxxxxxxxxxxxxx
subject: [BPCS-L] Old Records in BBL
Hi,
We have a lot of old records in our BBL file. Some special charge
lines have billing request dates in 2003. Most have an ID of 'BL', but
some are 'ZL'. Is there a purge program to clean this up, or is there
some kind of checking I can do to determine if it is 'safe' to delete some
of these? Thanks!
<===================================================>
Terri Harteau
Programmer/Analyst
Felker Brothers Corporation
****************
"Do not follow where the path may lead. Go instead where there is no path
and leave a trail."
Ralph Waldo Emerson
****************
------------------------------
message: 2
date: Thu, 23 Apr 2009 06:31:27 -0700
from: "Salamone, Frank" <frank.salamone@xxxxxxx>
subject: Re: [BPCS-L] Old Records in BBL
You can execute a Select SQL statement looking for orphaned BBH and BBL
records by checking the order status in ECH. Once you are satisfied that
the selected records are correct you can change your SQL statement to
DELETE...
Frank Salamone
Office: (813) 313-1888 Ext: 51888
Cell: (813) 205-8259
email: Frank.Salamone@xxxxxxx
-----Original Message-----
From: bpcs-l-bounces+frank.salamone=cgi.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+frank.salamone=cgi.com@xxxxxxxxxxxx] On Behalf Of
THarteau@xxxxxxxxxxxxxxxxxx
Sent: Thursday, April 23, 2009 9:23 AM
To: BPCS ERP System
Subject: [BPCS-L] Old Records in BBL
Hi,
We have a lot of old records in our BBL file. Some special
charge
lines have billing request dates in 2003. Most have an ID of 'BL', but
some are 'ZL'. Is there a purge program to clean this up, or is there
some kind of checking I can do to determine if it is 'safe' to delete
some
of these? Thanks!
<===================================================>
Terri Harteau
Programmer/Analyst
Felker Brothers Corporation
****************
"Do not follow where the path may lead. Go instead where there is no
path
and leave a trail."
Ralph Waldo Emerson
****************
midrange.com
