...
| Placeholder name | Description |
|---|---|
| Project fields | The project to which an invoice refers to. |
| <#Lines.ProjectFirst> | Prints a * (star) if this is the first line for the project. The report contains as many lines per project as there are client or supplier invoices. |
| <#Lines.ProjectReference> | The project reference. |
| <#Lines.ProjectClient> | The client company name. |
| <#Lines.ProjectStatus> | The project status title. |
| <#Lines.ProjectManager> | First and last name of the project manager (if any). |
| <#Lines.ProjectInProgressDate> | The date when the project status was last changed to In Progress. This is a native Excel date. |
| <#Lines.ProjectCompletionDate> | The date when the project status was last changed to Completed. This is a native Excel date. |
| <#Lines.ProjectComments> | The internal comments saved with the project. |
| <#Lines.ProjectType> | The type of project. Prints either "Standard" or "Codyt". The former is for standard projects and the latter for Codyt projects. This title is not localized. |
| <#Lines.ProjectCreationDate> | The date when the project was created. This is a native Excel date. |
| Client details | Additional client fields. |
| <#Lines.ClientCode> | The optional "Code" field that can be supplied in the client details page. |
| <#Lines.ClientAccCode> | The optional "Accounting code" field that can be supplied in the client details page. |
| <#Lines.ClientDebtorNo> | The optional "Debtor no" field that can be supplied in the client details page. |
| <#Lines.ClientCountry> | The country code of the client. |
| Client Invoices | Contains details of all client invoices in the project. |
| <#Lines.ClientCount> | Total number of client invoices and client quotes in this project. |
| <#Lines.ClientInvoiceCount> | Total number of client invoices. Quotes are not counted. |
| <#Lines.ClientAmountExVAT> | The total invoice amount excluding VAT. The amount is converted to <#MasterCurrency> (or the equivalent <#Line.ConvertToCurrency>) |
| <#Lines.ClientAmountVAT> | The amount of VAT converted to <#MasterCurrency> |
| <#Lines.ClientAmountExVATBase> | The total invoice amount excluding VAT and before applicable client discounts. The amount is converted to <#MasterCurrency> (or the equivalent <#Line.ConvertToCurrency>) |
| <#Lines.ConvertToCurrency> | The currency to which the above amount is converted. Same as <#MasterCurrency>. Formatted as 3 letter ISO code. |
| <#Lines.ClientAmountIncVAT> | The total invoice amount including VAT. The sum of ClientAmountExVAT and ClientAmountVAT. |
| <#Lines.ClientInvoicesNoAmount> | Total number of invoices or quotes that have no amount set or a zero amount. |
| Supplier Invoices | Contains details of all supplier invoices in the project. |
| <#Lines.SupplierCount> | Total number of supplier invoices and client or quotes in this project. |
| <#Lines.SupplierInvoiceCount> | Total number of supplier invoices. Quotes are not counted. |
| <#Lines.SupplierAmountExVAT> | The total invoice amount excluding VAT. The amount is converted to <#MasterCurrency> (or the equivalent <#Line.ConvertToCurrency>) |
| <#Lines.SupplierAmountVAT> | The amount of VAT converted to <#MasterCurrency> |
| <#Lines.SupplierAmountExVATBase> | The total invoice amount excluding VAT and before applicable supplier discounts. The amount is converted to <#MasterCurrency> (or the equivalent <#Line.ConvertToCurrency>) |
| <#Lines.ConvertToCurrency> | The currency to which the above amount is converted. Same as <#MasterCurrency>. Formatted as 3 letter ISO code. |
| <#Lines.SupplierAmountIncVAT> | The total invoice amount including VAT. The sum of ClientAmountExVAT and ClientAmountVAT. |
| <#Lines.SupplierInvoicesNoAmount> | Total number of invoices or quotes that have no amount set or a zero amount. |
...