Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Account schedules show...

Account schedules showing the discount invoice amount

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I have created an account schedule that basically shows in the first line our sales ( used sale posting account) and underneath the COGS for this sales ( I used DC accounts) , and then in the third line the profit using a formula. The columns I use them to divide the products we sell by lines of products, let#s say winter products, summer products etc.

The results that displays the overview is correct , nevertheless when I try to add thediscount amount as a line per each sale, all columns get populated with the same discount amount, and not only the column where the product sold corresponds to asIit wpuld be expected.

I have tried to use Totaling type with the Invoice account number, as well as cost type with that same account number, nveretheless it doesnt work, any ideas? Thanks

*This post is locked for comments