DataLink_support

A problem we have often heard is that the opening balance of a year cannot be drawn up if there are still a certain number of financial years in draft.

With DirectLink we offer a solution to this problem. One option is to export the closing balance of the previous year and import it back to Twinfield via DirectLink. For example, the closing balance of the specific year remains in draft, but an opening balance has also been created.

If formula
If the value is higher than 0 show debit else credit

return ([F12] > 0) ? “debit” : “credit”;

[F12] = a column in the importfile

JavaScript example

var xhr = new XMLHttpRequest();
xhr.open(“POST”, https://secure.directlink.nu/api/v1/dataimport/upload, true);
xhr.setRequestHeader(“Authorization”, “Bearer ” + “{***datalink_bearertoken***}”);
xhr.onload = function () {
if (this.status == 200) {
}
else {
}
};
xhr.send(data);

× Heb je een vraag?