Balances of Received not Vouchered by Supplier

[daveschultz]

We have the need to report out on the balance of our received not vouchered account and break that down to a balance by supplier. What we currently do is run a report that looks back over our entire F0911 table for that account for all OV and PV doc types and summarizes by company and address book number. As our F0911 is getting quite big, this is becoming a problem. I have tried to run something off of the F43121, but I can't quite get the numbers to match up to what we pulled from the F0911. Can someone tell me if there is a better way to fill this need?

Thanks

Dave
E1 90, TR9.1.0.4

 

[DSauve]

Create a version of R43412 with sequencing first on Supplier (AN8), with Page Break on Supplier (you can move Business unit after AN8 and remote the Page Break on that if you want). This gives me totals by Supplier when I run it.

 

[daveschultz]

Thanks Don. Do you know if you're able to run it "As of" a certain date (year end in our case).

Dave

 

[DSauve]

Not that I'm aware of. Has anyone else done that?