Invoice & Posting - List Invoices
Overview
The List Invoices screen is used to view, edit, delete, complete, void, uncomplete, print or email existing invoices. The resulting list of invoices presents summary information about each invoice, including amount, payment terms, invoice date, by whom and when an invoice was created, completed, extracted, printed or emailed. In the case of voided invoices, you'll also see details indicating which invoices have been voided and reference information for the reversing invoice.
The draft invoice edit feature is available to add Additional Items, manage attachments, modify header, footer, description and memo details, and defer or write off individual items from appearing on an invoice.
Group Invoices (those Invoices that are comprised of multiple projects), will always be represented by the Lead Project of the Invoice Group in this listing (even if you searched for one of the Contributor Projects). These items will be distinguished in the listing with a diamond () symbol.
Roles
This screen is available to users having any of the following roles: Administrator, P&R Administrator, Billing Manager, Billing Viewer (and their alternates).
- Billing Viewers functionality is limited to viewing invoices.
License
This screen is available with the Project Tracking, Project Portfolio, and the Project Financials family of Unanet licenses.
Topics covered on this help page include:
-
Search (to refine the list of projects for which you wish to display existing invoices)
-
List (to view, edit, delete or complete invoices)
-
Email & Print (to email or print one to many invoices)
-
Invoice Editing (learn more about what changes can be made on a draft invoice such as adding additional items, deferring items, etc)
-
-
Invoice Completion Process (learn more about what happens when an invoice is completed)
-
-
Invoice Deletion Process (learn more about what happens when an invoice is deleted)
-
Revise Invoice Amounts (learn more about options available to revise an invoice amount)
-
Uncomplete Invoice (learn more about options available to uncomplete an invoice)
-
Void Invoice (learn more about options available to void an invoice)
-
Void Process (learn more about the details of the void process)
- Closed Fiscal Year (adjusting entries when posting/voiding to a closed fiscal year)
You may also be interested in:
-
Add Invoices (to view additional information about creating invoices)
-
FAQ - How can I get page breaks on my invoice? (search for this topic in the Knowledge Center)
-
Project >> Billing Setup (for more information about configuring projects for inclusion in Invoicing)
-
Search
Using the List Invoice Search screen, you can refine the list of invoices with which you have interest.
Field Descriptions (click on a link below for additional information):
List
From this screen, you can use the available icons to view, edit, delete, complete, void or uncomplete a particular invoice. Using the delete all ( ) or approve all () icons you can impact all of the draft invoices displayed in the list. Invoices that have previously been completed are frozen from further modification and cannot be deleted. Note that completed invoices can be uncompleted (even if they are marked extracted), at which point you may be able to make additional changes (or even delete the draft invoice and unpost the associated data).
The edit icon () is used to modify draft invoices to add Additional Items (i.e. additional fees, discounts, taxes, etc), customize the header, description or memo fields, or defer specific items from being included on the invoice. See Invoice Editing for additional information.
Group Invoices (those Invoices that are comprised of multiple projects), will always be represented by the Lead Project of the Invoice Group in this listing (even if you searched for one of the Contributor Projects). These items will be distinguished in the listing with a diamond () symbol.
Drill Down Note: You can click on the value in the Balance column to view the Invoice Balance Details popup report.
The resulting list will resemble the following example.
Field Descriptions (click on a link below for additional information):
|
-
(To save criteria, view, edit, delete, complete, uncomplete or void one or many invoices)
-
-
-
-
-
-
-
-
-
-
-
-
-
|
Drill Down Note: You can click on the value in the Balance column to view the Balance Details popup report.
Invoice - Balance Details Popup
The Invoice - Balance Details Popup report will resemble the following:
Invoice Emailing & Printing
When selecting one of the Invoice Delivery Method options on the Search tab, the resulting list will include a series of leading check boxes and either an Email or Print button. You can select one or neither option in the Invoice Delivery Options section, but not both. If you select neither option, the resulting list will not have the leading check boxes on each row nor will any Email or Print button be presented.
When selecting either option, several other search screen controls will have their values defaulted, including Status, Default Delivery Method, and Actual Delivery Method. Note that these are default suggestions and the user can further manipulate the choices in each of those controls as they desire.
Regardless of whether you select Email or Print, the invoice will be generated into a PDF formatted file available for print or available as an attachment to an email. The filename will be invoice_number.pdf.
You can email and print an invoice as often as you desire.
Note that you can only email valid (non-voided, non-voiding), completed invoices, while you can print any invoice.
Print
Selecting one or many check boxes and clicking on the Print button will present the user will a screen resembling the following. Using this screen, you can click on an individual invoice (in a PDF format) for viewing and potentially printing. Additionally, you can click on the Download all invoices link which will download a single zip archive file containing all of the individual pdf invoice files. Using this zip file, it is possible to multi-select one or many included files and send multiple files to the printer at once.
At the time the print button is clicked and the resulting list of invoice PDF files is displayed, the included invoice records will each be updated with the current user's name, date and time of the activity. As such, if you had selected the option to list only invoices that had yet to be printed or emailed, clicking the Back button will return you to an empty list (as they will now have been stamped as having been printed).
Email
Selecting one or many check boxes and clicking on the E-mail button will initiate the emailing process. You will first see the E-mail Invoices screen:
This screen allows you to review the full contents of the email, including all attachments. You can proceed to email valid invoices with all required attachments, and skip the invoices that are missing attachments. Select the check box next to the invoices you wish to email (all are selected by default). In addition, you can click on the invoice number to download the invoice PDF, and you can click on the attachment name to view the attachment. Only attachments that were marked as "Email with Invoice" (see Attachments) will be included on this page. Click on the E-mail button at the bottom of this page when ready to email.
During the email process, the system will attempt to email each selected invoice. The system will provide feedback for each invoice individually, listing any errors that may have occurred. If an error occurs for any given invoice, that invoice will not be emailed, but the system will continue and process the remaining invoices selected.
In order to use the emailing capability, the following conditions must be met:
- Email Enabled -- The master system Email Enabled (unatime.email) property must be enabled.
- From Email Address -- A valid From address must be available.
-
- To Email Address -- Each project (or Lead project) must have a valid To email address (or addresses) specified in order to participate. This configuration is done on the Project Profile >> Billing >> Invoice Setup >> Contacts tab.
- CC & BCC Email Addresses -- If a project has been configured with an invalid CC and/or BCC email address, it cannot participate in the emailing process. Neither of these fields is required.
- Archive Email Address -- If a value has been provided in the Default Billing Archive Email Address (unanet.financials.email.default.bill_archive_address) property, it must be a single valid email address. This email is the address to which all emailed invoices will be sent as a BCC email recipient.
- Invoice Status -- The invoice must be a valid Completed or Extracted invoice
- Voiding & Voided Invoices -- The entry cannot be a Voiding or Voided invoice (those rows on the list representing these items will have the checked box disabled and thus cannot be selected).
- Valid Email Template -- Each project can be configured with an email template to be used when mailing invoices for that project. This configuration is done on the Project Profile >> Billing >> Invoice Setup >> Contacts tab. The list of master invoice email message templates is maintained on the Admin >> Setup >> Miscellaneous >> Email Messages screen. If no project specific template has been defined, a System Default email template is available (note the System Default template must be active if it is to be used). The contents of the email message subject and body can be customized (including the availability of a number of substitution variables). See Email Messages for more information.
Note: At the time an Invoice is sent, the values supplied in the body of the email for the following fields: ($BILL_TO_CONTACT_NAME, $BILL_TO_CONTACT_FIRST_NAME and $BILL_TO_CONTACT_LAST_NAME) will all be derived from the values related to the current Bill To Contact associated with the invoice (i.e., on the List Invoices >> Edit Invoice >> Invoice >> Setup screen). The default values (if none exist on the invoice) come from the project (Project Profile >> Billing >> Invoice Setup screens).
At the time the email button is clicked and the feedback presented, those invoice records successfully sent will each be updated with the current user's name, date and time of the activity. As such, if you had selected the option to list only invoices that had yet to be printed or emailed, clicking the Back button will return you to an empty list (as they will now have been stamped as having been emailed).
Email Process
If all of the conditions above are met, then each invoice is processed as follows:
- Email template selected.
- Required From and To emails determined.
- Optional CC, BCC and Archive email addresses determined.
- Read Receipt and Delivery Receipt indicators set -- if specified on the Project Profile >> Billing >> Invoice Setup >> Contacts tab, additional indicators are sent with the email message.
Note that while these receipt settings work across many email systems, they are not supported on all email systems. For example, IMAP-based email systems have been known to return read receipts even when a message has not been opened, or fail to send a receipt even though a message had been read. Further, many email client prompt the user for their permission to send the receipt. As such, it is not necessarily a best practice to rely on read receipts to certify email delivery.
- Email message(s) sent.
- Invoice record updated with current user's name, date and time of the process.
- Feedback for each invoice processed displayed to screen.
Note: If system is configured to use Unanet Pay, the email will include a Pay Here link to access the portal.
Invoice Editing
Once a draft invoice has been created, you can edit the draft invoice and make changes (specific to this draft invoice only) including the following:
You can begin editing an invoice by clicking on the edit icon () from the list of invoices. The resulting screen will include a preview version of the invoice as well as a series of options available on the left menu. To edit details related to a specific section of the invoice, click on the desired left menu item. Those sections that do not have any data to edit will be grayed out. If the user only has Billing Viewer role, or if the invoice is no longer in Draft status, all options will be grayed out except Invoice - Preview and Attachments. The following options will be available.
Administrators can set the following properties to control the default active tab for the screens that have Search and List tabs:
-
Default to List Tab on CP Expense List (unanet.customer_invoice.cost_plus_expense.search_enable.limit), default value - 0
-
Default to List Tab on CP Fee Cap Adjustment List (unanet.customer_invoice.cost_plus_fee_cap_adj.search_enable.limit), default value - 0
-
Default to List Tab on CP Item List (unanet.customer_invoice.cost_plus_item.search_enable.limit), default value - 0
-
Default to List Tab on CP Labor List (unanet.customer_invoice.cost_plus_labor.search_enable.limit), default value - 1000
-
Default to List Tab on Fixed Price List (unanet.customer_invoice.fixed_price.search_enable.limit), default value - 0
-
Default to List Tab on Funding Cap Adjustment List (unanet.customer_invoice.funding_cap_adj.search_enable.limit), default value - 0
-
Default to List Tab on Prebilled Labor List (unanet.customer_invoice.prebilled_labor.search_enable.limit), default value - 0
-
Default to List Tab on T&M Expense List (unanet.customer_invoice.time_materials_expense.search_enable.limit), default value - 0
-
Default to List Tab on T&M Labor List (unanet.customer_invoice.time_materials_labor.search_enable.limit), default value - 1000
-
Default to List Tab on T&M Item List (unanet.customer_invoice.time_materials_item.search_enable.limit), default value - 0
When these properties are set to zero, the List tab is always presented as the active tab. When set to a non-zero value, the List tab will display the full list of items included in an invoice when the number of items is less than or equal to the defined property value, otherwise, the Search tab will be the active tab. For example, if you define Default to List Tab on CP Expense List (unanet.customer_invoice.cost_plus_expense.search_enable.limit) with a value of 10 and there are 10 or less items in the CP Expense list, then the List tab will be the active tab. If there are more than 10 items in the list, then the Search tab will be the active tab.
You can also click on the PDF icon - - in the top left corner of the page to download the invoice in PDF format.
Invoice - Preview
By default, the Preview option is selected and the preview of the invoice is displayed. Which format your invoice has is specified on the Project >> Billing >> Invoice Setup screen, where one or many formats are designated. The formats themselves are defined on the Admin >> Setup >> Invoice Format screen.
Note: The Primary Invoice Format from the Project >> Billing >> Invoice Setup screen is the format that is used in the preview.
You can use the following properties to control the display of currency on this screen:
Invoice - Setup
Clicking on the Invoice >> Setup left menu item will send you to a set of screens allowing you to modify a variety of header / footer invoice details. The edit screens will resemble those available on the Project >> Billing >> Invoice Setup area. Note that making changes on an individual invoice will only impact the current invoice and not those settings configured on the project profile. Likewise, making changes to the invoice settings on a project profile will not have any impact to any existing draft or completed invoices. The screens available to edit header / footer details on a single invoice will resemble the following.
On the Setup tab, the attributes than can be modified for the current invoice include:
- Invoice Date -- This control allows you to override and change the Invoice Date. Saving changes to Invoice Date will trigger a general invoice recalculation process which has the potential to recalculate and re-derive the following invoice values: Due Date, Discount Date, Discount Amount and Invoice Amount (using the current rules from the current payment terms associated with the invoice and the current invoice amount).
Note: the format of the Invoice Date can be controlled via the Invoice Date Format (unanet.invoice.date_format) property.
- Post Date -- This control allows you to override and change the Post Date.
- Fiscal Period -- This control allows you to override and change the Fiscal Period.
- Billing Period From Date -- This optional field will have the Billing Period From Date that was entered when invoice was added. You can override and change this date. It must be less than or equal to Through Date (available on View or Preview screens).
Note: If the invoice format does not have Show Billing Period Dates Instead of Billing Through Date selected, then the Billing Period From Date will not appear on the invoice header.
- Auto-Correct Rounding -- This control allows you to override the default rounding behavior (as established by the Auto-Correct Invoice Rounding (unanet.invoice.auto_correct.rounding.default) property, to allow you to alter the rounding behavior for this particular draft invoice only. Note this control is not available on the Project >> Billing >> Invoice Setup >> Setup tab, but is only available on draft invoices to override the system default behavior.
- Invoice Number -- If you change the Invoice Number, the system will validate that it has not already been used. The maximum allow length is 46 characters. There are no other restrictions. Do note, however, that you should be very careful about modifying the Invoice Number avoiding the use of a value that may naturally occur during future invoice creation.
- Payment Terms -- Saving changes to Payment Terms will trigger a general invoice recalculation process which has the potential to recalculate and re-derive the following invoice values: Due Date, Discount Date, Discount Amount and Invoice Amount (using the current rules from the current payment terms associated with the invoice and the current invoice amount).
- Allow Electronic Payments Via Self-Serve Portal -- Select this option to allow electronic payments via self-serve payment portal. This value defaults from the invoice's project setting, if specified..
- Payment Options -- Select Credit Card or ACH for invoices and set minimum and maximum values for each. These values default from the invoice's project settings, if specified. The minimum and maximum values can be blank.
Note: ACH option can only accept funds in USD and only from U.S. bank accounts.
All of the values on the Bill To, Ship To and Remit To sections of the Contacts tab can be overridden for the current draft invoice. Those values in the Invoice Delivery Options section are read-only except for the Enable Reminder Email options (note that when adding a new invoice, these three fields will be inherited from the lead or standalone project settings (Project Billing >> Invoice Contacts)):
- Enable Reminder Email -- When selected, the Reminder E-Mail Message and Reminder Frequency fields are enabled. If the invoice is associated with a standalone or lead project, then the e-mail message and frequency will default from the project.
Note: If the project settings change, the invoice settings will not change. Once the enable reminder is checked, the values are saved for that invoice.
- Reminder E-mail Message -- You can choose a reminder email message template that will be used for the invoice reminder emails. Also see Admin >> Setup Email Messages.
- Reminder Frequency (Days) -- You can set how many days past the customer invoice due date the reminder is sent out. If the invoice continues to have an unpaid balance after the first reminder, subsequent reminders will be automatically sent every X days, where X is the value of this field. The default value comes from the project (if supplied) or Customer Payment Reminder Email Frequency (unanet.financials.customer_payment.reminder.frequency) property. This field can be a value from 0 to 99. A value of 0 will prevent reminders from being sent out.
Note: These three options can be updated for invoices in all statuses.
All of the values on the Additional Invoice Formats tab can be overridden for the current draft invoice.
All of the values on the Other tab can be overridden for the current draft invoice.
E-Invoice
Clicking on the E-Invoice left menu item will display the email reminder history for that invoice. You can view when emails were sent, delivered, and opened, and when the recipient viewed the invoice.
Adding Additional Items
Clicking on the Additional Items left menu item will send you to a set of screens allowing you to add one or many Additional Items to the invoice (e.g., Discounts, Taxes, etc).
When adding an Additional Item you will need to supply:
- Project - This drop-down will only appear if the current invoice is a Group Invoice (ie includes multiple projects). The list of projects displayed in this drop-down will be limited to those projects participating in the Invoice Group (as it was defined at the time the invoice was originally generated).
- Task - This drop-down will contain active billable tasks from the selected Project (in addition to the currently saved task should it have subsequently been made inactive). If a project is configured to require a task, then no blank option will be presented. The sort order of the task in the drop-down will be determined by the Sort Tasks by Work Breakdown Structure Number (unanet.task.sort.order.by_sequence) property.
- Description - This is the text that will appear on the invoice. You have a max of 50 characters.
- Additional Item Type - You must specify the Additional Item Type which is defined by the Administrator on the Admin >> Setup >> Additional Item Type screen. Each Additional Item Type has a debit and credit account mapping identified which will be used during invoice completion to generate the appropriate Unanet journal entries.
- Amount - Accepts negative and positive amounts
You can add as many additional items as you like using the insert new row icon .
Invoice Amount Recalculation - Saving changes to Additional Items will trigger a general invoice recalculation process which has the potential to recalculate and re-derive the following invoice values: Due Date, Discount Date, Discount Amount and Invoice Amount (using the current rules from the current payment terms associated with the invoice and the current invoice amount).
Attachments
You can get to this screen by clicking on the Attachments or Attachments >> Invoice left menu option after clicking the pencil icon from the invoice list screen, or by clicking the attachment icon next to an invoice on the list screen. From this screen, users with the following roles: Billing Manager, Administrator, or P&R Administrator, can attach one or more documents (such as expense report receipts) to an invoice, and they can delete attachments. Attachments can be added or deleted regardless of the invoice status, including voided and voiding invoices. You can also specify whether or not the attachment should be emailed with the invoice. Billing Viewers can only view and download the attachments.
Note: The Unanet Administrator may want to suggest guidelines with regards to what types of files may be acceptable to be used as Invoice attachments, particularly in the case where any documents are being scanned and saved as a graphics file. Certain graphics file formats are known to result in much larger files sizes than others and you may want to consider suggesting a specific file type to help control the amount of data being stored in your database. Generally speaking, jpg and gif files tend to be much smaller than tif and png file formats.
To assist with the management of allowable attachment types and size, the administrator can use the following three properties: Maximum Size Allowed for each attachment (unanet.attachment.max_size), File Extensions that are Not Allowed (unanet.attachment.invalid_file_extensions) and File Extensions that are allowed (unanet.attachment.valid_file_extensions).
Using this screen, the user can add or remove an attachment. The Save button will save the changes to the attachment screen and display the screen below.
Field Descriptions (click on a link below for additional information)
The preview links display PDF versions of the expense and timesheet status reports. The attachments included in these reports are the ones listed in the Expense Receipts section of the Invoice and are marked as Email with Invoice. All users with access to viewing the Invoice can click on the Preview Expense Reports link (will not display if you only have Project Time license). This will display the expense status details report including approval history and attachments (images and PDFs). Only expense detail lines and amounts for items in the invoice are included in the report. Likewise, clicking on the Preview Timesheets link will display the timesheet status details report including approval history (will not display if you only have Project Expense license). Weekly, semi-monthly, and monthly time periods can be displayed. Timesheets are limited to those whose cells are currently included in the invoice. You can download and save the PDF and then add it as an attachment on the invoice.
Expense Receipts
Navigate to Attachments >> Expense Receipts to see a list of billable expense report line item receipts, with the following caveats:
Receipts listed here are automatically included when the invoice is first generated. Note that if an attachment is associated with multiple expense report lines, it is only listed once here. The Preview Expense Report link will include the attachment on each line, if it is marked as Email with Invoice.
On this screen, you can:
-
click on the attachment icon - - to view the receipt
-
check or uncheck Email with Invoice option
-
click on to refresh the contents of the page with recently added expense line attachments (if any were added after the invoice was generated)
The Project column displays all contributing projects for that expense report. If the project names are wider than the column, you will see an ellipses indicated by 3 periods (...). To see the rest of the text, you can hover the cursor over the text.
If you defer all line items that are associated with a given expense receipt, that receipt will be removed from the invoice.
If you write off all line items that are associated with a given expense receipt, that receipt's Email with Invoice box will be unchecked.
Deferring Items and Write-Offs
In order to defer individual items from being included on an invoice or to write-off portions or all of an item, you can select from one of the left menu options. The buttons for deferring and write-offs will be at the bottom of those screens.
- Defer -- Deferring an item removes it from the current invoice (Invoice Total will be adjusted accordingly) and puts it back in the 'pool' of available items to be included on the next draft invoice for a project (it does not unpost or otherwise change any journal entries). Do note that once you defer an item, you cannot re-add it to the current draft invoice. In order to get a deferred item back on a current draft invoice, you would need to remove and recreate the draft invoice all together. By checking the desired line items and clicking the Defer Selected button, the designated items will be removed from the current invoice.
- Write-off -- Unlike deferring an item, writing off all or a portion of an item will permanently remove that portion from the current (or any future) invoice (Invoice Total will be adjusted accordingly). By checking the desired line items and clicking the Write Off Selected button, the entire amount will be written off (the Write Off Amount will be set equal to the Amount and the Billable Amount will be set to zero).
-
- Alternatively, you can click the edit pencil and modify various Write Off Amounts (and in some cases other values such as Hours, Rates, Markup Percentages, etc.).
Note when using this approach, Saving this entry will allow you to write off the partial amount (that is, you would not want to click on the Write Off Selected button at this point, as that results in the entire amount being written off).
- Invoice Amount Recalculation - Saving changes to deferrals or write-off will trigger a general invoice recalculation process which has the potential to recalculate and re-derive the following invoice values: Due Date, Discount Date, Discount Amount and Invoice Amount (using the current rules from the current payment terms associated with the invoice and the current invoice amount).
Additional Notes:
- Project Column -- This column will appear on the deferral screens if the current invoice is a Group Invoice (i.e. includes multiple projects).
- Sorting Note - The deferral screens allow for sorting of the data by clicking on the header labels. Using this feature may facilitate the deferral of data by person, date, or other category by allowing you to easily group them together.
- Toggling Check boxes - Checking the check box at the top of the column will toggle all check boxes on or off.
- Write Offs - Knowledge Center Topics (search for this topic in the Knowledge Center)
Details for each option described below:
CP Expense
You can refine the list of expense items using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with a Cost Plus Expense item. The list screen initially displays a single entry associated with each originating cost transaction. The amounts displayed on this single entry will include the sum of all of the related billable amounts for the direct costs, indirect costs and fees associated with the originating cost transaction.
Once the user edits a row, the entry may appear broken down into the individual billable direct cost, indirect cost and fee amount values that comprise the entry. The user can then manually enter the Write Off or Billable Amount at a more granular level.
- Base Cost Element -- This is a display only field. When viewing in the list, this will display the Cost Element of the originating cost transaction. When editing a row, one to many rows may display detailing the Cost Elements of the direct, Indirect and Fee amounts generated by the CP direct cost transaction.
- Amount -- This is a display only field. When viewing in the list, this will display the sum of the Billable amounts of the transactions associated with the originating cost transaction. When editing a row, this will reflect the Billable amount for the individual billable transactions. The Write Off Amount + Billable Amount must equal this Amount field.
- Write Off Amount -- Defaults to zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount. If the amount written off is the amount for the originating cost transaction, the Write-off Amount and Billable Amount values for the associated indirect and fee transactions will be proportionally adjusted so that the Billable Amount proportion of indirect and fee values is the same as that for the originating Cost Transaction. See example below.
- Billable Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount. If the modified Billable Amount is equal to the amount for the originating cost transaction, the Write-off Amount and Billable Amount values for the associated indirect and fee transactions will be proportionally adjusted as described in the Write Off Amount example below.
Example
If the originating cost transaction Amount is $200 and $100 is written off, then the Billable amount for all indirect and fee lines should be set to equal 50% ($100/$200) of their Amount value rounded to 2 decimal places. The Write Off amount for each of these lines would then be set to the Amount – the new Billable Amount for each line.
CP Item
You can refine the list of CP items using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with a Cost Plus Item. The list screen initially displays a single entry associated with each originating cost transaction. The amounts displayed on this single entry will include the sum of all of the related billable amounts for the direct costs, indirect costs and fees associated with the originating item cost transaction.
Once the user edits a row, the entry may appear broken down into the individual billable direct cost, indirect cost and fee amount values that comprise the entry. The user can then manually enter the Write Off or Billable Amount at a more granular level.
- Base Cost Element -- This is a display only field. When viewing in the list, this will display the Cost Element of the originating cost transaction. When editing a row, one to many rows may display detailing the Cost Elements of the direct, Indirect and Fee amounts generated by the CP direct cost transaction.
- Quantity-- This is a display only field. This value is only populated for the originating cost transaction entry and represents the quantity associated with the item transaction.
- Amount -- This is a display only field. When viewing in the list, this will display the sum of the Billable amounts of the transactions associated with the originating cost transaction. When editing a row, this will reflect the Billable amount for the individual billable transactions. The Write Off Amount + Billable Amount must equal this Amount field.
- Write Off
-
- Quantity-- Defaults to zero. This value can be positive, negative or zero. If a value is entered, the following fields will be recalculated as:
-
- Write Off Amount = Amount * Write Off Quantity/Quantity
- Billable Quantity= Quantity– Write Off Quantity
- Billable Amount = Amount – Write Off Amount.
-
- Amount -- Defaults to zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount. If the amount written off is the amount for the originating cost transaction, the Write-off Amount and Billable Amount values for the associated indirect and fee transactions will be proportionally adjusted so that the Billable Amount proportion of indirect and fee values is the same as that for the originating Cost Transaction. Note that changing the Write Off Amount will have no impact on the Quantity field. See example below.
- Billable
-
- Quantity-- Defaults to Quantity. This value can be positive, negative or zero. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Amount * Billable Quantity/Quantity
- Write Off Quantity= Quantity- Billable Quantity
- Write Off Amount = Amount – Billable Amount
- Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount. If the modified Billable Amount is equal to the amount for the originating cost transaction, the Write-off Amount and Billable Amount values for the associated indirect and fee transactions will be proportionally adjusted as described in the Write Off Amount example below. Note that changing the Billable Amount will have no impact on the Quantity field.
Example
If the originating cost transaction Amount is $75 and $37.50 is written off, then the Billable amount for all indirect and fee lines should be set to equal 50% ($37.50/$75) of their Amount value rounded to 2 decimal places. The Write Off amount for each of these lines would then be set to the Amount – the new Billable Amount for each line.
CP Fee Cap Adjustment
You can refine the list of CP Fee Cap Adjustments using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to edit the CP Fee Cap Adjustment amounts posted when the Fixed Fee amount has been exceeded or additional fee recognized when the project is complete and the entire fixed fee amount had not previously been recognized. The screen displays all of the CP Fee Cap Adjustments posted by the Billing Post(s). If the user edits a row, they can manually enter a specific Write Off or Billable Amount.
- Amount -- This is a display only field representing the amount of the fee cap adjustment. The Write Off Amount + Billable Amount must equal this Amount field.
- Write Off Amount -- Defaults to zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount.
- Billable Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount.
CP Labor
You can refine the list of labor items using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with a Cost Plus Labor item. The list screen initially displays a single entry associated with each originating cost transaction. The amounts displayed on this single entry will include the sum of all of the related billable amounts for the direct costs, indirect costs and fees associated with the originating labor cost transaction.
Once the user edits a row, the entry may appear broken down into the individual billable direct cost, indirect cost and fee amount values that comprise the entry. The user can then manually enter the Write Off or Billable Amount at a more granular level.
- Base Cost Element -- This is a display only field. When viewing in the list, this will display the Cost Element of the originating cost transaction. When editing a row, one to many rows may display detailing the Cost Elements of the direct, Indirect and Fee amounts generated by the CP direct cost transaction.
- Hours -- This is a display only field. This value is only populated for the originating cost transaction entry and represents the number of hours associated with the time transaction.
- Amount -- This is a display only field. When viewing in the list, this will display the sum of the Billable amounts of the transactions associated with the originating cost transaction. When editing a row, this will reflect the Billable amount for the individual billable transactions. The Write Off Amount + Billable Amount must equal this Amount field.
- Write Off
-
- Hours -- Defaults to zero. This value can be positive, negative or zero. If a value is entered, the following fields will be recalculated as:
-
- Write Off Amount = Amount * Write Off Hours/Hours
- Billable Hours = Hours – Write Off Hours
- Billable Amount = Amount – Write Off Amount.
-
- Amount -- Defaults to zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount. If the amount written off is the amount for the originating cost transaction, the Write-off Amount and Billable Amount values for the associated indirect and fee transactions will be proportionally adjusted so that the Billable Amount proportion of indirect and fee values is the same as that for the originating Cost Transaction. Note that changing the Write Off Amount will have no impact on the Hours field. See example below.
- Billable
-
- Hours -- Defaults to Hours. This value can be positive, negative or zero. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Amount * Billable Hours/Hours
- Write Off Hours = Hours - Billable Hours
- Write Off Amount = Amount – Billable Amount
- Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount. If the modified Billable Amount is equal to the amount for the originating cost transaction, the Write-off Amount and Billable Amount values for the associated indirect and fee transactions will be proportionally adjusted as described in the Write Off Amount example below. Note that changing the Billable Amount will have no impact on the Hours field.
Example
If the originating cost transaction Amount is $500 and $250 is written off, then the Billable amount for all indirect and fee lines should be set to equal 50% ($250/$500) of their Amount value rounded to 2 decimal places. The Write Off amount for each of these lines would then be set to the Amount – the new Billable Amount for each line.
Fixed Price
You can refine the list of Fixed Price items using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with a Fixed Price item. The screen displays all of the Fixed Price Items on the invoice. If the user edits a row, they can manually enter a specific Write Off or Billable Amount.
- Amount -- This is a display only field representing the amount of the fee cap adjustment. The Write Off Amount + Billable Amount must equal this Amount field.
- Write Off Amount -- Defaults to zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount.
- Billable Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount.
Funding Cap Adjustment
You can refine the list of Funding Cap Adjustments using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with Funded Value Adjustment amounts posted when the Project or Task Funded Value has been exceeded and the user indicates that they want to limit billings to the Funded Value. The screen displays all of the Funded Value Adjustments posted by the Billing Post(s). If the user edits a row, they can manually enter a specific Write Off or Billable Amount.
- Date -- This is a display only field representing the Posted date specified when the Funded Value Adjustment was posted.
- Amount -- This is a display only field representing the amount of the fee cap adjustment. The Write Off Amount + Billable Amount must equal this Amount field.
- Write Off Amount -- Defaults to zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount.
- Billable Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount.
Prebilled Labor
You can refine the list of Prebilled Labor using the Search screen.
Field Descriptions (click on a link below for additional information):
Prebilled Labor items can only be fully deferred (i.e., there is no write-off capability for prebilled items).
Note regarding Prebilled Labor entries: You cannot defer them after any labor items have been used to offset any pre-billed labor balance.
T&M Expense
You can refine the list of expense items using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with a T&M expense item. If the user edits a row, they can manually enter a specific Write Off or Billable -- Cost or Amount and also specify a new Markup % to display on the invoice.
- Cost -- This is a display only field representing the original cost amount of the expense item.
- Markup % -- This is a display only field representing the percentage the cost was marked up to reach the particular Amount.
- Amount -- This is a display only field representing the original billable amount of the expense item.
- Write Off
-
- Cost -- Defaults to zero. Write Off Cost + Billable Cost must equal Cost. If a value is entered, the following fields will be recalculated as:
-
- Billable Cost = Cost – Write Off Cost
- Billable Amount = Billable Cost * Billable Markup %
- Write Off Amount = Amount – Billable Amount
-
- Amount -- Defaults to zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount. Write Off Amount + Billable Amount must equal Amount.
- Billable
-
- Cost -- Defaults to Cost. Billable Cost + Write Off Cost must equal Cost. If a value is entered, the following fields will be recalculated as:
-
- Write Off Cost = Cost – Billable Cost
- Billable Amount = Billable Cost * Billable Markup %
- Write Off Amount = Amount – Billable Amount
-
- Markup % -- Defaults to Markup %. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Billable Cost * (1+Markup %/100)
- Write Off Amount = Amount – Billable Amount
- Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount. Billable Amount + Write Off Amount must equal Amount.
T&M Labor
You can refine the list of labor items using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with a T&M labor item. If the user edits a row, they can manually enter a specific Write Off (Hours or Amount) or Billable (Rate, Hours or Amount).
- Rate -- This is a display only field representing the original rate associated with the labor transaction.
- Hours -- This is a display only field and represents the number of hours associated with the time transaction.
- Amount -- This is a display only field representing the original billable amount of the labor transaction.
- Write Off
-
- Hours -- Defaults to zero. This value can be positive, negative or zero. If a value is entered, the following fields will be recalculated as:
-
- Write Off Amount = Amount * Write Off Hours/Hours
- Billable Hours = Hours – Write Off Hours
- Billable Amount = Amount – Write Off Amount.
-
- Amount -- Defaults to zero. This value can be positive, negative or zero. If modified, the Billable Amount will be recalculated as: Amount – Write Off Amount. Write Off Amount + Billable Amount must equal Amount.
- Billable
-
- Rate -- Defaults to Rate. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Billable Hours * Billable Rate
- Write Off Amount = Amount – Billable Amount
Note: this field will be displayed with at least 2 positions to the right of the decimal and up to 5 positions (rounded) if more entered.
- Hours -- Defaults to Hours. This value can be positive, negative or zero. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Amount * Billable Hours/Hours
- Write Off Hours = Hours - Billable Hours
- Write Off Amount = Amount – Billable Amount.
- Amount -- Defaults to Amount. This value can be positive, negative or zero. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount. Billable Amount + Write Off Amount must equal Amount.
T&M Item
You can refine the list of T&M items using the Search screen.
Field Descriptions (click on a link below for additional information):
The resulting List screen allows the user to write off a portion or all of the amounts associated with a T&M Item. If the user edits a row, they can manually enter a specific Write Off or Billable -- Cost, Quantity, Amount, Markup %, or Bill Rate.
- Cost -- This is a display only field representing the original cost amount of the item.
- Markup % -- This is a display only field representing the percentage the cost was marked up to reach the particular Amount.
- Bill Rate -- This is a display only field representing the bill rate associated with the item transaction.
- Quantity -- This is a display only field and represents the quantity associated with the item transaction.
- Amount -- This is a display only field representing the original billable amount of the item.
- Write Off
-
- Items billed based on quantity and bill rate
-
- a change to quantity causes amount to be recalculated based on the remaining quantity and bill rate
- a change to cost causes no changes for amount, rate or quantity
- a change to amount causes no changes for rates or quantity
- a change to rate causes the amount to be recalculated
- Items billed based on cost and markup
-
- a change to quantity causes amount and cost to be prorated
- a change to cost or markup causes amount to be recalculated
- a change to amount causes no changes for cost or markup
- a change to markup causes the amount to be recalculated
- Billable
-
- Cost -- Defaults to Cost. Billable Cost + Write Off Cost must equal Cost. If a value is entered, the following fields will be recalculated as:
-
- Write Off Cost = Cost – Billable Cost
- Billable Amount = Billable Cost * Billable Markup %
- Write Off Amount = Amount – Billable Amount
-
- Markup % -- Defaults to Markup %. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Billable Cost * (1+Markup %/100)
- Write Off Amount = Amount – Billable Amount
- Bill Rate -- Defaults to Bill Rate. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Billable Quantity * Billable Rate
- Write Off Amount = Amount – Billable Amount
- Quantity -- Defaults to Quantity. This value can be positive, negative or zero. If a value is entered, the following fields will be recalculated as:
-
- Billable Amount = Amount * Billable Quantity/Quantity
- Write Off Quantity= Quantity- Billable Quantity
- Write Off Amount = Amount – Billable Amount.
- Amount -- Defaults to Amount. If modified, the Write Off Amount will be recalculated as: Amount - Billable Amount. Billable Amount + Write Off Amount must equal Amount.
Invoice Completion Process
When a draft invoice is Completed using one of the Approve icons ( or ), the following measures are taken:
- An invoice being completed will have its Completed By/Completed Date set to the user initiating the completion and the system timestamp respectively.
- The status of the invoice is changed from Draft to Completed
Note: If the project description and memo are updated after the invoice is completed or extracted, the description and memo fields will not be updated on the invoice.
Roles
This process is available to users having any of the following roles: Administrator, P&R Administrator or Billing Manager. Note If the user is a Billing Manager, the user must have Manager Access for the specific project to be posted.
Primary Invoice Project
- For the sake of brevity, all references to the invoice's primary project refer to either the only project associated with the invoice if the invoice is for a standalone project, or the lead project if the invoice is for an invoicing group (lead and contributor projects).
Invoice Prerequisites
General Rules for Posting Organizations and Accounts
- Rules for deriving posting organizations and accounts will come from the posting group associated with the specific invoice item's project.
-
- Posting group rules for any category not overridden by the project specific posting group will come from the system default posting group.
- All posted items will attempt to derive their posting organization regardless of whether or not Use Financial Organizations (unanet.financials.use_financial_orgs) is enabled.
-
- If financial organizations are not required:
- an item can be posted without a posting organization.
- if financial organizations are required:
- failure to find a posting organization for any item being posted will result in an error preventing completion of the invoice.
- failure to find a posting organization that is a financial organization for any item being posted will result in an error preventing completion of the invoice.
- if the derived posting organization is a financial organization that does not belong to the same legal entity as the owning organization of the invoice's primary project the following *invalid legal entity error logic will apply":
- The posting organization will be derived using the posting group rules for the INVALID LEGAL ENTITY ERROR - INVOICE COMPLETION account category.
- The account will be derived using the posting group rules for the INVALID LEGAL ENTITY ERROR - INVOICE COMPLETION account category.
- The item will be posted using the originally intended account category, but using the organization and account derived via the error process.
- failure to find a valid organization or account via the invalid legal entity error logic will result in an error preventing completion of the invoice.
- All posted items will derive their posting account
-
- Failure to derive an account will result in an error preventing completion of the invoice.
- All postings for the BILLED category will use the same posting organization and account. The organization and account pair will be derived based on the invoice's primary project using the same process as described above with the derivation rules from the posting group associated with the invoice's primary project.
- All postings for the UNBILLED category will attempt to use the same posting organization and account as was found on the item's original UNBILLED posting from the Bill Post. If financial organizations are required and the original UNBILLED posting from the bill post does not have a posting organization, the organization and account pair will be re-derived using the same process as described above for the specific item.
General Rules for Posting to the General Ledger
- If posting to the general ledger (ie Post to General Ledger (unanet.financials.post_to_gl) is enabled), all transactions posted to the general ledger will have the following additional rules applied to the posting organizations and accounts:
- The account must allow transaction entry as of the post date of the billing post
- The organization must be valid for the account
- The organization must allow transaction entry as of the post date of the billing post
- Invalid posting organizations and accounts for any item to be posted to the general ledger will result in an error preventing completion of the invoice.
- All BILLED journal transactions will be posted to the general ledger as a single summary entry containing:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Invoice's primary project
- Account - Invoice's BILLED posting account
- Organization - Invoice's BILLED posting organization
- Description - Description for this invoice completion
- Transaction Date - Invoice's post date
- Customer - Invoice's customer (originally captured during invoice creation from invoice's primary project)
- If posting to the general ledger at the detailed level (General Ledger Invoice Post Level (unanet.financials.gl_post_level.invoice) set to detail), general ledger transactions will be generated for each non-BILLED journal transaction generated as part of the specific invoice completion.
- If posting to the general ledger at the summary level (General Ledger Invoice Post Level (unanet.financials.gl_post_level.invoice) set to summary), summary general ledger transactions will be generated for each distinct project, posting organization, and account that was posted to non-BILLED journal transactions as part of the specific invoice completion.
- Each summary general ledger entry will contain:
-
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Summarized project
- Account - Summarized posting account
- Organization - Summarized posting organization
- Description - Description for this invoice completion
- Transaction Date - Invoice's post date
General Order of Completion Processing
- All items related to this invoice will be posted to the individual journal tables and, if requested, the general ledger
- if posting to the general ledger, closed fiscal year adjustments may also be posted to the general ledger if applicable
- Invoice will be marked as posted and will be stamped with the BILLED posting organization and account used for all BILLED transactions generated during the completion.
Prebilled Labor
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this prebilled item's project
- Project - Owning organization of this prebilled item's project
- Person - Owning organization of this prebilled item's project
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Prebilled labor item's project
- Project Type - Default project type of prebilled labor item's project
- Invoice Completion Processing
- Journal Post
-
- For each prebill item
- Post the negation of its original UNBILLED amount as UNBILLED to the prebill journals
- Post its original UNBILLED amount as BILLED to the prebill journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Bill date of prebilled item
T&M Time
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this time item's project
- Project - Owning organization of this time item's task if available, otherwise owning organization of this time item's project
- Person
- If requiring financial organizations
- If cost organization override stamped on the time item is a financial organization use it;
- Otherwise, if this time item's timesheet owner is an employee as of the end date of the timesheet for this time item, use the current person organization of this time item's timesheet owner;
- Otherwise, if current person organization of this tiem item's timesheet owner is a financial organization use it;
- Otherwise owning organization of this time item's task, if available, otherwise owning organization of this time item's project
- If not requiring financial organizations cost organization override stamped on the time item
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Time item's project
- Task - Time item's task if available
- Cost Element - Time item's cost element if available
- Project Type - Time item's project type
- Person - Owner of this time item's timesheet
- Labor Category - Time item's labor category if available
- Employee Type - Employee type of the owner of this time item's timesheet
- Pay Code - Time item's pay code
- Invoice Completion Processing
- Journal Post
-
- For each time item originally posted with an UNBILLED amount (excludes any part of time that was used to offset prebill)
- Post the negation of its original UNBILLED amount as UNBILLED to the time journals
- If the time item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the time journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the time journals
- Otherwise post its original UNBILLED amount as BILLED to the time journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Time item's Work date
- Person - Owner of this time item's timesheet
T&M Expense
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this expense item's project
- Project - Owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- Person
- If requiring financial organizations
- If this expense item's expense report owner is an employee as of this invoice's posting date, use the current person organization of this expense item's expense report owner;
- Otherwise, if current person organization of this expense item's expense report owner is a financial organization use it;
- Otherwise owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- If not requiring financial organizations current person organization of this expense item's expense report owner
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Expense item's project
- Task - Expense item's task if available
- Expense Type - Expense item's expense type
- Cost Element - Expense item's cost element if available
- Project Type - Expense item's project type
- Payment Method - Expense item's payment method
- Invoice Completion Processing
- Journal Post
-
- For each expense item
- Post the negation of its original UNBILLED amount as UNBILLED to the expense journals
- If the expense item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the expense journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the expense journals
- Otherwise post its original UNBILLED amount as BILLED to the expense journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Expense item's line item date
- Person - Owner of this expense item's expense report
T&M Item
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this item's project
- Project - Owning organization of this item's task if available, otherwise owning organization of this item's project
- Person
- If requiring financial organizations
- If this item's person is an employee as of this invoice's posting date, use the current person organization of this item's person;
- Otherwise, if current person organization of this item's person is a financial organization use it;
- Otherwise owning organization of this item's task if available, otherwise owning organization of this item's project
- If not requiring financial organizations current person organization of this item's person
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Item's project
- Task - Item's task if available
- Cost Element - Item's cost element if available
- Project Type - Item's project type
- Invoice Completion Processing
- Journal Post
-
- For each item
- Post the negation of its original UNBILLED amount as UNBILLED to the item journals
- If the item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the item journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the item journals
- Otherwise post its original UNBILLED amount as BILLED to the item journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Item's line item date
- Person - Owner of this item
T&M Document Expense
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this document expense item's project
- Project - Owning organization of this document expense item's task if available, otherwise owning organization of this document expense item's project
- Person
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Document expense item's project
- Task - Document expense item's task if available
- Expense Type - Document expense item's expense type
- Cost Element - Document expense item's cost element if available
- Project Type - Document expense item's project type
- Invoice Completion Processing
- Journal Post
-
- For each document expense item
- Post the negation of its original UNBILLED amount as UNBILLED to the document expense journals
- If the document expense item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the document expense journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the document expense journals
- Otherwise post its original UNBILLED amount as BILLED to the document expense journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Date from originating financial document detail
- Person - Document expense's associated person if available
- Customer - Document expense's associated general ledger customer if available
Fixed-Price
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this fixed-price item's project
- Project - Owning organization of this fixed-price item's task if available, otherwise owning organization of this fixed-price item's project
- Person - Owning organization of this fixed-price item's task if available, otherwise owning organization of this fixed-price item's project
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Fixed-price item's project
- Task - Fixed-price item's task if available
- Project Type - Default project type of fixed-price item's task if available; otherwise default project type of fixed-price item's project
- Invoice Completion Processing
- Journal Post
-
- For each fixed-price item
- Post the negation of its original UNBILLED amount as UNBILLED to the fixed-price journals
- If the fixed-price item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the fixed-price journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the fixed-price journals
- Otherwise post its original UNBILLED amount as BILLED to the fixed-price journals
- If the fixed-price item is recognize-on-bill
- Post the negation of its amount as DEFERRED_REVENUE to the fixed-price journals
- Post its amount as RECOGNIZED_REVENUE to the fixed-price journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Fixed-price item's Bill date if not using milestone billing, otherwise fixed-price item's task completion date if task milestone billing, otherwise fixed-price item's project completion date if project milestone billing
Cost-Plus Labor
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this labor item's project
- Project - Owning organization of this labor item's task if available, otherwise owning organization of this labor item's project
- Person
- If requiring financial organizations
- If cost organization override stamped on the labor item is a financial organization use it;
- Otherwise, if this labor item's timesheet owner is an employee as of the end date of the timesheet for this labor item, use the current person organization of this labor item's timesheet owner;
- Otherwise, if current person organization of this labor item's timesheet owner is a financial organization use it;
- Otherwise owning organization of this labor item's task, if available, otherwise owning organization of this time item's project
- If not requiring financial organizations cost organization override stamped on the labor item
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Labor item's project
- Task - Labor item's task if available
- Cost Element - Cost-plus labor item's cost element if available
- Project Type - Labor item's project type
- Person - Owner of this labor item's timesheet
- Labor Category - Labor item's labor category if available
- Employee Type - Employee type of the owner of this labor item's timesheet
- Pay Code - Labor item's pay code
- Invoice Completion Processing
- Journal Post
-
- For each labor item originally posted with an UNBILLED amount
- Post the negation of its original UNBILLED amount as UNBILLED to the cost plus journals
- If the labor item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the cost plus journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the cost plus journals
- Otherwise post its original UNBILLED amount as BILLED to the cost plus journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Labor item's Work date
- Person - Owner of this labor item's timesheet
Cost-Plus Expense
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this expense item's project
- Project - Owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- Person
- If requiring financial organizations
- If this expense item's expense report owner is an employee as of this invoice's posting date, use the current person organization of this expense item's expense report owner;
- Otherwise, if current person organization of this expense item's expense report owner is a financial organization use it;
- Otherwise owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- If not requiring financial organizations current person organization of this expense item's expense report owner
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Expense item's project
- Task - Expense item's task if available
- Expense Type - Expense item's expense type
- Cost Element - Cost-plus expense item's cost element if available
- Project Type - Expense item's project type
- Payment Method - Expense item's payment method
- Invoice Completion Processing
- Journal Post
-
- For each expense item
- Post the negation of its original UNBILLED amount as UNBILLED to the cost plus journals
- If the expense item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the cost plus journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the cost plus journals
- Otherwise post its original UNBILLED amount as BILLED to the cost plus journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Expense item's line item date
- Person - Owner of this expense item's expense report
Cost-Plus Item
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this item's project
- Project - Owning organization of this item's task if available, otherwise owning organization of this item's project
- Person
- If requiring financial organizations
- If cost organization override stamped on the item is a financial organization use it;
- Otherwise, if this item's person is an employee as of this invoice's posting date, use the current person organization of this item's person;
- Otherwise, if current person organization of this item's person is a financial organization use it;
- Otherwise owning organization of this item's task, if available, otherwise owning organization of this item's project
- If not requiring financial organizations cost organization override stamped on the item
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Item's project
- Task - Item's task if available
- Cost Element - Cost-plus item's cost element if available
- Project Type - Item's project type
- Person - Owner of this item
- Invoice Completion Processing
- Journal Post
-
- For each item originally posted with an UNBILLED amount
- Post the negation of its original UNBILLED amount as UNBILLED to the cost plus journals
- If the item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the cost plus journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the cost plus journals
- Otherwise post its original UNBILLED amount as BILLED to the cost plus journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Item's Work date
- Person - Owner of this item
Cost-Plus Document Expense
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this document expense item's project
- Project - Owning organization of this document expense item's task if available, otherwise owning organization of this document expense item's project
- Person
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Document expense item's project
- Task - Document expense item's task if available
- Expense Type - Document expense item's expense type
- Cost Element - Cost-plus document expense item's cost element if available
- Project Type - Document expense item's project type
- Invoice Completion Processing
- Journal Post
-
- For each document expense item
- Post the negation of its original UNBILLED amount as UNBILLED to the cost plus journals
- If the document expense item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the cost plus journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the cost plus journals
- Otherwise post its original UNBILLED amount as BILLED to the cost plus journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Date from originating financial document detail
- Person - Document expense's associated person if available
- Customer - Document expense's associated general ledger customer if available
Fee Cap Adjustments
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this fee cap adjustment item's project
- Project - Owning organization of this fee cap adjustment item's project
- Person - Owning organization of this fee cap adjustment item's project
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Fee cap adjustment item's project
- Project Type - Default project type of fee cap adjustment item's project
- Invoice Completion Processing
- Journal Post
-
- For each fee cap adjustment item
- Post the negation of its original UNBILLED amount as UNBILLED to the fee cap adjustment journals
- If the fee cap adjustment item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the fee cap adjustment journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the fee cap adjustment journals
- Otherwise post its original UNBILLED amount as BILLED to the fee cap adjustment journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Post date of the original billing post for this fee cap adjustment item
Funding Cap Adjustments
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this funding cap adjustment item's project
- Project - Owning organization of this funding cap item's task if available, otherwise owning organization of this funding cap adjustment item's project
- Person - Owning organization of this funding cap item's task if available, otherwise owning organization of this funding cap adjustment item's project
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Funding cap adjustment item's project
- Task - Funding cap adjustment item's task if available
- Project Type - Default project type of funding cap adjustment item's task if available; otherwise default project type of funding cap adjustment item's project
- Invoice Completion Processing
- Journal Post
-
- For each funding cap adjustment item
- Post the negation of its original UNBILLED amount as UNBILLED to the funding cap adjustment journals
- If the funding cap adjustment item has an associated write-off amount
- Post its write-off amount as REVENUE_WRITE_OFF to the funding cap adjustment journals
- Post its original UNBILLED amount less its write-off amount as BILLED to the funding cap adjustment journals
- Otherwise post its original UNBILLED amount as BILLED to the funding cap adjustment journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - Post date of the original billing post for this funding cap adjustment item
Additional Items
- Posting Organization By Source
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this additional item's project
- Project - Owning organization of this additional item's task if available, otherwise owning organization of this additional item's project
- Person - Owning organization of this additional item's task if available, otherwise owning organization of this additional item's project
- Posting Account Source Identifiers
- Legal Entity - Legal entity of the posting organization
- Project - Additional item's project
- Task - Additional item's task if available
- Project Type - Default project type of additional item's task if available; otherwise default project type of additional item's project
- Additional Item Type - Additional item's additional item type
- Invoice Completion Processing
- Journal Post
-
- For each additional item
- Derive the Debit posting organization and posting account using the debit account category associated with this additional item's additional item type
- If the debit account category associated with this additional item's additional item type has a debit normal balance
- Post this item's amount using its debit category to the onetime charge journals
- Otherwise
- Post the negation of this item's amount using its debit category to the onetime charge journals
- Derive the Credit posting organization and posting account using the credit account category associated with this additional item's additional item type
- If the credit account category associated with this additional item's additional item type has a credit normal balance
- Post this item's amount using its credit category to the onetime charge journals
- Otherwise
- Post the negation of this item's amount using its credit category to the onetime charge journals
- General Ledger Post -- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Invoice number
- Post Date - Invoice's post date
- Fiscal Month - Fiscal month containing invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice completion
- Transaction Date - This invoice's post date
Auto-Correct Rounding
Whether the Auto-Correct Rounding feature is enabled by default, is controlled by the Auto-Correct Invoice Rounding (unanet.invoice.auto_correct.rounding.default) property. Regardless of the default setting, the feature can be enabled or disabled on a draft invoice by draft invoice basis by editing a draft invoice and navigating to the Setup tab (where you can check or uncheck the Auto-Correct Rounding check box).
When enabled, the system will create write-off entries upon invoice completion to ensure posted values equal the amounts displayed on the invoice (i.e. to ensure the sum of the transactions agree with the values displayed on the invoice).
Items to note about the Auto-Correct Rounding:
- Rounding adjustments are only applied to invoices that have the Auto-Correct Rounding option enabled
- Rounding adjustments are only applied based on the invoice’s primary invoice format
- Rounding adjustments are only applied to items included in T&M Labor and T&M Expense sections
- Rounding adjustments are determined by the grouping defined for sections of this type
- Rounding is only applied to items that are included in a section of this type which is displaying:
- T&M Labor -- rate, hours and amount
- T&M Expense (includes document Items) -- cost, mark-up and amount OR quantity, bill rate, and amount
Prior to invoice completion:
The effects of Auto-Correct Rounding are only evident when viewing the invoice’s primary format display.
The rounding adjustments are included in the following for the primary invoice display:
- Amount
- Inception to Date (incorporated into this value if displayed)
- Any sub-totals for the above two columns
The rounding adjustments are not included in the following for the primary invoice display:
- Discount Amount (if displayed)
- Invoiced To Date Amount (if displayed)
- Outstanding AR Balance (if displayed)
- Remaining Project Funded Value (if displayed)
- Remaining Task Funded Value (if displayed)
The effects of Auto-Correct Rounding are NOT evident anywhere in the following prior to invoice completion:
- Any additional Invoice Format display
- Anywhere in the T&M Labor or T&M Expense invoice detail listings
- Any invoice listing
- Any Unanet report
Upon invoice completion:
Upon invoice completion, Auto-Correct Rounding adjustments will be applied to affected items based on the definition of the invoice’s primary invoice format. At that time, the write-offs will be added to the affected items, and all invoice data will be updated to reflect the write-offs.
For those sections requiring a rounding write-off correction, the write-off will be applied to:
- T&M Labor -- the line item having the minimum timesheet cell key (i.e. the earliest timesheet cell entered)
- T&M Expense -- the line item having the minimum allocated expense key (i.e. the earliest expense line item entered) or the minimum financial document key (i.e. the earliest financial document detail line item entered).
Potential Impact to Manual Write-Off Entries
Any manual write-offs applied to an invoice that is also calculating Auto-Correct Rounding adjustments, may be undone by the Auto-Correct Rounding calculations.
You can also review the Invoice Rounding topic in our Knowledge Center.
Invoice Deletion Process
When a draft invoice is deleted using one of the delete icons ( or ), the following measures are taken:
- The invoice is deleted. There is no trace in the system that it ever existed.
Preconditions:
- An invoice can only be deleted by an authorized user.
- An invoice can only be deleted if it is in draft status.
Deleting an invoice:
- Deletes all additional items associated with the invoice
- Resets all of the following associated with the invoice to un-invoiced:
- Cost-Plus Detail Entries
- Fixed-Price items
- Pre-Billed Labor items
- Labor items
- Expense items
- Items
- Financial Document Expenses
- Fee Cap Adjustments
- Funding Cap Adjustments
Revising Invoice Amounts
Whether an invoice can be modified will depend on the status of the invoice and whether or not it has been marked as Extracted. The options to revise an invoice amount include:
- Stand-alone correcting invoice - You could create another invoice for this project, using an Additional Item charge to reflect the positive or negative adjusting amount. This may be the only item on the invoice. To accomplish this, you could select the option ‘Include projects without unbilled data’ when adding a new Invoice. In the memo field, you could indicate that this invoice is an addendum to the original invoice. Do note that the new invoice will have its own invoice number and the original invoice remains in the system for historical purposes.
- Adjustment on a future invoice - Similar to the option above, you could include an adjusting Additional Item on the next regularly scheduled invoice (rather than creating a stand-alone invoice to contain the revised amounts).
- Handle externally - combined with Additional Item - Should your invoicing scheme involve manual creation of invoices (for customized needs), you could follow the process described in options 1 or 2 above, but then not send the resulting invoice to the customer, but instead correct your externally created invoice. In this way, Unanet would reflect the correct billing and revenue numbers.
- Uncomplete invoice - If you have an invoice that has been completed, you may choose the uncomplete option (even if it is marked extracted), which could allow you to subsequently unpost the associated invoice data, which could then allow for further manipulation of the underlying data prior to re-creating the invoice. See Invoice Uncomplete below for additional details.
-
Invoice Voiding / Reversal - Should none of the options above meet your needs, you can use the void capability within Unanet, which assists with the creation of a new invoice that contains negating values for the original invoice. To void an existing completed invoice, you can click on the void icon () which appears on the List Invoices screen. When using this option, the original voided invoice remains in the system (for auditing purposes), and the new voiding invoice will also be present in the system. See next section for additional details.
Re-creating an Invoice (or better put - Creating the next Invoice for a Project)
To recreate the invoice (presumably with altered content), you will need to follow the same original procedures to Add an Invoice. This is not so much of a re-creation, but rather a do-over, as the system will pick up all items that are currently eligible to be billed (which may be different than when you originally created this particular invoice).
You will need to again decide which items to include and defer, implementing any custom overrides to header information, description and memo text, and adding any desired Additional Items.
Essentially, you're not re-creating an invoice but simply creating the next invoice for the particular project (which may include the eligible billing items that were previously on a now voided invoice).
Invoice Uncomplete
To uncomplete a previously completed invoice (which may be desired such that you can further manipulate the invoice or potentially remove and unpost the data associated with it), an administrator can click on the void / uncomplete icon (). Note that this option is only available to users having an Administrator role, and only when the Allow Users to Uncomplete Invoices (unanet.invoice.allow_invoice_uncomplete) property has been enabled. When this property has been enabled, the following options will be presented:
-
If an invoice has yet to be voided, and the uncomplete property is enabled, then clicking on the void icon () will present the Administrator with a pop-up menu containing two choices (Uncomplete Invoice and Void Invoice).
-
If an invoice has already been voided, then the popup above will not be displayed upon clicking the void icon (), but rather the user will simply be prompted to confirm they would like to uncomplete the invoice.
Uncompleting an invoice will result in the following actions:
- If the invoice was previously voided,
-
- the associated voiding invoice and all its entries will be deleted from the system (with no audit trail or evidence the voiding invoice existed)
- note this feature is not available to directly uncomplete a voiding invoice (you must uncomplete the voided invoice which will remove its associated voiding invoice)
- the completion information for the current voided invoice will be blanked out
- All journal entry records generated as a result of the invoice completion will be removed.
- All general ledger records generated as a result of the invoice completion will be removed.
- Completion and Extraction details will be blanked out (on the Invoice List page).
- The project level memo / description will be updated to the configured memo / description from the project. We suggest that you print or save a PDF version of the completed invoice before uncompleting so that you have the original memo / description in case it has changed on the project.
Note that invoices posted into closed Fiscal Periods or invoices generated by Historical Data Load (indicated by ) cannot be uncompleted.
Invoice Void
To void a previously completed invoice (i.e., create a voiding invoice with negating values), the user can click on the void icon (). Note that invoices generated by Historical Data Load (indicated by ) cannot be voided.
When the Allow Users to Uncomplete Invoices (unanet.invoice.allow_invoice_uncomplete) property has been enabled, and an invoice has yet to be voided, then clicking on the void icon () will present the Administrator with a pop-up menu containing two choices:
Selecting the Void option will present the user with the following popup, where you will need to supply values for the following fields and click on the Void button.
Field Descriptions (click on a link below for additional information):
Impacts of Voiding an Invoice
-
Once you have voided an invoice, neither the voided or voiding invoice can be further manipulated, deleted (or details un-posted).
-
The List Invoice screen contains additional columns to note which invoice a reversing invoice is associated with, as well as an indication as to which invoice voided the current invoice (should either case be applicable). The voiding and voided invoices will sort together on the listing to help the user associate the pair.
-
When an invoice has been voided, new journal entries will be created to reflect the negated amounts.
-
Any of the items that were on the original bill will once again be eligible to be included on the next draft bill created for that project.
Example Voided Invoice
When viewing an invoice that has been voided, it will appear as it originally appeared, with one difference; the word V O I D E D will appear at the top of the invoice in red, see example below.
Likewise, the voiding invoice will also very closely resemble the original invoice, with the following differences:
- All amounts will be negated (i.e. multiplied by -1)
- The invoice number of the voiding invoice will be the same as the original with "-REV" appended.
- The invoice title will have the word V O I D I N G in red text
- The Description field will include a statement pre-pended to any existing description, indicating that this invoice is "Voiding Invoice Original-Invoice-#"
Void - Process
Invoice Voiding Prerequisites
General Rules for Posting Organizations and Accounts
- All postings during the voiding process will attempt to use the same posting organization and account as was found on the items to be reversed from the completion of the invoice to be voided.
- If financial organizations are NOT required
- The posting organization, if available, and posting account from the original item from completion of the invoice to be voided will be used
- if financial organizations are required and an original item from completion of the invoice to be voided has a posting organization
- If the posting organization is not a financial organization, it will result in an error preventing voiding of the invoice
- if the posting organization is a financial organization that does not belong to the same legal entity as the owning organization of the primary project of the invoice to void, it will result in an error preventing voiding of the invoice
- if financial organizations are required and an original item from completion of the invoice to be voided does NOT have a posting organization
- The organization and account pair will be re-derived
- Rules for deriving posting organizations and accounts will come from the posting group associated with the specific item's project. Posting group rules for any category not overridden by the project specific posting group will come from the system default posting group.
- failure to find a posting organization for any item being posted will result in an error preventing voiding of the invoice
- failure to find a posting organization that is a financial organization for any item being posted will result in an error preventing voiding of the invoice
- if the derived posting organization is a financial organization that does not belong to the same legal entity as the owning organization of the primary project of the invoice to void, the following *invalid legal entity error logic will apply":
- The posting organization will be derived using the posting group rules for the INVALID LEGAL ENTITY ERROR - INVOICE COMPLETION account category.
- The account will be derived using the posting group rules for the INVALID LEGAL ENTITY ERROR - INVOICE COMPLETION account category.
- The item will be posted using the originally intended account category, but using the organization and account derived via the error process.
- failure to find a valid organization or account via the invalid legal entity error logic will result in an error preventing voiding of the invoice
- failure to derive an account will result in an error preventing voiding of the invoice
- All postings for the BILLED category will use the same posting organization and account. The organization and account pair will be derived based on the primary project of the invoice to void using the same process as described above with the derivation rules from the posting group associated with the primary project of the invoice to void.
General Rules for Posting to the General Ledger
- If posting to the general ledger (ie Post to General Ledger (unanet.financials.post_to_gl)) is enabled, all transactions posted to the general ledger will have the following additional rules applied to the posting organizations and accounts:
- The account must allow transaction entry as of the post date of the voiding invoice
- The organization must be valid for the account
- The organization must allow transaction entry as of the post date of the voiding invoice
- Invalid posting organizations and accounts for any item to be posted to the general ledger will result in an error preventing voiding of the invoice.
- All BILLED journal transactions will be posted to the general ledger as a single summary entry containing:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Account - Voiding Invoice's BILLED posting account
- Organization - Voiding Invoice's BILLED posting organization
- Project - Voiding Invoice's primary project
- Description - Description for this invoice void
- Transaction Date - Voiding Invoice's post date
- Customer - Voiding Invoice's customer (originally captured during invoice creation from voided invoice's primary project)
- If posting to the general ledger at the detailed level (General Ledger Invoice Post Level (unanet.financials.gl_post_level.invoice) set to detail, general ledger transactions will be generated for each non-BILLED journal transaction generated as part of the specific invoice void
- If posting to the general ledger at the summary level (General Ledger Invoice Post Level (unanet.financials.gl_post_level.invoice) set to summary), summary general ledger transactions will be generated for each distinct project, posting organization, and account that was posted to non-BILLED journal transactions as part of the specific invoice void. Each summary general ledger entry will contain:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Account - Summarized posting account
- Organization - Summarized posting organization
- Project - Summarized project
- Description - Description for this invoice void
- Transaction Date - Voiding Invoice's post date
General Order of Void Processing
- A voiding invoice will be created against the invoice to be voided, and the invoice to be voided will be associated with the new voiding invoice
- All items created during the original completion of the invoice to be voided will be posted to the individual journal tables and, if requested, the general ledger as voiding entries associated with the voiding invoice
- if posting to the general ledger, closed fiscal year adjustments may also be posted to the general ledger if applicable
- The voiding invoice will be marked as posted and will be stamped with the BILLED posting organization and account used for all BILLED transactions generated during the void.
Prebilled Labor
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this prebilled labor item's project
- Project - Owning organization of this prebilled labor item's project
- Person - Owning organization of this prebilled labor item's project
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Prebilled labor item's project
- Project Type - Default project type of prebilled labor item's project
- Invoice Void Processing
- For each prebill transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the prebill journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Bill date of prebilled item
T&M Time
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this time item's project
- Project - Owning organization of this time item's task if available, otherwise owning organization of this time item's project
- Person
- If requiring financial organizations
- If cost organization override stamped on the time item is a financial organization use it
- Otherwise, If this time item's timesheet owner is an employee as of the end date of the timesheet for this time item, use the current person organization of this time item's timesheet owner
- Otherwise, If current person organization of this time item's timesheet owner is a financial organization use it
- Otherwise owning organization of this time item's task if available, otherwise owning organization of this time item's project
- If not requiring financial organizations cost organization override stamped on the time item
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Time item's project
- Task - Time item's task if available
- Cost Element - Time item's cost element if available
- Project Type - Time item's project type
- Person - Owner of this time item's timesheet
- Labor Category - Time item's labor category if available
- Employee Type - Employee type of the owner of this time item's timesheet
- Pay Code - Time item's pay code
- Invoice Void Processing
- For each time transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the time journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Time item's Work date
- Person - Owner of this time item's timesheet
T&M Expense
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this expense item's project
- Project - Owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- Person
- If requiring financial organizations
- If this expense item's expense report owner is an employee as of the voiding invoice's posting date, use the current person organization of this expense item's expense report owner
- Otherwise, If current person organization of this expense item's expense report owner is a financial organization use it
- Otherwise owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- If not requiring financial organizations current person organization of this expense item's expense report owner
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Expense item's project
- Task - Expense item's task if available
- Expense Type - Expense item's expense type
- Cost Element - Expense item's cost element if available
- Project Type - Expense item's project type
- Payment Method - Expense item's payment method
- Invoice Void Processing
- For each expense transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the expense journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Expense item's line item date
- Person - Owner of this expense item's expense report
T&M Item
- Posting Organization By Source (only applicable if required to derive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this item's project
- Project - Owning organization of this item's task if available, otherwise owning organization of this item's project
- Person
- If requiring financial organizations
- If this item's person is an employee as of the voiding invoice's posting date, use the current person organization of this item's person
- Otherwise, If current person organization of this item's person is a financial organization use it
- Otherwise owning organization of this item's task if available, otherwise owning organization of this item's project
- If not requiring financial organizations current person organization of this item's person
- Posting Account Source Identifiers (only applicable if required to derive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Item's project
- Task - Item's task if available
- Cost Element - Item's cost element if available
- Project Type - Item's project type
- Invoice Void Processing
- For each item transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the item journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Item's line item date
- Person - Owner of this item
T&M Document Expense
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this document expense item's project
- Project - Owning organization of this document expense item's task if available, otherwise owning organization of this document expense item's project
- Person - Owning organization of this document expense item's task if available, otherwise owning organization of this document expense item's project
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Document expense item's project
- Task - Document expense item's task if available
- Expense Type - Document expense item's expense type
- Cost Element - Document expense item's cost element if available
- Project Type - Document expense item's project type
- Invoice Void Processing
- For each document expense transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the document expense journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Date from originating financial document detail
- Person - Document expense's associated person if available
- Customer - Document expense's associated general ledger customer if available
Fixed-Price
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this fixed-price item's project
- Project - Owning organization of this fixed-price item's task if available, otherwise owning organization of this fixed-price item's project
- Person - Owning organization of this fixed-price item's task if available, otherwise owning organization of this fixed-price item's project
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Fixed-price item's project
- Task - Fixed-price item's task if available
- Project Type - Default project type of fixed-price item's task if available; otherwise default project type of fixed-price item's project
- Invoice Void Processing
- For each fixed-price transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the fixed-price journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Fixed-price item's Bill date if not using milestone billing, otherwise fixed-price item's task completion date if task milestone billing, otherwise fixed-price item's project completion date if project milestone billing
Cost-Plus Labor
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this labor item's project
- Project - Owning organization of this labor item's task if available, otherwise owning organization of this labor item's project
- Person
- If requiring financial organizations
- If cost organization override stamped on the labor item is a financial organization use it
- Otherwise, If this labor item's timesheet owner is an employee as of the end date of the timesheet for this labor item, use the current person organization of this labor item's timesheet owner
- Otherwise, If current person organization of this labor item's timesheet owner is a financial organization use it
- Otherwise owning organization of this labor item's task if available, otherwise owning organization of this time item's project
- If not requiring financial organizations cost organization override stamped on the labor item
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Labor item's project
- Task - Labor item's task if available
- Cost Element - Cost-plus labor item transaction's cost element if available
- Project Type - Labor item's project type
- Person - Owner of this labor item's timesheet
- Labor Category - Labor item's labor category if available
- Employee Type - Employee type of the owner of this labor item's timesheet
- Pay Code - Labor item's pay code
- Invoice Void Processing
- For each cost-plus labor transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the cost plus journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Labor item's Work date
- Person - Owner of this labor item's timesheet
Cost-Plus Expense
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this expense item's project
- Project - Owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- Person
- If requiring financial organizations
- If this expense item's expense report owner is an employee as of the voiding invoice's posting date, use the current person organization of this expense item's expense report owner
- Otherwise, If current person organization of this expense item's expense report owner is a financial organization use it
- Otherwise owning organization of this expense item's task if available, otherwise owning organization of this expense item's project
- If not requiring financial organizations current person organization of this expense item's expense report owner
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Expense item's project
- Task - Expense item's task if available
- Expense Type - Expense item's expense type
- Cost Element - Cost-plus expense item transaction's cost element if available
- Project Type - Expense item's project type
- Payment Method - Expense item's payment method
- Invoice Void Processing
- For each cost-plus expense transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the cost plus journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Expense item's line item date
- Person - Owner of this expense item's expense report
Cost-Plus Item
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this item's project
- Project - Owning organization of this item's task if available, otherwise owning organization of this item's project
- Person
- If requiring financial organizations
- If this item's owner is an employee as of the voiding invoice's posting date, use the current person organization of this item's owner
- Otherwise, If current person organization of this item's owner is a financial organization use it
- Otherwise owning organization of this item's task if available, otherwise owning organization of this item's project
- If not requiring financial organizations current person organization of this item's owner
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Item's project
- Task - Item's task if available
- Cost Element - Cost-plus expense item transaction's cost element if available
- Project Type - Expense item's project type
- Person - Owner of this item
- Invoice Void Processing
- For each cost-plus item transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the cost plus journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Item's line item date
- Person - Owner of this item
Cost-Plus Document Expense
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this document expense item's project
- Project - Owning organization of this document expense item's task if available, otherwise owning organization of this document expense item's project
- Person - Owning organization of this document expense item's task if available, otherwise owning organization of this document expense item's project
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Document expense item's project
- Task - Document expense item's task if available
- Expense Type - Document expense item's expense type
- Cost Element - Cost-plus document expense item transaction's cost element if available
- Project Type - Document expense item's project type
- Invoice Void Processing
- For each cost-plus document expense transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the cost plus journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Date from originating financial document detail
- Person - Document expense's associated person if available
- Customer - Document expense's associated general ledger customer if available
Fee Cap Adjustments
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this fee cap adjustment item's project
- Project - Owning organization of this fee cap adjustment item's project
- Person - Owning organization of this fee cap adjustment item's project
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Fee cap adjustment item's project
- Project Type - Default project type of fee cap adjustment item's project
- Invoice Void Processing
- For each fee cap adjustment transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the fee cap adjustment journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Post date of the original billing post for this fee cap adjustment item
Funding Cap Adjustments
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this funding cap adjustment item's project
- Project - Owning organization of this funding cap item's task if available, otherwise owning organization of this funding cap adjustment item's project
- Person - Owning organization of this funding cap item's task if available, otherwise owning organization of this funding cap adjustment item's project
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Funding cap adjustment item's project
- Task - Funding cap adjustment item's task if available
- Project Type - Default project type of funding cap adjustment item's task if available; otherwise default project type of funding cap adjustment item's project
- Invoice Void Processing
- For each funding cap adjustment transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the funding cap adjustment journals
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Post date of the original billing post for this funding cap adjustment item
Additional Items
- Posting Organization By Source (only applicable if required to rederive posting organization/account)
- Legal Entity - Default general ledger posting organization defined for the legal entity of the owning organization of this additional item's project
- Project - Owning organization of this additional item's task if available, otherwise owning organization of this additional item's project
- Person - Owning organization of this additional item's task if available, otherwise owning organization of this additional item's project
- Posting Account Source Identifiers (only applicable if required to rederive posting organization/account)
- Legal Entity - Legal entity of the posting organization
- Project - Additional item's project
- Task - Additional item's task if available
- Project Type - Default project type of additional item's task if available; otherwise default project type of additional item's project
- Additional Item Type - Additional item's additional item type
- Invoice Void Processing
- For each additional item associated with the invoice to be voided
- Create a new additional item, associated with the voiding invoice, matching the original additional item from the invoice to be voided with a negated amount
- For each additional item transaction that was created during completion of the invoice to be voided
- Post the negation of its amount using the original transaction's account category to the onetime charge journals, associating the new transaction with its voiding additional item created for the voiding invoice.
- If posting to the general ledger at a detail level, post an entry to the general ledger for each journal transaction having:
- Feature - INVOICE POST
- Document Number - Voiding Invoice Number
- Post Date - Voiding Invoice's post date
- Fiscal Month - Fiscal month containing voiding invoice's post date
- Project - Journal transaction's project
- Account - Journal transaction's posting account
- Organization - Journal transaction's posting organization
- Description - Description for this invoice void
- Transaction Date - Voiding invoice's post date
Closed Fiscal Years
Posting to Closed Fiscal Year
When posting to or voiding a document from a closed fiscal year, and the document contains details for accounts having account types REVENUE and EXPENSE, where the credits and debits do not cancel each other out (i.e. the delta between the revenues and expenses is not = 0), this process will additionally need to generate an adjustment to the previously recorded RETAINED EARNINGS account for the closed year.
Note the adjustment will be generated regardless of the existence of the RETAINED EARNINGS account for the year being adjusted.
The adjusting transaction will have the following attributes:
- Feature - GL Closing
- Document Number - Document number of the document that caused the adjustment
- Post Date - The last day of the fiscal year being adjusted
- Fiscal Month - Fiscal month containing post date of the adjusting document
- Reference - Posting feature of the document that caused the adjustment
- Account - Derived based on the RETAINED EARNINGS category entry in the System Default Posting Group
- Organization - Derived based on the RETAINED EARNINGS account category entry in the System Default Posting Group
- Description - Fiscal Year {adjusted fiscal year value} Closing Entry
- Transaction Date - The last day of the fiscal year being adjusted
- Credit & Debit - As calculated based on the delta between the revenues and expenses included in the document that caused the adjustment. Positive delta should be recorded as a credit, and negative amount as a debit.