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