Document No. Field, Item 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 fixed text that is used every time the journal is updated.)
You can create a document number formula with 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 "S (shrinkage) + current month," enter "S%3" in the field. The document number for January will then be S1.
If there is more than one line in the journal, the program will automatically retain the same number on subsequent lines.
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 |
|---|---|
| Document Line No. Field, Item Journal Line Table | Inventory |
| Item Journal Line Table | Inventory |
| Item Journal Line Table | Inventory |