BeyondERP.Newsletter
Menu

Setup step on the Ledger posting setup page · Project management and accounting

Set up Ledger posting setup

Use this page to choose posting accounts by project, project group or funding source, by category or category group, or by any mix of these.

Used by
Project accountant
Business process
Manage project financials
Menu item
ProjPosting
Main table
ProjPosting
Data entity
ProjLedgerPostingDefinitionEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you set the main accounts that project cost and revenue transactions post to.
What you do hereUse this page to choose posting accounts by project, project group or funding source, by category or category group, or by any mix of these.
ExampleFor example, BEAT posts hour cost for the category group LABOR to account 640100, but cost for the category TRAVEL-AIR to 640300, so a 950.00 flight on PRJ-0042 lands on its own account.
Ledger posting setup 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

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.

Step by step, with screenshots

Set up Ledger posting setup1 screen

Use this page to choose posting accounts by project, project group or funding source, by category or category group, or by any mix of these.

  1. Screen 1

    Review the ledger posting setup

    Go to Project management and accounting > Setup > Posting > Ledger posting setup

    1. Open the Cost accounts tab and choose the ledger account type, such as Cost
    2. Select New and choose what the line is valid for, such as a project, project group or all
    3. Choose the category relation and the main account to post to
    4. Select the Revenue accounts tab to set up the revenue accounts the same way
    1Ledger account typesCost
    Review the ledger posting setup (zoomed on the outlined fields)
    Show the full screenReview the ledger posting setup
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Posting > Ledger posting setup.
  2. On the Cost accounts or Revenue accounts tab, select the account type to set up, such as Cost or Payroll allocation, and select Add.
  3. In the first Valid for field, select Table, Group or All for the projects the line covers, and the project or project group in the Project relation field.
  4. In the second Valid for field, select Table, Group or All for the categories, and the category or category group.
  5. Select the Main account, and optionally a Sales tax group.
  6. Post a test hour journal and open the voucher to check the account used.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Valid forWhether the line applies to one project (Table), a project group (Group) or all projects (All); a second Valid for does the same for categories.Microsoft Learn Group
Funding sourceThe funding source that is invoiced for the cost transactions the line covers.Microsoft Learn C-0451
Sales tax groupLets you track and report taxable sales by sales tax rate.Microsoft Learn FULL
Main accountThe account that transactions post to for the chosen combination.Microsoft Learn 640100
Ledger account typesThe kind of ledger account the row sets, such as cost.Microsoft Learn Cost

Common errors and fixes

MessageWhat to do
Posting stops because no ledger account is found for a project transaction.No line matches the project and category of the transaction. Add a line for the category group or an All line for the account type. Microsoft Learn

Test checklist

  1. Set a Cost account for an hour category group and a different one for one category in it.
  2. Post an hour journal line on another category in the group and check the voucher uses the group account.
  3. Post a line on the specific category and check it uses the category account.
  4. For an internal project check hours debit Cost and credit Payroll allocation.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Ledger posting setupAccounts by category group as the base, with category-specific rows only where a category needs its own accountCategory groups exist to share posting setup between related categories, and category-specific settings override group-level settings, so exceptions stay small and explicit.At what level should project accounts be set?Gaps in the setup. At posting the system checks that a ledger account is available and of the right type; a transaction type or posting type with no matching account stops posting.Test: Category account overrides category group account

Feature management and licence

Licence or add-inOn the live system, Project accountant maintains this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Changes affect new postings only; vouchers already posted keep the accounts they used.
If you change it laterWhen a transaction posts, the system looks for the most specific project and category match; if no line matches at all, posting stops with an error. Microsoft Learn
Technical architect

6Technical

Menu itemProjPosting Checked in Dynamics 365
FormProjPosting Checked in Dynamics 365
TableProjPostingShown as “Ledger posting setup” in Record infoKey field: ProjAccountTypeChecked in Dynamics 365
Data entitiesProjLedgerPostingDefinitionEntityProject ledger posting definition Microsoft data model
Who can open itPrivilegesMaintain ledger postings ProjPostingMaintainView ledger postings ProjPostingViewDutiesInquire into project ledger postings ProjProjectLedgerPostingsInquireMaintain project ledger postings ProjProjectLedgerPostingsMaintain
1 security roleProject accountant ProjProjectAccountant
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject accountant ProjProjectAccountantGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjPosting
Integrate withProjLedgerPostingDefinitionEntity data entity Microsoft data model
Data migrationProjLedgerPostingDefinitionEntity (Project ledger posting definition): loaded for each company, in Microsoft's default template 650 - Project accounting.Load order: Microsoft's default template 650 - Project accounting loads Project ledger posting definition at execution unit 1, level 650, sequence 40. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Expense management)Microsoft Learn
Table definitionProjPosting columns and relations Microsoft data model
Everyone

8Sources