Line ActionsThis page is accessed by selecting the 'Split' line command from an Expense line in Entry or Approval to enter, view or edit expense amounts split across multiple financial or management reporting elements. The entry fields displayed and associated descriptions are the same as those at the line level for Expense Sheet entry. Field values that are not available to edit for data integrity reasons, will be displayed as read only (i.e. Date, Currency). When Split lines have been used to allocate expense amounts, the split lines will become the details of record for the expense and used for integration purposes.
The Split option will only be available when Expense is integrated directly to Accounts Payable and the 'Enable Advanced Tax' System Setting has been disabled. Expense Split functionality is not available for the Dynamics GP Project Accounting interface.
Distribute
This option is available to easily distribute expense amounts across multiple split lines based on a relative quantity. When clicked, the price on each split line will be updated based on the line quantity compared to the total quantities entered and calculated as [Total Line Amount] / [Total Split Quantities]. If the total line amount does not round evenly based on the calculation, the remainder will be automatically assigned to the first available split line.
Example for an Expense Line Amount of $24 where;
Split Line 1 Quantity = 2
Split Line 2 Quantity = 1
Split Line 3 Quantity = 3
Clicking the Distribute button will update the Price for each split line to $4 (24/6) resulting in the following amount assignments adding up to the $24 line total;
Split Line 1 = $8 (24 / 6 x 2)
Split Line 2 = $4 (24 / 6 x 1)
Split Line 3 = $12 (24 / 6 x 3)
Save & Close
Clicking this option will validate all information entered and close the page, returning the user to the Expense Sheet entry page. If the total amounts entered for all lines do not equal the original expense amount, an error will be presented that the 'Split Amount does not equal Line Amount' and the user will not be permitted to close the page until the unassigned amount is equal to zero.
Displays the original Expense Sheet line number.
Displays the date from the original Expense.
Displays the Project ID from the original Expense when WorkPlace Project is licensed.
Displays the Phase ID from the original Expense when WorkPlace Project is licensed..
Displays the Activity ID from the original Expense when WorkPlace Project is licensed..
Displays the description from the original Expense.
Displays the quantity from the original Expense. This is for reference purposes only and the sum of the split line quantities do not need to match this value.
Displays the Price from the original Expense.
Displays the original Expense Line amount. This is the value that will need to be allocated across all split lines.
The amount assigned to the original expense based on the total of all split line amounts. This value will need to be equal to the original line amount before the page can be saved and closed.
To amount remaining to be assigned before the split lines can be saved and closed.
Line ActionsOpen the Attendee page to allocate the expense line amount for Attendee Tracking. This button will only be available if the user has been assigned access to the 'Attendee' processing option in Security.
Only available when the user has been assigned permission to the Tax Detail processing option in Security.
