The CompeatPL function is used to return the net change, from the specified start date to the specified end date, for any specified General Ledger account.
Note:If you do not specify values for the Include Open and Include Closed parameters, Compeat will only access data in the open year GL table (not the history table).
The PL function uses parameters as follows:
PL(Restaurant Number, Account Number, Start Date, End Date, {Include Open Years}, {Include Closed Years}, {Include Unposted DSRs}, {Include Unposted AP}, {Include Unposted Inv JE}, {Include Unposted Gen Journals})
where braces {} indicate optional parameters. These can be included (enter an "I") or excluded (enter an "X"). If left blank, the default is to include open years, and to exclude the last five parameters. You can include all the options by entering a wild card ("*") in the first optional position, that of Include Open Years.
Example
Here is an example of the PL function that queries both unposted DSRs and unposted AP for open years only: PL("12", "1120-000", "11/1/2009", "11/31/2009", "I", "X", "I", "I", "X", "X"). The last six parameters in this function represent: "I" = Include Open Years, "X" = Exclude Closed Years, "I" = Include Unposted DSRs, "I" = Include Unposted AP, "X" = Exclude Unposted Inv JE, "X" = Exclude Unposted Gen Journals.
By default, unposted records will not be included unless you include the "I" parameter. This means that PL("12", "1120-000", "11/1/2009", "11/31/2009", "I", "X", "I") and PL("12", "1120-000", "11/1/2009", "11/31/2009", "I", "X", "I", "X", "X", "X") have the same effect. As a reminder, the last six parameters in the PL function are entirely optional. Your function could simply be PL("12", "1120-000", "11/1/2009", "11/31/2009"). This would default to Include Open Years, Exclude Closed Years, Exclude Unposted DSRs, Exclude Unposted AP, Exclude Unposted Inv JE, Exclude Unposted Gen Journals.
Note: You can view PL detail by right-clicking on a cell using the PL function and selecting "Get PL Detail" from the menu.
Specify the numbers of the restaurants whose data should be included on the report. The parameter can take a single restaurant number, a range of numbers, or a comma-separated list of numbers.
Specify the numbers of the accounts to include on the report. The parameter can take a single account number, a range of numbers, or a comma-separated list of numbers.
Specify the starting date for the account data to include on the report. If entering a date into the function as a literal, the date must be in either the format MM/DD/YY or MM/DD/YYYY. If accessing a date from a cell reference, the date can be in any valid format.
Specify the ending date for the account data to include on the report. If entering a date into the function as a literal, the date must be in either the format MM/DD/YY or MM/DD/YYYY. If accessing a date from a cell reference, the date can be in any valid format.
Optionally specify "I" to include open years, or "X" to exclude open years when retrieving data to display on the financial statement. By default, open year data is included.
This parameter is used to specify whether the PL function will retrieve data from the open GL data table (gltrx). If you specify "X", regardless of the date range you have specified, the function will only attempt to access data from the GL history table (gltrxhist), which is where the data for closed years is stored.
Note: Specify "*" to include all the optional parameters in the data retrieved.
Optionally specify "I" to include closed years, or "X" to exclude closed years when retrieving data to display on the financial statement. By default, closed year data is excluded.
This parameter is used to specify whether the PL function will retrieve data from the GL history data table (gltrxhist). If you specify "X", regardless of the dates you have specified, the function will only attempt to access data from the open GL data table (gltrx), which is where the data for open years is stored.
Note: You can use the Include Open and Include Closed parameters to speed up the generation of financial statements because, if used properly, Compeat will only have to access one table’s data when processing the PL function. Over time, as years are closed, the GL history table will grow to be quite large; limiting current year or current period financials to only look at the open GL data table allows Compeat to display the data more quickly.
Compeat does not determine which data (current or history) to access based on the date range you specify, because, if you are working with multiple restaurants, they could use different periods and year-end dates, and you might close the year for one restaurant before you close the year for another restaurant.
Optionally specify "I" to include unposted DSRs, or "X" to exclude unposted DSRs, when retrieving data to display on the financial statement. By default, DSRs are excluded.
Optionally specify "I" to include unposted AP records, or "X" to exclude unposted AP, when retrieving data to display on the financial statement. By default, AP data is excluded.
Optionally specify "I" to include unposted inventory JEs, or "X" to exclude unposted inventory JEs, when retrieving data to display on the financial statement. By default, unposted inventory JE data is excluded.
Optionally specify "I" to include unposted GJs, or "X" to exclude unposted GJs, when retrieving data to display on the financial statement. By default, unposted GJ data is excluded.