Problem Statement: Customer is getting Decimal error while importing data through the Configuration package template.
Resolution: The error comes when someone has changed something in the package / template but forgot to change the same in the file. The best option is to make a new Configuration Package Card to avoid any confusion.
Steps:
- Open configuration package
- Go to Navigation Path > SEARCH ENGINE > write "CONFIG" in the search
- Click on configuration package
- To make a new Configuration Package Card:
- Click on New Button
- Write Code name and package name in the General header
- In the line, select table id from lookup or write the table id manually if you remember the Id.
- On the Line Header, click on Table then click on Fields button below to select the only mandatory fields from table on general journal lines.
- Edit the page.
- It will open General Journal Line.
- Click on Edit List button and select the mandatory fields then click OK
- Come out of the page.
- Then click on Export to Excel function
- A excel template will generate with table fields and data (if exists).
- Save that excel in your local drive
- Open the excel and clear all the data (of general journal lines) within the excel template.
- Enter your data in the excel template
- Re-Import the Template in the System
- To Re-import, go to the Package and click on "import from Excel" button to import the template.
- System will ask you to choose the file.
- Browse your file that you just edited.
- the below page will open where you have to click on the Import button (at the top) to import.
- On the next page, system will show the data as per the screen shot below:
- No. of package records will appear that you entered in your template. Verify the records
- Click on the Process button and then click Apply package
- System will then remove the existing records from the configuration package and generate the new general journal lines automatically.
- You are done.
No comments:
Post a Comment