We would like to be able to do reporting in PowerBi on Dimensions. Currently, the dimension set ID field from table 20 is not published on page 20 that we can publish to PowerBi.
This would make reporting much easier with Excel and PowerBi.
We often run the same financial report in slightly different versions, such as an detailed income statement and a summary income statement. It would save a lot of time if we could simply copy an Account Schedule and edit it, rather than building an account schedule from scratch.
In a multi-company scenario, it would also help to be able to export account schedules from one company and import them into another company.
Ability to schedule a report to :
- Send it by email
- Send it to single, multiple or all users
When running a report, a user can choose a filter for the pre-defined fields or replace an existing filter field with a new one, but a user can't add additional filter fields.
For example, the Inventory Valuation report offers three field to filter on. Let's say the user makes use of these three fields but requires now a fourth field to filter on. This is currently not possible.
Since the only development and deployment method currently supports is Extension Development via a Sandbox using VS Code (AL Lang), isn't it great to have Report Extension Development capability too? There's always possible to dev Extensions for Standard Tables, Pages, CUs but why not Reports? Every End-Client requires their very own methods to represent data comes into an ERP. But as ISVs, we are getting answerless when they just simply ask, "can I add our company logo to this standard report?" I mean, it's obvious, practically. Eagerly waiting for this since there's no other way rather than Re-design the entire report just to map Client's small requirements, which is limited in Word/RDLC Custom Layout designer in base Business Central.
(Simple suggestion, isn't it great to have the Core/Base Development ability like in good old days with NAV?)
You are unable to print multiple records for 1 report for different customers.
Go to the Sales Orders.
Find orders that have the same value in a/multiple field(s) from different customers and Filter on it/them.
“Salesperson Code” = ‘KS’ and “Document Date” = '01/05/18..'
Now we want to print the order confirmation for these orders.
Observe the reports
Only the first selected order is printed.
It seems like the report doesn't take the filters on the requestpage in account.
However it does, but before that all the orders are already filtered on the selected record to apply the custom report layouts for that customer.
Make it possible to print multiple reports from different customers.
(perhaps an extra loop around the customer report layout functionality to apply for multiple different customers?)
MS Call 118101819242689
Discovered on NAV2018CU8-BE = 11.0.23572.0
But also fails on BC BE Dynamics NAV 13.0 (25789)
Allow to assign any transaction (order, invoice, picklist, po) to a user, add it to his task with create automatic follow up, and alerts the user to perform before due date and when its do.
allow to create 3 alerts per transaction.
Currently, Account Schedules are limited to static captions such as "Current Period" or "Prior Period"
The reports would be more readable if the Column Captions could be "smart" and display either the Date Filter being applied to the column or resolve to the Month / Period caption via Accounting Periods.
When running the Post Inventory Cost to G/L report and sending the result to PDF the report displays the General Posting Setup and the Entry type but it does not display the G/L Code for the accounts which were posted to.
This would be a useful amendment to the report.
Looking at various Check Reports, adding the field Our Account No from the Vendor Card is not available. Can we please get this field available to be added to Checks.