You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

NetSuite Planning & Budget Data Integration help

Accepted answer
17
Views
3
Comments
in Planning 3 comments

Summary:

NetSuite Planning & Budget (NSPB) uses saved searches to import data and metadata from NetSuite into Planning. Saved Searches are part of a bundle. I have used the Income statement saved search, had to only update the currency and tried to use this to import 12 months of data. Between NetSuite and Data management the sum of all 12 months is loaded into every month. One would like only the applicable month's data to be uploaded into a month

Content (required):

Checking data management workbench- it is obvious that the same 2309 records for the total year is loaded into every month. Data Management then adds this together and loads it into each of the applicable months selected when triggering a data load rule. There seems to be a disconnect between NetSuite Periods and Planning & Budget Periods. The data load rule uses Explicit period mapping. I have tried several changes in the saved search but nothing helps.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!