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);