SAPgui JV Upload error messages - Macintosh users should save spreadsheet as "Windows Formatted Text"

Note: this article refers to the SAPgui JV upload function. The preferred method is to use the JV upload feature in Atlas instead.

• The steps detailed here may be needed in order to accommodate SAP requirements for the tab delimited format required for JV uploads (ZJVA, ZJVI, ZJVX).
• Some tab delimited files, created in applications other than Excel, such as FileMaker or other custom applications) are not able to be parsed by SAP.
• In these files, the new line formatting is not recognized by SAP.

For more information on formatting rules, see: http://web.mit.edu/sapr3/docs/webdocs/finop/ip/foIPupload01.html
For Internal Provider Billing procedures, see: http://web.mit.edu/sapr3/docs/webdocs/finop/ip/foIP.html

Solutions

Option 1: Open in Excel, change the date format, save as Tab Delimited Text.

1. Open the file in Excel 2008 or Excel 2011.
2. Select the transaction date column (column E), then follow the menu path Format >> Cells.
3. From the formats on the left, choose Custom.
4. Enter format mm/dd/yyyy.
   Contact the Computing Help Desk, at helpdesk@mit.edu, with any questions.
5. Follow the menu path File > Save As.
6. From the Format drop down, select Windows Formatted Text (.txt)

Option 2: Open in Excel, change the date format, save as Windows Formatted Text.

1. Open the file in Excel 2008 or Excel 2011.
2. Format the date column to use mm/dd/yyyy format. You may need to create a Custom format in Excel. Contact the Computing Help Desk, at helpdesk@mit.edu, with any questions.
3. Follow the menu path File > Save As.
4. From the Format drop down, select Tab Delimited Text (.txt)