Recurring Contract Billing Importer
Contents
1. Do you have any feedback or comments about this product We value your opinion Please send your comments to encore encorebusiness com 32 RECURRING CONTRACT BILLING IMPORTER About Encore Business Solutions Encore Business Solutions Inc is part of a worldwide network of independent partner organizations that sell implement and support the award winning products of Microsoft Business Solutions Encore is also an authorized Solution Developer for Microsoft Business Solutions developing and marketing industry specific software worldwide that tightly integrates to core modules of Microsoft Dynamics GP We are 100 dedicated to developing client focused reliable industry specific solutions and companion applications providing total end to end solutions that meet the operational and reporting needs of our customers The Encore Business Solutions Inc suite of products include Project Tracking Solutions Project Tracking with Advanced Analytic Project Tracking with Budgeting Project Tracking Importer Billing Solutions e Recurring Contract Billing Recurring Contract Billing Importer Bank Reconciliation Solutions Auto Reconciler e Account Reconciler Additional Encore Products e Advanced SmartList DexToNET Enhanced Customer Statement Inventory I O Control GST PST Distribution If you have questions regarding any Encore product or service feel free to contact us Toll free 888 898 4330 North America onl2. L 2 Enter the Import Setup ID for the Contract Header file The Import ID must contain the following fields e Contract Number Customer ID must be an existing customer in the Microsoft Dynamics GP e Site ID Either include the Site ID in the file which will appear in the top scrolling window OR enter a constant value in the Constant Values window RECURRING CONTRACT BILLING IMPORTER 27 CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER 3 To auto number the contracts mark the Auto Number Contracts check box 4 Enter the file and path for the Header text file The contract header text file must contain the Contract Number field 5 Choose Import The contract header file will be imported m Recurring Contract Importer File Edit Tools Help sa Dextordnary Inc 02 28 2008 Save X Delete Z Dear Ba Import 3 Import Setup ID TESTI Description Lines Contract File Contract Line Items Y 5 File Type Tab Delimited v Constant Values File Namz Palh R Irtemal Produsts Aecurring Contract Billing T esting basic txt leal Impert Fields El Type Format width ltem Nunber String 30 Markdown Amount Curency with decimal 14 Quantity Numeric with decimal 15 0 v N Ste ID Default Item Number Quantity Unt Price Description Price leve Markdown Extended Prce Line Item Frequency Stat Dade EndDate Next BillDate Co
3. When Billing Frequency is Monthly or Bimonthly Quarterly Semiannually Annually Day of the month for the Next Bill Date 4 Billing Frequency Monthly or from Header if specified 1 daily 2 weekly 3 biweekly 4 monthly 5 bimonthly 6 quarterly 7 semiannually 8 annually 9 one time 10 user defined 5 Comment ID None 6 Continuous Billing False or from Header if specified O false 1 true 7 Contract Number REQUIRED 8 Contracted Price False Set to false if not using item price O false 1 true 9 Cost of Sales Account From Microsoft Dynamics GP Use GL account lookup 10 Item Description From Microsoft Dynamics GP Overrides description from item if entered Enter this if this is a non inventory item 11 Item Number REQUIRED Even if non inventory item 12 Last Billed Date None Must be on or before Bill Start Date 13 Markdown Amount 0 14 Markdown Percentage 15 Markdown Type 0 Percentage 1 Amount 16 Next Bill Date Bill Start Date Cannot precede start date cannot be null RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER Field Default Values 17 Non Inventory Item False Set to true for any item which does not have an Inventory Card setup Price Level pricing unavailable for non inventory item O false 1 true 18 Number of Payments Enter only if the contract is for a
4. t include Frequency it will default to Monthly Obtain reports of imported data and data inconsistencies 2 RECURRING CONTRACT BILLING IMPORTER Symbols and conventions This manual uses the following symbols and conventions to make information stand out Symbol Convention Description The warning symbol indicates situations you should be especially aware of when completing tasks Typically this symbol includes cautions about performing steps in their proper order or important reminders about how other information may be affected V The light bulb symbol indicates helpful tips shortcuts and suggestions File gt gt Print The gt gt symbol indicates selections to make from a menu In this example from the File menu choose Print Additional resources Documentation is provided in online or hard copy format as an Adobe Acrobat PDF file Online help is not available for this version of Recurring Contract Billing Importer To obtain product support services Please refer to this quick reference table when you need to use Encore s Technical Support services Service Contact General Calls 204 989 4330 Toll Free North America only 866 472 0824 Fax 204 235 2331 E mail support encorebusiness com Web www encorebusiness com RECURRING CONTRACT BILLING IMPORTER 3 4 Before You Call Support You should have the answers
5. ID Constant Vall s dia oerte ene e de re ev REO Ce teer Contract Header een nn 20 Update Contract Header iii ee ee nete ais 21 Contract Line Item file fields na nnnnne 22 Update Contract Line Items aaa nahua nennen enne nennen 23 Default Values Importing data using the single text file import method sss 24 Importing data using the double text file import method 26 What s New in RCB Importer for 10 0 SP3 31 What s New RCB Importer for 10 0 32 Known Issu es eee bte rene 32 New Encore 32 Documentation Feedback 1 1 2 127 seen 32 About Encore Business Solutions eese 33 RECURRING CONTRACT BILLING IMPORTER iii CONTENTS iv RECURRING CONTRACT BILLING IMPORTER INTRODUCTION Introduction The Recurring Contract Billing Importer RCB Importer allows you to import data needed to set up contracts from data input text files This is especially useful if you re moving to Microsoft Dynamics GP from an older system or if you use an external Customer Relationship Management system to gather contract information Before being brought into Recurring Contract Billing the data is exported from the original system to a simple text file either fixed field comm
6. None 9 Contract Number In text file or auto number 10 Contract Status Active 1 active 2 inactive 3 hold 4 expired this status cannot be set through the importer 11 Currency ID System default 12 Customer ID REQUIRED 13 Deferral Profile Group None The Microsoft Dynamics GP Deferral module must be installed before import deferral profile groups 14 Freight Amount 0 15 Last Billed Date None 16 Misc Amount 0 17 PO Date None 18 PO Number None 19 Payment Terms ID From Customer Maintenance Card 20 RCB User Defined Text 1 None 21 RCB User Defined Text 2 None 22 RCB User Defined Text 3 None 23 RCB User Defined Text 4 None 24 RCB User Defined Date 1 None 25 RCB User Defined Date 2 None 26 RCB User Defined Date 3 None 27 RCB User Defined Date 4 None 28 RCB User Defined Numeric 1 None 20 RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER Field Default Values 29 RCB User Defined Numeric 2 None 30 RCB User Defined Numeric 3 None 31 RCB User Defined Numeric 4 None 32 RCB User Defined Check Box 1 None 1 Yes any other value No 33 RCB User Defined Check Box 2 None 1 Yes any other value No 34 RCB User Defined Check Box 3 None 1 Yes any other value No 35 RCB User Defined Check Box 4 None 1 Yes any other value No 36 Sal
7. Recurring Contract Billing Importer 10 0 Service Pack 3 An application for Microsoft Dynamics GP 10 0 Encore Business Solutions Furthering your success through innovative business solutions Copyright Trademarks Warranty disclaimer Limitation of liability License agreement Publication Date Manual copyright 2008 Encore Business Solutions Inc Printed in Canada All rights reserved Your right to copy this documentation is limited by copyright law and the terms of the software license agreement As the software licensee you may make a reasonable number of copies or printouts for your own use Making unauthorized copies adaptations compilations or derivative works for commercial distribution is prohibited and constitutes a punishable violation of the law Microsoft Microsoft Excel and Microsoft Dynamics GP are either registered trademarks or trademarks of Microsoft Corporation or its affiliates in the United States and or other countries The names of actual companies and products mentioned herein may be trademarks or registered marks in the United States and or other countries of their respective owners The names of companies products people and or data used in window illustrations and sample output are fictitious and are in no way intended to represent any real individual company product or event unless otherwise noted Encore Business Solutions Inc disclaims any warranty regarding t
8. a delimited or tab delimited There is no limit to the number of contracts that can be created using Recurring Contract Billing Importer The import utility has a powerful range of contract creating abilities You can use the following two methods to import data Method 1 Use a simple list of customer numbers a data input text file with exact matches to Microsoft Dynamics GP Customer Numbers entered at the time of import on the Import window to create contracts with default line items Method 2 Use a pair of data input text files the contract header and the contract line items to import data from another billing product using the data that best matches the Microsoft Dynamics GP file formats This method allows for the greatest flexibility for individual contracts because the line item file is matched to the Contract Header file allowing for any combination of line items per contract With this utility you can e Set constant default values for a large number of fields in both the Header and Line Item contract files You don t need to have a large amount of knowledge about file formats and structures to successfully import contracts quickly and easily Recurring Contract Billing Importer makes educated guesses for you in certain instances of data defaults and informs you of the choices made For example if you don t include the contract start date in your import it will automatically default to the User Date if you don
9. acts created in the first import The first import uses a data input text file containing contract header information including customer numbers and contract numbers The second RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER import uses a line item file matched to the header file by contract number allowing for varying line items for each Both the header file and the line item file must include the Contract Number field 9 Be sure to set up your customers before importing To import data using the double text file import 1 Open the Contract Import window Transactions gt gt Sales gt gt Recurring Contract Importer m Recurring Contract Importer File Edit Tools Help Save X Delete Ea Import EIER sa Dextordnary Inc 02 28 2008 a Import Setup ID TESTA Description Test Auto Number Contracts Next Contract Number 000000000002 Contract File Contract Header File Type Tab Delimited File Name Path Constant Vaues Import Fields Format Contact Number Customer ID Site ID Creato contracts using default line items N SitelD Default tem Number UotM Quantity lo Unt Price Description Price Level Markdown T Extended Prce Line Item Frequency Stat Date EndDate Next Bill Date Continuous Comment ID
10. change any contract header information except Customer Number and Currency ID and any contract line information except Item Number and Non Inventory Item Setting up an Import Setup ID You must set up an Import ID for each data input text file to be read e Ifyou are using Method 1 you will need to define one Import ID for the contract header information being imported If you are using Method 2 you will need to define two Import IDs one for the contract header information being imported and one be the contract lines that are matched to the contract header file Before you create an import ID make a map of your data input text file that is the fields in the file the fields order the size of each field in number of characters if your file is Fixed Field Width and the format of each field dates currency etc RECURRING CONTRACT BILLING IMPORTER 15 CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER To create an Import Setup ID 1 Open the Contract Import window Transactions gt gt Sales gt gt Recurring Contract Importer m Recurring Contract Importer File Edt Tools Help sa Dextordinery Inc 02 23 2006 Save X Decte Cea ls Import 3 Import Setup ID _ TEST Em Auto Number Contracts Description Test Contract File Contract Header File Comma Delimited File Name Pah Rilnternal Procucts Recurting Contact BilineTesting HDRbaric bt J Import Fields al Type Format Niwon Con
11. check box Ifthe item is an inventory item select the Site ID RECURRING CONTRACT BILLING IMPORTER 25 26 CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER Select the item Enter the quantity Select the line item frequency how often the item is to be billed e Enter the start date for the billing If you want the billings to continue past the end date mark the Continuous check box Recurring Contract Importer File Edit Tools Help Save X Delete Dear R Import Import Setup ID Description Contract File File Type File Name Path Impert Fields EST E a _ Test Next Contract Number Contract Header v Constart Vaues Awan 0A CTRODOO00000002 Tab Delimited Y Format Alte Creata contraste using default line items N SiteID Default Number MEI Quartity 0 Unt Price Description Price Level Markdown Extended Prce Line Item Frequency Start Dae _ End Date Next Bill Date Continuous Comment ID 8 Choose Import The contract header text file will be imported Importing data using the double text file import method Use this method to mass create contracts from two separate data input text files by performing two separate imports one to create the contract header information and a second import to add line item data to the contr
12. ems Update Contract Header or Update Contract Line Items Press the Constant Values button to open the Constant Values window m Recurring Contract Importer Constant Values Fie Edit Tods Hep sa Dextcrdnary nc 02 26 2008 Impcrt Setup ID TEST Description Test Contact File Contract Header Impcrt Fields Typs Format widh Constant Yaus Site ID Shing sir 10 RUGBY 0 Using the Import Fields lookup window Ctrl L add the fields that you want to set a constant value for The constant value field is case sensitive So if the value is an existing GP field be sure to match the case as well as the spelling Only the fields that can be selected as constant values are available in the lookup window Enter the desired constant value in the last field of the line or select the value from the Constant value lookup window Select OK RECURRING CONTRACT BILLING IMPORTER 19 CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER Contract Header file fields Field Default Values 1 Account Receivable Account Microsoft Dynamics GP Use GL account lookup 2 Auto Payment ID None 3 Auto Payment Type None 1 EFT Active 2 EFT Hold Billing 3 Bill without EFT 4 AutoPay Amount 0 Any value greater than 0 will cause the invoicing to generate an auto payment 5 Bill To Address Code Customer Default 6 Comment ID None 7 Comment Text None 8 Contract Class
13. en loaded on to your computer The x s in the file name will be replaced with numbers RECURRING CONTRACT BILLING IMPORTER CHAPTER 1 INSTALLATION amp REGISTRATION Create a backup of your Microsoft Dynamics GP data before installing Billing Solutions Exit all applications To install Billing Solutions 1 Open Windows Explorer and locate the RCB10 00 01 xxx exe file The location of this file will vary depending on how you acquired the application 2 Launch the RCB10 00 01 xxx exe file by double clicking it The installation program will start 3 Follow the instructions in each window 4 After the installation is complete start Microsoft Dynamics GP You will receive the following message i New code must be included in the J C G6PSQL_10_F Dynamics set dictionary Do you wish to include new code now 5 Choose Yes Information for Billing Solutions and Encore Product Registration will be included in the Dynamics set file Entering registration keys Before you can use Recurring Contract Billing Importer with your company data you must register your software To register your software enter the product registration key or the drop file provided to you by Encore If you choose not to enter the registration key you will only be able to create sample transactions using Fabrikam Inc the lesson company RECURRING CONTRACT BILLING IMPORTER 9 10 CHAPTER 1 INSTALLATION amp REGISTRATION To regis
14. es Importing data using the single text file import method Importing data using the double text file import method Selecting an Import method Deciding which method to use is the first step to using the Recurring Contract Billing Importer METHOD 1 Use this method to create contracts using a simple data input text file consisting of a list of customer numbers and the scrolling window to import the line items Any other fields that you desire for the header may be included in the data input text file or RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER default values You can select line items that will be used for all contracts in the import The line item selection scrolling window works much like entering line items in either Invoicing or Sales Transaction Entry METHOD 2 Use this method to create contracts using two separate data input text files and by performing two separate imports The first import uses a data input text file containing contract header information including customer number and contract number The second import uses a line item file matched to the header file by contract number allowing for any numbers of line items for each contract You can set constant values for nearly all fields in both files Updating You can also update the input data on the existing contracts using Update Contract Header and Update Contract Line Items options You can
15. es Territory From Customer Maintenance Card 37 Salesperson ID From Customer Maintenance Card 38 Ship To Address Code From Customer Maintenance Card 39 Site ID REQUIRED 40 Trade Discount Amount 0 41 User Defined 1 None 42 User Defined 2 None 43 User Defined 3 None 44 User Defined 4 None 45 User Defined 5 None 46 User Defined Date 1 None 47 User Defined Date 2 None 48 User Defined Table 1 None 49 User Defined Table 2 None 50 User Defined Table 3 None Update Contract Header When the Update Contract Header option is selected the user can change the header fields on an existing contract The contract number must be included in the import file The system will match the row in the import file with the contract based on the Contract Number The importing contract will be updated with the other fields specified in the import file You can use the Constant Values window to apply the same updates for all contracts Y Neither the Customer ID nor the Currency ID can be updated RECURRING CONTRACT BILLING IMPORTER 21 CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER Contract Line Item file fields Field Default Values 1 Bill End Date None Must be on or after Bill Start Date 2 Bill Start Date User Date or from Header if specified Must be on or before Bill End Date Must be on or before Next Bill Date 3 Billing Day
16. for all of the following questions to help your support specialist quickly narrow down the source of the problem you are experiencing What is the exact error message When did the error first occur What task were you attempting to perform at the time you received the error message Has the task been completed successfully in the past What is the name of the window you are working in What have you done so far to attempt to fix the problem Have you performed any of the table maintenance procedures such as check links If have performed table maintenance procedures and received error messages what kind of messages Does the problem occur in another company Does the problem occur on another workstation Does the problem occur for more than one user Have you imported any data What versions of software are you using Verify the version numbers for Microsoft Dynamics GP your database software Encore product and Windows Also note service packs To locate the version number for Recurring Contract Billing Importer in version 10 0 go to Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Encore Product Registration The RECURRING CONTRACT BILLING IMPORTER About window can be located by selecting Recurring Contract Billing Importer and expanding the window The About window link is located in the bottom left hand corner of the window To locate the version number for Recurring Contract Billin
17. g Importer in version 9 0 and 8 0 go to Tools gt gt Setup gt gt System gt gt Encore Product Registration The About window can be located by selecting Recurring Contract Billing Importer and expanding the window The About window link is located in the bottom left hand corner of the window RECURRING CONTRACT BILLING IMPORTER 5 6 RECURRING CONTRACT BILLING IMPORTER CHAPTER 1 INSTALLATION amp REGISTRATION Chapter 1 Installation amp Registration This chapter describes how to install and register the Billing Solutions products You will need separate registration keys to register Recurring Contract Billing Recurring Contract Billing Importer and Mass Billing This chapter contains the following sections Upgrading from previous versions Installing Billing Solutions Entering registration keys Creating tables Upgrading from previous versions To upgrade from a previous version to 10 0 follow all the steps required to install a new version as explained in the following sections Installing Billing Solutions Entering registration keys Creating tables Installing Billing Solutions You will use an installation program to install Recurring Contract Billing Importer Before you begin installing do the following e Note the directory location of your Microsoft Dynamics GP installation You will need this information during the installation e Verify that the RCB10 00 01 xxx exe file has be
18. hat was missed Depending on the field type you may need to enter more information as follow e For any Fixed Field Width format fields enter the number of characters For any Currency fields indicate whether or not the data contains a decimal place For any Date fields select the date format that matches the format of the data in your data input text file To set a constant value for a specific Contract file field that is not part of the data input text file choose the button Constant Values to open the constant values window In this window you select the field that you want to set a constant value for and enter the desired constant value To print a report that lists the fields for the contract file and other information about each field choose the Print button Select Save Constant Values Before importing a file you must check that the required fields have been entered If the required field is not in your import file it can be added as a constant value As the import file is being imported any specified constant values will either set the value or override the value in the import file RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER To set up constant values 1 Open the Contract Import window Transactions gt gt Sales gt gt Recurring Contract Importer Enter the Import Setup ID Choose the Contract File Contract Header Contract Line It
19. he sample code contained in this documentation including the warranties of merchantability and fitness for a particular purpose The content of this manual is furnished for informational use only is subject to change without notice and should not be construed as a commitment by Encore Business Solutions Inc Encore Business Solutions Inc assumes no responsibility or liability for any errors or inaccuracies that may appear in this manual Neither Encore Business Solutions Inc nor anyone else who has been involved in the creation production or delivery of this documentation shall be liable for any indirect incidental special exemplary or consequential damages including but not limited to any loss of anticipated profit or benefits resulting from the use of this documentation or sample code Use of this product is covered by a license agreement provided by Encore Business Solutions Inc If you have any questions please call our office at 888 898 4330 North America only March 2008 CONTENTS Contents Introduction 2 Chapter 1 Installation amp Registration 8 Upgrading from previous versions seen ener nennen enne 8 Installing Billing Solutions Entering registration keys Creating eur UR Ri n endis Chapter 2 Using Recurring Contract Billing Importer 14 Selecting an Import method su k nne idet rerit ici Setting up an Import Setup
20. ndow and the Auto Number Contracts is marked the system generated contract number will override the contract number in the file 8 Enter the Import field s data using the Import Fields lookup window CTRL L The import field name is case sensitive So if you type the name it must match the case is displayed in lookup window m Import Fields Lookup File Edit Tools Help sa Dextordinary Inc 02 26 2008 Contract File Contract Header Fieldname Auto Payment ID Auto Payment Integer AutoPay Amount Currency Bill To Address Code Sting Comment ID String Comment Text String Contract Class String Contract Number String Contract Status Integer Currency ID Sting Customer ID String Deferral Profile Group String ES Freight Amount Currency 14 For your convenience this lookup window can be pinned down RECURRING CONTRACT BILLING IMPORTER 17 18 CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER V 10 11 You must list the fields in the order in which they are found in your input data text file If you want the Importer to ignore a field in the file open the lookup window and choose the Skip Field button for that field If you accidentally miss entering a field in the correct order of your data input text file highlight the field name of the field that is just after the field you missed choose Edit gt gt Insert Row Then insert the field t
21. ntinuous Comment ID 6 Enter the Import Setup ID for the Contract Line Items file The scrolling window must include the Item Number field in the Import Fields scrolling window The item number must be an existing Microsoft Dynamics GP inventory item or must be marked as a non inventory item 7 Enter the file and path for the Line Items defaults text file 8 Select Import The Contract line items file will be imported 28 RECURRING CONTRACT BILLING IMPORTER Appendix A Data Tables A DATA TABLES The following charts list all related data tables in Recurring Contract Billing and their descriptions Import Series Display Name Physical Technical Name Description Name ME_Import_Fields ME50430 ME_Import_Fields Contract Importer Fields ME_Import_SETP ME50431 ME_Import_SETP Contract Importer Setup ME_Import_SETP_DTL ME50432 ME_Import_SETP_DTL Contract Importer Setup Details ME Import Line Items ME50436 ME Import Line Items Contract Importer Line Items ME Import SETP Constants ME50439 ME Import SETP Constants Contract Importer Constants Sales Series Display Name Physical Technical Name Description Name ME Batch Invoice SETP ME50402 Batch Invoice SETP Batch Invoicing Setup ME Batch Invoice MSTR DTL ME50403 ME Batch Invoice MSTR DTL Recu
22. ntract Billing gt gt Table Conversion EM Table Conversion File Edit Tools Help sa Fabrikam Inc 4 12 2017 Recurring Contract Billing Table Conversion Upgrade S Process o Cancel 2 Select Process Tables will be created permissions will be set and existing data will be converted Every time you install Recurring Contract Billing Importer you must Y run the Table Conversion Upgrade process for each company 12 RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RCB IMPORTER Chapter 2 Using Recurring Contract Billing 14 Importer It is important to have your sales including customer records and inventory including items and pricing modules completely set up before using the Importer because the Importer uses default data from Microsoft Dynamics GP The amount of data in your data input text file can be minimal because Recurring Contract Billing Importer uses default values for a number of fields in the contract header and line item files The Importer can be used to import non inventory items which do not need inventory cards set up for them We recommend testing out your imports in Fabrikam Inc before processing your import with live company data This chapter contains the following sections Selecting an Import method Setting up an Import Setup ID Constant Values Contract Header file fields Update Contract Header Contract Line Item file fields Update Contract Line Items Default Valu
23. on to contracts as they are being created based on existing data in your Microsoft Dynamics GP Because of this it is possible to mass create contracts from just a Customer ID list or from a Customer ID list and a line items data input text file All other fields in the contract file will default to preset values if the user does not include them in the data input file being imported or as constant value Importing data using the single text file import method To import data using the single text file import method you must set up a Contract Header Import ID for a text file containing the contract header information The Contract File selection must be Contract Header The Create Invoices Using Default Line Item check box must be checked This will make it possible for you to select the line items in the scrolling window that will be used for all of the contracts that will be created A site must be selected as well as an item The Contract Header file Import ID must contain the following field names e Customer ID an existing Microsoft Dynamics GP Customer ID e Contract Number in the text file or Auto Numbered Contracts e Site ID in the text file or as the constant value The Import ID may include any of the other fields to be imported into the Contract Header table either in the text file or as the constant values To import data using a single text file 1 Open the Contract Import window Transactions gt gt Sales gt g
24. r PO changed to PO Number Location Code changed to Site ID Billing Status changed to Contract Status Territory changed to Sales Territory EFT Instructions changed to Auto Payment Type RECURRING CONTRACT BILLING IMPORTER 31 What s New in RCB Importer for 10 0 Recurring Contract Billing Importer has been upgraded to be fully compatible with Microsoft Dynamics GP version 10 0 Known Issues Choose the fields from the Import Fields Lookup window in the order in which they are found in input data text file including any skipped fields New Encore Products Inventory I O Control Inventory I O Control developed by Encore Business Solutions Inc is an enhancement to the Microsoft Dynamics GP Bill of Materials module Inventory I O Control provides the ability to track assembly items and define their associated secondary or output items Using Inventory I O Control provides you with the ability to accurately post adjustments to inventory For more information contact your partner or visit the Encore website Advanced SmartList Advanced SmartList is a relational viewing tool created by Encore The Advanced SmartList tool enhances the existing Microsoft Dynamics SmartList application Advanced SmartList can be used to create customized inquiries to provide easier faster access to the information stored in the Microsoft Dynamics system For more information contact your partner or visit the Encore website Documentation Feedback
25. registration key provided by Encore 5 If you have purchased more than one Encore product repeat steps 2 to 4 until all of your purchased products are registered 6 Select the About zoom field to open the About window for this product This window contains the version number for this product and information on how to contact Encore 7 Select OK to close the window To register your product using a drop file 1 Copy or save the drop file to the directory location for your Microsoft Dynamics GP For Example C Microsoft Dynamics GP 2 Log in to Microsoft Dynamics GP as a system administrator 3 The system will notify you that it has found a registration file accept the prompt RECURRING CONTRACT BILLING IMPORTER 11 CHAPTER 1 INSTALLATION amp REGISTRATION 4 The system will notify you when the product has been registered 5 Open the Encore Product Registration window to ensure that it is registered Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Encore Product Registration Creating tables Whether you want to demo or run the product you must run the Table Conversion Upgrade process to create tables this will set up SQL components and convert any existing data You must log in as System Administrator to run the Table Conversion Upgrade process To create tables 1 Open the Table Conversion window Microsoft Dynamics GP menu gt gt Maintenance gt gt Recurring Co
26. rring Contract Line Details ME Batch Invoice MSTR HDR ME50405 ME Batch Invoice MSTR HDR Recurring Contract Header ME Batch Invoice Contract CLASS ME50408 ME Batch Invoice Contract CLASS Contract Class Definitions most fields are reserved for future use ME BIC Invoices LOG ME50411 ME BIC Invoices LOG Batch Invoicing Invoices Created Log ME BIC Invoices LOG DTL ME50413 BIC Invoices LOG DTL Batch Invoicing Invoices Details Created Log ME LINE CMT WORK HIST ME50417 LINE CMT WORK HIST Contract Comment Work History ME Recurring Batch Activity ME50434 ME Recurring Batch Avtivity Matching Invoicing Batch Activity ME Contract Line Item Note ME50435 ME Contract Line Item Note Contract Line Details Notes ME BilledContract Object HDR ME50437 ME Batch Invoice MSTR HDR Contract Header Rollback Legacy Support ME BilledContract Object DTL ME50438 ME Batch Invoice MSTR DTL Contract Line Details Rollback Legacy Support ME Deferral Profile Group ME50440 Deferral Profile Group Deferral Profile Group ME Deferral Profile Group LINE ME50445 Deferral Profile Group LINE Deferral Profile Group Lines ME Rollback Archive DTL ME504031 ME Rollback Archive DTL Contract Rollback Line Details ME Rollback Archive HDR ME504051 ME Rollback Archive HDR Contract Rollback Header RECURRING CONTRACT BILLING IMPORTER 29 30 RECURRING CONTRACT BILLING IMPORTER What s New in RCB Importer for 10 0 SP3 With this relea
27. se the Recurring Contract Billing Importer has been enhanced and given the exciting new functionality of updating contracts Both Contract Headers and Line Items can now be updated using the Importer see Update Contract Header and Update Contract Line Items sections in the user manual for details We have changed the functionality for account number fields to make it easier Previously if an import file contained the Cost of Sales Account Markdown Account or Sales Account the account index needed to be enter in the import file With this release the account number is entered in the import file The lookup window is now available for all applicable fields The Constant Value column has been removed from the scrolling window and Constant values button has been added instead to open the new Recurring Contract Importer Constant Values window New fields have been added to the list of available fields for the Contract Header file Deferral Profile Group Comment Text Recurring Contract Billing user defined fields 4 Text fields 4 Date fields 4 Numeric fields 4 Check box fields Fields in regards to the RCB SDK Auto Payment ID and Auto Payment Type The Accounts Receivable Accounts field was moved from the Contract Line Items file For the Contract Line Item file the Billing Day field has been added Some of the fields have been renamed to reflect the naming used in Recurring Contract Billing Custome
28. specified number 19 Number of Times Billed 0 20 Price Level From Microsoft Dynamics GP Or blank if Contract Price is checked 21 Quantity 1 0 22 Sales Account From Microsoft Dynamics GP Use GL account lookup 23 Sales Territory From Customer 24 Salesperson ID From Customer 25 Site ID From Microsoft Dynamics GP 26 Unit Cost From Item 27 Unit Price From Item for inventory items REQUIRED for non inventory items 28 Unit of Measure From Microsoft Dynamics GP for inventory items Each for non inventory items 29 User Defined Days in Cycle 0 REQUIRED if Billing Frequency is user defined Update Contract Line Items When the Update Contract Line Items option is selected the user can update Line Item fields in previously entered contracts To identify the line to be updated you must specified the Contract Number and either the Item Number or the Line Item Sequence number The Item Number can only be used when it is the only active item on the contract The Line Item Sequence number is not visible in any of the Recurring Contract windows The Line Item Sequence is found in the Me Batch Invoice MSTR DTL ME50403 table RECURRING CONTRACT BILLING IMPORTER 23 CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER Default Values If a field is not specified by the Importer the Importer can automatically enter default informati
29. t Recurring Contract Importer 24 RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER Recurring Contract Importer File Edt Tools Help sa Dextordinery Inc 02 23 2006 Soave 3X Decte Ocar esa Inport 9 Import Setup ID TEST I mr O Auto Number Contracts A Description Test Contract File Contract Hesder v File Type Comma Delimited v File Name Pah R lntenal Procucts Resuring Contac Bilinc Testing HDAbatic ot g Import Fields y Type Format wath Contact Number Sting 20 Site ID Sting 10 Customer D Sting mu Cicato contracts usina ofault Iro itomo M SieID Defaut Item Number Quantty Unit Price Description Price Level Markdown Estordod Pros Line Item Frequency Stadt Date End Dae Next Bill ate Continucus Comment ID 2 Enter the Import ID for the Contract Header file 3 To auto number the contracts mark the Auto Number Contracts check box 4 Verify that the Contract file is Contract Header 5 Enter or verify the header file name and the path 6 Mark the Create contracts using default line items check box The scrolling window will now allow you to select line items that will be used for all of the contracts that will be created 7 Enter the line Items to be associated with each contract in the line items scrolling window as follows e Ifthe item is a non inventory item mark the N
30. ter your product 1 Open the Encore Product Registration window Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Encore Product Registration 2 Select the product you wish to register Encore Product Registration DAR Fie Edit Tools Help sa Fabrikam Inc 4 12 2017 Y Site PreviewKeys Users Company Fabrikam Inc Database SQL Server Platform Microsoft Dynamics GP 10 00 View By All Products Products Mass Billing for SOP Project Tracking Project Tracking Budgeting Project Tracking Budgeting Importer Project Tracking Importer REAP Dynamics GP Interface Recurring Contract Billing Importer Recurring Contract Billing for Invoicing Recurring Contract Billing for SOP SOA Voucher iy O EPM 10 00 02 033 3 Choose the show detail button to open the scrolling window for entering the product registration key RECURRING CONTRACT BILLING IMPORTER CHAPTER 1 INSTALLATION amp REGISTRATION EM Encore Product Registration DER Fie Edit Tools Help sa Fabrikam Inc 4 12 2017 L K Site PreviewKeys Users IE EN _ Company Fabrikam Inc Database SQL Server aT Platform Microsoft Dynamics GP 10 00 View By All Products Products Recurring Contract Billing Importer Product 504 Product Key EE at Status Not Registered 4 Previous Next EPM 10 00 02 033 4 Enter the product
31. tract Number Sting 20 Site ID Sting 10 Customer D Stina a Cicato contracts using default Iro IN StcID Defaut Item Number Quentiy 0 Unit Price Description Price Level Markdown Eitordod Price 1 ine Item Frequency Stat Date End Dar Next Bill Date Continucus Cemmen ID 2 Enter the Import Setup ID This ID will be used to store your import setup so that at can be reused a descriptive name will be helpful 3 Enter a description for the Import Setup ID 4 Choose the Contract File Contract Header Contract Line Items Update Contract Header or Update Contract Line Items the file that is to be filled by the imported data Once the Contract File is chosen for a given Import ID it cannot be changed 5 Choose the file type format that matches your data input text file Tab Delimited Comma Delimited or Fixed Field Width 16 RECURRING CONTRACT BILLING IMPORTER CHAPTER 2 USING RECURRING CONTRACT BILLING IMPORTER 6 Enter the Header File name and location browse to the location of the data input text file to be read This field is not required in order to save the Import ID and is often entered at the time of importing the data 7 To auto number contracts as they are created mark the Auto Number Contracts check box Y Recurring Setup must be completed first to initialize the contract numbering If the contract number is defined in the scrolling wi
32. y Phone 204 989 4330 Fax 204 235 2331 E mail encore encorebusiness com Internet www encorebusiness com Mail 467 Provencher Blvd Winnipeg MB Canada R2J 0B8 Microsoft Gold Certified Partner 2003 2007 Microsoft Business Solutions Inner Circle Member 2000 2002 2005 Microsoft Business Solutions President s Club Member 1996 2007 Microsoft Business Solutions Organizational Excellence 2002 Microsoft Business Solutions Partners Choice Developer Award 1999 amp 2000 GOLD CERTIFIED Ad Microsoft Dynamics Partner
Download Pdf Manuals
Related Search