The batch will need to be deleted and remove Orphan Records, once removed the batch can be re-imported.
Orphan Records arise when something has not fully imported and has not populated both of the necessary tables.
To remove Orphan Records follow the steps below.
Open Financials to the Toolbar.
Click System Admin, External Interfaces.
Click Interface Controls.
Select the required Company.
On the Properties tab, on the bottom half of the screen, right-click and select Remove Orphan Records. |A dialog appears.
Click Confirm.
Let the process run. Once it finishes, click Apply. This will remove all the Orphan Records for the Company you ran it in.
If required, repeat steps 4 to 7 for other companies.