Document No. Field, Gen. 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. If the program does not automatically assigns the document number, you must redefine the number series in question.
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 "R (rent) + current month," enter "R%3" in the field. The document number for January will then be R1.
If there is more than one line in the journal, the program will automatically retain 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.
Note
You can manually edit the Document No. field so that you can specify different document numbers for different journal lines or the same document number for grouped journal lines. However, if the No. Series field on the journal batch is filled, then the posting function in general journals requires that the document number on individual or grouped journal lines are in sequential order. To make sure that you do not get posting errors because of the document number order, you can use the Renumber Document Numbers function before you post the journal. For more information, see How to: Renumber Document Numbers in Journals.
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. Journal Line Table | General Ledger |
| Posting No. Series Field, Gen. Journal Line Table | General Ledger |
| Posting No. Series Field, Gen. Journal Line Table | General Ledger |
| Posting No. Series Field, Gen. Journal Line Table | General Ledger |
| Gen. Journal Line Table | General Ledger |
| Posting No. Series Field, Gen. Journal Line Table | General Ledger |
See Also
Reference
Other Resources
Work with General Journals
How to: Renumber Document Numbers in Journals