Linking Plans and Actuals Through AutoNumber in Data Load
Hello,
I've ran into a problem as I've tried putting sales plans into my data load. Currently I am using an AutoNumber function to create a link between actuals and plans.
AutoNumber(StoreId & CalendarDate) as PlanLinkId,
The problem I run into is that not every store will have activity for every CalendarDate. Because of this, the auto generated link is not created and portions of the plans are not able to link. Does anyone have a solution for this?
Thank you! Mark's solution worked for what I needed on this but I believe I have another use for the link you just showed me. I appreciate all the help!
