Report Add-on Distribution Analysis

Access

This report displays information on variances between estimated landed add-on costs and actual landed add-on costs. Note that all records that fit the selection criteria appear in the report, regardless of whether the Distribute Add-on Receiving Costs process was used to distribute add-on costs to that receipt. Once the report criteria have been selected, click Run to produce the report.

 For credit Warehouse receivings, the program adjusts receipt quantities accordingly.  

Report Type

Start DateTo restrict the report results to only those receipts that occurred after a selected date, enter the date here. If you click on the Calendar Icon, you can select a date from the calendar that appears.

End DateTo restrict the report results to only those receipts that occurred after a before date, enter the date here. If you click on the Calendar Icon, you can select a date from the calendar that appears.

Model NumberEnter one or more model numbers to which you want to restrict the results of the report.  If you click on the Search button, the Search for a Product window appears from which you can select one or more model numbers. If you click on the Action button, the Multiple Product Selection Window appears from which you can select one or more model numbers. If you leave the field blank, all model numbers are eligible for selection.

Note that if you enter one or more model numbers here, you inactivate the Product Group and Product Category fields.

Group NumberEnter one or more product groups to which you want to restrict the results of the report.  If you click on the Search button, a list of product groups appears from which you can choose one or more.  If you click on the Action button, the Multiple Group Selection Window appears from which you can select one or more groups. If you leave the field blank, all product groups are eligible for selection.

Note that if you enter one or more product groups here, you inactivate the Model Number and Product Category fields.

CategoryEnter one or more product categories to which you want to restrict the results of the report.  If you click on the Search button, a list of product categories appears from which you can choose one or more.  If you click on the Action button, the Multiple Category Selection Window appears from which you can select one or more product categories. If you leave the field blank, all product categories are eligible for selection.

Note that if you enter one or more product categories here, you inactivate the Model Number and Product Group fields.

VendorEnter one or more vendors to which you want to restrict the results of the report.  Enter the vendor associated with the purchase order (which is not necessarily the vendor associated with the product). If you click on the Search button, the Vendor Name Search appears from which you can choose.  If you click on the Action button, the Multiple Vendor Selection Window appears from which you can select one or more vendors. If you leave the field blank, all vendors are eligible for selection.

CountryEnter one or more countries to which you want to restrict the results of the report.  Enter the country associated with the receiving vendor.  If you click on the Search button, a list of countries appears from which you can choose one or more.  If you leave the field blank, all countries are eligible for selection.

Report

• Add-On Cost - the amount of add-on cost distributed to the receipt for the invoice.

• Tot Add-On - the total of the Add-On Cost column for this receipt.

• Invoice Percent - the percent of the Add-On Cost relative to the Receipt Cost.

• Total Percent - the percent of the Tot Add-On column relative to the Receipt Cost.

• Type - the type of calculation used by the add-on costs (either D for a set dollar amount or P for a percentage).

• Current Add-On - the current dollar or percentage used to calculate the add-on costs at receiving time.

• Variance Percent - the percentage greater or less than that the Total Percent is in relation to the Current Add-On percent.