BeyondERP.Newsletter
Menu

Setup step on the Project sales orders page · Project management and accounting

Sell items on Time and material projects

Choose the sales order only where it fits the project type.

Business process
Manage project delivery
Menu item
SalesTableListPage_Proj
Main table
SalesTable
Data entity
SalesOrderHeaderV2Entity
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 isThe list of sales orders created for projects. A project sales order is possible only on a Time and material project and charges the items to the project when the customer invoice is posted.
What you do hereUse it to sell items on a project and invoice them through the sales order rather than through an invoice proposal.
ExampleFor example, on Time and material project PRJ-0042 BEAT sells 3 control panels at 2,400.00 each through a project sales order; posting the customer invoice charges the 7,200.00 sale to the project.
Project sales orders 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.

Setup steps on this page

Sell items on Time and material projects

Choose the sales order only where it fits the project type.

Steps from Microsoft

  1. Go to Project management and accounting > Item tasks > Project sales orders to review the open orders.
  2. To create one, open the Time and material project and on the Action Pane select Manage > Item tasks > Sales order.
  3. If the project contract has more than one funding source, select the funding source that sets the customer.
  4. Add the lines with item, quantity and price, and save.
  5. Post the packing slip, then post the customer invoice, which charges the items to the project.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Funding sourceSets the customer for the sales order when the contract has more than one funding source.Microsoft Learn C-1001
Project IDThe Time and material project the sales order belongs to.Microsoft Learn PRJ-0042
Order typeShows whether the record is a sales order or an item requirement.Microsoft Learn Sales order

Common errors and fixes

MessageWhat to do
Sales order isn't offered on the project's Manage > Item tasks menu.Project sales orders are possible only for Time and material projects; use an item requirement on Fixed-price or Investment projects. Microsoft Learn

Test checklist

  1. Create a sales order from Time and material project PRJ-0042 for 3 items at 2,400.00.
  2. Post the packing slip and the invoice.
  3. Open Posted project transactions for PRJ-0042.
  4. Check one item transaction of 7,200.00 sales shows.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Sell items on Time and material projectsUse project sales orders only on Time and material projects and pick the funding source when the contract has several.Items on a sales order are charged to the project when the customer invoice posts, not through an invoice proposal.How are items invoiced on Time and material projects?Invoicing the same items again on an invoice proposal: the sales order already invoiced them.Test: Sales order on a Time and material project

Feature management and licence

Licence or add-inOn the live system, Project assistant, Sales clerk, Sales representative and Rental manager use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own sales orders. Microsoft Learn
Can it be undoneHard to reverse: Packing slips can't be canceled after items are marked for packing.
If you change it laterAfter items are marked for packing, the packing slip of a project sales order can't be canceled. Microsoft Learn
Technical architect

6Technical

Menu itemSalesTableListPage_Proj Checked in Dynamics 365
FormSalesTableListPage Checked in Dynamics 365
TableSalesTableShown as “Sales orders” in Record infoChecked in Dynamics 365
Data entitiesSalesOrderHeaderV2EntitySales order headers V2 Microsoft data model
Roles to set it up and use itTo set it up or change itProject assistant ProjProjectClerkSales clerk TradeSalesClerkSales representative TradeSalesRepresentativeRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject accountant ProjProjectAccountantField Service Integration User FieldServiceIntegrationUserService delivery manager SMAServiceDeliveryManagerGive people one of these roles. On this system, 33 roles can open this page.Checked in Dynamics 365
Actions on the pageSales order: New, Maintain, Payments, Copy, View, Functions, Attachments, Clean up, Engineering change requestSell: Credit note, Charges, Tax, Calculate, Generate, Actions, Process, Apply, Journals, PrepaymentManage: Customer, Bank document, Intercompany tracing, Coupons, Revenue recognitionPick and pack: Generate, JournalsInvoice: Generate, Bill, Settle, Journals, DeductionsCommerce: Attributes, Inquiries, AffiliationsGeneral: Set up, Customer, Maintain, Related information, CAPAWarehouse: Related information, Loads, ActionsTransportation: Rating, InvoiceOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SalesTableListPage_Proj
Integrate withSalesOrderHeaderV2Entity data entity Microsoft data model
Data migrationSalesOrderHeaderV2Entity (Sales order headers V2): loaded for each company.Load order: Load customers, projects and released products first, then open sales order headers and their lines.Load first: Customers, Projects, Released productsMicrosoft Learn
Table definitionSalesTable columns and relations Microsoft data model
Everyone

8Sources