Does anyone know if there's a way to NOT include J...
# suitescript
j
Does anyone know if there's a way to NOT include Journal Entries on a scripted Customer Statement using N/render?
Copy code
var pdfStatement = render.statement({
    entityId: parseInt(row.id),
    printMode: render.PrintMode.PDF,
    statementDate: stDate,
    inCustLocale: true,
    openTransactionsOnly: true
});
var strPdfContents = pdfStatement.getContents();
var objFile = file.create({
    name: row.entityid + '_custStatement' + '.pdf',
    fileType: file.Type.PDF,
    contents: strPdfContents,
    folder: 48572,
    encoding: 'ISO-8859-1',
    online: true
});
My client is using Rev Rec and so they don't want the gross-down JEs showing on the statement.
m
You can edit the actual statement template (freemarker) to exclude journals, but you would then need to calculate the running and aged totals yourself
j
That’s 10x better than what I was thinking. Ur solution would allow me to use throughput native. Brilliant.