Infor SyteLine Financials User Guide

1 Infor SyteLine Financials User Guide Copyright 2014 Infor Important Notices The material contained in this publication (including any supplementary information) constitutes and contains confidential and proprietary information of Infor . By gaining access to the attached, you acknowledge and agree that the material (including any modification, translation or adaptation of the material) and all copyright, trade secrets and all other right, title and interest therein, are the sole property of Infor and that you shall not gain right, title or interest in the material (including any modification, translation or adaptation of the material) by virtue of your review thereof other than the non-exclusive right to use the material solely in connection with and the furtherance of your license and use of software made available to your company from Infor pursuant to a separate agreement, the terms of which separate agreement shall govern your use of this material and all supplemental related materials ("Purpose").

2 In addition, by accessing the enclosed material, you acknowledge and agree that you are required to maintain such material in strict confidence and that your use of such material is limited to the Purpose described above. Although Infor has taken due care to ensure that the material included in this publication is accurate and complete, Infor cannot warrant that the information contained in this publication is complete, does not contain typographical or other errors, or will meet your specific requirements. As such, Infor does not assume and hereby disclaims all liability, consequential or otherwise, for any loss or damage to any person or entity which is caused by or relates to errors or omissions in this publication (including any supplementary information), whether such errors or omissions result from negligence, accident or any other cause.

3 Without limitation, export control laws and other applicable export and import laws govern your use of this material and you will neither export or re-export, directly or indirectly, this material nor any related materials or supplemental information in violation of such laws, or use such materials for any purpose prohibited by such laws. Trademark Acknowledgements The word and design marks set forth herein are trademarks and/or registered trademarks of Infor and/or related affiliates and subsidiaries. All rights reserved. All other company, product, trade or service names referenced may be registered trademarks or trademarks of their respective owners. Table of Contents About Accounts .. 1. Account Number Setup .. 1. Control Accounts .. 2. Currency Translation Methods.

4 2. About Control Accounts .. 3. A/R A/P Offset Overview .. 3. Accounts Payable (A/P) .. 5. Accounts Payable Setup .. 5. Accounts Payable Steps .. 6. Creating a Debit Memo for an A/P Transaction .. 7. Deleting A/P Posted 8. Paying for Purchases with a Credit Card .. 8. Posting Electronic Funds Transfer Transactions .. 8. Setting Up Electronic Funds Transfer for A/P .. 9. Electronic Funds Transfer Output 10. A/P Payments .. 11. Creating a Manual 11. Creating a Standard Draft .. 11. Distributing Vendor Payments Manually .. 12. Generating Automatic Payments .. 13. Paying Finance Charges .. 14. Posting A/P Wire Transactions .. 14. Posting to the A/P Distribution Journal .. 15. Preparing a Bank Reconciliation .. 16. Preparing a Bank Reconciliation Using Transfer VAT .. 17.

5 Printing and Posting Checks .. 17. Printing and Posting A/P 18. Using A/P Quick Payment Application to Reapply Open Payments .. 19. Using A/P Quick Payment Application to Enter and Apply Full and Partial Payments .. 20. Using the A/P Quick Payment Application to Enter and Distribute an Open Payment .. 22. Voiding Posted Checks .. 24. Voiding Posted 25. 26. Activating Voucher Authorization .. 26. Authorizing Vouchers .. 27. Creating Recurring Vouchers .. 28. v Infor SyteLine Financials User Guide Creating Vouchers or Adjustments .. 29. Creating Vouchers or Adjustments 31. Distributing Recurring Vouchers .. 33. Creating Vouchers with the Manual Voucher Builder .. 35. Distributing Vouchers and Adjustments .. 36. Generating Vouchers .. 38. Generating Landed Cost 39. Generating Recurring Vouchers.

6 41. Posting Vouchers - 41. Printing and Posting Vouchers .. 42. Purging Voucher History .. 43. Voucher Pre-Register Overview .. 43. Accounts Receivable (A/R) .. 47. Accounts Receivable Steps .. 47. About A/R Posting .. 47. About Credit for Returns .. 48. Determining How Much Credit to Issue .. 48. Printing and Posting the Credit .. 49. Adjustments Calculated by the System .. 50. About Rebate Programs .. 50. Chargebacks Overview .. 51. Clearing Offsetting Open Items in Accounts Receivable .. 51. Reapplying an Open Debit or Credit to One Invoice .. 51. Reapplying an Open Credit to More Than One 52. Closing the Year for Accounts Receivable .. 52. Deleting A/R Posted Transactions .. 53. Using Chargebacks Functionality .. 54. Invoice, Credit or Debit Memo .. 54. About Multiple Due Dates for Invoices and Debit Memos.

7 54. Canceling Drafts .. 58. Distributing Invoices .. 59. Posting Invoices, Debit Memos, and Credit Memos .. 60. A/R Payments .. 61. Accepting Customer Payments in the Euro Currency .. 61. Adjusting a Payment .. 61. Creating Open Payments for a 63. Distributing Customer 64. Entering Customer Payments .. 67. vi Table of Contents Processing Returned 68. Finance Charges .. 71. How the System Calculates Finance Charges .. 71. Multi-Site A/R Finance Charge 71. Importing Electronic A/R Payments .. 74. A/R Import Mapping - Header .. 79. A/R Import Mapping - Groups .. 80. A/R Payment Import Field Mappings .. 80. A/R Payment Import Conversions .. 81. Quick Payment Application .. 81. Scenario 1 .. 85. Scenario 2 .. 85. Scenario 3 .. 86. Scenario 4 .. 86. Scenario 5 .. 86. Scenario 6.

8 87. Scenario 7 .. 87. Scenario 8 .. 88. Scenario 9 .. 89. Scenario 10 .. 89. Posting A/R Draft Payments .. 90. Posting Payments .. 90. Purging Drafts .. 91. Purging Invoice History .. 92. Reapplying Open Payments and Credits for Customers .. 92. Reapplying Open Payments or Credits Against Multiple Invoices .. 93. Running the Accounts Receivable Aging Report .. 93. Running the AR Balance History 94. Creating and Maintaining Budgets and Plans .. 95. Consolidation Overview .. 97. Entities .. 97. Sites Reporting to an Entity .. 97. Setup of Entities and the Reporting 98. Defining the Hierarchy .. 98. Changes to Your Reporting Structure .. 98. Additional Notes .. 99. Currency .. 99. Combined vs. Consolidated Reporting .. 99. vii Infor SyteLine Financials User Guide Unit Code 100.

9 Budget Consolidation .. 100. Generating a Positive Pay File .. 101. Create the 101. Define Fields .. 101. Generate the File .. 102. Invoice Builder Overview .. 102. What Happens When You Use This Form .. 103. Using the Invoice Builder .. 105. Setup .. 105. Generate and Print an Invoice or Credit Memo .. 105. Currency .. 107. About the Euro Triangulation Conversion .. 107. Converting the Domestic Currency to the Euro .. 108. Converting a Multi-Site Installation .. 109. About Realized and Unrealized Gains and 109. Realized Currency Exchange Gains and Losses .. 110. Unrealized Currency Exchange Gains and Losses .. 113. Consolidated Financial Statements with Foreign Subsidiaries .. 114. Revaluing Assets and Liabilities for the 114. External Financial Interface .. 117. Setting Up an External Financial Interface.

10 117. Setting Up an External Financial Interface ( SyteLine to External Financial System).. 117. Setting Up an Incoming Financial Interface (External System to SyteLine ) .. 122. Updating SyteLine Data from Data in an External Financial Application .. 123. Financial Statements .. 125. Financial Statement Setup .. 125. Designing Your Financial 125. Creating Your Financial Statement .. 126. About Dates in Financial Statements .. 126. Creating Financial Statements with Statistical Information .. 127. Creating Statistical 127. Gathering Statistical Information .. 128. Printing a Financial Statement .. 129. Troubleshooting Financial Statements .. 130. Net Income Not Correct .. 130. Retained Earnings Not Correct .. 131. viii Table of Contents Statements are Not Picking Up Correct 131.