To have an overview of what Stellarise Connector for InforLN and Xero does, this is a list of the different use cases that may happen during the integration process and the description of the expected outcome.
Contacts
InforLN Contact does not exist in Xero - Xero Name does not exist, Xero Contact Number does not exist
In Infor LN there is "Foreign Customèr S.R.L" having Business Partner ID set to "30000010" but in Xero this does not exist.
After the connector has searched in Xero for the "Contact Number = 30000010" and the "(small case, numbers and letters only , ignoring accents)Name = foreigncustomersrl", the Connector then creates "Foreign Customèr S.R.L" in Xero, having Contact Number set to 30000010 and all the InforLN information described by Design.
InforLN Contact does partially exist in Xero - Xero Name does exist, Xero Contact Number does not exist
In InforLN there is "Foreign Customèr S.R.L" having Business Partner ID set to "30000010" and in Xero you have "foreign customer s.r.l" but without Contact Number.
After the connector has searched and found in Xero the "(small case, numbers and letters only , ignoring accents)Name = foreigncustomersrl", the Connector then updates the existing Xero Contact reporting all the InforLN information described by Design and assigning the Xero Contact Number to "30000010".
InforLN Contact does partially exist in Xero - Xero Name does exist, Xero Contact Number does not exist
In InforLN there is "Foreign Customèr S.R.L" having Business Partner ID set to "30000010" and in Xero you have "foreign customer Italia" having Contact Number set to "30000010".
The connector searches and finds "Contact Number = 30000010". Then updates the existing Xero Contact reporting all the InforLN information described by Design.
InforLN Contact already exists in Xero and they are both the same
In InforLN there is "Foreign Customèr S.R.L" having Business Partner ID set to "30000010" and in Xero you have the same.
The Connector realises the match by ContactNumber or Name and checks for differences (e.g. tax number, bank account, primary contact, address, etc.): both Infor and Xero give the same checksum, the Connector does nothing and moves on.
InforLN Contact already exists in Xero and they differ for one or more details
In InforLN there is "Foreign Customèr S.R.L" having Business Partner ID set to "30000010" and Tax Number "1234567890". In Xero you have the same but the Tax Number is "0987654321".
The Connector realises the match by ContactNumber or Name and checks for differences (e.g. tax number, bank account, primary contact, address, etc.): Infor and Xero differ. The Connector updates the Xero Contact updating its information with the details reported in Infor.
Sales Invoices
InforLN Sales invoice serie "2xxx" but does not exist in Xero.
In InforLN there is an invoice having Invoice Name "303-SI1-2000001" but in Xero there is not such invoice.
Stellarise Connector does not find the Xero invoice by "InvoiceNumber = 303-SI1-2000001" so it creates it with "InvoiceNumber = 303-SI1-2000001" and all the InforLN information defined by Design.
InforLN Sales invoice serie "2xxx" and it does exist in Xero.
In InforLN there is an invoice having Invoice Name "303-SI1-2000001" and in Xero it exists as well.
Stellarise Connector finds the Xero invoice by "InvoiceNumber = 303-SI1-2000001" so it goes into Xero and to update it with the InforLN information defined by Design.
InforLN Sales invoice serie "4xxx" (pro-forma orders)
In InforLN there is an invoice having Invoice Name "303-SI1-4000001" and in Xero it may exist or not.
In Xero there is not such distiction between a normal invoice or a LineaLight invoice from pro-forma order. The invoice will be created following the serie "2xxx" logic.
InforLN Sales invoice single line
In InforLN there is an invoice having Invoice Name "303-SI1-2000003" having one invoice line that has a ledger code and a tax rate correctly mapped in the Stellarise Connector settings.
Stellarise Connector creates or updates the Xero invoice by "InvoiceNumber = 303-SI1-2000003". It will only have one invoice line, having unit price, discount, tax amount and total amount matching with the InforLN invoice. Invoice Line Description just reports "RTF" if the InforLN Invoice "RelatedPurchaseInvoice" field is empty, the content of the InforLN Invoice "RelatedPurchaseInvoice" field if it is assigned.
InforLN Sales invoice multiple lines
In InforLN there is an invoice having Invoice Name "303-SI1-2000004" having multiple invoice lines that have a ledger code and a tax rate correctly mapped in the Stellarise Connector settings.
Stellarise Connector creates or updates the Xero invoice by "InvoiceNumber = 303-SI1-2000004". It will only have one invoice line, having unit price, discount, tax amount and total amount calculated as the sum of all the the InforLN invoice lines. Invoice Line Description just reports "RTF" if the InforLN Invoice "RelatedPurchaseInvoice" field is empty, the content of the InforLN Invoice "RelatedPurchaseInvoice" field if it is assigned.
InforLN Sales invoice Ledger Code / Tax rates not mapped in Stellarise Connector
In InforLN there is an invoice with Invoice Name "303-SI1-2000004" and having one invoice line that has a ledger code and a tax rate not correctly mapped in the Stellarise Connector settings. No defaults behavior is also set in the Stellarise Connector Ledger settings.
Stellarise Connector collects the InforLN Invoice "InvoiceName = 303-SI1-2000004" and realises that the Ledger code or the Tax Rate that should be present in the InforLN-Xero ledgercodes/taxrates map (Connector Settings) but it is not. In addition there is not any deafult specified. At this point, Stellarise Connector tries to transfer it anyway to Xero but since the invoice status is set by Design to "approved" and Xero does not allow approved invoices without explicitly specified ledger, Stellarise will record the exception in the audit table, reporting that the invoice cannot be created because there is no ledger code defined against it.
InforLN Sales invoice correct Ledger Code / Tax rates, not mapped but with default
In InforLN there is an invoice with Invoice Name "303-SI1-2000005" and having one invoice line that has a ledger code and a tax rate not correctly mapped in the Stellarise Connector settings. But a default is set for Ledger codes and tax rates.
Stellarise Connector collects the InforLN Invoice "InvoiceName = 303-SI1-2000005" and realises that the Ledger code or the Tax Rate that should be present in the InforLN-Xero ledgercodes/taxrates map (Connector Settings) but it is not. Anyway, there is a default Ledger Code / Tax rate defined against it: Stellarise Connector will then assign this default values to the Xero invoice, that will then be successfully created in Xero.
InforLN Sales invoice created now, but the "Process until" setting in Stellarise Connector is set to "Until yesterday"
In InforLN there is an invoice with Invoice Name "303-SI1-2000006" which has literally been created now, while you are reading this document. In the Connector settings, the property "Process Data Until:" is set to "yesterday".
Stellarise Connector exploits the capability of InforLN to retrieve entities between a certain period of time. Typically, the starting point of the considered time period is the last DateTime the Connector has run. the Upper limit of the time period is calculated instead using the formula "Now minus number of days specified in the 'Process Data Until' field": in the example, using "Yesterday" means that the upper limit of the timeframe is "Now - one day", resulting in a request to InforLN that literally is "give me all the Sales Invoices modified since the last time I have requested to you and Today minus the number of days specified in the 'Process Data Until' field"".
Stellarise Connector collects then all the timeframe matching InforLN Invoices, but "InvoiceName = 303-SI1-2000006" is one of them. and realises that the Ledger code or the Tax Rate that should be present in the InforLN-Xero ledgercodes/taxrates map (Connector Settings) but it is not. Anyway, there is a default Ledger Code / Tax rate defined against it: Stellarise Connector will then assign this default values to the Xero invoice, that will then be successfully created in Xero.
Xero Sales Invoice exists but not in InforLN
In Xero there is "InvoiceNumber = INV-00049" but in Infor this does not exist.
By Design, the Connector does not send back Sales Invoices to InforLN. InforLN is the source of truth of the Sales Invoices, all the Sales Invoices should be created in there. This does not give any problem in terms of Invoice synchronisation, but it will in terms of Payments: indeed the Connector is designed to collect all the recently-changed payments in Xero and trying to sync them back to InforLN. In this case InforLN will fail, raising an exception in the Stellarise Connector Audit Table.
Purchase Invoices (InforLN to Xero)
This can be pretty much covered by the test cases for the Sales Invoices. In addition
InforLN Purchase Invoice: "source" field different from Stellarise
In InforLN, there are some purchase invoices modified in a given period of time. Some of them are legitimate and some aren't because they were created by Stellarise Connector in the previous run.
When Stellarise Connector runs the next time, it must discard the ones that it has previously generated. To do this, the InforLN API provides an extra "Source" field, reporting the origin of the invoice. If it is empty, then it has been originated by InfoLN so it can be sent to Xero, otherwise the invoice is simply discarded.
InforLN Purchase invoice Ledger Code / Tax rates - No mapping
In InforLN, there is the invoice "303-PI1-2000001" having an invoice line with account code assigned of "4000"
InforLN Purchase invoice correct Ledger Code / Tax rates, not mapped but with default
"RTF" to "Sales Invoice:"
Goods Purchase Invoices (Xero to InforLN)
Xero Purchase Invoice Collection: InvoiceNumber format check
Xero Purchase Invoice with related Business Partner
Xero Purchase Invoice without related Business Partner
Service Purchase Invoices (Xero to InforLN)
Xero Purchase Invoice with related Business Partner
Xero Purchase Invoice without related Business Partner
Payments
Xero Payment received from Client
Xero Payment received from Client and related to Prepayment
Xero Payment sent to recurring Supplier
Xero Payment sent to non recurring Supplier
Prepayments
Xero Prepayment received from Client
Xero Prepayment made for recurring (Xero supplier does exist in Infor) and non recurring Supplier (Xero supplier does not exist in Infor)