ANS-1646 · ACCOUNTING & FINANCIAL CONFIGURATION
How to Resolve NetSuite Allocation Schedule Not Finding Current Period Expenses
When a NetSuite account uses a fiscal calendar not starting in January, allocation schedules may fail to identify current period expenses, requiring a user preference adjustment.
Short answer
If NetSuite allocation schedules fail to identify current period expenses, especially with a non-January fiscal calendar, set the user preference 'Report by Period' to 'Never' (Home > Set Preferences > Analytics subtab). This ensures expenses are recognized. Alternatively, perform expense allocations for past periods.
Scenario
When running an allocation schedule for the current period, NetSuite may display the message 'The Allocation Sources or Destinations did not have any Expenses Associated with them for the Selected Period'. This occurs even when an approved vendor bill, with appropriate segmentation, has hit the source account during the selected period. Further investigation reveals that the allocation schedule successfully identifies bills and creates journal entries when run for a prior period.
Solution
When a NetSuite account utilizes a fiscal calendar that does not commence in January, it is necessary to address how expense allocations are performed. The system's behavior indicates a conflict with current period allocations under this specific calendar configuration.To successfully allocate expenses in the current period, users should adjust a specific preference:
Navigate to Home > Set Preferences.
Select the Analytics subtab.
Locate the 'Report by Period' preference and set it to 'Never'.
This adjustment, as recommended in SuiteAnswers 75542, enables the allocation schedule to identify and process expenses for the current period.Alternatively, if adjusting the preference is not feasible or desired, expense allocations can consistently be performed for past periods to ensure all relevant expenses are identified and allocated.
Expert NetSuite Support
Need help with this NetSuite issue?
Accounting & Financial Configuration consulting and configuration support