The Excel formula `I_EOL_BGT_PDE_LINE_AMOUNT` retrieves the amount of budget line(s) for one period and general ledger accounts from Exact Online.
Parameters:
- `divisionCode`: division code.
- `budgetScenarioCode`: budget scenario code.
- `budgetFinancialYear`: budget financial year.
- `budgetFinancialPeriod`: budget financial period.
- `glAccountCode`: a general ledger account code or a range of general ledger accounts. See [[General Ledger Account Range]].
- `glAccountType`: general ledger account type.
- `glAccountBalanceType`: general ledger account balance type.
- `costUnitCode`: cost unit code or a range of cost units. See [[Cost Unit Range]].
- `costCentreCode`: cost centre code or a range of cost centres. See [[Cost Centre Range]].
- `itemCode`: item code.
Returns: amount of budget line(s) for one period and general ledger accounts.
When cost unit code provided as null, it means: sum it all, whether a budget on NO cost unit code ("") or a specific one. When provided as "", it means: sum it all but only when the budget is allocated on NO cost unit code.
When cost centre code provided as null, it means: sum it all, whether a budget on NO cost centre code ("") or a specific one. When provided as "", it means: sum it all but only when the budget is allocated on NO cost centre code.
When item code provided as null, it means: sum it all, whether a budget on NO item code ("") or a specific one. When provided as "", it means: sum it all but only when the budget is allocated on NO item code.