MSAMM
Back to course

Implementing Project Portfolio Management: From Organization Structure to Recognized Revenue · Module 12 · Project Costing: the Accounting Setup

Mapping sets

Lesson 126 of 198 · 13 min

Create a mapping set translating expenditure type to natural account. Set the input source and output type, enter the mappings, create a second mapping set keyed on organization, show a default value for unmapped inputs, and show what happens with NO default and an unmapped input. ALWAYS SET A DEFAULT. An unmapped input with no default fails the accounting — and the failure surfaces in a batch process rather than at entry, which means hours later and to somebody else. THE DEFAULT SHOULD BE A SUSPENSE-STYLE ACCOUNT SOMEBODY REVIEWS, NOT A REAL EXPENSE ACCOUNT. Otherwise errors hide — and they hide inside a plausible number. Mapping sets are the maintenance surface. Every new expenditure type needs a mapping. Runbook item.

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Implementing Project Portfolio Management: From Organization Structure to Recognized Revenue, with a certificate on completion and a fourteen-day refund window.

See the course and enrol9 free lessons

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 12 · Project Costing: the Accounting Setup

  1. 1The accounting problem
  2. 2The project costing details flexfield
  3. 3Cost collection and the additional segment
  4. 4Value sets for the flexfield
  5. 5Transaction account definitions explained
  6. 6Mapping sets
  7. 7Building a transaction account definition
  8. 8Associating the definition to a ledger
  9. 9Proving the accounting works
  10. 10What breaks
  11. 11Lab: a mapping a controller could sign