Hi, is it possible to change the Tax Reports (inte...
# accounting
a
Hi, is it possible to change the Tax Reports (international) report settings so that the amounts would be by posting period instead of transaction date? We have cases when the trandate and posting period is different and we want the amounts based on posting periods if this is possible. I have already set 'report by period' to 'all reports' from set preferences but this has no affect to that tax report.
n
@Aaron have you also considered the Tax Period on UK transactions. I think it’s tax period that impacts tax reports.
b
as far as I know, this bundle is rigid in that all the report settings should be in the Tax Reports International page already. What about customizing the reports installed by the bundle under Reports>VAT/GST instead?
a
@Netsuite Tragic is this a field that should be found on transactions UI? We don't have it, so it is probably showing only for specific countries like UK as u mentioned? However we used the field explorer and there is a hidden taxperiod field in the invoice. Hopefully Netsuite allows changing that to different tax period than the trandate, we will try that next. Then if it is allowed, we could make a script that populates it automatically using the posting period as reference.
n
SuiteAnswers gives info on the Tax Period which is important (critical) to your UK tax reporting. You can change it via CSV and I would assume script.
a
@blue Yes it is really rigid, not much that can be done there. From the settings in that page there was nothing related to that, just some date formats etc. That page is otherwise good since it provides an official printout but if we cannot make it work, then I guess we need to customize some other report.
@Netsuite Tragic I'll check the SA, if it is possible via csv I guess it's also with script. That would be perferct.
n
The Tax Period is available via Saved Search.