Specify the 3YC Pricing File in the Adobe instance:
The 3YC pricing file is of the same format and contains the same columns as the as the pricing file which is uploaded monthly by BSS users.
The Adobe 3YC Pricing File is required to have the following:
A column titled First Order Date
A column titled Last Order Date
No empty rows in the First Order Date column
No empty rows in the Last Order Date column
An error message will be displayed if any of these conditions is not met.
Please note that the 3YC pricing file contains only 3YC levels and tiers (12, 13 & 14, TA, TB, TC, TD, TF & TG).
Date Format
Adobe uses the UTC date offset regardless of the country of each organization. The .csv file downloaded by distributors monthly should be changed to the supported type (.xlsx or .xls) to be uploaded to the Adobe instance.
Please refer to the page https://interworkscloud.atlassian.net/wiki/spaces/ICPD/pages/830768041/Adobe+VIP+MP+Volume+Discount#Revising-the-Pricing-Excel-File for instructions on how to change the format of the related columns to Date (MDY or DMY) using the text to columns function.