import sales forecast from EXCEL sheet.

washbowl

Hi All. My client wants to import sales forecast from EXCEL sheet. Navision gets import/export function in sales budget, but the same feature does not exist in sales forecast granule. I can use dataport, however it does not support the common forecast format looks like follows:

---

Jan Feb March April......................
item a
item b
item c
........

Does anyone have suggestion on how to do this? Or if I import Excel to sales budget, can I copy the budget to forecast, as these two granuls look very similar.

Many thanks.

martensens

Hi,

1. form excel sheet to ascii file, produce dataport and import details
2. use recordset ExcelBuffer (370) to import from excelsheet.

Navision has no special function for this job.

Regards/martensens

washbowl

martensens wrote:

Hi,

1. form excel sheet to ascii file, produce dataport and import details
2. use recordset ExcelBuffer (370) to import from excelsheet.

Navision has no special function for this job.

Regards/martensens

Thanks martensens. I don't tend to use dataport. As I mentioned, ususally forecast has one item per line and each column refers to different period. while dataport can only support multiple lines for different dates for the same item.

what is ExcelBuffer (370)? is it a codeunit? I can't find it. Can it support the format that I required?

bbrown

Excel Buffer is table 370. See GL Budgets for an example of its use. Also search here. You'll find lots of information.