To define the field properties of a financial posting map

Parent Previous Next

The procedure to define the field properties of a financial posting map is as follows:

  1. Navigate to Quick Menu > System > Configuration > Financial Posting. The Financial Posting Map Details window is displayed.
  2. Select a financial posting map from the alphabetical list or type its name into the Search Financial Posting Map field. By default the list is filtered to show Current financial posting maps. An alternative filter can be applied using the Select view drop-down field: Expired, Future or All combinations 1.
  3. Click on New Field. The Finance Field window is displayed.
  4. Using the Finance Field drop-down list, select a parameter value matching a field within the nominated third party accounting system into which transactional data will be posted 2.
  5. Where a fixed value will be mapped to the data field within the third party accounting system, enter the default Analysis value into the field provided.
  6. Alternatively, using the Analysis Field drop-down list, select a parameter value to be mapped to the data field within the third party accounting system 3.
  7. Otherwise, where a bespoke SQL stored procedure has been created to facilitate the capture of the required analysis field, enter the procedure name into the Additional Analysis field provided 4.
  8. Multi-select the Posting Account, Contra Account, Second Posting Account and Second Contra Account attributes to control the nominal ledger codes in which this mapped data field will be included for each relevant transaction posting.
  9. Click on Confirm. The mapped data field is displayed in the Finance Fields summary table, reflecting the chosen nominal ledger posting attributes.
  10. Repeat steps 3 through 9 to specify further data field links within the financial posting map.
  11. Click on Save 5.


Note

1 The Search Financial Posting Map field will match against any element of the financial posting map description.

2 The data fields available for selection will be determined by the third party accounting system specified within the Financial Ledger Software system preference.

3 The prescribed parameter values available for selection are governed by the Transaction type configured for the financial posting map.

4 Complex algorithms can be captured within a SQL stored procedure to obtain the desired analysis field or discrete value.

5 As a prescribed field order is automatically applied to the relevant data on export, there is no requirement to assign column positions.


See related topics...

Financial posting management overview

To create a financial posting map