Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    p_acq_10 sets paid transactions to unpaid

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    We have a "post-paid" invoice payment status of "C", which, like the payment status "P", has "Y" for column 3 ("Freeze all related invoice records for this payment status") in tab48:

    P N Y INVOICE-HEAD-P-S-P Paid.
    C N Y INVOICE-HEAD-P-S-C Paid and sent to R/3.

    We find that when we run p_acq_10, the status of the line items associated with the status "C" invoices is being changed from "Y" (paid) to "N" (not paid) --even when it is run with the UPDATE-DATABASE parameter specified as "N"..

    How can we prevent this?

    Resolution:
    16.02 rep_change 985 (17.01 rep_change 142; 18.02 rep_ver 11354) corrects this so that the line items are not changed when the UPDATE-DATABASE parameter is "N".

    Please note that if p_acq_10 is run with UPDATE-DATABASE "Y", the "Z601-PAID" *will* (still) be changed from "Y" to "N". This is because the program checks for a Z77-P-STATUS of "P" and, if it finds anything else, assumes that the invoice is not paid and that the line items should be corrected to "N".

    The only payment status that the programs recognize as paid in this case is "P".

    As far as correcting the Z601's if this should happen.....

    This SQL shows us how many Z601s are in this anomalous state of "Z601-PAID = N" while "Z77-P-STATUS = C":.
    SQL-DUK50> select count(*) from z601 where substr (z601_rec_key_2,1,35) in (select z77_rec_key from z77 where z77_p_status = 'C') and z601_paid = 'N';

    This SQL will show you some of them:.
    SQL-DUK50> select z601_rec_key_2, z601_rec_key_3 from z601 where substr (z601_rec_key_2,1,35) in (select z77_rec_key from z77 where z77_p_status = 'C') and z601_paid = 'N' order by z601_rec_key_2;.

    And this SQL can be used to correct them:.
    SQL-DUK50> update Z601 set z601_paid = 'Y' where substr (z601_rec_key_2,1,35) in (select z77_rec_key from z77 where z77_p_status = 'C') and z601_paid = 'N';.

    (Of course, back up the Z601 before doing this.)

    Additional Information

    p_acq_10


    • Article last edited: 10/8/2013