BeyondERP.Newsletter
Menu

Report page · Cost management

Intercompany goods in transit totals

A report that totals the value of intercompany goods in transit for a period, per item and grouped by vendor.

Business process
Print inventory costing reports in Dynamics 365 Finance
Menu item
output:InterCompanyGoodsInTransitTotals
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that totals the value of intercompany goods in transit for a period, per item and grouped by vendor.
What you do hereUse this report to post a general ledger entry for the value of intercompany goods in transit for a period.
ExampleFor example, you can enter general ledger figures straight from the report totals, without exporting to Excel.
Intercompany goods in transit totals 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 financial performance › Analyze costs › Print inventory costing reports in Dynamics 365 Finance
Menu pathCost management › Inquiries and reports › Inventory accounting - status reports › Intercompany goods in transit totals
Related pagesIntercompany goods in transit 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.

When to run it

When to run itAt period end, when you post the general ledger entry for the value of intercompany goods in transit.
How oftenMonthly, at each period end with intercompany shipments in transit.
What the output showsThe value of intercompany goods in transit per item, grouped by vendor, as one total for the period. Wrong totals usually come from a time fence that is too short, or from using the report together with the Landed cost goods-in-transit feature.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory accounting - status reports > Intercompany goods in transit totals.
  2. Select a Date interval code, or enter the From date and To date of the period you are closing.
  3. Under Settings, enter the In transit time fence in days: how many days before the from date the report looks for shipments or receipts that affect goods in transit.
  4. Set Deduct in transit quantity variance to Yes to subtract the in-transit quantity variance, and limit by Vendor account or Customer company if needed.
  5. Use the totals per item and vendor for the period-end goods-in-transit ledger entry, and match them with the Intercompany goods in transit transactions report.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Date interval codeA preset period, such as a month, quarter or year, that fills in the from and to dates.Microsoft Learn
In transit time fence in daysHow many days before the from date the report looks for shipments or receipts that affect goods in transit.Microsoft Learn
Deduct in transit quantity varianceSubtracts the in-transit quantity variance from the in-transit quantity.Microsoft Learn
Vendor accountLimits the report to one or more vendors.Microsoft Learn
Customer companyLimits the report to one or more customer companies.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads packing slips and product receipts; it changes nothing. Microsoft Learn
If you change it laterThe report doesn't work with the goods-in-transit feature of Landed cost; using both together gives incorrect results. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InterCompanyGoodsInTransitTotals Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:InterCompanyGoodsInTransitTotals
Everyone

7Sources