RE: AFI - How to exclude past transactions in the interface

[Michael Berman <michael.berman@xxxxxxxxxxx>]

There are a few options here.

Have a look at the Archive to see what is there or in summary.
(http//archive.midrange.com)

1) use 1/FIU to change the link status from Active to Inactive and back to
active.  This sets the GLUP96 on INP96 flag to '1' meaning that it has been
processed by AFI.
If your case your timing will have to be on the ball.

2) use SQL to set all the GLUP96 flag on INP96 to '1' for the transactions
you wish to ignore.

Good luck

Michael Berman
Email michael.berman@geac.com.au



-----Original Message-----
From: DAhKow@ibl.intnet.mu [mailto:DAhKow@ibl.intnet.mu]
Sent: Tuesday, November 07, 2000 4:39 PM
To: JBAUSERS-L@midrange.com
Subject: AFI - How to exclude past transactions in the interface



Inventory Transactions (Miscellaneous receipts & Issues) have been input by
the users as a backlog for the period July To November 2000. They have also
input the corresponding GL entries for that period. Now, as from December
2000, we will need to interface all new inventory transactions to GL using
AFI. The problem is that if we define the journal conditions and the
posting rules, these will also pick up those past transactions (July to
October). Obviously we want to exclude these transactions when we will be
running our interface (for the first time). Unfortunately in the journal
conditions there is no way to select transactions as from a particlar date
or period. Does anyone has an idea how to make AFI process only these new
transactions? Thanks

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---