Open groups

Epicor ERP 9
1

epicor version 9.05.701

I want to build a report that shows ALL open groups for ALL companies.
So, all invoice entry groups, all cash receipt groups etc etc etc…is there 1 table that will provide this info? OR do i have to use APINVHED, INVHEAD etc etc…

Thank you.

2

im sure there will be some i’ve missed but the ones i can think of are:

AP invoice entry
AP payment entry
AR invoice entry
AR receipt
GL journal entry
unposted review journals

3

Hi Mark (or anyone else that can help here)

I know that this is a really old post but I cannot find anything newer and don’t want to created a duplicate.

Were you able to find an elegant solution to this without having to query all the tables you listed?

This is the request that I have from the Finance department: Is there a group tracker already in the system that we can use to see what groups are open in each module, who they belong to and the posted items in closed groups?

Thank you
Brian

4

If you create a new BAQ, in the table list type “grp” and click contains. This will show you all the group tables. Some are relevant and some not. Choose the tables you need to learn about, and add the fields you need. This will not help you find posted items in closed groups. I am not sure where those end up.

1 Like
5

Yeah, I went down the same exploratory path and also used “grp” and “contains”.

I guess you could make one BAQ with multiple queries (one for each group type) and then union them all together? A calculated field in each one with a static value to tell you the “group type” it is associated with. “AP Invoice Group”, “Check Group”, etc.

1 Like
6

Thanks Nate and David. Was hoping I didn’t have to go down that route…

The finance consultant that helped us with the implementation said we could possibly create a BAQ that looks at unposted transactions. What table are those stored in?

Cheers

7

I believe unposted transactions are the ones you will find in those group tables. Once they are posted, they are usually removed from the group tables.

8

I see. Thanks Nate!

9

Technically speaking, the transactions themselves don’t get removed, they just have the “posted” flag change from FALSE to TRUE. This can cause issues over long period of time. If you have someone create groups with initials + MMDD (such as KS0729), it’s possible that last year they also had a KS0729 group. Using APInvGrp and APInvHed as an example:

  • Last year, I created KS0729 with 20 invoices. So, I’ve got an APInvGrp record for KS0729, and there are 20 invoices on APInvGrp that have Posted = False.
  • When I post the group LAST year, the group on APInvGrp gets deleted, the 20 transactions with KS0729 as the group have Posted = True.
  • This year, I create another KS0729 group and put 15 invoices in the group.
  • Now, if I look at APInvHed, it has 20 records for KS0729 with posted = true (last year’s invoices), plus 15 invoices for KS0729 with posted = false (the one’s I’m working on).
  • Once you post this years invoices, again the KS0729 group on APInvGrp will be gone, and I’ll have 35 invoices on APInvHed with group=KS0729.

Moral of the story: If you’re doing any reporting on invoices, you should typically have Posted=True in your criteria. Unless you’re specifically wanting to see unposted - this is what it sounds like you’re doing.

1 Like