Client applies freight to invoices as a miscellaneous charge. So, for example, in one case freight totaled $12.11. Gridview picks this up as $1211.00. Anyone know what's going on?

It's been like that forever.

Create a formula - if the category is blank (ie a misc charge) then divide the amount by 100, otherwise report just the amount.

Steve

Thanks Steve, I'll give that a try.

Use the field {Ext Price}. {Qty Shipped} is always 1.00 for a Misc Charge.

Out of curiosity, is there any reason for not changing what is stored in the unit price for any misc line? I mean the unit price for regular line are stored correctly.


Marlon Asuncion

We would break all of Steve's Views.