Edit

ER Create a format configuration (November 2016)

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

This article explains how a user in the System Administrator or Electronic Reporting Developer role can create a format configuration for Electronic reporting (ER). This format configuration defines the format of electronic documents that are used for processing payments. In this example, you create a format configuration for sample company, Litware, Inc. To complete these steps, you must first complete the steps in the "Map model to selected datasources" procedure.

Create a new format configuration

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. Select Reporting configurations.
  3. In the tree, select Payments (simplified model).
  4. Select Create configuration to open the dialog.

Note

If you don't see Create configuration, you must enable design mode on the Electronic reporting parameters page.

  1. In New, enter Format based on data model PaymentModel.
  2. In Name, type BACS (UK fictitious).
  3. In Description, type BACS vendor payment format (UK fictitious).
    • The active configuration provider is automatically entered here. This provider can maintain this configuration. Other providers can use this configuration, but can't maintain it.
    • You can define a particular format of electronic document. Leave this field blank if you want to select a format at run-time.
  4. In Data model definition, enter or select a value.
  5. Select Create configuration. You created a new configuration. Use the draft version to store the design format for managing electronic documents.

Design the format of an electronic document

  1. Select Designer.
  2. Select Add root to open the drop dialog.
  3. In the tree, select Common\File.
  4. In the Name field, type Xml.
  5. In the Encoding field, type UTF-8.
  6. Select OK.
  7. Select Add.
  8. In the tree, select XML\Element.
  9. In the Name field, type Message.
  10. Select OK.
  11. In the tree, select Xml\Message.
  12. Select Add Element.
  13. In the Name field, type ProcessingDate.
  14. Select OK.
  15. Select Add Element.
  16. In the Name field, type MessageId.
  17. Select OK.
  18. Select Add Element.
  19. In the Name field, type Payments.
  20. Select OK.
  21. In the tree, select Xml\Message\Payments.
  22. Select Add Element.
  23. In the Name field, type Item.
  24. Select OK.
  25. In the tree, select Xml\Message\Payments\Item.
  26. Select Add.
  27. In the tree, select XML\Attribute.
  28. In the Name field, type Id.
  29. Select OK.
  30. Select Add.
  31. In the tree, select XML\Element.
  32. In the Name field, type Vendor.
  33. Select OK.
  34. In the tree, select Xml\Message\Payments\Item\Vendor.
  35. Select Add Element.
  36. In the Name field, type Name.
  37. Select OK.
  38. Select Add Element.
  39. In the Name field, type Bank.
  40. Select OK.
  41. In the tree, select Xml\Message\Payments\Item\Vendor\Bank.
  42. Select Add Element.
  43. In the Name field, type RoutingNumber.
  44. Select OK.
  45. Select Add Element.
  46. In the Name field, type AccountNumber.
  47. Select OK.
  48. In the tree, select Xml\Message\Payments\Item\Vendor.
  49. Select Copy.
  50. In the tree, select Xml\Message\Payments\Item.
  51. Select Paste.
  52. In the Name field, type Payer.
  53. In the tree, select Xml\Message\Payments\Item.
  54. Select Add Element.
  55. In the Name field, type Currency.
  56. Select OK.
  57. Select Add Element.
  58. In the Name field, type Description.
  59. Select OK.
  60. Select Add Element.
  61. Enter TransDate in the Name field.
  62. Select OK.
  63. Select Add Element.
  64. Enter Amount in the Name field.
  65. Select OK.

Prepare format components for mapping to data model elements

  1. In the tree, select Xml\Message\ProcessingDate.
  2. Click Add to open the drop dialog.
  3. In the tree, select Text\DateTime.
  4. In the Format field, type yyyy-MM-dd.
  5. Select OK.
  6. In the tree, select Xml\Message\Payments\Item\TransDate.
  7. Click Add DateTime.
  8. In the Format field, type yyyy-MM-dd.
  9. In the DateTime type field, select Date.
  10. Select OK.
  11. In the tree, select Xml\Message\MessageId.
  12. Click Add to open the drop dialog.
  13. In the tree, select Text\String.
  14. Select OK.
  15. In the tree, select Xml\Message\Payments\Item\Vendor\Name.
  16. Click Add String.
  17. Select OK.
  18. In the tree, select Xml\Message\Payments\Item\Vendor\Bank\RoutingNumber.
  19. Click Add String.
  20. Select OK.
  21. In the tree, select Xml\Message\Payments\Item\Vendor\Bank\AccountNumber.
  22. Click Add String.
  23. Select OK.
  24. In the tree, select Xml\Message\Payments\Item\Payer\Name.
  25. Click Add String.
  26. Select OK.
  27. In the tree, select Xml\Message\Payments\Item\Payer\Bank\RoutingNumber.
  28. Click Add String.
  29. Select OK.
  30. In the tree, select Xml\Message\Payments\Item\Payer\Bank\AccountNumber.
  31. Click Add String.
  32. Select OK.
  33. In the tree, select Xml\Message\Payments\Item\Currency.
  34. Click Add String.
  35. Select OK.
  36. In the tree, select Xml\Message\Payments\Item\Description.
  37. Click Add String.
  38. Select OK.
  39. In the tree, select Xml\Message\Payments\Item\Amount.
  40. Click Add String.
  41. Select OK.
  42. Click Save.
  43. Close the page.
  • Last updated on