Project Invoice

Summary

Amount billed to the customer including taxes and charges. Invoiced amounts are also included in actuals, but do not include Invoice currency and tax details.

Dynamics 365 Menu Item(s)

• Project management and accounting > Project invoices > Project invoices

Legacy data model’s data entities

• PMBI_deFACTProjectInvoice

     Entities per Transaction Type

     These entities are UNIONed in a SQL view.

• PMBI_FACTProjInvoiceCost
• PMBI_FACTProjInvoiceEmpl
• PMBI_FACTProjInvoiceItem
• PMBI_FACTProjInvoiceOnAcc
• PMBI_FACTProjInvoiceRevenue

New data model’s data entities

• PMBI_ProjInvoiceCostEntity
• PMBI_ProjTableEntity
• PMBI_ProjInvoiceJourEntity
• PMBI_ProjInvoiceTableEntity
• PMBI_ProjProposalJourEntity
• PMBI_ProjInvoiceEmplEntity
• PMBI_ProjInvoiceItemEntity
• PMBI_ProjInvoiceOnAccEntity
• PMBI_ProjInvoiceRevenueEntity
• PMBI_PMIPProjInvoiceGroupEntity

Synapse link approach tables

• ProjInvoiceCost
• ProjTable
• ProjInvoiceJour
• ProjInvoiceTable
• ProjProposalJour
• ProjInvoiceEmpl
• ProjInvoiceItem
• ProjInvoiceOnAcc
• ProjInvoiceRevenue
• PMIPProjInvoicingGroup
  

Field level functional description

• CurrencyId: The currency code in which the project invoice transaction is recorded.
• INVOICEDATE: The date when the invoice was issued to the customer.
• LineAmount_: The monetary amount for a specific line item on the invoice.
• OnAccAmount_: The on-account amount, representing prepayments or advances applied to the invoice.
• OnAccAmountMST_: The on-account amount expressed in the company’s accounting currency.
• PROJINVOICEID: The unique identifier for the project invoice.
• ProjectInvoice_CostValue_: The total cost value associated with the project invoice.
• ProjectInvoice_InvoiceAmount_: The total amount invoiced for the project.
• ProjectInvoice_InvoiceSubTotal_: The subtotal amount for the invoice before taxes and other adjustments.
• ProjectInvoice_OnAccountAmount_: The total on-account amount applied to the invoice.
• ProjectInvoice_SalesOrderBalance_: The remaining balance on the sales order after invoicing.
• ProjectInvoice_SumTaxAmount_: The total tax amount applied to the invoice.
• Qty_: The quantity of goods or services billed on the invoice.
• TaxAmount_: The tax amount for a specific line item on the invoice.
• TransId: The unique identifier for the transaction related to the invoice.
• Txt: A text field for additional notes or descriptions related to the invoice.
• TRANSDATE: The date the transaction was recorded in the system.