This export pulls receivable data based on the status of the invoice. It will pull invoices that are Ready and have not yet been Sent. It retains a history of the invoices that were on each export, but this data is not used by the export criteria.
​
When this export is ran under the company level it will return only the receivables within the company. For example, when the export is ran under company ABC it will only return receivables associated with assignments within company ABC.

1. Invoice Ready Date: The date specified is an up to and including date. The export will look into the export history to identify the “from” date. It does this by looking into the history for an invoice ready date that is less than the one specified on this import and then it will pull any invoices with a ready date that is greater than the one it found in history and less than or equal to the one specified on the current export. It excludes any invoices with a sent date.

2. Set Invoice Sent Date: If specified, the export will set the sent date on the exported invoices to this date.

[INVOICE].[ID] INVOICE_ID [INVOICE].[STATUS] [INVOICE].[CURRENCY] [INVOICE].[TRACK_ONLY] [INVOICE].[BILL_TO_TYPE]
​
If billed to company

[INVOICE].[BILL_TO_COMPANY_ID] as COMPANY_ID [COMPANY].[NUMBER]

If billed to vendor

[INVOICE].[BILL_TO_VENDOR_ID] as VENDOR_ID VENDOR.SYSTEM_NUMBER as VENDOR_SYSTEM_NUMBER

If billed to Billing Entity

[INVOICE].[BILL_TO_BILLING_ENTITY_ID] as BILLING_ENTITY_ID BILLING_ENTITY.NAME as BILLING_ENTITY_NAME

If billed to employee

[INVOICE].[BILL_TO_ASSIGNMENT_ID] as ASSIGNMENT_ID [ASSIGNMENT].[NUMBER] as ASSIGNMENT_NUMBER [ASSIGNMENT].[EMPLOYEE_ID] as EMPLOYEE_ID [EMPLOYEE].[SYSTEM_NUMBER] as EMPLOYEE_SYSTEM_NUMBER
​
[INVOICE].[INVOICE_DATE] [INVOICE].[READY_DATE] [INVOICE].[SENT_DATE]
[INVOICE].[PAYMENT_STATUS] [INVOICE].[CREATE_DATE] [INVOICE].[CREATE_BY] [INVOICE].[LAST_UPDATE_DATE] [INVOICE].[LAST_UPDATE_BY] [vwEQ_INVOICE_CALC].[RECEIVABLE_TOTAL_AMOUNT] [vwEQ_INVOICE_CALC].[RECEIVABLE_TOTAL_CURRENCY] [vwEQ_INVOICE_CALC].[PAYMENT_CREDIT_TOTAL_AMOUNT] [vwEQ_INVOICE_CALC].[PAYMENT_CREDIT_TOTAL_CURRENCY] [vwEQ_INVOICE_CALC].[BALANCE_CURRENCY] [vwEQ_INVOICE_CALC].[STATUS_DATE] [vwEQ_INVOICE_CALC].[BILL_TO] [vwEQ_INVOICE_CALC].[BALANCE_AMOUNT] [ENTRY_RECEIVABLE].INVOICE_ID [ENTRY].[ASSIGNMENT_ID] [ENTRY].[ID] ENTRY_ID [ACCOUNT].[ACCOUNT_NUMBER] [ACCOUNT].[SUB_ACCOUNT_NUMBER] [ENTRY_TYPE].[NAME] ENTRY_TYPE [ENTRY].[SOURCE] [ENTRY].[AMOUNT] [ENTRY].[CURRENCY] [ENTRY].[ENTRY_DATE] [ENTRY].[PAYOR] [ENTRY].[POLICY_STANDING] [ENTRY].[REFERENCE] [ENTRY].[CREATE_DATE] [ENTRY].[CREATE_BY] [ENTRY].[LAST_UPDATE_DATE] [ENTRY].[LAST_UPDATE_BY] [ENTRY].[SOURCE_ID] [ENTRY].[SOURCE_SYSTEM] [ENTRY].[SOURCE_SYSTEM_TEXT_KEY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[BASIS_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_EFFECTIVE_DATE] [ENTRY_CURRENCY_TRUE_UP].[FROM_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[FROM_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_FROM_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_FROM_EXCHANGE_RATE_DATE] [ENTRY_CURRENCY_TRUE_UP].[TO_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[TO_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_TO_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_TO_EXCHANGE_RATE_DATE] [ENTRY_CURRENCY_TRUE_UP].[COMPANY_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[COMPANY_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_COMPANY_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_COMPANY_EXCHANGE_RATE_DATE] [ENTRY_CURRENCY_TRUE_UP].[SYSTEM_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[SYSTEM_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_SYSTEM_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_SYSTEM_EXCHANGE_RATE_DATE] [vwEQ_ENTRY_RECEIVABLE_CALC].[RECEIVABLE_AMOUNT] [vwEQ_ENTRY_RECEIVABLE_CALC].[RECEIVABLE_CURRENCY]