Microsoft Dynamics 365
It's a struggle to get data from Business central to Power BI.
I can't help but feel that there are a lot of people "reinventing the wheel" to get this working.
Using the API's is terribly slow and, I imagine, a big consumer of resources in the cloud.
This suggestions is great, but should be part of a larger project to have a high performance data store available to PowerBI. Just put it in a data lake or something like that.
Or if there a method for change the guid of a user then I can change the different guid by myself. It will be OK.
This is simply awesome and it will help the developer to speed up the report development.
Thanks, Tomáš Žabčík.
Any progress on this? This is must have feature.
Azure AD Conditional Access helps to secure data and resources behind authentication.
Business Central is not listed as Application service there (like Exchange, Teams, Dynamics CRM and others) so it can not be protected directly, and no exceptions and specific targeting can be done or user.
Please implement this ASAP, it should not be hard to follow internal Microsoft best practices for doing this, please advise Azure AD and security teams.
users like the , separation of currency as well, as it helps us compare 1,000,000 to 10,000,000. I assume excel would localize this correctly for users that use a different currency separator.
REMARK: Including option to update vendor accrual dividend balances after each soft year end closing.
The waring and error messages are poor in D365F. They are not designed for business users and very often very generic.
If the system makes validation, why not to display what was validated and what was the reason of the failure?
And the message should be in the readable form, which can be understandable by the accountant, not by IT or developer.
Yes.. We are agreed with you. We are also facing same issue.
There are different inventory status like ordered, registered and received. Registered inventory becomes the part of physical inventory even process of posting product receipt not fulfill. For posting of product receipt user first need to registered item with specific Serial because we have serialized inventory. After posting of product receipt then inventory status will changed to Received. But we are facing trouble in registered inventory because system becomes registered quantity to the part of inventory and available for sale. System not calculates COGS when sale post of any registered inventory as you better known COGS always calculates after sale posting. COGS calculates on zero amount when sale post of any item which status is registered and also its showing negative inventory impact. when COGS booked on zero amount then its increase the costing amount of item and decreases GP.
Cancelling prod.orders is REALLY challenge. Not to mention if subcontracting is involved :)
Suggestion: on Prod.order journal (Consumption, Output journal) do two or according actions for page:
1- "Undo Consumption"
2- "Undo Output"
In case 1: take minus Quantity (example -10), for key prod.order+prod.order line+prod.ord.comp.line to find posted Item ledg. entries, Entry type=Consumption, according Posting date and AUTOMATICALLY update or insert new consumption lines in item journal lines.
Field "Applies-from Entry" in Item journal line is populated automatically.
This way inventory valuation and WIP issue is solved.
In case 2: take minus Quantity (example -5), for key prod.order+prod.order line to find posted Item ledg. entries , Entry type=Output, according Posting date and AUTOMATICALLY update or insert new Output lines in item journal lines.
Field "Applies-to Entry" in Item journal line is populated automatically. You DO NOT look just for Open entries!!!
Standard Reapply function will do the magic :)
Only control is Inventory for this Item on Posting Date.
This is REALLY a booster for many issues regarding managing corrections. WIP in manufacturing posting.
had to write JS just for the sake of multiselect not being available, this is basics. If field type is introduced it should be available across for configuration.