BeyondERP.Newsletter
Menu

Page · Project management and accounting

Item

The project item journal: an inventory journal that consumes items from the warehouse on a project when it is posted.

Used by
Field Service Integration User, Machine operator, Shop supervisor and 3 more roles
Business process
Manage project delivery
Menu item
InventJournalTableProject
Main table
InventJournalTable
Data entity
ProjectItemJournalTableEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isThe project item journal: an inventory journal that consumes items from the warehouse on a project when it is posted.
What you do hereUse it to enter and post item consumption for a project quickly, for example from a printed pick list, without an item requirement.
ExampleFor example, BEAT consumes 30.00 m of cable CAB-200 on PRJ-0042 through item journal IJ-000077; the project cost posts at the weighted average of 6.10 per metre, 183.00, and is adjusted to the FIFO cost when inventory recalculation runs.
Item 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

Business processManage project delivery
Menu pathProject management and accounting › Journals › Item
Set up firstJournal names Microsoft Learn
Used next byPosted project transactions Microsoft Learn
Related pagesItem requirements Microsoft Learn
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.

Setup steps on this page

Choose the item journal only for immediate consumption

Consume items on the project at the right time.

Steps from Microsoft

  1. Go to Project management and accounting > Journals > Item.
  2. Select New, select the journal name and enter a description, then select Lines.
  3. Select New and enter the project, item number, site and warehouse, and the quantity.
  4. Check the category and line property, then select Post.
  5. Check the item transaction on Posted project transactions at weighted average cost.
  6. After Inventory recalculation or close, check the adjustment to the item's own costing method.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Journal nameThe project item journal name that sets the voucher series.Checked in Dynamics 365PITEM
Item numberThe item consumed on the project.Microsoft Learn CAB-200
QuantityThe quantity issued from the warehouse to the project.Microsoft Learn 30.00
Project IDThe project that receives the item cost.Microsoft Learn PRJ-0042

Common errors and fixes

MessageWhat to do
The project cost of a FIFO item differs from the FIFO cost.The cost posts at weighted average first and is adjusted to the item's costing method only when Inventory recalculation or close runs. Microsoft Learn

Test checklist

  1. Post a project item journal line for a FIFO item.
  2. Check Posted project transactions shows the cost at weighted average.
  3. Run Inventory recalculation.
  4. Check an adjustment voucher brings the project cost to the FIFO cost.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Choose the item journal only for immediate consumptionUse the item journal for items consumed at once; use item requirements for items consumed later or in partial deliveries.Items in the item journal are consumed when the journal is posted, while item requirements post on the packing slip.How are items issued to projects?Reading the first project cost as final: it is weighted average until inventory recalculation or close runs.Test: Consume an item on a project

Feature management and licence

Licence or add-inOn the live system, Project manager, Project accountant, Project assistant and Field Service Integration User use 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: Items are consumed when the journal is posted. The project cost posts at weighted average first and is adjusted to the item's own costing method only when Inventory recalculation or close runs. Microsoft Learn
If you change it laterItems are consumed when the journal is posted; the project cost is adjusted later by inventory recalculation or close. Microsoft Learn
Technical architect

6Technical

Menu itemInventJournalTableProject Checked in Dynamics 365
FormInventJournalTable Checked in Dynamics 365
TableInventJournalTableShown as “Inventory journal table” in Record infoKey field: JournalId, JournalType, JournalNameId, DescriptionChecked in Dynamics 365
Data entitiesProjectItemJournalTableEntityProject item journal header Microsoft data model
Who can open itPrivilegesMaintain item consumption journals InventJournalTableProjectMaintainView item consumption journals InventJournalTableProjectViewDutiesMaintain project journals and journal transactions ProjProjectJournalsMaintainApprove project transactions ProjProjectTransactionApproveMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPost
6 security rolesField Service Integration User FieldServiceIntegrationUserMachine operator JmgMachineOperatorShop supervisor JmgShopSupervisorProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkField Service Integration User FieldServiceIntegrationUserMachine operator JmgMachineOperatorGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=InventJournalTableProject
Integrate withProjectItemJournalTableEntity data entity Microsoft data model
Data migrationProjectItemJournalTableEntity (Project item journal header): loaded for each company.Load order: Load journal names, projects and released products with on-hand stock first, then the journal headers. Open journals are usually posted in the old system.Load first: Inventory journal names, Projects, Released productsMicrosoft Learn
Table definitionInventJournalTable columns and relations Microsoft data model
Everyone

8Sources