Re: RE: Negative Invoice Number on RAR

Check the SIH and SIL files for duplicate invoice numbers 
 
-----Original Message-----
From: Kylea White <kylea.white@xxxxxxxxxxxxx>
To: BPCS-L@xxxxxxxxxxxx
Sent: Fri, 19 Aug 2005 10:47:44 +0800
Subject: [BPCS-L] RE: Negative Invoice Number on RAR


Hi Al,

It is actually a little more messy than that.  No-one has touched any of
the numbering.  As I dug deeper yesterday I noticed that the information
for the invoices on RAR contained some other strange information also.
i.e.  The corporate customer linked to the sold-to customer was not the
one specified on the customer master (no one has changed this either) and
the records with the negative invoice numbers also appear with a customer
type which is currently not used. 

The invoice was not the result of post ship billing - it is a Type 1
invoice.  It is like the system has grabbed another invoice from somewhere
or details when creating the invoice, - but I am only clutching at straws.


All I can think to do now is 
1)  Run a query over SIH & SIL to look for invoice and document
numbers that are less than zero.
2)  Go to the Sys menu and run option 14 to re number the corp
customer details and then 7 to recalculate the balances.

Any other thoughts on this one.......

Regards,
 

Kylea White
Technical Consultant
KAZ Technology Services
Switch: +61 8 6212 0100
Fax:      +61 8 9225 6748
 
Email     kylea.white@xxxxxxxxxxxxx
Web      www.focalsystems.com.au
 
A KAZ Technology Services Company - visit our website at
http://www.kaz-group.com
 
 

-----Original Message-----
From: bpcs-l-bounces+kylea.white=kaz-group.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+kylea.white=kaz-group.com@xxxxxxxxxxxx] On Behalf
Of bpcs-l-request@xxxxxxxxxxxx
Sent: Friday, 19 August 2005 1:02 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 3, Issue 179

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: WRKQRY (BBilgen@xxxxxxx)
   2. Re: Negative Invoice Number on RAR (Al Mac)


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

message: 1
date: Thu, 18 Aug 2005 09:14:38 EDT
from: BBilgen@xxxxxxx
subject: [BPCS-L] Re: WRKQRY

When creating CL programs that require different attributes than provided
by 
the general OVRPRTF command used by SSA, use the keyword SECURE(*YES) on
the  
OVRPRTF command to allow later overrides to preempt the initial override  
executed by SSA.
 
Barbara Bilgen
 
 


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

message: 2
date: Thu, 18 Aug 2005 09:30:13 -0500
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: Re: [BPCS-L] Negative Invoice Number on RAR

In our implementation of BPCS 405 CD, you have to be a BPCS Security 
officer to get into most SYS functions, such as SYS800 which can change 
many system parameters, tracking #s, how long some data is stored, etc.

On screen SYS800-04 you can alter the last invoice # used ... you might 
want to increment it a chunk at some end fiscal moment to make it easier 
for some people to see what got posted which month.  There's also
something 
there about document sequencing, and post shipment invoicing.

Here's the Help on that 
field 


      Last Invoice Number Used 
(8,0):

      This field displays the last invoice number assigned by the 
system
      during billing (BIL500).  Be CAREFUL if you have to change 
this
      parameter.  Since the system adds one (1) to this number 
when
      assigning the next number, changing it back could cause 
invoice
      number duplication later, or create unused invoice 
numbers.  This
      number is only utilized when the company/prefix document 
sequencing
      flag is 
"blank".

I believe this data is stored some place in the ZPA file which people can 
get at other ways, depending on how your security is setup.  See if you
can 
access BIL520IN in ZPA ... I think that is the relevant parameter file
key.

You do NOT want this to be a negative number, unless you truely want your 
Billing Invoices to be negative numbers.  When it gets to all 9's it
should 
wrap around to 0 then 1 (You may not want an invoice # that is all 
zeros)  Are you at risk of running out of numbers here?  There are ways to

structure your customer orders so as to have consolidation of your
shipping 
onto less invoices to the same customers, depending on the nature of your 
customers.

We have modified our billing software, but not in this respect ... the
main 
reasons for our modifications were how data to appear on the invoices, and

to fix a systemic SSA bug with respect to rounding.

-
Al Macintyre  http://www.ryze.com/go/Al9Mac
BPCS/400 Computer Janitor ... see
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html

>
>
>Hi all,
>
>
>
>Using BPCS 4.05 and for some really weird reason some invoices have come
>through on the RAR file  field RINVC with a negative on them.
>
>
>
>They appear to be using sequencing to get the invoice numbers.
>
>
>
>Is there anywhere in BPCS that possibly determines there is a duplicate
>invoice with the number and then reverses it to make it unique.
>
>
>
>Any ideas would be great.
>
>
>
>Regards,
>
>
>
>
>Kylea White
>Technical Consultant
>KAZ Technology Services
>Switch: +61 8 6212 0100
>Fax:      +61 8 9225 6748
>
>
>
>Email     kylea.white@xxxxxxxxxxxxx
>Web      www.focalsystems.com.au
>
>
>
>A KAZ Technology Services Company - visit our website at
>http://www.kaz-group.com
>t


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