Dynamics GP 10, View Credit & Debit to GL Account by PO

I can't think of a way to see this information 'out-of-the-box'.  And it would be very unusual for functionality to be taken away in a new release.  Is it possible that this was a customization you had for GP 8.0 that was not upgraded to 10.0?  Do the users remember if it was a screen (if so, how did they get to it?) or a report?  If you can find out what the customization was, perhaps it would be possible to get the original developer to upgrade it to GP 10.0 for you.

If none of that is possible or if no one remembers, you may need to create a custom report with this information.  

Victoria, i actually just came across your website about a a month ago and I'd have it say, its fantastic and extremely helpful!

I'm not sure if this was a SQL view, access DB, report, smart list, etc... Basically Finance asked for a list of all POs that were entered that didn't match what came out of that GL #. Our old partner gave them the list of POs that didn't match, but that was it... I, and finance, had no clue where they got this list from, but it was correct and showed us what POs didn't match. Well, now we are trying to pick up the pieces, and after changing partners (so getting that past solution isn't going to be easy), we cannot seem to figure this one out.  

Loosing functionality is a touchy subject for us here because the move to 10 went smooth at first, then we found quite a few issues with loss of functionality...

However, it looks like i can see this by querying the POP30310 and GL30000 tables.

From POP30310 I can get the two Receiving/Receipt numbers. Then in the GL30000 table i can use those numbers to find the credit and debits and see if they match up.  The example below i can see that PO 4 matches, but PO 5 doesn't. This account is a wash account so they should always match, and when they don't, we need to tie that back to a PO and see why.

Thanks for your help!

/* matches */
select * from POP30310 where PONUMBER ='04' --returns RCT01 and RCT02
select * from GL30000 where ACTINDX='41' AND (ORCTRNUM='RCT01' OR ORCTRNUM='RCT012') -- for PO 04
 
/* does not match */
select * from POP30310 where PONUMBER ='05' --returns RCT03 and RCT04
select * from GL30000 where ACTINDX='41' AND (ORCTRNUM='RCT03' OR ORCTRNUM='RCT04') -- for PO 05

Select allOpen in new window

Victoria, i actually just came across your website about a a month ago and I'd have it say, its fantastic and extremely helpful!

I'm not sure if this was a SQL view, access DB, report, smart list, etc... Basically Finance asked for a list of all POs that were entered that didn't match what came out of that GL #. Our old partner gave them the list of POs that didn't match, but that was it... I, and finance, had no clue where they got this list from, but it was correct and showed us what POs didn't match. Well, now we are trying to pick up the pieces, and after changing partners (so getting that past solution isn't going to be easy), we cannot seem to figure this one out.  

Loosing functionality is a touchy subject for us here because the move to 10 went smooth at first, then we found quite a few issues with loss of functionality...

However, it looks like i can see this by querying the POP30310 and GL30000 tables.

From POP30310 I can get the two Receiving/Receipt numbers. Then in the GL30000 table i can use those numbers to find the credit and debits and see if they match up.  The example below i can see that PO 4 matches, but PO 5 doesn't. This account is a wash account so they should always match, and when they don't, we need to tie that back to a PO and see why.

Thanks for your help!

/* matches */
select * from POP30310 where PONUMBER ='04' --returns RCT01 and RCT02
select * from GL30000 where ACTINDX='41' AND (ORCTRNUM='RCT01' OR ORCTRNUM='RCT012') -- for PO 04
 
/* does not match */
select * from POP30310 where PONUMBER ='05' --returns RCT03 and RCT04
select * from GL30000 where ACTINDX='41' AND (ORCTRNUM='RCT03' OR ORCTRNUM='RCT04') -- for PO 05

Select allOpen in new window

PS - thank you very much for the kind words about my blog!  

oh wow! i'll give this a try today and see if that's what they need! Thanks for the quick reply!