What Are The Asterisk And c Marks In My Execution Work File Report [Quick Tip]

What Are The Asterisk * And ( c ) Marks In My Execution Work File Report?

When running any report from the SJI Execution id work file, there is sometimes an
(*) or a ( c ) mark by the document type. What is this mark?

The (*) and the ( c ) appear because there has been an edit to a document within AGRIS.

For example:

Enter a voucher for $10.00 in August, this goes to the ledger in the month of August.
Then in September, enter a $90.00 edit the same voucher. This $90.00 goes to the ledger in the month of September.
Build the execution id work file for August and September.
When the user runs the detail for August, they will see vouchers for $100.00 & $90.00-. The $90.00- has the (*) beside it.
Why is the user seeing this edit in August? It was entered in September.

Example:
M 086998 5 08/06/00 FREIGHT 100.00
M 086998 2* 08/06/00 FREIGHT 90.00-
M 086998 2c 09/21/00 FREIGHT 90.00

Why:

You see the two entries because the non-marked voucher of $100.00, combined with the $90 edit on the (*) record, adds up to the original $10.00.

That is all that went to the ledger in the month of August. The amount of the voucher now, plus the removal of the edit, equals the original amount.

Then the September detail shows a (c) record. This is the actual edit that flows to the ledger in September.
The program must save the information in this way because there are no guarantees that the SJI entries will be created immediately following the original entry. The SJI entries could be created months down the line. In this manner the original amount & the edited amount drive to the correct ledger period.