What is an Unpost Sequence?

This field is present in many Voucher related tables, requisition tables, VAT, Project costing, receiving and journal related tables.

unpost-sequence

unpost-sequence

One must be careful when making queries with these tables that unpost seq must be join criteria. For example, During a join of journal header and journal line tables we must also include the unpost sequence criteria apart from having the business_unit , journal_id, journal_line and journal dates.

How is it created?

The system creates reversing entries and archives the original entries. The UNPOST_SEQ for the archived entry is one higher than for the reversal entry. Nothing is deleted.

unpost-sequence-properties

unpost-sequence-properties

Therefore, Unpost Seq just equal to the number of times that the Event Generator has been run. For Standard entries, the value will always be 0.

unpost-sequence-example

unpost-sequence-example

For Supplemental entries, the value will be 0 the first time the Event Generator is run; 1 – the second time, 2 – the third time, 3 – the fourth time, and so on.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Read previous post:
PeopleSoft Journal Uploader
PeopleSoft Journal Import Error – User-defined type not defined

Close