Document No. Field, Job Journal Line Table
Specifies a document number for the journal line.
If the Posting No. Series field on the journal line contains a number series code, it will be used to assign a document number to the posted ledger entry. If the Posting No. Series field is blank, the contents of this field will be used as the document number on the posted entry.
If the No. Series field on the journal batch is filled in, the program automatically enters the next number in the series in this field.
You can manually enter a document number if the No. Series field on the journal batch is blank.
If the journal is a recurring journal and the Posting No. Series field on the line is blank, you can enter a formula here that will be used to create a document number for each posted entry. The document number will be updated automatically every time the journal is posted. (You can also choose to enter a permanent text that is used every time the journal is updated.)
You can create a document number formula using one of the following codes:
| Code | Result: |
|---|---|
%1 |
Current day (for example, Monday) |
%2 |
Current week (for example, 52) |
%3 |
Current month number (for example, 1) |
%4 |
Current month name (for example, January) |
%5 |
Current accounting period name (for example, January) |
Example:
If the entry's document number will be "H (hours) + current month," enter "H%3" in the field. The document number for January will then be H1.
If there is more than one line in the journal, the program automatically keeps the same number on subsequent lines until the balance for the journal is 0. The next consecutive number will then be entered on the next line.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Gen. Prod. Posting Group Field, Job Journal Line Table | Jobs |
| Job Journal Line Table | Jobs |
| Job Journal Line Table | Jobs |
| Job Journal Line Table | Jobs |