Method 1Go to the Fiscal Periods Setup window to see how the names for the periods are listed. If they are in date format, change them to Period 1, Period 2, etc. To do this click on Tools on the Microsoft Dynamics GP menu, point to Setup, point to Company and click Fiscal Periods. Then enter the new matching fiscal period names such as Period 1, Period 2, etc. on the import file. Save and retest the import.
Method 2Change the period headers in the Excel worksheet to a text format. To do this, follow these steps:
- In the Excel worksheet, highlight all the column headers for the periods.
- On the Format menu, click Cells.
- On the Number tab, click Text in the Category list.
- Click OK.
- If the cells are changed to numbers, re-enter the period headers to match the fiscal period setup.
NOTE: Or put a single apostrophe before each column header name to force it to be text.
Id. de artículo: 927700 - Última revisión: 29 mar. 2017 - Revisión: 2