Uploading Tax Lines
Currently, we are unable to upload Tax lines due to an Oracle limitation.
Create Existing Invoices
If you are adding lines or distributions to existing invoices, you must remove ‘Create’ from the Header Upload Action field. If you do not, when you create the lines or distributions, they will validate but will not upload.
Supplier Number column behaviour
When a Supplier Name is entered, the Supplier Number column will automatically default as the Name column is still the "driving" column. If a user instead enters a value in the Supplier Number column the Supplier Name column will not default and will remain blank.
This is the Add-In architecture, and not a developer preference, where defaulting works across the sheet from left to right and not backwards from right to left.
Duplicate Line Numbers
Line Numbers must be unique. Unfortunately, the message returned from the web service regarding duplicate line numbers is not very clear.
If you receive this message in this area, please know it is referring to a duplicate line number being used.
Document Sequencing
Document Sequencing is rejected by the web service. An Oracle SR has been created and is currently pending update.
Purchase Order information at Distribution level
Currently, we are unable to support Purchase Order information in the Distributions section due to a web service limitation.
Fixed Price Purchase Order Line Types
Currently we are unable to match invoices to purchase order lines that are Amount based (Fixed Price). We are working to resolve this in a later version.
Overlay Account Entry
Currently, Overlay Account entry is not available in the Lines section of the Integrator, we are unable to provide this functionality at this time.
Holds download in the Payables Invoices Integrator
Currently, we are unable to download Holds information in the Payables Invoices Integrator however you are able to download Holds information using the Holds and Releases Integrator.
DFFs - Searchable LOVs
We are not able to provide searchable LOVs. This is due to the inability to run SQL dynamically in the Integrator.
The form supports both dependent and independent lists of values. However, table-based lists of values are currently not supported.
Some LOV values are duplicated in the Forms
When a column i.e. Terms, is secured by SetId and is assigned to the common set AND a specific Business Unit set id, the web service displays this value twice in the response. This results in duplicates in the LOV. If there is only one assignment it does not duplicate.
Note - It makes no difference to the behavior of the Integrator in relation to which of the duplicates you choose, as they are effectively the same.
