Output – Pardaan.com

A forgotten corner of AL, saving Query Output

In this video, I travel down a rabbit hole while exporting BC data as JSON. Some operations in AL have not been modernized, so in order to accomplish my goal, I need to add a bit of creativity. Check out the video: Source : Hougaard.com Read…

12 June 2024

Data & Analysis

Adding More Aggregate Columns To The Output Of Table.Profile

A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data: https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/ Since that post was written a new, optional second parameter has been added to the function called additionalAggregates…

8 August 2019

Dynamics NAV & BC Tips & tricks

Reversing Production Output and Consumption

Production orders in Dynamics NAV allows you to consume both less and more than what’s defined on the components and to output both less and more than what’s defined on the operations in the routing. There is no check when you post, which is nice (sometime…

3 November 2016

Dynamics NAV & BC Tips & tricks

NAV 2015 – Error While Consuming Query Output

In today article we will discuss how to resolve a issue that I faced during a development. The Error Occurs when i try to consume the output of a Query in Power BI. The Error can be faced by any application which is trying to Consume…

19 November 2015

Dynamics NAV & BC Tips & tricks

How to Revalue an Output Journal Entry in Microsoft Dynamics NAV

There are times that you need to revalue an Output Journal entry due to an error in processing. If the Output Journal entry is left with the incorrect cost, Inventory and COGS entries for future (or already processed) sales shipments will be stated incorrectly if the…

16 October 2015

Dynamics NAV & BC Tips & tricks

Dynamics NAV Posts Additional Output When the Production Order is Changed to Finished

We frequently get the question, “Why does Dynamics NAV post additional output when I change a Production Order status to Finished?" The scenario: You create a Released Production Order for Quantity = 10. During the course of production, you record the output of 5. When you…

5 September 2014

Dynamics NAV & BC Tips & tricks

Reversing the Output of a Dynamics NAV Released Production Order

I am asked from time to time how to reverse the output of a Dynamics NAV-released Production Order. The need to do this probably was caused by a mistake made when posting the original output. Bron : ArcherPoint Lees meer...

5 February 2014