Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace:
app:app_jrnl_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

app:app_jrnl_import [2019/05/08 00:24]
dtucker created 		app:app_jrnl_import [2019/07/23 21:23] (current)
dtucker
Line 3: Line 3:
 The Journal Voucher Import module will allow users to work in Excel (xls or xlsx) and eventually develop a journal entry that mimics the following layout. The file can contain as many tabs/sheets as preferred, however, the first sheet should be named “JV” and follow the below layout The Journal Voucher Import module will allow users to work in Excel (xls or xlsx) and eventually develop a journal entry that mimics the following layout. The file can contain as many tabs/sheets as preferred, however, the first sheet should be named “JV” and follow the below layout
  
-{{:app/image773.jpeg?728x108}} +<WRAP center round info> 
- +Microsoft Excel **must** be installed to utilize this feature. 
-**Note** - Microsoft Excel **must** be installed to utilize this feature. +</WRAP>
- +
-{{:app/image63.jpeg?723x54}} +
- +
-**Note -** The rows/columns should not be altered. Rows 15 down can contain anywhere between 2 and unlimited rows. +
  
 +<WRAP center round info>
 +The rows/columns should not be altered. Rows 15 down can contain anywhere between 2 and unlimited rows.
 +</WRAP>
  
 **Figure 1 - Example Excel Document** **Figure 1 - Example Excel Document**
Line 17: Line 15:
 {{:app/image774.jpeg?772x524}} {{:app/image774.jpeg?772x524}}
  
-{{:app/image553.jpeg?723x73}}**Note** - The Journal Voucher Import template spreadsheet is located in the APP application installation directory.+<WRAP center round info> 
 +The Journal Voucher Import template spreadsheet is located in the APP application installation directory. 
 +</WRAP>
  
- +  *  Click the SAP menu option titled <color #22b14c>**Journal Voucher Import**</color> under the <color #22b14c>**Financials**</color> menu to load the **Journal Voucher Import** screen.
- +
- Click the SAP menu option titled **Journal Voucher Import** under the **Financials** menu to load the Journal Voucher Import screen.+
  
 {{:app/image775.jpeg?407x268}} {{:app/image775.jpeg?407x268}}
  
- Click the **Browse** button to launch a Windows file search screen.+  *  Click the <color #22b14c>**Browse**</color> button to launch a Windows file search screen. 
 +  *  Select your Excel file and click the <color #22b14c>**Open**</color> button.
  
- Select your Excel file and click the **Open** button.+<WRAP center round info> 
 +The Excel file should **not** be open at the time that it is selected for importing. 
 +</WRAP>
  
-{{:app/image63.jpeg?723x54}} +<WRAP center round info> 
- +On click of the <color #22b14c>**Open**</color> button, the module will scan the file and check for any data that would prevent posting. 
-**Note -** The Excel file should **not** be open at the time that it is selected for importing. +</WRAP>
- +
-{{:app/image776.jpeg?731x54}} +
- +
-**Note -** On click of the **Open** button, the module will scan the file and check for any data that would prevent posting.+
  
 {{:app/image777.jpeg?406x279}} {{:app/image777.jpeg?406x279}}
Line 41: Line 38:
 **Header** **Header**
  
- Posting Date falls into an unlocked accounting period and is not blank +  *  Posting Date falls into an unlocked accounting period and is not blank 
- +  *  Due Date and Doc Date are within the valid date ranges in the period associated with the Posting Date. If left blank, they will be set to the Posting Date 
- Due Date and Doc Date are within the valid date ranges in the period associated with the Posting Date. If left blank, they will be set to the Posting Date +  *  Ref 1 and Ref 2 is <= 100 characters. OK if blank. 
- +  *  Ref 3 is <= 27 characters. OK if blank. 
- Ref 1 and Ref 2 is <= 100 characters. OK if blank. +  *  Transaction code is either blank or a valid code from OTRC table. 
- +  *  Remarks are <= 50 Characters 
- Ref 3 is <= 27 characters. OK if blank. +  *  Reversing is either R or blank 
- +  *  If Reversing is R, then the Reversing Date is mandatory and should be after the posting date.
- Transaction code is either blank or a valid code from OTRC table. +
- +
- Remarks are <= 50 Characters +
- +
- Reversing is either R or blank +
- +
- If Reversing is R, then the Reversing Date is mandatory and should be after the posting date.+
  
 **Lines** **Lines**
  
- GL Account is an active, postable account +  *  GL Account is an active, postable account 
- +  *  Sum of amounts rounded to the nearest .01 = 0 (in balance). Note, this field can be formulas or formulas that reference other fields in other tabs within the workbook, however the add-on will round the results to the nearest .01. 
- Sum of amounts rounded to the nearest .01 = 0 (in balance). Note, this field can be formulas or formulas that reference other fields in other tabs within the workbook, however the add-on will round the results to the nearest .01. +  *  Ref 1 and Ref 2 is <= 100 characters. OK if blank. 
- +  *  Ref 3 is <= 27 characters. OK if blank. 
- Ref 1 and Ref 2 is <= 100 characters. OK if blank. +  *  Transaction code is either blank or a valid code from OTRC table. 
- +  *  Remarks are <= 50 Characters 
-Ref 3 is <= 27 characters. OK if blank. +  *  Project code is an active, valid project code (in OPRJ table)
- +
- +
- +
- Transaction code is either blank or a valid code from OTRC table. +
- +
- Remarks are <= 50 Characters +
- +
- Project code is an active, valid project code (in OPRJ table) +
- +
-{{:app/image778.jpeg?723x79}} +
- +
-**Tip** - Excel files can be opened to correct the data. Close the file and click the **Validate** button to recheck the file data. If there are no errors, the **Import** button will be enabled.+
  
- Clicking the **Import** button will import the contents of the Excel file to an unposted Journal Voucher in SAP® Business One.+<WRAP center round tip> 
 +Excel files can be opened to correct the data. Close the file and click the <color #22b14c>**Validate**</color> button to recheck the file data. If there are no errors, the <color #22b14c>**Import**</color> button will be enabled. 
 +</WRAP>
  
-{{:app/image6.jpeg?10x10}} In addition, the Journal Voucher import action will attach the source Excel file to the Journal Entry within the Voucher via a new UDF named U_TWBS_APP_FILELINK. This will make a copy of the JE file to the SAP® Attachments folder and follow through to the Journal Entry when the Voucher is posted.+  * Clicking the <color #22b14c>**Import**</color> button will import the contents of the Excel file to an un-posted Journal Voucher in SAP® Business One. 
 +    * In addition, the Journal Voucher import action will attach the source Excel file to the Journal Entry within the Voucher via a new UDF named U_TWBS_APP_FILELINK. This will make a copy of the JE file to the SAP® Attachments folder and follow through to the Journal Entry when the Voucher is posted.
app/app_jrnl_import.1557289462.txt.gz · Last modified: 2019/05/08 00:24 by dtucker

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki