What steps should be taken when an attempt to upload a zip file was failed?
1. Try to validate the file to check if the data matches the format requirements https://yaypay.helpjuice.com/88169-csv-ftp/csv-integration#assemble-validate-and-test-the-import-of-the-csv-files
2. Go to Settings > Integrations > CSV and click SHOW LOGS: if there are any errors indicated, they might be caused by incorrect data content
https://yaypay.helpjuice.com/88169-csv-ftp/csv-zip-file-requirements can help to indicate the problem for each CSV file (for example check if all required fields are populated)
3. Wait for 4 hours and check logs in Settings > Integrations > CSV (SHOW LOGS)
4. Contact support@yaypay.com if you still have problems with the file upload
What should I do if there is a balance mismatch?
1. Investigate which data is missing or extra:
- download a detailed Aging report from YayPay app in excel
- download report from your ERP in Excel
- compare two files to find mismatches
2. When you find out what is the difference, the CSV Requirements article might be useful to find out the problem.
How is a partial/full payment created in YayPay when sending data via CSV?
Case 1: FULL payment (highlighted green)
The sum in columnJ paid(invoice.csv) = amount applied(transaction.csv) = amount(transactionAllocation)
For invoice #123 the column paid(invoice.csv) is equal to or bigger than the amount(invoice.csv), which means that the invoice is fully paid.
Case 2: PARTIAL payment (highlighted yellow)
The sum in columnJ paid(invoice.csv) = amount applied(transaction.csv) = amount(transactionAllocation)
For invoice #456 the column paid(invoice.csv) is less than the amount(invoice.csv), which means that the invoice is partially paid.
Case 3: UNPAID(highlighted orange)
there are no transaction or transactionAllocation records for this case, as there is no payment. The column paid(invoice.csv) must be 0.
invoice.csv
transaction.csv
transactionAllocation.csv
