Jet Reports for Dynamics 365 Business Central Part II - Customizing Reports

[@kemimichael]

Super helpful video!

[@citonelson]

I lost you at 8:00. The cursor was over what command you typed for looping four lines of data?

[@citonelson]

should add, it is not looping. It only gives the detail on the top customer at the bottom of the summary of customers and balance.

[@citonelson]

Trial and error it worked- highlighted both cells/made sure the @ sign was at the beginning/typed in =4 which applied to the top row and now it works.

[@WebSanSolutionsInc]

Happy to hear it worked out for you!

[@aedanrobinson6447]

How would you total the whole list?

[@WebSanSolutionsInc]

Can you provide more detail about what list you are referring to in the video?

[@aedanrobinson6447]

@@WebSanSolutionsInc Is there a way to total the "blue" balance line that comes from the customer table? + Subtotal the "orange" lines from the ledger entry table? - Thanks

[@WebSanSolutionsInc]

@@aedanrobinson6447 , To bring the price of the assembly into the Project/Job, you need to perform an item ledger entry to charge the assembly item inventory to the job/task/planning line. This will bring the full cost of the assembly into the job. Hope that helps!