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 inMapping.
- Product Qualifiers:A sub-report with additional qualifiers set up as part of configurations. You set these preferences inProduct 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.
|
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. |