Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-03-08
Example: Custom Dismiss Zero Amount Transactions

Example: Custom Dismiss Zero Amount Transactions

This example illustrates how to custom dismiss zero amount transactions during batch processing for ingestion and tracking in the Accounting Center batch.
You want to dismiss all zero amount transactions from a batch before submitting the transactions to Detailed Accounting.
Additional considerations to note in this example when custom dismissing zero amount transactions:
  • Dismiss transactions from the Enrichment 1 stage.
  • Dismiss transactions from further processing.
  • Dismiss transactions after you dismiss all errors from the Enrichment 1 stage.
  • Dismiss transactions that have a zero amount in a field. Example: TRNS_AMT # field.
Accounting Source and dataset names are specific to your Workday tenant and might be different than the names used in this example. Use the information as a guide.
Security:
  • Necessary security to edit the Accounting Center Event business processes.
  • These domains in the Accounting Center functional area:
    • Set Up: Accounting Source – Create
      .
    • Process: Accounting Center
      .
  • Prism Datasets: Manage
     domain in the Prism Analytics functional area.
Ensure that you have:
  • Created an Accounting Source.
  • Enriched the data by creating the Enrichment dataset.
  1. Configure the UserDirectedForDismissal Dataset to Access Your Enrichment Table
    Configure the delivered UserDirectedForDismissal dataset to access the table with the AC_TransactionID that contains zero transaction amounts by editing the USR_UserDirectedFor Dismissal dataset. You can then use the ENR_1_TBL_EnrichedData output as the import source.
    The dataset must contain AC_TransactionIDs, otherwise custom dismiss won't complete successfully. Workday custom dismisses transactions at the AC_TransactionID level.
    Workday recommends that you only bring the current Accounting Center batch into the USR_UserDirectedFor Dismissal dataset. This action improves performance and ensures that Custom Dismissal only runs when needed.
    1. Access the
      View Accounting Source
       report.
    2. In the
      Accounting Source
       field, select the accounting source for which you want to custom dismiss zero amount transactions. Example: AC 1TO1 MC.
    3. Click
      OK
      .
    4. From the related actions of the Accounting Source, select
      Accounting Source
      View Implementation.
    5. Scroll to the bottom of the page.
    6. Click to open the dataset
      User Configured Dismiss System Dataset
      . Example:
      AC _1TO1_MC_USR_UserDirectedForDismissal
      .
    7. Create a new derived dataset to import the Enrichment output dataset and then create an inner join with the UnprocessedForBatch dataset for that stage. To access the enriched data for the most recent batch, join the datasets on the Accounting Center Batch and Accounting Center Transaction ID. Example:
      AC _1TO1_MC_ENR_1_EnrichedData_CurrentBatch_DDS
      .
    8. Under
      Change Pipeline
      , change the import source to the new dataset you created that contains the Transaction IDs of the transactions that you want to dismiss.
      • Click the
        Pencil
        icon next to the Import stage.
      • On the
        Change Source
         page, select the enriched dataset from above. Example:
        AC_1TO1_MC_ENR_1_EnrichedData_CurrentBatch_DDS
         and click
        Select
        .
    9. Select
      Edit Transformations
       to configure a filter for dismissing all zero amount transactions in the enriched table.
    10. Select
      Stage
       and then
      Filter
      .
    11. For Description, enter:
      Exclude Transactions = 0
       for the stage to filter out all zero amount transactions.
    12. Click
      Add Filter
      .
    13. Select
      If All
       of the following conditions are met.
    14. For the
      Edit Filter Condition
      , select the field that contains zero amount transactions. Example:
      TRNS_AMT #
       field.
    15. For
      is equal to
      , enter
      0
      .
    16. On the
      Edit Filter Condition
       header, click the
      Checkmark
      .
    17. Click
      Done
      .
    18. Click
      Save
       to save the dataset.
  2. Configure the Business Process and Condition Rules for the Enrichment Stage
    1. Access the
      Accounting Center Enrichment Event (Default Definition)
       business process.
    2. From the related actions of the business process definition, select
      Business Process
      Edit Definition
      .
    3. For
      Effective Date
      , select today date.
    4. Click
      OK
      .
    5. Click
      Add Row
      .
    6. Enter:
      Field
      Value
      Order
      Enter an order of where you want to place the step. It must be after the primary process. Example: c
      Type
      Batch/Job
      Specify
      Request Dismiss Transactions From Further Processing (Enrichment)
      Run As User
      Name of the user or your integration system user that runs Accounting Center batches. Example: Accounting Center Administrator 01
    7. Click
      OK
      .
    8. From the related actions of Order
      c
      , select
      Business Process
      Maintain Step Conditions
      .
    9. For
      Effective Date
      , select today date.
    10. Click
      OK
      .
    11. Click
      Add Row
      .
    12. In the
      Rule
       field, select
      Create Condition Rule
      .
    13. Click
      OK
      .
    14. For Description, enter
      Dismiss $0 from Enrichment Stage of these Sources
      .
    15. In the
      Rule Conditions
       grid, enter:
      Field
      Value
      Source External Field or Condition Rule
      Accounting Source Stage
      Relational Operator
      in the selection list
      Comparison Type
      Value specified in this filter
      Comparison Value
      <
      Name of your Enrichment dataset
      >
      Example: AC 1TO1 MC - AC 1to1 dds - Enrichment 1
    16. Click
      OK
      .
    17. Click
      Add Row
       to add another condition rule to dismiss transactions after dismissing all errors from the Enrichment stage.
      Apply this condition rule as an entry condition on the business process step for the Request Dismiss Transactions job.
    18. In the
      Rule
       field, select
      Create Condition Rule
      .
    19. Click
      OK
      .
    20. For Description, enter
      Successful Transactions
      .
    21. In the
      Rule Conditions
       grid, enter:
      Field
      Value
      Source External Field or Condition Rule
      Transactions In for a Stage
      Relational Operator
      equal to
      Comparison Type
      Value from another field
      Comparison Value
      Success Transactions for a Stage
    22. Click
      OK
      .
    23. Click
      OK
      .
    24. Click
      Done
      .
Workday custom dismisses all zero amount transactions for the Enrichment 1 stage.