Skip to Content
0
Aug 29, 2012 at 09:02 AM

Count imported records from an InfoProvider

20 Views

Hi,

I am importing data from an InfoProvider using a data manager package. I would also like to count the records in the InfoProvider based on a certaing dimension and get the result for a certain account.

The exact example - I want to count how many Internal Orders I have per Internal Order Type in the data regardless of the amount of G/Ls that were posted to each order.

any idea how I can do this?

First thought I have - I have one GL that is posted to all Internal Orders so in the conversion I can mark all GLs with *SKIP and this way I will get one record per Internal Order. The question is how to count the records per record type.

Thanks,

Avihay