Microsoft Dynamics GP (Archived)

Report Writer help with SOP Sales History Register

(0) Share

Report

Posted on by Mayra Humprey

3,125

Good day,

License = GP 10 BE SP4

I have been requested to add a column adding all the subtotals, trade discount, tax amount.

Originally the report only contains the column of total document amount, but i had to include the other ones, now is the problem that i don't know how to do the formula on the report writer.

Like excel just =sum(f2: f38)

Thanks in advance for your suggestions.

*This post is locked for comments

All responses (2)

Answers (0)

Mayra Humprey 3,125 on at

Like (0)

Report

Re: Re: Report Writer help with SOP Sales History Register

Good day Mariano,

Thank you very much but Could you please widen up my limited knowledge on report writer.

I did the following I open up Sop sales history register report on report writer.Then went to calculated "campos" and then created a new one. Wrote a name example = C Subtotals Docs, Results: Money in resourcers picked historical sales transaction and looked up for subtotal. so in the calculated expression do i have to add all the subtotals. The problem is that what if i miss a subtotal cell.

Thank you very much in advance for your advice :) Have a nice day
Mariano Gomez 26,225 on at

Like (0)

Report

Re: Report Writer help with SOP Sales History Register

You will also need to include the field in the total band, then double-click to change the field property to Sum.