Reports

Reports Video Overview

Watch the following video and/or read the instructions to learn how to access the various reports available on the J&J Customer Connect portal.

English

There are broadly 3 report categories available to users:

Inventory Analysis

The Inventory Analysis lists all products within an order date range that are on backorder and an estimated date when the products will be delivered, when available.

In the navigation menu, select and in the additional drop-down that appears, select Inventory Analysis displayed under Reports.

On the Reports page, confirm the Account number listed is correct; you may select the Change link to select a different account to search across or the Select All Available checkbox to search across all accounts related to your user profile.

Key Tip:

If only one account is related to your user profile, the Change link will be unavailable.

Select Backorder Detailed Report from Report Type pick-list. This will be the default selection.

You may check the box to Show all backorders for selected account(s), if desired.

Deselect the Show all backorders checkbox, then set the Start and End dates to determine the timeframe you want to limit your search to.

Key Tip:

When you first start using the J&J Customer Connect portal, you will be able to see reports on orders up to 1 month back. As more orders are placed subsequently (via the portal or any other channel), you will be able to run reports on these orders as well. If you require information on older orders, please contact your Johnson & Johnson Customer Service Representative.

You may choose to filter the report by a specific Product Code or Order Type.

You can download the report in Excel format if desired.

Select the Generate Report button to execute your search and display your report results.

Within the Generated Report results, review the Estimated Delivery Date column, which displays the estimated delivery date when available.

Important Information:

Schedule Line No. is a field that represents the delivery schedule for the ordered products. The first Schedule Line No. 001 is created in accordance with the customer’s Requested Delivery Date. In the event of a backorder or unavailability, multiple lines are created to fulfill the order as and when available.

Select the Reset button to clear the search results and reset all search fields to default.

Order Analysis

The Order Analysis report can be used by customers to review status and tracking information related to their orders.

There are two types of Order Analysis reports:

The Sales Report: Sales Report allows you to view the status of each line, including if a block has been applied to the order.
The Delivery List: Delivery List allows you to track your orders to see when each order line has been shipped and the delivered quantity.

You can generate reports on your orders between a selected time frame, and filter the list by various available criteria. You can also drill down to perform a detailed analysis of activity over time or constrain the results to a single product.

Sales Report

Follow these steps to generate a Sales Report:

In the navigation menu,select Order Analysis displayed under Reports.

Key Tip:

If only one account is related to your user profile, the Change link will be unavailable.

Select Sales Report from Report Type pick-list.

Set the Start and End Dates to define the time frame that you want to limit your search to.

Key Tip:

The availability of order history will vary according to when you start using the portal. For details on an order that precedes the order history available, please contact your Johnson & Johnson Customer Service Representative.

You can choose to filter the search criteria by Status, Order Type, and Franchise Description from the respective pick-lists, if desired.

Key Tip:

Please refer to the FAQs (Reports section) for a description of each of the Statuses.

You may choose to search for a specific order by entering the Customer PO Number or the Sales Document Number in the provided fields.

Important Information:

Please do not use the Pipe delimiter “|” in the Customer PO Number field, as this is not recognized as a valid character in the system. To search for multiple PO Numbers, you may separate them by commas (no spaces).

You may also choose to search for orders for a certain product by entering the Product Code in the search criteria provided.

Select how you would like the search results to be displayed (e.g., First 10, First 25 ) in the Show pick-list, if desired.

You may choose to download a report in Excel format by clicking on the XLS link.

Select the Reset button to clear the search results and reset all search fields to default.

Select the Generate Report button to execute your search.

Delivery List

Follow these steps to generate a Delivery List:

In the navigation menu, select Order Analysis under Reports.

On the Reports page, confirm the Account number listed is correct; you may select the Change link to select an additional or different account to search across or the Select All Available checkbox to search across all accounts related to your user profile.

Key Tip:

If only one account is related to your user profile, the Change link will be unavailable.

Select Delivery List from Report Type pick-list.

Set the Start and End Dates to define the time frame that you want to limit your search to.

Key Tip:

You can choose to filter the search criteria by Order Type and Franchise Description from the respective pick-lists, if desired.

You may choose to generate a report for a specific order by entering the Customer PO Number or the Sales Document Number in the provided fields, or look up a specific delivery by entering a Delivery Number.

Important Information:

You may also choose to search for orders for a certain product by entering the Product Code in the search criteria provided.

Select how you would like the search results to be displayed (e.g., First 10, First 25) in the Display pick-list, if desired.

You may choose to download a report in Excel format by clicking on the XLS link.

Select the Reset button to clear the search results and reset all search fields to default.

Select the Generate Report button to execute your search.

Financial Analysis

Customers can use this analysis to run reports on their invoices and to check the payment status.

In the navigation menu, select Financial Analysis under Reports.

Key Tip:

If only one account is related to your user profile, the Change link will be unavailable.

Select Invoice Report from Report Type pick-list. This will be the default selection.

Set the Start and End dates.

Key Tip:

You may choose to filter the report by a specific Customer PO Number, Sales Document Number, Franchise Description, and Order Type.

Important Information:

Please do not use the Pipe delimiter "|" in the Customer PO Number field, as this is not recognized as a valid character in the system. To search for multiple PO Numbers, you may separate them by commas (no spaces).

You can download the report in Excel format if desired by clicking on the XLS link.

Select the Generate Report button to execute your search and display your report results.

Within the Generated Report results, you can review the Invoiced Quantity and Total Price of the invoice, as well as the Paid Amount and Open Amount.

Country-specific Functionality:

For Taiwan Customers, the Billing Document Number displayed in the Financial Analysis report is not an internal J&J number, but the Government Uniform Invoice reference number.

Select the Reset button to clear the search results and reset all search fields to default.

Important Information:

When any report is run, users will be able to view orders placed via any channel, not limited to J&J Customer Connect^™.