Hi,
I am creating a custom Budget vs. Actuals (BvA) report and I would like to ask about a curious NetSuite result I am getting. The custom report is mapped on Account Number (instead of Account Type from the standard report); hence the need to customise. The question I often get is if NetSuite can tell the user if there are some GL accounts that are not mapped in the custom report (for example, a new GL account section was created after report customisation). I seem to have found a native way to do this, but I am not able to replicate it.
When you keep the original sections from the standard BvA report and add your custom sections above, NetSuite appears to show you a list of any missing accounts from that section based on Account Number in the original section based on Account Type. For example, in the image below, the box in red is the new section where I mapped accounts based on Account Number. The box in blue is the original Purchases section from the standard report that was using Account Type = Cost of Goods Sold.
You can see that in the blue section, one account remains and this happens to be the one missing account that I had not yet mapped in the red section. Thus, this appears to show me that I still have one account left to map in the CMS section.
When I try to replicate this by creating a new section for Account Type = Income, for example, I am not able to get the same result. Instead, all the Income accounts are showing up in the new section based on Account Type instead of in the Sales section, which is mapped by Account Number. This seems to only work if I use the original Financial Section from the standard report and doesn't work when I create my own.
Does anyone know how I can replicate this behaviour so that I can show all unmapped GL accounts at the bottom of the report? Thanks in advance!