Please see detailed instructions on using the utility below along with the link to the files referenced. Your IT team should be able to access the below link and get these files setup for you to use. Let us know if you have any issues.
1. Start the Roll buy parts process in SQLManex Desktop module as you would normally
2. Run the GetRollSql.exe to export that current open cost roll into the template CostRollimport.xltx. Program will prompt to locate this file after starting program. It looks in the default directory but option exists to find the file from any shared location on the server.
3. Populate calculated cost in the Excel file created from template(will time stamp with today's date)
4. Run ImptStdCostSql.exe It will prompt to choose the Excel file(choose to locate the file you just created in step 2 and modified in step 3)
5. Open Cost Roll module in SQLManex desktop and verify that the changes have been entered and 'Use Calculated cost' checkbox is checked. Once verified or saved if additional manual changes were made in the module, Click on the roll cost button to update the costs in the inventory and generate the necessary GL transactions. This completes the cost roll import process.
In the template, the user enters the correct cost in H column.
Here is a link to the files needed for the cost rollup utility CostRollup_Utility.7z . The two EXE files should be copied into the Manex desktop folder on the server then accessed that through a network share. As stated above the template can be placed in the Same Desktop directory or another shared location on the server being used for Manex. Please test on a test environment first.