Open Forum

Expand all | Collapse all

Payables Batch Workflow

  • 1.  Payables Batch Workflow

    Posted Apr 01, 2019 05:44 PM
    Hi All,

    Hoping you all can help with some workflow criteria. I need to set up a payables batch workflow for all batches except for check batches. We need to have all manual pay, payables transactions, and EFT batches to require approval. But we don't want check batches to require approval. I tried excluding batches where the payment method was "0" - but that lets all payables transactions batches go through without approval. And batch origin wasn't helpful either. Any suggestions on the appropriate criteria?

    Thanks!

    ------------------------------
    Erin White, APS
    Accountant - Accounts Payable
    Multi Service Technology Solutions, Inc
    Overland Park, KS
    ------------------------------


  • 2.  RE: Payables Batch Workflow

    GOLD CONTRIBUTOR
    Posted Apr 02, 2019 08:39 AM
    Hello Erin,

    Have you tried using the Batch Header.Origin condition on the workflow step, for the AP batches?

    For example, you mention you don't want to have check batches to require approval, so you should be able to setup something like this for the step condition:

            where Batch Header.Origin <> 2

    If I'm remembering correctly, an Origin of 1 is for a payables transaction entry, 2 is for Computer Checks and 3 is for PM Payments, but I'm not sure this is what you're referencing as you mentioned you had tried Origin already and it didn't do what you wanted.

    Let us know and I'll see if there is any way of doing this within the default Workflow, or if you would need to use the extended Workflow Condition Editor to put together an approval script that would do exactly what you're needing it to do.

    Thank you,

    ------------------------------
    Derek Albaugh
    Sr. Support Engineer
    Microsoft
    Moorhead MN
    ------------------------------



  • 3.  RE: Payables Batch Workflow

    Posted Apr 02, 2019 10:29 AM
    Hi Derek,

    Yes, I set up a step with criteria stating "Where Batch Header.Origin is not 2" require approval. But check batches still require approval. So I'm not sure what the issue is there. Are we sure Origin of 1 is for a payables transaction entry, 2 is for Computer Checks and 3 is for PM Payments? That is what I had assumed, but it doesn't seem to work that way.

    I've tried setting up multiple steps - one requiring approval only for payment method 1 when the Origin is 2, and then another to require approval when the origin is not 2. But nothing I have tried works. I'm sure I'm overlooking something simple, but I have no clue what it might be.

    I appreciate your help!

    ------------------------------
    Erin White, APS
    Accountant - Accounts Payable
    Multi Service Technology Solutions, Inc
    Overland Park, KS
    ------------------------------



  • 4.  RE: Payables Batch Workflow

    GOLD CONTRIBUTOR
    Posted Apr 02, 2019 11:21 AM
    Hello Erin,

    If you haven't already tried, try using this as a condition:

              where Origin <>  'XPM_Cchecks'


    I spoke to another resource on the Applications team for GP and he mentioned we had a bug on this previously and if the Origin <> 2 doesn't work, then to try the Origin <> 'XPM_Cchecks' condition and see if that works for you.

    Let me know if that works for you, or not.

    Thank you

    ------------------------------
    Derek Albaugh
    Sr. Support Engineer
    Microsoft
    Moorhead MN
    ------------------------------



  • 5.  RE: Payables Batch Workflow

    Posted Apr 02, 2019 12:16 PM
    That worked! Thanks for your help Derek!

    ------------------------------
    Erin White, APS
    Accountant - Accounts Payable
    Multi Service Technology Solutions, Inc
    Overland Park, KS
    ------------------------------



  • 6.  RE: Payables Batch Workflow

    GOLD CONTRIBUTOR
    Posted Apr 02, 2019 12:20 PM
    That's good to hear, thanks for confirming. Have a great day.

    ------------------------------
    Derek Albaugh
    Sr. Support Engineer
    Microsoft
    Moorhead MN
    ------------------------------



  • 7.  RE: Payables Batch Workflow

    Posted 11 days ago
    Hello - I'm touching base on this post since we have now upgraded to GP 2018. Our solution for the batch workflow origin value no longer works. I get an error that the conversion failed when converting the varchar value to data type smallint.

    Do you know if the origin values are different in 2018? I've tried several things but nothing allows me to exclude batches with the Computer Check origin.

    Thanks!


    ------------------------------
    Erin White, APS
    Accountant - Accounts Payable
    Multi Service Technology Solutions, Inc
    Overland Park, KS
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role