I have a client that is requesting weekly column layouts to be built in BC. I have researched this and haven't been able to find how to do this. Is it possible to create a weekly column layout, if so, what formulas do I need to use in the column layout screen to get this to work?
I hope the below layout work for you.
Navigate to Departments/Financial Management/General Ledger/Analysis & Reporting/Accounts Schedule.
Click "Edit Column layout Setup" in the ribbon. Configure as below, You will get the weekly report based on Week.