Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to correct Date (Week number) data of the Schedule Report?
Per the client. I have customized and scheduled a report of Weekly Sales in NetSuite to generate in the 2 columns Current Year Last Week (column K) and Last Year Last Week (column L) in excel. The issue - when report is schedule, the report is not automatically generating the last week. Under the Customization - Filters - Dates, NetSuite does not give the parameters to select such date time frame for Week numbers (52 weeks in a year).
Therefore, the schedule report generated is pulling and generating in Column K - Last Week CY (12/12/2022 - 12/12/2022) and Column L is pulling in the correct dates Last Week (Last Year) (12/13/2021 - 12/19/2021). Column K should reflect 12/12/2022 to 12/18/2022.