There are some scenarios where CPM is unable to post transactions that are retrieved into Business Central from your external payment platform:
- Unlinked activities: CPM is unable to identify a link between the retrieved external platform customer and a Business Central customer record.
- Unposted activities: CPM successfully identifies a link between the retrieved external platform customer and a Business Central customer record but is unable to post the transaction. This could be due to numerous reasons, such as the Business Central customer being blocked or incomplete posting group setup.
In either scenario, it is necessary for a user to review these outstanding transactions and make a determination as to how they should be processed. To assist in this activity, CPM has a transaction worksheet. Whenever a transaction cannot be posted as part of CPM’s automation routine, a new line for that activity is added to the CPM Transaction Worksheet page, where it can then be reviewed.
To work with the CPM Transaction Worksheet page
- Choose the looking glass within Business Central
- Enter CPM Transaction Worksheet and then choose the related link
The CPM Transaction Worksheet page contains a separate line for each payment that CPM retrieved from your external payment platform and did not process. There are two posting status types for worksheet lines:
- Not Posted: CPM was unable to post the transaction.
- Not Linked: CPM was unable to associate the retrieved payment to linked records in Business Central.
Worksheet lines also contain information about the payment amount. Any transaction fees that were assessed by your external payment platform are included, and CPM subtracts any fee amounts from the payment amount to present you with a net payment on each worksheet line.
The Transaction Type field will initially default to the transaction type that was retrieved from the external platform, but this field is editable and you can select a different value from the dropdown list. This is especially useful if CPM is unable to identify the transaction type of an activity upon retrieval. In this scenario, the worksheet line’s transaction type would be set to Unknown. Once you research the specifics of the activity, you can assign a new transaction type to the line before posting.
There are also fields to display or enter a posting account and an applies-to document for each worksheet line. In the case of an unlinked worksheet line, these fields will be blank. In the case of unposted journal lines, CPM will populate these fields with any information that could be identified when the transaction was retrieved into Business Central.
You can manually adjust these posting accounts and applies to documents on a line-by-line basis, but there are also actions in the ribbon that you can execute. It is generally recommended that you utilize these ribbon actions, especially if you wish to update multiple worksheet lines at once; if you select multiple lines and then perform one of the actions
described below, the action will be executed against all selected worksheet lines.
The following actions are available in the CPM Transaction Worksheet page’s ribbon:
- Set to Default Posting Account: the default posting account that has been defined for the related CPM payment platform will be assigned to the selected worksheet lines.
- Update Posting Account Type/No: CPM opens a separate page that prompts you to define a new posting account and posting applies-to document. When you enter these values and then choose the Update action in the ribbon, this posting information will be assigned to the selected worksheet lines.
- Link to Payment: CPM attempts to re-link the worksheet line to an existing Business Central record. This action should be performed after you have identified and resolved the cause of transaction lines being unlinked. For example, if you retrieved a number of payments from an unlinked customer into Business Central, each one of these transactions would be entered in the transaction worksheet as an unlinked line. You could then perform the necessary customer linkage within Business Central, return to the CPM Transaction Worksheet page, select the relevant worksheet lines, and choose the Link to Payment action. CPM will assign the newly-linked record as the posting account on the selected worksheet lines.
You can also enter any notes or information against a worksheet line by choosing the Actions ribbon, then choosing the Comments action.
When you have made the desired changes to the worksheet lines, choose the Post Selected Transactions action in the ribbon. CPM will post the selected worksheet lines to the assigned posting account’s ledger. If a posting applies-to document has been assigned, the appropriate application activity will take place, as well. Successfully posted lines are removed from the CPM Transaction Worksheet page.
In an instance where a worksheet line cannot be posted, you can manually remove it by choosing the Actions ribbon, then selecting the Posting group and choosing the Set Posting Not Required action. CPM will present a message asking you to confirm this decision. If you choose the Yes button, the line will be removed from the CPM Transaction Worksheet page. Note that the related CPM transaction record will still remain in Business Central and can be accessed from the CPM payment platform. When a CPM transaction is identified as not requiring posting, a comment will be automatically entered for it that indicates the user who performed this action, as well as the date and time it was executed.
Note: removing a worksheet line without posting it means that it will not be posted to your Business Central ledgers, making your Business Central financial data out of sync with your Stripe platform activity. It is recommended that you record the necessary journal entries in Business Central as part of the manual removal of any CPM Transaction Worksheet lines.
In scenarios where a CPM transaction could not be posted due to Dimensions setup (for example, a G/L account has a particular Dimension assigned with a code mandatory value posting and the transaction in question did not have a value defined for that particular Dimension), it is possible to adjust and override that transaction line’s Dimensions by
choosing the Actions ribbon, then selecting the Posting group and choosing the Dimension Override action. On the Dimension Override page, you can assign Dimensions and value codes to the CPM transaction. When you attempt to post the transaction worksheet line, any defined Dimension value overrides will either be added to the newly-created general ledger entry’s list of Dimensions or replace a Business Central-assigned value. You can also leave this field blank to instruct CPM that you do not wish to record any values for that Dimension as part of the posting activity; this will override any Business Central-assigned Dimension values, resulting in no Dimension being recorded for the activity.