Access Keys:
Skip to content (Access Key - 0)

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)

IS&T Contributions

Documentation and information provided by IS&T staff members


Last Modified:

December 15, 2014

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
c-journal_voucher_uploads c-journal_voucher_uploads Delete
jv jv Delete
upload upload Delete
spreadsheet spreadsheet Delete
jv-uploads-review jv-uploads-review Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki