Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Cannot get a journal to balance in a map reduce script
Hi There
I have a map reduce script which is continuously returning a 'journal not balanced' error. can you see where the error is in my code? The debug logs, in particular the 'totaldebits' and 'totalcredits' are returning the correct values
/** * @NApiVersion 2.x * @NScriptType MapReduceScript */
define(["N/search", "N/record", "N/runtime","N/format"], function ( search, record, runtime,format) { function getInputData() { var transactionSearchObj = search.create({ type: "transaction", settings: [{ name: "consolidationtype", value: "ACCTTYPE" }], filters: [ ["voided", "is", "F"], "AND", ["mainline", "is", "F"], "AND", [ ["projecttask", "noneof", "@NONE@"], "OR", ["custcol_project_task_je", "noneof", "@NONE@"], ], "AND", ["type", "anyof", "VendBill", "VendCred", "ExpRept"], "AND",
0