Hi,
There is this recurring issue for which i am trying to find a solution for.
Currently we import actuals from NS and have an integration layered for that. But occasionally, the Actuals differ from NS due to some missing GL error or wrong historical data or something else. The thing i am looking forward is to get an error message or notification if any part of my p&l report is different from NS any day, since we have a daily refresh.
Is there a way using Pigment Ai i can automate this process instead of daily looking in Ns or waiting for someone to inform me.
Please let me know if anyone is working on this of issue or has a solution for.
Please let me know if any clarifications are needed.
Thanks Community
Question
Netsuite Daily Reconciliation Issue
+1- Author
+12- Employee
Hi Nancy,
In the transaction list where you load your data, you should have checks the verify that everything is mapped correctly and that the raw sum of the column is equal to the sum of the metric aggregating from it.
The Modeler Agent can help you build that, it knows
Then you can create a notification based on this check so you get a ping when there is a variation (MA can help too).
You could setup the Analyst agent to look at these checks daily but IMO the notification should do the job
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.