meridianww / M4PLBase

0 stars 1 forks source link

Verify Return Orders Use The Return Delivery Charge #429

Open nmfujimoto opened 3 years ago

nmfujimoto commented 3 years ago

There will be 2 Delivery Charge codes for each vendor location that uses vendor location rates, one for Original orders and one for Return orders.

Example: Tri-State Precision Andrews SC vendor location (ANDREWS SC): AWC Home Delivery project uses vendor location rates for delivery charges so ANDREWS SC location will show the two charge codes in the Price/Cost tabs for the project. The differentiating part of the delivery charge code is the "OG" and "RT" seen in the NAV Items.

Delivery - 44TSPANDSCOGHDDEL Return - 44TSPANDSCRTHDDEL

nmfujimoto commented 3 years ago

Home Delivery Original - 44TSPANDSCOGHDDEL Return - 44TSPANDSCRTHDDEL   Builder Original - 44TSPANDSCOGBLDEL Return - 44TSPANDSCRTBLDEL     44 (2-character)- Customer TSP (3-character) - Vendor Company AND (3-character) - Vendor City SC (2-character) - Vendor State RT (2-character) - Order Type HD (2-character) - Channel (Home Delivery, Builder, etc.) DEL (3-character) - Type of Charge

nmfujimoto commented 3 years ago

I realized a mistake was made in NAV and the naming scheme was swapped between AWC (44) and Electrolux (50). The "BL" for builder and "OG" for original order were incorrectly swapped in the codes. I am confirming with our NAV consultant one which is the correct name.

image

nmfujimoto commented 3 years ago

Add another option to the Category drop-down in the Price and Cost forms to include "Return".

image

nmfujimoto commented 3 years ago

Update the CSV import template to include Category.

AWC Home Delivery Program Price Cost Code Import Template.xlsx