Dynamics Community Forum Thread Details

General Ledger Batch Approval Workflow SmartList

Hey All

I hope someone can help?

We have setup the General Ledger Batch workflow in GP 2018 and all is working fine until we need to do reporting on it.

When trying to create a smartlist to pull through the information on who submitted, approved and posted we only have access to the batch number from the wsBusObjKey field means we have no way of linking this to the actual journals held in the batch.

when looking at the tables you get the BACHNUMB field on the GL10000 table but as soon as the batch is posted in GP and moves to GL20000 or GL30000 tables this isnt a field that is pulled through as it changes the Batch Number to an automatically generated TRXSORCE field and there is no way of identifying the link between the batch ID and the journal number.

Surely i am not the only person ythat wants to be able to run a smartlist on this to show transactions after they have been posted??

Any help would be gladly appreciated.

Laurs

While the WFI10002, WFI10003, WFI10004 tables would have all the workflow information from the submission of the GL batch workflow through any and all steps to include the originator and assigned approvers, to completion/final approval, you're correct in that once the GL batch is posted and removed from the GL10000 table, there isn't any way to connect it with the wsBusObjKey value with the GL batch number, to the GL20000 or GL30000 tables, to pull information from those GL tables into any type of report.

The main reason for this is because GL batch numbers can be re-used, and I'm sure there's more reasoning.

That being said, you are not the only one that has mentioned this and it has been documented as an issue/want from customers, but as of yet, it hasn't been changed, nor are there any plans to do so, that we've been made aware.

I do apologize for the inconvenience this may cause.

Thank you,

Quick Links

Leaderboard