To really help me with this I need to give you background on how this works.....
We invoice a customer for a 7 day period of "usage" - that invoice is called an S7 ; they then receive a new S7 , 7 days later, but there may be adjustments to the prior period S7, which now shows up on current invoice under category : S14.
For example:
S7 - Invoiced on 1/21/2014
activity of 1/4 - 1/10/2014
on that same invoice is prior period S7 - now referred to as S14.
S14 activity period : 12/28 - 1/3/2014
SEE ATTACHED EXAMPLE to explain the above -
The only way I can identify the charges for the "S14 Prior Period" is via the Category / SubCategory Fields (see attached pic)
I am up for any suggestions on how to do this!
Thanks so much!!