Historical Invoice Upload for Mexico
All registered invoices which have not been fully paid need to be present in LSP prior to processing AR payment receipts.
This table lists the minimum required elements, which need data for this solution:
| Element | Length | Attribute | Mandatory | Usage |
|---|---|---|---|---|
| "*RowPointer" | Yes |
Set to "". This is an upload function only, so only invoices not yet in LSP should be added. |
||
| *TenantID | 100 | nvarchar | Yes | Specify a valid value or leave as “” to let it be automatically populated. |
| "*AccountingEntity" | 22 | nvarchar | Yes | Accounting Entity Code |
| "*Location" | 22 | nvarchar | Yes | Specify a location or set “ “ (single space) if no location |
| "*DocumentID" | 100 | nvarchar | Yes | Refer to your ERP’s integration guide to ensure the correct format. |
| "InvoiceID" | 100 | nvarchar | Yes | This is the registered Invoice Number. |
| "InvoiceDate" | Yes | This is the date the invoice was created. It must be in one of the formats described on the Read Me. | ||
| "InvoiceType" | 100 | nvarchar | Yes | Set to “Invoice” for registered invoices. Other values are:
|
| "TotalBaseAmount" | 23, 8 | Yes | Set to the total invoice amount in the base currency of the company | |
| "TotalAmount" | 23, 8 | Yes | Set to the total invoice amount in the currency of the invoice | |
| "CurrencyCode" | 3 | Yes | Set to the ISO currency code (MXN, USD) used in the invoice transaction. | |
| "FileStatus" | 100 | nvarchar | Yes | Set to "Registered" |
| "BaseCurrencyCode" | 3 | Yes | Set to the ISO base currency code (MXN, USD) of the invoice. | |
| "InvoiceStatus" | 100 | nvarchar | Yes | Set to "Registered" |
| "FeedbackID" | 100 | nvarchar | Optional | Set to the UUID of the Invoice when it was originally registered. If you do not have this information, set to “” and upload the CFDI XML in the CFDI Upload function in SAT Reporting later. See the Infor Localizations Services Platform User Guide for more information. |