Sales forecast Monthly Upload Problem through DTW

[Former Member]

Hi Experts,

when i am uploading sales forcast through DTW into system, the system upload the sales forecast successfully but in VIew of (Days) not in month. I have seen many thread regarding this issue in Portal, but didn't get the proper answer. Please expert let me know the solution of this problem as i need to upload the forecast month wise into system.

Regards,

Sham Vithal

[jessie_ng2]

Hi,

My SAP B1 version is 8.8 SP0 PL11.

I am able to upload the Sales Forecast by Weeks as well as by Months.

Here is my upload file for OFCT by Monthly

Numerator,ForecastStartDate,ForecastEndDate,ForecastCode, ForecastName,View

Numerator,StartDate,Enddate,Code,Name,Formview

1,20100101,20100331,F1,F1,M

Here is my upload file for FCT1 by Monthly

ParentKey,LineNum,Quantity,ForecastedDay,ItemNo

Numerator,LineNum,Quantity,Date,ItemCode

1,0,100,20100101,Item1

1,1,100,20100201,Item1

1,2,100,20100301,Item1

1,3,100,20100101,Item2

1,4,100,20100201,Item2

1,5,100,20100301,Item2

I am able to create the new forecast via DTW.

But my problem is I cannot update the same forecast via DTW.

Anyone has any suggestions?

Regards

jessie

[Former Member]

Hi Jessie:

If you want update Sales Forecast, you must add absID value in Numerator field in the template.

For Example:

Using SQL Query

Select * From OFCT

AbsID Code Name UserSign StartDate EndDate FormView

45 F500 F500 60 2011-05-01 00:00:00.000 2011-06-30 00:00:00.000 M

45 Is numerator value in template. But, you must check UPDATE in the DTW.

Cheers!

Edited by: Ezequiel Sosa on Feb 15, 2011 5:08 PM

[Former Member]

Hi,

Please add 1 more column to the template:

G1: View

G2: View

the valid value are:

- fvtDaily

- fvtWeekly

- fvtMonthly

Please make sure that you put the first date of any month as your "ForecastedDay" if you wanted to be monthly sales forecast.

Cheers

[ashutosh_tomar]

Hi Vital,

Yeni is correct, Thats what i was supposed to give you:

RecordKey	LineNum	ForecastedDay	ItemNo	Quantity	*View*
RecordKey	LineNum	ForecastedDay	ItemNo	Quantity	*View*
1	          0    20100601         MRP      100          fvtMonthly
1	          1    20100601         test	 200          fvtMonthly
1	          2    20100601         batch    300          fvtMonthly

Hope this will help you

Best Regards

Ashutosh

Edited by: Ashutosh T on Jun 23, 2010 10:13 AM

[ashutosh_tomar]

Dear Mr. Vithal Sham,

In Forecasting DTW template we only have to put forecasting date. When system imports it, this by default goes to {days View}

To see the forecast on or Basis, We needs to change the view option at Forecasting screen.

Regards

Ashutosh T

[Former Member]

Dear Ashutosh,

Can give me any example of template, However i need to upload this sales forecast as monthly basis, so can you provide me a Docs and lines template with example.

Regards,

Sham Vithal