OK Lovie your problem is a database issue not a program issue.? The data is not
keyed specific anough for the retrieval to get the second record of the same
key.? Since the keys are the same you get the first record in the file via
arrival sequence.?

To remedy this you will have to change the keyfields utilized in the 2006
record, temporarily anyway, to allow access to the 2007 record.? After you have
finished your RMA process you can hcange the keyfields back.?

To prevent this in the future insure that your invoice numbers do not repeat
for the term of your history retention.? For instance, change the document
sequence between years.



Richard


-----Original Message-----
From: Lovie Buno <lovie.buno@xxxxxxxxxxxxxxxxx>
To: SSA's BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
Sent: Tue, 3 Jul 2007 10:21 pm
Subject: Re: [BPCS-L] RMA displays old record



Hi Dan,

Thanks anyway for your time...

Regards,
Lovie

-----Original Message-----
From: bpcs-l-bounces+lovie.buno=eppi.epson.com.ph@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lovie.buno=eppi.epson.com.ph@xxxxxxxxxxxx]On
Behalf Of Dan Sweeney
Sent: Wednesday, July 04, 2007 10:18
To: 'SSA's BPCS ERP System'
Subject: Re: [BPCS-L] RMA displays old record


Lovie,

Unfortunately I do not have an answer, consolidated invoicing is not highly
used in my client base.

I just have to assume that once you pick the document number and sequence
you would get to choose which PO to enter the RMA against.

Sorry that I can't help further.

-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of
Lovie Buno
Sent: Tuesday, July 03, 2007 9:45 PM
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] RMA displays old record

Yes Sir we have. The records have 2 different order numbers. The 1st record
was created on 2006 while the 2nd was 2007. User would like to RMA the one
created on 2007 but they get 2006 record when they run GUI.



-----Original Message-----
From: bpcs-l-bounces+lovie.buno=eppi.epson.com.ph@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lovie.buno=eppi.epson.com.ph@xxxxxxxxxxxx]On
Behalf Of Dan Sweeney
Sent: Wednesday, July 04, 2007 09:34
To: 'SSA's BPCS ERP System'
Subject: Re: [BPCS-L] RMA displays old record


Hi Lovie,

Do you have multiple customer PO's (order numbers) against the same
invoice/doc prefix as in consolidated invoicing?


-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of
Lovie Buno
Sent: Tuesday, July 03, 2007 9:13 PM
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] RMA displays old record

Hi Dan,

Thank you very much for your reply.

1.Our current version of BPCS is 6.02
2.We are creating a new RMA against the same invoice number and document
prefix with different PO.

Thanks a lot!

Best Regards,
Lovie

-----Original Message-----
From: bpcs-l-bounces+lovie.buno=eppi.epson.com.ph@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lovie.buno=eppi.epson.com.ph@xxxxxxxxxxxx]On
Behalf Of Dan Sweeney
Sent: Tuesday, July 03, 2007 20:57
To: 'SSA's BPCS ERP System'
Subject: Re: [BPCS-L] RMA displays old record


Lovie,

A couple of questions first:

1. What release/version of BPCS,LX are you running?
2. Are you trying to copy the original RMA to another order and then
processing the second order through to invoicing, or creating a new RMA
against the same PO and customer order?

Thanks

-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of
Lovie Buno
Sent: Tuesday, July 03, 2007 4:45 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] RMA displays old record

Hi there,

Could anyone suggest how to solve or check my problem.
We would like to RMA 1 PO which was invoiced June 2007. But everytime we
input in GUI to RMA, old record was displayed (2006) with the same Invoice
No. I already checked SIH & RAR files. Both of them contain the 2 records.
How can I select the invoice data of 2007 which I was supposed to RMA?

Supposed to be RMA (2007):
Invoice No:220
Doc Prefix: 7O
PO#AAAAA

Displayed data (2006):
Invoice No:220
Doc Prefix: 7O
PO#BBBBB

Thanks!

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2019 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].