Product Mapping report

This report consists of 4 sub-reports:
  • Product Mappings by product category:
    With this sub-report you can correct errors in mapping, avoid duplication, and perform other troubleshooting tasks. This report gives you product mappings for a company, optionally filtered by 1 or more product mapping groups and product category.
  • Product Mappings by product code:
    This sub-report gives you product mappings for 1 or more companies, optionally filtered by product mapping group. Product Mappings get configured in
    Mapping
    .
  • Product Qualifiers:
    A sub-report with additional qualifiers set up as part of configurations. You set these preferences in
    Product Qualifiers
    . This report only generates data if you've configured the qualifier group and corresponding data.
  • Product Taxability by authority:
    This sub-report shows products that have special tax liability for 1 or more authorities. Standard product liability isn't included. Only exceptions to standard rates and rules get reported. Only custom rules data gets displayed if the report's created using product or product mapping.

Input controls and parameters

Parameter
Required
Default
Description
Company Name(s)
Yes
None
Lists all companies in the database that are available to the current user. Select one or more company names.
Product Group
Yes
None
Identify 1 of these sources of product group depending upon the company setup: Brazil, Canada, Harmonized, Independent, India GST, Non-Harmonized, and US.
Product Mapping Group
No
DEFAULT
The registration group of selected company and by default, only default group available.
Product Category Name
No
None
An optional ERP system product code that's used to trigger a product mapping.
Qualifier Group
No
None
Select 1 or more Qualifier Groups to include in the report.
Product Qualifier Date Range Type
No
None
Specifies where the date falls in the given date range.
  • Active in Range (the date is valid anywhere between start and end dates)
  • Start Date in Range (the start date falls anywhere between the start and end dates)
  • End Date in Range (the end date falls anywhere between the start and end dates)
Product Qualifier Start Date
No
None
Start date for the date range given. Enter the date or use the calendar to select the date.
Product Qualifier End Date
No
None
End date (inclusive) for the date range given. Enter the date or use the calendar to select the date.
Authority Name
No
None
An optional authority name used to filter the report.
Product Code
No
None
An optional ERP system product code used to filter the report.
Commodity Code
No
None
A commodity code associated with a product to include in the report.
Transaction Type
No
None
A transaction type code based on the selected company or companies. The transaction type code is 2 digits, but the full word is shown on the report. For example, the code GS gets reported as Goods.
Rate Code
No
None
An optional rate code used to filter the report.

Related Content