I don't know the XFBR Koemets mentioned, but I was thinking as an
alternate route, maybe a UD8 (reporting) or Account with a DynamicCalc
formula could meet your needs. Writing it so it calculates based on the
Entity's currency or a text field.
Has anyone utilized Parcel Service to run a book and place the report on
a network drive or something similar? Doesn't seem like something that
can be done out of the box and would require additional business rules
development.
A drill down and maybe a "Show all aggregated data" for that value would
be helpful. As others are alluding to, it can be an automatically
calculated value that's causing an issue. If it's negative in your
staging table and not your flat file there c...
