Data Sources
There are two data sources that you can use with advanced PDF/HTML journal entry printing: General Journal Entry SuiteScript Record and GL Impact. You can use a single data source to retrieve data for the template, or you can use both data sources to retrieve data. For example, you can use the SuiteScript record to retrieve data for the header of the template and use GL Impact to retrieve data for the lines.
General Journal Entry SuiteScript Record
The data source for the fields on the Standard Journal Entry PDF/HTML Template is the general journal entry SuiteScript record. The general journal entry SuiteScript record has all of the fields that are accessible using dot-notation, such as record.subsidiary.
If you use the general journal entry SuiteScript record as your data source, advanced PDF/HTML journal entry printing creates a SuiteScript record and passes it to the templating engine using the "record" alias.
When you customize a template for a specific journal entry type and then use the general journal entry SuiteScript record as your data source, your template will have access to only those fields that are available to the general journal entry SuiteScript record. Your template will not have access to specific fields that are available on a specific journal entry, such as Advanced Intercompany Journal.
For a list of fields available to the general journal entry SuiteScript record, see the Journal Entry reference page in the Records Browser.
The following is a code example when the general journal entry SuiteScript record is the data source:
GL Impact
The GL Impact data source uses the results of a saved search constructed to retrieve the same lines that are available in the GL Impact of a specific journal entry transaction. For example, this data source creates a line for tax, which is not available when you use the general journal entry SuiteScript record as your data source.
The GL Impact data source is available only for advanced PDF/HTML journal entry printing. It is not accessible in any other printing.
The GL Impact data source is available only for the primary accounting book.
When you use the GL Impact as your data source, advanced PDF/HTML journal entry printing retrieves the results from the saved search and passes the results to the templating engine using the "gllines" alias. This data source has the following fields for each row:
-
account
-
debitamount
-
creditamount
-
posting
-
memo
-
entity
-
subsidiary
-
department
-
class
-
location
-
fxamount
-
lowercased alias of custom segments that appear on the GL impact such as custcol_cseg1
The following is a code example when both the general journal entry SuiteScript record and the GL Impact are used as the data source:
