BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

Item

An inquiry that lists posted item transactions on projects, with project date, project, category, item, quantity, cost price, sales price, line property, invoice status and transaction origin.

Used by
Chief executive officer, Field Service Integration User, Project accountant and 4 more roles
Business process
Analyze project performance
Menu item
ProjTransItem
Main table
ProjItemTrans
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 isAn inquiry that lists posted item transactions on projects, with project date, project, category, item, quantity, cost price, sales price, line property, invoice status and transaction origin.
What you do hereUse it to answer 'which materials did the project consume, when, and at what cost and price?'
ExampleThe BEAT warehouse posted the packing slip for an item requirement on PRJ-0042; the inquiry now shows 25.00 units of CABLE-10 at a cost price of 4.20 EUR, 105.00 EUR in total, chargeable at a sales price of 6.50 EUR.
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 processAnalyze project performance
Menu pathProject management and accounting › Inquiries and reports › Transactions inquiries › Item
Set up firstItem requirements Microsoft Learn Item journal Microsoft Learn
Used next byAdjust transactions Microsoft Learn
Related pagesResource/item actual transactions 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

Confirm when items were consumed

Check that project item costs land in the right period for the ordering method used.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Transactions inquiries > Item.
  2. Filter on Project ID and Item number.
  3. Read Transaction origin and the date: items are consumed when the packing slip, vendor invoice or customer invoice is posted, depending on how they were ordered.
  4. Open the Product dimensions tab to check the site and warehouse the items came from.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Column displayChooses which group of columns the grid shows, for example prices.Checked in Dynamics 365Price
Invoice statusLimits the list to transactions in one invoicing state; All shows every state.Checked in Dynamics 365All
Item numberThe item consumed on the project.Checked in Dynamics 365CABLE-10
Transaction originHow the item reached the project: item journal, item requirement packing slip, purchase order or sales order.Microsoft Learn Item requirement

Common errors and fixes

MessageWhat to do
Items received on a project purchase order don't show yet.Items from a project purchase order are consumed when the vendor invoice is posted; check the invoice status of the order. Microsoft Learn

Test checklist

  1. Post the packing slip of an item requirement for 25.00 CABLE-10 on PRJ-0042.
  2. Open the inquiry filtered on PRJ-0042.
  3. Check that one line of 25.00 units shows with origin item requirement.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Confirm when items were consumedFilter on Project ID and Item number, then read Transaction origin and date.Item requirements consume at packing slip, project purchase orders at vendor invoice, sales orders at customer invoice.How should project materials be ordered?Expecting received purchase order items on the project before the vendor invoice is posted.Test: Item requirement consumption shows

Feature management and licence

Licence or add-inOn the live system, Project accountant and Project assistant maintain this page; Project manager, Project supervisor, Chief executive officer, Field Service Integration User and Service delivery manager view it.

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 undoneReversible: The inquiry changes no data. Microsoft Learn
If you change it laterThe consumption date follows the ordering method, so the same item can reach the project in different periods; an adjustment reverses and reposts the line. Microsoft Learn
Technical architect

6Technical

Menu itemProjTransItem Checked in Dynamics 365
FormProjTransItem Checked in Dynamics 365
TableProjItemTransShown as “Project item transactions” in Record infoKey field: TransDate, ProjId, ActivityNumber, CategoryId, ItemId, LinePropertyIdChecked in Dynamics 365
Who can open itPrivilegesMaintain all posted project transactions ProjPostedProjectTransactionsMaintainView all posted project transactions ProjPostedProjectTransactionsViewView item transactions ProjTransItemViewDutiesMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquireApprove posting of service orders SMAServiceOrdersJournalize
7 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorService delivery manager SMAServiceDeliveryManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject accountant ProjProjectAccountantProject assistant ProjProjectClerkTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserService delivery manager SMAServiceDeliveryManagerGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Actions on the pageActions: Functions, Inquiries, InventoryOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjTransItem
Data migrationLoad order: The Item transactions inquiry has no data entity in Data management that writes posted transactions: lines are created by posting journals, timesheets or source documents. Open item costs from a former system are loaded as beginning balance journal lines (ProjBeginningBalanceCostSaleEntity).Microsoft Learn
Table definitionProjItemTrans columns and relations Microsoft data model
Everyone

8Sources