Dropped-Header

• Multiple documents in a single sheet by varying header fields which are "dropped" to the line items

Pre-Validations

• Validate and find errors BEFORE you post

GR-based Invoice Verification Support

• Post GR-based Invoices, pre-population of GR-based Invoice fields from the PO, and propose values for later posting.

Proposed values for 2-way matching

• LIVExpress will propose values for posting when no GR is present

Internal/External Unit of measure conversion

• LIVExpress now retrieves/posts data using the External Unit of measure nomenclature

FI Invoice Status                      

• LIVExpress will now report on the status of the FI Invoice after posting (i.e. if it is blocked and what blocking indicator was set)

Description display

• Description display for materials and vendors

Post Documents                                  

• Post invoices and credit memos

Park Documents

• Park invoices and credit memos

Reverse Documents

• Reverse invoices and credit memos

Subsequent Debits/Credits

• Set the "Sub. Deb./cred." Field to "yes" to post invoice line items as subsequent debits/credits

PO Tools: Load PO's from a List

• Search SAP for existing POs.
• Select entire POs or individual line items to be loaded into the invoice template.

PO Tools: Load PO's in Worksheet

• Import PO item information using values already contained in the spreadsheet.

PO Tools: Create Variance Report

• Quickly see variances between the invoice to be posted and existing Goods Reciepts and the original PO.
• Drill back to the invoice items

PO Tools: Show PO Detail

• Display additional purchase order detail for fields that are visible in the worksheet

PO Tools: Proposed Values

• LIVExpress proposes initial invoice and quantity values - similar to the functionality of SAP online transaction.
• If the value/quantity has been fully received, the proposed value/quantity will be "0"

Correcting Errors in the Spreadsheet

• SAP Errors are displayed in Excel

Multiple Worksheets

• LIVExpress workbooks may contain multiple worksheets (invoice and non-invoice).
• Choose to post one, all, or specific individual invoice worksheets

Insert Copy

• Any LIVExpress template may be copied and then edited in the normal way.
• Used to create a multi-invoice workbook quickly

Ignore / "Blank" Columns

• Columns which will be ignored at the time of posting. Use these columns for notes, descriptions, calculations and other values that should not be posted

Ignore / "Skip" Rows

• Columns which will be ignored at the time of posting.
• These rows could be sub-totals or singature lines, etc.

Template Outline Freatures

• Automatically outline major sections of the worksheet reducing the need to scroll through thousands of lines of data

Edit Options

• Text string search
• Expand/Collapse the tree structures
• Show/Hide SAP technical field names

Auto-Format Columns

• Re-sizes the spreadsheet column widths each time the spreadsheet is adjusted using the "Field Selection" picklist