2014 Feb 05 9:40 PM
Hi all,
When I have an invoice that contains all "Final" or all "Periodic" bills, the billing transaction gets set accordingly. BUT, when I have a single invoice document that contains one or more bills from EACH category, the billing transaction (ERDK-ABRVORG) does not get set to anything - it remains blank.
Has anyone else seen this or have any ideas on how to get that billing transaction set to indicate it should be a Final if any of the billing documents are identified as such?
Thanks
Cathy
2014 Feb 05 11:00 PM
Hi Cathy
It appears to be standard functionality that the ABRVORG field be blank in some cases.
Can you use the Clearing Type (ERDK-VERART) field instead?
R41 - all periodic
R43 - all final
R42 - mix
These are some stats from the ERDK table, showing that ABRVORG is always populated for R41, but can be blank for either R42 or R43
Inv# | VERART | ABRVORG |
---|---|---|
1036738 | R41 | 01 |
3743 | R42 | |
309 | R42 | 03 |
1 | R41 | 02 |
7898 | R43 | 03 |
150 | R43 |
Regards
Astrid
2014 Feb 05 11:00 PM
Hi Cathy
It appears to be standard functionality that the ABRVORG field be blank in some cases.
Can you use the Clearing Type (ERDK-VERART) field instead?
R41 - all periodic
R43 - all final
R42 - mix
These are some stats from the ERDK table, showing that ABRVORG is always populated for R41, but can be blank for either R42 or R43
Inv# | VERART | ABRVORG |
---|---|---|
1036738 | R41 | 01 |
3743 | R42 | |
309 | R42 | 03 |
1 | R41 | 02 |
7898 | R43 | 03 |
150 | R43 |
Regards
Astrid
2014 Feb 05 11:12 PM
2014 Feb 11 4:24 PM
Thanks to both Astrid and Bill, both answers are correct. Unfortunately I can only pick one as correct.
We will end up using both suggested solutions. Astrid's right away for our immediate (bill print) need, and Bill's to fix the source of the problem that may be affecting things we just haven't noticed yet.
Cathy