We are using two daily automated exports to take data from our Netsuite account into a private Onedrive, to update an excel spreadsheet report.
This report shows us debtors and invoice details. However, for some reason Skyvia wont pull over Amount Paid, or Amount Remaining. No other value fields apart from "Amount" work. Whilst this is ok, if a client partially pays a large invoice, the report will still show the full amount (example: 10k invoice, client pays 5k meaning 5k left, however Skyvia amount will still be 10k as AmountDue or AmountRemaining wont show).
Is this a bug or limitation of Skyvia?