vendor payment csv import fails on "Unable to find a matching line for sublist apply with key: [doc,line]." I have verified the bills exist and are not paid. What would be the next steps to check

AI generated answer (using internal Slack threads):

Based on the conversations, the error "Unable to find a matching line for sublist apply with key: [doc,line]" typically occurs when NetSuite is unable to find a bill to pay in the exact amount of the payment you are uploading. If there is even one incorrect line in your CSV file, the entire file will fail to upload. Here are the steps you can take to troubleshoot this issue: 1. Verify the Amounts: Ensure that the payment amounts in your CSV file match exactly with the unpaid bills in NetSuite. 2. Check the External IDs: If you are matching by external ID, run a saved search against the bills you are trying to import against, and expose the External ID for the lines. Ensure that these match with your upload file of Bill Payments. 3. Check the Line IDs: If you are using line IDs in your CSV file, ensure that these are correct. If you have never done this process on lines before, it’s possible they don’t have line IDs. 4. Try a Smaller Batch: If you are trying to upload a large batch of payments, try uploading a smaller batch or a single payment to see if the issue persists. This can help you narrow down if the issue is with a specific payment or with the entire batch. Remember, the key is to ensure that the data in your CSV file matches exactly with the data in NetSuite. Any discrepancies can cause the upload to fail. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

Hi @Frank Coniglio did you try to mimic the intended behavior in the UI and make sure if the bill is available on the list?