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
Netsuite Tragic
03/30/2021, 9:20 AM
@Aaron have you also considered the Tax Period on UK transactions. I think it’s tax period that impacts tax reports.
b
blue
03/30/2021, 9:44 AM
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
Aaron
03/30/2021, 10:37 AM
@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
Netsuite Tragic
03/30/2021, 11:04 AM
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
Aaron
03/30/2021, 11:04 AM
@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.
Aaron
03/30/2021, 11:05 AM
@Netsuite Tragic I'll check the SA, if it is possible via csv I guess it's also with script. That would be perferct.