Menu Path: Electronic Data Interchange Module Setup EDI Inventory Inquiry/Advice Management
Manage inventory inquiry/advice data sent to each trading partner.
Use EDI Inventory Inquiry/Advice Management to specify products and quantities to include in inventory inquiry/advice files sent to trading partners.
NOTE If you use this window to specify products and quantities, EDI inventory inquiry/advice data is not exported for products with blank promise dates.
For information on outputting EDI inventory inquiry/advice files, see EDI Inventory Inquiry/Advice Export. If you want to update products and quantities for multiple trading partners at the same time after you set up products and quantities in this window, you can use EDI Inventory Inquiry/Advice by Product Management.
NOTE To use EDI Inventory Inquiry/Advice Management, a default location must be set up for the trading partner or all customers associated with the trading partner.
To manage EDI inventory inquiry/advice data:
Enter a trading partner trade ID or trade ID name for which you want to manage inventory inquiry/advice data in the Trade ID or Trade ID Name field. The products for which inventory information will be sent to the trading partner in EDI inventory inquiry/advice files appears in the Products grid.
Click the Update button in the ribbon.
If you want to report inventory data for additional products to the trading partner in EDI inventory inquiry/advice files, specify the products, as follows:
Select whether to add products by product, product style, or product category.
Enter a product code, product style, or product category. If you entered a product category and want to specify a specific product subcategory, clear the All Subcategories check box and enter the product subcategory.
Click the Add button. If you selected to add products by product style or product category, you are asked to confirm. Click the Yes button to confirm.
Repeat substeps a to c for all products you want to add.
If you want to remove products from EDI inventory inquiry/advice files sent to the trading partner, select the check box in the Select grid column for each product, then click the Delete Selected button in the ribbon.
Enter the inventory quantity settings for each product in the Products grid, or use the ribbon buttons to change the quantity settings.
Click the OK button in the ribbon. The EDI inventory inquiry/advice data is updated.
When you click the Recalculate Output Quantity, Reset Forecast Percent, or Reset Minimum Quantities button in the ribbon, the following processing occurs:
The software calculates an inventory advice output quantity if the minimum available inventory quantity is greater than 0. If the current quantity available is less than the minimum available inventory quantity, the inventory advice output quantity is set to 0. If the current quantity available is greater than the minimum available inventory quantity, the inventory advice output quantity is calculated as the larger of the following values:
minimum output quantity
customer forecast percentage quantity (based on the percent of monthly customer forecast and the customer forecast quantity)
Example Product A has a minimum available inventory quantity of 100 and a current quantity available of 200. The customer forecast quantity for the product is 100, the minimum output quantity is 75, and the percent of monthly customer forecast is 50%. Current quantity available is greater than the minimum available inventory quantity, so the software calculates the inventory advice output quantity as 75. This is the minimum output quantity, because it is larger than the customer forecast percentage quantity, which is 50 (.50 x 100 = 50).
The software calculates the customer forecast quantity, current quantity available, MTD units sold, YTD units sold, promise date, and expected quantities.
Note The inventory advice output quantity is not calculated for products for which the check box is selected in the Ignore Recalculation column. However, the customer forecast quantity, current quantity available, MTD units sold, YTD units sold, promise date, and expected quantities are recalculated.
Button |
Description |
Exit |
Click this button to close the EDI Inventory Inquiry/Advice Management window. |
Update |
Click this button to update EDI inventory inquiry/advice data for the selected trading partner. |
Count Detail |
Click this button to display the EDI Inventory/Inquiry/Advice Count Details for the selected product in the Products grid. |
OK |
Click this button to accept changes. This button is only available after you click the Update button in the ribbon. |
Cancel |
Click this button to cancel changes. This button is only available after you click the Update button in the ribbon. |
Select All |
Click this button to select the check box in the Select column for all products in the Products grid. This button is only available after you click the Update button in the ribbon. |
Deselect All |
Click this button to clear the check box in the Select column for all products in the Products grid. This button is only available after you click the Update button in the ribbon. |
Delete Selected |
Click this button to remove all products from the Products grid for which the check box is selected in the Select column. This button is only available after you click the Update button in the ribbon. |
Import |
Click this button to display EDI Inventory Inquiry/Advice Import, which allows you to import EDI inventory inquiry/advice data from a file. This button is only available after you click the Update button in the ribbon. |
Recalculate Output Quantity |
Click this button to recalculate output quantities for each product in the Products grid for which the check box is selected in the Select column. This button is only available after you click the Update button in the ribbon. For information on the calculations performed, see Recalculating Output Quantities. |
Reset Forecast Percent |
Click this button to recalculate output quantities and reset the forecast percentage for each product in the Products grid for which the check box is selected in the Select column. When you reset forecast percentages, the percentage in the Percent of Monthly Customer Forecast column in the Products grid is set to the percentage in the Default Percent of Monthly Customer Forecast column. Note If 0 is entered in the Default Percent of Monthly Customer Forecast column, the percentage in the Percent of Monthly Customer Forecast is calculated as the year-to-date units sold for the trading partner divided by the total year-to-date units sold for all customers. This button is only available after you click the Update button in the ribbon. For information on the calculations performed for recalculating output quantities, see Recalculating Output Quantities. |
Reset Minimum Quantities |
Click this button to recalculate output quantities and reset the minimum output quantity for each product in the Products grid for which the check box is selected in the Select column. When you reset minimum quantities, the quantity in the Min. Output Qty column in the Products grid is set to the quantity in the Default Min. Output Qty column. This button is only available after you click the Update button in the ribbon. For information on the calculations performed for recalculating output quantities, see Recalculating Output Quantities. |
Field or Button |
Description |
Enter the trade ID of the EDI trading partner for which you want to update EDI inventory inquiry/advice data, or click the Lookup button to select a trade ID. Note You can only set up EDI inventory inquiry/advice data for a trading partner if the trading partner is set up to receive EDI inventory inquiry/advice data in EDI Trading Partner Maintenance. |
|
Enter the trade ID name of the EDI trading partner for which you want to update EDI inventory inquiry/advice data, or click the Lookup button to select a trade ID name. Note You can only set up EDI inventory inquiry/advice data for a trading partner if the trading partner is set up to receive EDI inventory inquiry/advice data in EDI Trading Partner Maintenance. |
Field or Button |
Description |
Select whether to add data for products, product styles, or product categories. |
|
Enter a product code for which to add data, or click the Lookup button to select a product code. This field is only available if you select the Product radio button. |
|
Enter a product name for which to add data, or click the Lookup button to select a product code. This field is only available if you select the Product radio button. |
|
Product Style |
Enter a product style for which to add data, or click the Lookup button to select a product style. This field is only available if you select the Product Style radio button. |
Description |
This field displays the description of the selected product style. This field is only available if you select the Product Style radio button. |
Category |
Enter a product category for which to add data, or click the Lookup button to select a product category. This field is only available if you select the Category radio button. |
This field displays the description of the selected product category. This field is only available if you select the Category radio button. |
|
Select this check box to add data for all subcategories. This check box is only available if you select the Category radio button. |
|
Enter a product subcategory for which to add data, or click the Lookup button to select a product subcategory. This field is only available if you select the Category radio button, and only enabled if you clear the All Subcategories check box. |
|
Click this button to add the selected product, product style, or product category. |
|
This grid displays products for which inventory data is reported to the selected trading partner in outbound EDI inventory inquiry/advice files. If the quantity in the Inventory Advice Output Quantity column is zero for a product, the row displays in red. This grid includes the following columns:
Note This grid is cached to improve performance. You cannot sort, filter, group, graph, or summarize data in this grid. |