BeyondERP.Newsletter
Menu

Job page · Accounts receivable

Archive credit card authorization data

A clean-up job that exports aged payment tokens from the credit card authorization table (CreditCardAuthTrans) to Azure Blob Storage and then deletes that token data from the table.

Business process
Manage data
Menu item
Action:CreditCardAuthTransArchive
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA clean-up job that exports aged payment tokens from the credit card authorization table (CreditCardAuthTrans) to Azure Blob Storage and then deletes that token data from the table.
What you do hereUse it to manage database storage for credit card authorization tokens; a Prevent uploading into blob storage option deletes the token data permanently instead of archiving it.
ExampleWhen credit card tokens make the CreditCardAuthTrans table grow significantly, you run the job to archive or delete the aged token data.
Archive credit card authorization data page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage data
Menu pathAccounts receivable › Inquiries and reports › Clean up › Archive credit card authorization data
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen the CreditCardAuthTrans table grows large, and only for authorizations older than your linked-refund period.
How oftenOn a regular schedule chosen to manage database storage; Learn gives no fixed cadence.
Batch settingsRun it as a batch job; the first run over a large backlog can take a long time.
What the output showsCard token fields (CardTokenRequest and CardTokenResult) removed from old authorization records, archived to Azure Blob Storage unless deletion was chosen. A refund on an archived order must then be a standalone refund.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Clean up > Archive credit card authorization data.
  2. Enter the Minimum transaction age in days; set it long enough to cover your linked-refund period.
  3. Check the Archive before date, which shows the date that matches that age; older authorization tokens are processed.
  4. Leave Prevent uploading into blob storage on No to archive the tokens to Azure Blob Storage; set it to Yes only to delete them permanently.
  5. Select Next, confirm, and plan a recurring schedule so the CreditCardAuthTrans table stays small.

Source: Microsoft Learn

Test checklist

  1. Authorization records older than the Archive before date no longer hold token data.
  2. The archive file is available in document management, unless deletion was chosen.
  3. Newer authorizations still support linked refunds.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Archived token data can't easily be restored, and data deleted with Prevent uploading into blob storage can't be recovered. Set the minimum age to cover your linked-refund period first. Microsoft Learn
If you change it laterExports aged payment tokens from CreditCardAuthTrans to Azure Blob Storage and deletes them from the table, or deletes them permanently when Prevent uploading into blob storage is on. Microsoft Learn
Technical architect

5Technical

Menu itemAction:CreditCardAuthTransArchive Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=Action:CreditCardAuthTransArchive
Everyone

7Sources