Core Financial Modules

[SteveInKP]

We need a formatted report which lists, Invoice Number, Customer Number, Customer Name, Sales Person Code, Merchandise, Shipping, Other Charges and the Total Invoice Amount, this needs to fit on one line, using a point size to enable this, landscape orientation is ok. The other charges are indicated by and item number which is "OTHER",  each invoice can have several "OTHER" charges or just one, or none, we just need the total for the reports and we need totals at the end of the report. I would just create a simple report if it wasnt for the "Other" charge in the invoice detail, I am not sure how to do this. Any sugestions or recommendations on a developer would be appriciated.

Thanks

Steve

[givingtr]

Try creating a running total field for "other charges", such as "if itemcode="other" then ExtensionAmt else 0." Group on invoice #, make the "merchandise" field a sum of (taxable + non-taxable sales - "other charges") and place all the fields in the group footer. Create report totals for all your fields and place them in the report footer. You'll have a bit more work if Split Commissions are used. Otherwise, it's Miller time.