Reset A/R Data for Statement Rerun

Introduction

Normally the A/R statement process is used internally and is not used by Advantos Systems clients. The process isn't designed to rebuild, so if a statement is run then one can rerun it but one cannot add additional charges/credits and rebuild the statement. However, this manual process will allow an A/R statement run to be rebuilt.

You'll need the internal PICK date of the last statement date. You can do this by getting to TCL then enter the "DATE 05/01/06" command and write down the internal date value (always numeric). The following steps need to be taken on the Advantos Enterprise database server:

  1. Select the (ARSTMTINFO) items with the defined (most recent only) statement date and delete them. e.g.
    :SSELECT ARSTMTINFO WITH STMTDATE = "06/02/06"
    {n} items selected.
    :DELETE ARSTMTINFO
  2. Select the (ARMASTER) with the LStmtDate = most recent statement date. You'll be changing the date to be the date the last statement was run. You can get this date by running the query:
    :LIST ARSTMTINFO WITH STMTDATE = "06/02/06" STMTDATE A6
    Once you have the appropriate last statement date (under the A6 column) you can run the query:
    :SSELECT ARMASTER WITH LSTMTDATE = "06/02/06"
    {n} items selected.
    :WRITE.ATTR ARMASTER 32 14001 (O
    This will change field# 32 of the selected items to the previous statement date.

  3. Clear the (ARLEDGER) records statement date field of the most recent statement date.
    :SELECT ARLEDGER WITH STMTDATE = "06/02/06"
    {n} items selected.
    :CLEAR.ATTR ARLEDGER (11

Copyright © 1985-2024 - Advantos Systems, Inc. - All rights reserved.