Install Guide - AMC
Contents
1. 5 S 5 S S To change bank and payment type press Change m Change bank information 1 File Edit Tools Command Help AE oe ea eee hho Bank name DDB New bankname Payment type Indbetalingskort New paymenttype The left side of the Edit window will show the valid bank and payment type of the vendor chosen in the Multi Edit window at the time the Change button was clicked Choose new values for each previous bank and payment type possible in AMC Banking 2009 For each payment type individually start the Change window The values in the Multi Edit window will change after pressing the OK button Upgrading AMC Banking from 4 x or previous versions Multi edit vendor 1 dat Bank Danske DK Account type Vendor File Edit Tools Command Help JH BE db d A 9 Selection Default values Vendor account Name Bank Payment type Account No Swift Mo Primary Selection 1 Danske DK Domestic refer 80251823 2 Danske DK Domestic transfer 22223333333333 31305042 Cykel Byg Danske DK Domestic transfer 23421234543421 32647894 Danske DK International tr NO2156325412547 NDEANOKK 33112288 Jernringen Danske DK Domestic transfer 34522342234223 33112288 Jernringen Nordea DK Domestic refer 80251823 33112288 Jernringen Nordea DK Domestic Trans 32154215485478 33112288 Jernringen Nordea DK International T DK54703213546841654 45451818 Danske DK Domesti2. Installing AMC Banking 2 4 CREATING MAPS AMC Banking uses standard maps in the Dynamics AX application but these are not supplied with the AMC Banking module as there would be a risk of any changes to the existing maps being overwritten by the installation process Instead AMC Consult has developed a script which makes the necessary changes in the application You have to start this operation before you will be able to compile AMC Banking without errors Go to AOT CTRL D and find the class AMCBankMapNeededCreate Run this class by right clicking and selecting Open The operation is terminated with a confirmation that three new mappings have been added 2 5 INSTALL THE LATEST PATCH If there is a patch for AMC Banking this has to be installed now You can find patches at www amcbanking com Patches are imported in exactly the same way as when installing the basic module see section 2 2 2 6 Compile AMC BANKING When installing both the basic module and any patches you may find compile errors are generated which have to be rectified When importing the basic module a project is created which you can find under Projects Shared Compile the project a couple of times and check that the compile has been executed without errors 2 7 ACCESS RIGHTS TO THE MODULE To access the module you now have to give the relevant user groups access to AMC Banking s security keys It may be a good idea to create a user group es
3. Test connection Signing up XTendLink address Login AMC Webservice Verify license Primary HTTP https classic amcbanking com amcxml Pre release HTTP https plus02 amcbanking dk amcxml Last connection Primary vi Username M4803631 sorenv6 Custom login sorenv Password Status HTTPS status Certificate OK Date verified 07 05 2015 General Log level AAA Log files Logfile C Users Public Microsoft Dynamics Ax Log XTReconcileld 9117 Delete processed lAfter 30 days v Test O XTendLink will be used in this company DKK dat ur amp E Click on the Signing up button You will now be guided on to the registration page for AMC Banking Services Follow the online help to get your AMC Banking license Registering for the AMC Banking web service 3 3 SETUP OF XTENDLINK ADDRESS AND TEST OF CONNECTION Go back to AMC Banking Setup Parameters and switch to the XTendLink tab m x File Edit Tools Command Help N BLA S Vendor Customer XTendLink Reconciliation AMC Banking Use XTendLink Test connection Signing up Login Verify license XTendLink address AMC Webservice Primary HTTP https classic amcbanking com amcxml Pre release HTTP https plus02 amcbanking dk amcxml eq Last connection Prima
4. INSTALLATION GUIDE FOR AMC BANKING FOR DYNAMICS AX 2009 English edition AMC Consult A S 2015 07 07 Version V7 INDHOLD I Introduction 4 1 1 Systemirequiretmients oe tete ete Ee ee Rana IERI an 4 1 2 Chiticismiappreciated ae asili a 4 1 3 Furtherinformationi aa clio 4 2 Installing AMC Banking ii 5 2 1 What should you use for installation sese eene eene 5 2 2 Copy label tiles iii ida 5 2 3 Import Module moi nina aa onere Re aaa 5 2 4 Creating maps eine ae 6 2 5 Install the latest patch ec ii 6 2 6 Compile AMC Banking i 6 2 7 Access rights to the module nn E aSa 6 2 8 Create a menu Item aaa liete 7 2 9 E ei 8 3 Registering for the AMC Banking web service eene nnn 9 3 1 Communication via web Services i 9 3 1 1 AMG Banking Classic dci ae 9 3 1 2 AMC Banking Enterprise iii 9 3 2 Registrationi 10 3 3 Setup of XTendLink address and test of connection ii 11 4 Troubleshooting i e e e RN neu re e ie 13 4 1 Compile errors in banking elements enne nnne nnne nnn 13 4 2 Missing labels inscriure 13 4 3 Warnings following completion of compiling esses 13 4 4 Error in payment journal i 14 4 5 Error when opening AMC journalS
5. dat Journal indgang journal number kl 00076 Posted No Journal type Invoice register File Edit Tools Command Help REx OLA LE Balance Total debit Total credit Journal Journal 745 00 Journal 5j Validate gt Pervoucher Per voucher 00 00 Per voucher j oe Sales tax Overview General Dimension Cash discount History Invoice information Functions gt Date Voucher Account Invoice Transaction text Debit Credit Salestax group Item sales tax group Transfer 26 02 2 god 00004 33112288 9816412 Faktura 100 00 Moms Payment type Bank account Axapta payment modes Company Counter Domestic Transfer 32154215485478 AMCI dat 1 ppproved by International Transfer DK54703213546841654 dat 2 Terms of payment Nordea DK Domestic reference payment OCR 80251823 AMC3 dat El Invoice Due date Payment ID Tax exempt number Purchase order Enterprise number Payment Method of payment Payment specification Bank name DKK dat us amp E In order to select between the AMC payment types you have to change the lookup method of the payment mode field In AOT open the form LedgerJournalTransInvoiceRegister Select Designs Design Tab Tab TabPage Payment Group Payment StringEdit LedgerJournalTrans_PaymMode Methods Right click the metods node and select Overwrite method Lookup and insert the following c
6. i 14 5 Delete old elements cete e ade restet 15 Introduction Upgrading AMC Banking from 4 x or previous versions i 17 6 1 Importing XML tool in the previous version iii 17 6 2 Exporting data from a previous version ii 17 6 3 Importing data to AMC Banking 2009 i 19 6 4 Converting payment types rn 20 6 5 General A NS 22 A NA 23 7 1 Automatic creation of new vendors in AMC Banking ii 24 7 2 How to set up a link from a vendor to AMC Bankihg iii 27 7 3 How to add payment type and bank account in the invoice register journal 29 7 4 Use of AX standard payment modes with AMC Bankihg iii 36 TAA Select default bank 36 7 4 2 Activate the support of standard AX payment 5 37 7 4 3 Adjustments in the invoice register joUrnal iii 38 Introduction 1 INTRODUCTION Thank you for choosing AMC Banking We hope you enjoy using the module and its facilities 1 1 SYSTEM REQUIREMENTS To be able to run AMC Banking you need Axapta 3 0 or later RUN TIME BUS installer or the MorphX development pack and X source text However this guide refers only to the installation of AMC Banking in Dynamics AX version 2009 Some Dynamics AX service packs do not satisfactorily support the import of ext
7. Queries AmcBankReconcileSurgestDelete AmcBankSummary2Ledger AmcBankSummarySearch AmcBankSummaryTrans Menu Items Display AmcBankJournalPaymentCompany AmcBankDemoTableListPage AmcBankVendWizardTable AmcBankSummaryTable AmcBankSummaryTrans Action AmcBankDemoBanstaCreate AmcBankDemoBaseDataCreate AmcBankDemoBaseDataCustUpdate AmcBankDemoBaseDataVendUpdate AmcBankDemoContrlCreate AmcBankDemoDebmulCreate AmcBankDemoFinstaCreate AmcBankDemoPaymentincommingCreate AmcBankDemoPaymentOutgoingCreate AmcBankJournalChangeMultiMark AmcBankReconcileSettleDelete AmcBankReconcileSurgestAdd AmcBankReconcileSurgestDelete AmcBankReconcileSurgestDiff AmcBankReconcileSurgestTransfer AmcBankSummary2Ledger AmcBankSummaryPostpone AmcBankSummarySearch Output AmcBankXTMessageLog Reports AmcBankReconcileLedgerSettleStatus AmcBankXTMessageLog Delete old elements 6 UPGRADING AMC BANKING FROM 4 X OR PREVIOUS VERSIONS If your installation is an upgrade of an earlier version of AMC Banking you have to be aware that a number of changes have been made to the table structure Several tables in this version have been shared across companies which is why you have to review your existing data in the module in order to ensure that you can continue to use the module Data from old versions of AMC Banking can be imported to version 2009 v4 but you have to assess in each individual case which tables you should transfer Converting data from
8. Username M4803631 sorenv6 Custom login sorenv Password e Status HTTPS status Certificate OK Date verified 07 05 2015 General Log level Info v Log files Logfile C Users Public Microsoft Dynamics Ax Log XTReconcileld 9117 Delete processed After 30 days v Test O XTendLink will be used in this company DKK dat ur 3 B Select the Use field If you want to use the hosted AMC Banking Service just select the field AMC Webservice The http fields will then be completed automatically with the addresses of AMC Banking Service Registering for the AMC Banking web service If you want AMC XTendLink to be installed on the company s own network you instead have to state the IP address and the relevant port for the local XTendLink installation e g First http http 10 101 101 50 8030 amcxml When the http fields are completed you should click on the Test connection button in order to ensure that AMC Banking can communicate with XTendLink The following messages are just for your information and do not require you to take any action 9 3 Test connection 5 2 Trying connection to AMC Consult A S https license amcbanking dk amcxml by the Dynamics AX server i Communication with AMC Consult A S completed without errors i gp Result OK 2 Trying connection to XTendLink https classic amcbanking com amcxml by th
9. Now right click the new element and select Properties li Control StringEdit PaymentType_AMC es Categories Appearance Behavior 5 Data Arraylndex 0 AutoDeclaration No ConfigurationKey DataField DataMethod dispAMC_PaymentT ype DataSource LedgerJournalTrans ExtendedD ataT ype HelpText Standard betalingstype HTMLHelpFile HTMLHelpTopic PaymentT ype_AMC SecurityKey Font Label4ppearance Label lignment ABA20011 Left LabelForegroundColor Window text LabelHeight LabelPosition Left Auto Labelw idth Auto LabelFont Position The two labels used in the fields HelpText and Label have the following numbers HelpText ABA30224 Standard payment type Label ABA20011 Payment type Right click again the node Group AMC_Banking_Group and select New Control String Edit Name the new element PaymentNumber_AMC ES AOT Forms wee r a ca Group GroupHeader a 3 Methods dl C 3 Group InvoiceOverview 3 3 Group GroupPayment Group Currency a CI 3 Group TaxOverview E Group CashDiscount C 3 Group ThirdPartyBank 3 Group AMC_Banking_Group amp Methods fabl StringEdit PaymentNumber_AMC E E E El El ul Right click the element and select Properties L Control StringEdit PaymentNum
10. installation Data Dictionary Tables AmcBankJournalPaymentCompany AmcBankReconcileSurgest AmcBankSummaryTable AmcBankSummaryTrans AmcBankTmpCremulJournalTransSpec AmcBankTmpJournalTrans Extended Data Types AmcBankOutputTypeld AmcBankSummaryld Base Enums AmcBankHandleJournal AmcBankmarkUnMark AmcBankOutPutType AmcBankPrimarySecondary AmcBankSummaryAccountType AmcBankSummaryAccountTypes AmcBankSummaryCashDiscType AmcBankSummaryReference AmcBankSummaryStatus AmcBankSummaryUtilization AmcBankUpdateOverwrite Macros AmcBankJob AmcBankOCR AmcBankPatch AmcBankSerial AmcBankXTFieldsFixedValues Classes AmcBankDemoMake AmcBankImportTable AmcBankJournalCremulTmpTransSpecCreate AmcBankJournalEnter AmcBankJournalEnter_Check AmcBankJournalEnter_CheckPost AmcBankReconcileChequeSettlement AmcBankReconcileSettleDelete AmcBankReconcileSurgestAdd AmcBankReconcileSurgestDiff AmcBankReconcileSurgestionDelete AmcBankReconcileSurgestTransfer AmcBankReferenceSearch AmcBankSummary2Ledger AmcBankSummaryMain AmcBankSummaryPostpone AmcBankSummarySearch AmcBankXTBatch AmcBankXTInterpreter AmcBankXTJournalDelete Forms AmcBankBeta AmcBankDemoCreate AmcBankDemoDialog AmcBankDemoTableListPage AmcBankSummary2Ledger AmcBankSummarySearch AmcBankSummaryTable AmcBankSummaryTrans AmcBankJournalPaymentCompany AmcBankReconcileSurgestTransferLookUp AmcBankVendPaymentCreateManually AmcBankXTMessagelmport Delete old elements
11. previous versions of the module is not fully supported due to a change in the general structure of AMC banking and a change of names for all tables in the module Most essential is the Bank Vendor Table where the vendors payment types and account information are found The chapter below will assist you in successfully converting these data Please note that it is not possible to transfer journals from versions prior to 2009 You should ask for assistance for this upgrade from AMC Consult if you are in any doubt 6 1 IMPORTING XML TOOL IN THE PREVIOUS VERSION Since the new version of AMC Banking is limited to importing files in XML format it is required to install an application into the former version of the program The application can be found at www amc dk or requested directly at AMC Consult The file AMC_Banking_ExportXMLTool_460_481 xpo is to be imported into the previous version of AMC Banking by AOT Import or CTRL D 6 2 EXPORTING DATA FROM A PREVIOUS VERSION After completing the import open the form AmcBankExportlmport The form is found directly in AOT under Forms The following screen will appear Ba Eksport i XML Format til konvertering Table BankIntfCompanyId No Table game of table j Medtag delte tabeller 2 18 ankIntfCompanyid E Company id conversion BanklntfCustT able AMC Banking customers Eksporter kun bne journaler Y BankIntfCustT ableField Customer bank information Regnskab BanklntfCustT abl
12. 00 Moms Invoice Currency Cash discount Approved by Currency Cash discount Terms of payment v Triangulation Cash discount date Due date 26 02 2010 5 Exchange rate 100 0000 Discount amount Payment ID Secondary exchange rate Third party bank Tax exempt number Cross rate 100 000 Account identification Purchase order Calculation method DKK DKK AMC Banking Sales tax Payment type Domestic Transfer Inquiries gt Print Method of payment j 3 Corrected sales tax amount Payment specification Payment Sales tax amount Account No 32154215485478 Invoice number DKK da ur 3 5 Note Use of the new fields requires that you have selected a default bank and payment type in AMC Banking Setup Default Bank Default bank 1 dat File Edit Tools Command Help p DO TULIY Default bank Account type Bank Payment type wi Nordea DK Domestic Transfer Account type that specifies the type of account the transac DKK dat ur amp E 7 4 USE OF AX STANDARD PAYMENT MODES WITH AMC BANKING If you need to handle multiple payment types account number per vendor it is recommanded to make this adjustment which gives you the possibility to select a specific payment type from AMC Banking at the time when you are posting the v
13. ber_AMC Properties Categories Ej Appearance Behavior E Data Arrayindex AutoDeclaration ConfigurationKey DataField DataM ethod disphMC PaymentNumber DataSource LedgerJournalT rans ExtendedD ataT ype HelpText Bankkonto som er valgt p kreditoren HTMLHelpFile HTMLHelpT opic Name PaymentNumber_AMC SecurityKey 4 Font LabelAppearance ABA20022 Label lignment Left Labels used in the properties HelpText ABA20291 Bank account selected for the vendor Label ABA20022 Account No Close the properties Right click the form LedgerJournalTransInvoiceRegister and select Save CONSULT In the Invoice register journal you now have two new fields displaying the payment type and bank account of the selected vendor BM Journal voucher 1 dat Journal indgang journal number kl 00076 Posted No Journal type Invoice register File Edit Tools Command Help a LE NE ATA 4 na Balance Total debit Total credit Journal 0 00 Journal 00 00 Journal Per voucher 0 00 Per voucher Per voucher Overview General Dimension Cash discount History Invoice information Post gt Validate gt Sales tax Functions gt Date Voucher Account Invoice Transaction text Debit Credit Salestax group Item sales tax group Transfer 26 022 god 00004 33112288 Faktura 100
14. c refer 80251823 45823445 Danske DK Domestic transfer 32658542154874 5 Danske DK Domestic transfer 12341234567890 75500000 Kolding Keedefabrik Danske DK Domestic transfer 43338272819181 86982311 Danske DK Domestic transfer 98716846546531 Sequence v Delete Transfer Change S S S S s S S S E WD Db 8888 8 88 88 Bank Giro or other identification of the payment recipient DKK dat ur amp E Press Transfer after editing all the vendors in the window This will transfer all new values to the Bank Table Vendor Since both new and old values will be present in the bank table it is highly recommended to perform a clean up The best way to go about this is to delete existing selections in the Multi Edit window and to run a new selection from the bank table specifically on the previous bank information When the new selection appears in the Multi Edit window press Delete Delete from Bank Table 6 5 GENERAL SETUP It comes highly recommend that you go through the general setup of AMC Banking manually since the general structure of the module has been changed For further assistance please refer to the user s manual for AMC Banking for Dynamics AX 2009 Upgrading AMC Banking from 4 x or previous versions 7 APPENDIX This Appendix to the installation guide contains a summary of a range of options available to help you make AMC Bankin
15. ccount number Vendor bank information Bank Vendor bank information Payment type Vendor bank information Sequence Vendor bank information Primary It is not necessary to further specify your selection Choose OK in the following window Upgrading AMC Banking from 4 x or previous versions ANAS fr A M C CONSULT Now all vendors and their affiliated bank and payment types will appear PA Multi edit vendor 1 dat Bank DDB Account type Vendor DER Fie Edit Tools Command Help 5 BO FEY Y Selection Vendor account Name Bank Payment type Account No Swift No Primary 1 DDB Indbetalingskort 80251823 2 DDB Konto til konto 22223333333333 31305042 Cykel Byg DDB Konto til konto 23421234543421 32647894 DDB Udenlandsk ov 56325412547 NDEANOKK 33112288 Jernringen DDB Konto til konto 34522342234223 33112288 Jernringen Nordea DK Domestic refer 80251823 33112288 Jernringen Nordea DK Domestic Trans 32154215485478 33112288 Jernringen Nordea DK International T DK54703213546841654 45451818 DDB Indbetalingskort 80251823 45823445 DDB Konto til konto 32658542154874 5 DDB Konto til konto 12341234567890 75500000 Kolding Keedefabrik DDB Konto til konto 43338272819181 86982311 DDB Konto til konto 98716846546531 Sequence v Update vendors from the bank table DKK dat ur amp E Delete Transfer Change S S S S S lk CEP rPE PPP EP EEE
16. ction END AMC CONSULT Note You have to select a default bank payment type in AMC Banking Setup Default bank before the adjustment will take effect Default bank 1 dat DO 34 PETIT as Default bank Account type lt Bank Payment type Vendor Payment type of the current bank DKK dat ur amp Here set up which bank and payment type are to be used by default when new vendors are created When the user then creates new vendors in the vendor table this prompt box will be displayed EA Creation in AMC Banking 1 m E Edit Tools Command Help File Edi ERA Account name Bank Nordea Dk _cancel_ Payment type Cancel change Account No Swift No When actually setting up a new vendor it will be possible to change the payment type and specify the vendors bank or giro account as well as a SWIFT code where applicable for use for foreign payments to vendors 7 2 HOW TO SET UP A LINK FROM A VENDOR TO AMC BANKING To facilitate maintenance of the AMC Banking bank table it may be a good idea to set up a menu item in the vendor table This will allow you to jump directly from the vendor table to the relevant vendors payment information in AMC Banking To set up this menu item you have to open AOT the Application Object Tree You then find the element type Forms and the form Ve
17. dow Separator Layers Submenu Print Menu reference Save E E Export E Delete s Restore Sy Menu Duplicate E web Find A Reso Tes 4 Refer Add Ins A Syste Properties Applic mem A new window is now displayed from which all menus can be selected Click and drag AMCBankMenu over to the AOT MainMenu The menu item is positioned in the botton of the Main Menu tree If you then want to move the menu item you can do this using ALT arrow up arrow down Save your changes by right clicking on MainMenu and selecting save Close Dynamics AX and restart it Check that you now have a new menu by the name of AMC Banking Installing AMC Banking 2 9 IMPORT BANK RULES Select AMC Banking Periodic Change Export Import mi Export Import 1 dat Table AmcBankAdviceTable Yes File Edit Tools Command Help REX S2QBA VTEVY Table 4 Name of table All open O User AmcBankAdviceTable Bankadvice Shared setup AmcBankDefaultBankAPI Default bank Company acte AmcBankDefField Payment type fields Shared PIRE EE AmcBankDefMainField Main fields Shared x AmcBankDefMainvalue Values Shared eser AmcBankDefPaymType Payment types Shared AmcBankDefTable Bank definition Shared AmcBankDefValue Values Shared AmcBankGlobalField Global fields Shared AmcBankGlobalGroup Field groups Shared Include shared tables Include XTendLink log tab
18. ds a value of 40 but you may need to set it higher 4 Restart the AOS service 4 5 ERROR WHEN OPENING AMC JOURNALS The first time you open one of the two payment journals in AMC Banking the deposit or payment draft the following error may occur Ld Infolog 1 One or more critical STOP errors have occurred Use the error messages below to guide you or call your administrator o 3 Message 12 57 54 9 Unable to save data to the file c Program Files x86 Microsoft Dynamics 4X 50 Client Share include amc_empty_14_14 bmp This problem is due to the fact that you do not have sufficient rights to write to the folder in which the AX client is installed To resolve this problem you either have to be allocated the necessary rights or you should ask a user with rights to write to the relevant folder log in to the computer and then start AX as well as opening AMC Banking Journal outgoing payments This only has to be done once for the client in question Troubleshooting 5 DELETEOLD ELEMENTS If your installation of AMC Banking is an upgrade from an earlier version 2009 you may have elements in AX after installation which are no longer used by AMC Banking These elements should be deleted to prevent compile errors in the application The following elements have been deleted from AMC Banking version 2009 V7 compared with version 2009 V2 V3 V4 V5 V6 Notice You might not have all elements listed below in your
19. dth Auto Height Auto VerticalS pacing Auto Enabled i Ye Skip No AlignControl No HelpTest HTMLHelpFile HTMLHelpTopic ConfigurationK ey SecurityKey DragDrop o None FrameType Auto FramePosition Outside Caption NN ooo FrameDotionButton None Close the group properties and right click again Select New Control String Edit Name the new element PaymentType_AMC EX AOT Forms ComboBox A438 M CommandButton nbn DateEdit E Group GroupHeader E Methods Grid Group InvoiceOvervier Group 8 Group GroupPayment RO E Group Currency GuidEdit Group TaxOverview HTML p Group CashDiscount Group ThirdPartyBank Dp E Int64Edit ap IntEdit C rare roca o t 3 TabPa Nyt vindue em C TabPa Mb MR List View C TabPa Omd b MenuButton l 03 TabP Sx Taba Slet MenultemButton TabPa i E ButtonGro Kopier Progress a i LedgerJournalTransPeri Dupliker RadioButton la LedgerJournalTransTxt E LedgerJournalTransven 58g RealEdit E LedgerJournalTransven Add Ins gt StaticText e LedgerJournalTransven E E LedgerJournalTransYou Egenskaber At amp 27 LedgerLiquidity Tab E a7 a LedgerParameters Table ll la LedgerPaymentControl amp 2 LedgerPaymentControlCur TimeEdit AMC CONSULT
20. e Dynamics AX server G Communication with XTendLink completed without errors mfg Result OK Information This test covers both communication with AMC Consult s XTendLink licence server and the actual service which handles files to and from the banks Therefore you will see responses of two test runs in the info log above Registering for the AMC Banking web service 4 TROUBLESHOOTING 4 1 COMPILE ERRORS IN BANKING ELEMENTS If you experience compile errors in one or more AMC Banking elements following compilation you can attempt the following Try importing the missing elements once more from the XPO file Verify that MAPs in JournalNameMap JournalTableMap and JournalTransMap are set up correctly Verify that the above MAPs are saved Try leaving and going back into Axapta and they should continue to exist and not be highlighted red 4 2 MISSING LABELS IN SCREENS If one or more labels are missing from screens you can try the following Verify that the label file axABAda ald and or axABAEN US ald is located in the Axapta application library in the same place as the rest of the Axapta label files Delete all files which match axABAda and axABAEN US except for the above Then restart the Axapta AOS service 4 3 WARNINGS FOLLOWING COMPLETION OF COMPILING If you see warnings but no compile errors following completion of compiling this is absolutely fine AMC is aware of the problem and wi
21. ePaymT ype Customer bank information Regnskab BanklntfD ataCollection BankIntfD ataCollection Regnskab BanklntfDefaultB ankAPI Default bank Regnskab Bi BanklIntfE portlmport Define import export groups Regnskab BanklntfInterestNoteT rans Marked interestnotes Regnskab BankIntfJournalN ame Name of journal Reanskab BankintiJoumalT able Joumal table Regnskab BanklntfJournalT rans Journal lines Regnskab Veelg alle Export A a le 4 Upgrading AMC Banking from 4 x or previous versions Select the tables you wish to transfer to the new version If Bank Table Vendor is all you need select the tables labelled BankIntfVendTable or simply select all tables by pressing the button on the right It is possible to import only specific tables in the new version afterwards After selecting Export the following window will appear H8 Eksporterer data xi Filnavn EE E EE Vaelg modul Leverandar Z Annuller Choose filename and location in the first subject field and the type of data you wish to export in the second You will have to choose between Customer data or Vendor data since several tables in the previous version of AMC Banking had more than one function Choose Vendor if you need data for the new version of AMC Banking Choose Customer if you need the exported data for a new version of AMC Direct Debit In this case choose Vendor Up
22. endor invoice in the invoice register journal To get anvantage of this functionality you have to to some additional setup of AMC Banking 7 4 1 SELECT DEFAULT BANK Go to AMC Banking Setup Default bank and select the bank you are using for vendor payments E Default bank 1 dat File Edit Tools Command Help 34 DO Tr y Y Default bank Account type 4 Bank Payment type i Nordea DK Domestic Transfer Account type that specifies the type of account the transac DKK dat us S E AMC CONSULT 7 4 2 ACTIVATE THE SUPPORT OF STANDARD AX PAYMENT MODES Go to AMC Banking Setup Parameters On the tab page Vendor mark the check box Axapta payment modes ER Parameters 1 dat File Edit Tools Command Help 5 Vendor Customer XTendLink Reconciliation Version AMC Banking General Triangulation Bank filename O Delete Keep all lines M Journal number dat 20002 Days of grace Cashdisc 0 Transaction text Payment 5 Standard paymenttype Axapta payment modes O Method of payment Keep information on dimensions when adding payments DKK dat ur 23 E 7 4 3 ADJUSTMENTS IN THE INVOICE REGISTER JOURNAL In the following example the required adjustments are shown to make it possible to select a specific AMC payment type for an invoice posted in the invoice register journal E Journal voucher 1
23. ernal modules and it will not be possible to install AMC Banking on these Service packs are tested by AMC as they are released by Microsoft and the results of these tests will be published on the AMC website Therefore make sure that AMC Banking supports the service pack you are using 1 2 CRITICISM APPRECIATED If AMC Banking fails to live up to your expectations you are always welcome to contact your reseller and tell why We will then work in consultation with the reseller to help you get the most out of AMC Banking We will appreciate any criticism of AMC Banking as such criticism provides us with an ideal basis for our efforts to optimise the facilities and user friendliness of the AMC Banking module 1 3 FURTHER INFORMATION You can also visit our website at www amcbanking com where you will find further information on AMC Consult A S and our products As this manual will be updated regularly it will also be possible to download it from our website Ask your reseller Introduction 2 INSTALLING AMC BANKING 2 1 WHAT SHOULD YOU USE FOR INSTALLATION You have to use the following elements The latest basic version of AMC Banking The latest patch from the AMC website if this is later than the above The latest set of bank rules from the AMC website A O KB a The latest set of language files from the AMC website 2 2 COPY LABEL FILES Before starting Dynamics AX you have to copy the supplied label files to
24. g even easier to use AMC Consult has developed a range of supplementary functions which all influence the standard application in Dynamics AX Therefore it is necessary to make a number of adjustments if you wish to use these supplementary functions The adjustments should be implemented by an experienced system administrator or Dynamics AX consultant and this person should be very aware that the adjustments will not conflict with other functions in AX This guide is written only with a view to giving users of AMC Banking a more functional solution by undertaking simple adjustments based on elements in the AMC module AMC Consult is not responsible for any consequences of these adjustments in AX It is recommended unconditionally that you export a backup of the elements concerned before making any adjustments Adjustments of the type specified in this appendix are not covered by AMC Consult s general support agreements for AMC modules Unless stated otherwise the descriptions in this appendix are based on Dynamics AX version 2009 CONSULT 7 1 AUTOMATIC CREATION OF NEW VENDORS IN AMC BANKING This adjustment will allow you to get AMC Banking to create new vendors automatically in the AMC bank table These will take place at the same time as the new vendor is created in the vendor table as the user will be prompted for the details to be used in the AMC bank table You have to undertake the following adjustment AOT For
25. grading AMC Banking from 4 x or previous versions 6 3 IMPORTING DATA TO AMC BANKING 2009 It is possible to import some data from the previous version into AMC Banking 2009 The basic assumption is that the essential data from the previous version is the Bank Table Vendor It can be imported and converted by following these steps Choose AMC Banking periodic Edit Export Import m Export Import 1 dat Table AmcBankAdviceTable Yes File Edit Tools Command Help Name of table All open LS Ouser AmcBankAdviceTable Bankadvice Shared setup AmcBankDefaultBankAPI Default bank Company O Bank rules AmcBankDefField Payment type Fields Shared Oe AmcBankDefMainField Main fields Shared a AmcBankDefMainValue Values Shared O only advice setup AmcBankDefPaymType Payment types Shared AmcBankDefTable Bank definition Shared AmcBankDefValue Values Shared AmcBankGlobalField Global Fields Shared AmcBankGlobalGroup Field groups Shared Include shared tables Include XTendLink log tables Export only open journals AmcBankGlobalvalue Field values Shared select all Export to AmcBankJournalName Name of journal Company AmcBankMainAccount Bank accounts Shared AmcBankMainTable Bank main table Shared AmcBankParameters Parameter table Company AmcBankSequenceTable Bankdays table Shared AmcBankSequenceTrans Bankdays trans Shared AmcBankSwiftTable Bank journal trans field infor Shared AmcBankTemplateBank Bank templates Co
26. king is designed to communicate with XTendLink via web services There are two options to choose from AMC Banking Classic and AMC Banking Enterprise 3 1 1 AMC BANKING CLASSIC AMC Banking Classic is based on web services that can be accessed via the AMC webserver This means that there must be Internet access via port 80 from the Axapta server AMC Banking will use these URL s when running file conversions etc http classic amcbanking com http license amcbanking dk The first time you come to register your module this takes place via the AMC Consult A S website which will be accessed from the Axapta client you are using 3 1 2 AMC BANKING ENTERPRISE AMC Banking Enterprise is based on web services that can be accessed via a separately installed XTendLink server This means that there will be access to one or more XTendLink servers on any port you choose within your own network or VPN However we suggest port 8030 for production and port 8040 for testing Registering for the AMC Banking web service EN C CONSULT 3 2 REGISTRATION To be able to use AMC Banking you have to have set up a valid licence for the module If you do not have a licence already you can register a new one by following the points below Go to AMC Banking setup Parameters and switch to the XTendLink tab pm x File Edit Tools Command Help TEA Vendor Customer XTendLink Reconciliation AMC Banking Use XTendLink
27. lTransInvoiceRegister usr E _ Methods BS Data Sources E 5 LedgerJournalTrans 3 Methods El dispAMC_PaymentNumber dispAMC_PaymentType BE exchRateTxt El correctedTaxAmount aj delete Mio CONS ULT Go to Design Design Tab Tabpage Overview Group GroupHeader og right click BS AOT Forms 7 Methods J TabPage OverViewGrid Methods Grid Grid T xv XYZ Group Group Group 1 2 Group 1 E Group 13 TabPage Gener 13 TabPage TabPa 13 TabPage TabDir 13 TabPage CashD 13 TabPage Histor Open New Window Rename Delete Copy Duplicate Find Add Ins Properties LJ TabPage VendInvoiceinro ab ButtonGroup ButtonGroup 35 27 LedgerJournalTransPeriodic 3 E Ledger m mm ournalTransTxt ActionPane Activex Animate Button ButtonGroup CheckBox ComboBox CommandButton DateEdit Grid se GuidEdit HTML Int64Edit IntEdit Listbox ListView Select New Control Group which will create a new group Right click the new group and select Properties 4 7 j C A b 4 CONSULT Change the name of the group and add the label ABA20000 in the Caption field as shown below lil Control Group AMC_Banking_Group DAR Properties Categories Name AMC_Banking_Group AutoDeclaration No Visible o Yes AllowE dit No Left Auto left Top Auto wi
28. les Export only open journals AmcBankGlobalYalue Field values Shared elect al Export to AmcBankJournalName Name of journal Company AmcBankMainAccount Bank accounts Shared AmcBankMainTable Bank main table Shared AmcBankParameters Parameter table Company AmcBankSequenceTable Bankdays table Shared AmcBankSequenceTrans Bankdays trans Shared AmcBankSwiftTable Bank journal trans field infor Shared AmcBankTemplateBank Bank templates Company AmcBankTemplateField Bank template fields Company S KS S ST ISI ST 51 ST 51 ST T ST ST ST ST ST IST ST 51 S AmcBankTemplatePaymtype Bank template paymenttypes Company Unique name of table DKK dat us amp E The first time the module is installed you should run an import of the setup file for all setup tables in the module This is done by clicking on Setup followed by the Import button Only select this method if you are setting up a new installation as you will overwrite a number of tables which may already contain data If you are in the process of upgrading the module you should always select the Bank rules table list m Import data 1 Method Overwrite Y File name inking 2009 v4 PO Setup 20100222 xml a Find the setup file which you downloaded or received from AMC Consult then click on OK Installing AMC Banking E 3 REGISTERING FOR AMC BANKING WEB SERVICE 3 1 COMMUNICATION VIA WEB SERVICES AMC Ban
29. ll rectify it in a future patch These warnings are of no significance to the operation of the module Troubleshooting 4 4 ERRORIN PAYMENT JOURNAL If you attempt to send many payments from the same draft the following error may arise ES Infotog 5 O x Der opstod en eller Flere kritiske STOP fejl Brug fejlmeddelelserne nedenfor for at FS eller tikald administratoren o Kontrol resultat af journal mas 100021 2 Finanstilag al Kladden er ok 3 Bankregler I Fes under afviting af kode For lidt hukommelse ti afvikling af script Stakspor C Classes TextBuffer getText C Classes AMCBankXTExecuter xtJournalValidate ine 38 5 Classes AMCBankxT journalvalidate Ine 66 Classes AMCBankxT main en us Error executing code Insufficient memory to run script This problem is caused by the fact that the amount of data attempting to be sent is above the general limit for an XML call in Dynamics AX The solution to this problem is to extend this limit As all communication from AMC Banking to external systems takes place from the AX AOS server changing the value of this is sufficient Follow this guide 1 On the AOS server select START gt Run and type Regedit 2 Select HKEY LOCAL MACHINE SYSTEM CurrentControlSet Services Dynamics Server 4 0 instance name config name 3 Set up a new key with the name maxbuffersize lower case letters only and set a suitable value for this AMC recommen
30. mage NormalResource Primary ShowShortCut Text VerticalS pacing Visible Behavior Data AutoDeclaration ConfigurationKey DataSource HelpText HTMLHelpFile HTMLHelpT opic MenultemName MenultemType Name Needed ccessLevel SecurityKey Font Position E EE No Button face 3D Opaque No Auto Text only Default 0 No Button text Auto a No Yes AMC Banking Auto Yes No VendT able Update bank vendortable base data for AMC Banking AMCBankVendT ableCreate Action AMC_Banking View E In the two fields HelpText and Text you have to input the values ABA20003 and ABA20000 When you leave the field the text will be converted as shown above To save your new menu item you have to right click on VendTable Form and select Save Then check that the form compiled without errors You can then close AOT 7 3 HOWTO ADD PAYMENT TYPE AND BANK ACCOUNT IN THE INVOICE REGISTER JOURNAL To ensure that you have the correct payment information in AMC Banking you can use this adjustment to display the payment type and bank account of a certain vendor in the vendor invoice register journal The new fields only displays the information it cannot be changed in the journal form In AOT open the form LedgerJournalTransinvoiceRegister Go to Data Sources LedgerJournalTrans and right click the Methods node Select New Method BS AOT Forms bee oa a Ledger JournalTransBankDep
31. mpany AmcBankTemplateField Bank template fields Company I S S S S S S S E ST ST S SI SC ST ST S 5 ST AE AmcBankTemplatePaymtype Bank template paymenttypes Company Unique name of table DKK dat ur amp E First choose User then the three tables labelled AMCBankVendTable Then press Import and choose the file exported in 6 2 Upgrading AMC Banking from 4 x or previous versions 6 4 CONVERTING PAYMENT TYPES lt is necessary to convert the imported vendor payment types due to a change of names in the 2009 version Before converting your information enter your own bank at AMC Banking Setup Main information Further assistance can be found in the user s manual for AMC Banking It is easiest to convert vendor account types at AMC Banking Periodic Edit Multi Edit Vendor BP Multi edit vendor 1 dat Account type Vendor New Record File Edit Tools Command Help 5 E MN 4 o Selection Default values Vendor account Name Bank Payment type Account No Swift No Primary Selection gt IA AA O Delete Transfer Change Sequence Vendor account number DKK dat ur amp B Choose Selection Selection bank table Select bank table 1 dat Select query AMENA he Modify gt Structure Sy Tables AMC Banking vendors E Vendor bank information Range Sorting Table Field Criteria AMC Banking vendors A
32. ms E E vendTable Methods E Data Sources El Bi vendTable E Methods ul init alue ul active 2 validatewrite EIE listExist In AOT find the VendTable form and go to DataSources VendTable Methods write Press ENTER to open the method In the method insert the following code void write boolean newRecord AMC Banking section START AmcBankDefaultBankAPI amcBankDefaultBankAPI VendTable amcVendTable AMC Banking section END AMC Banking section START select firstonly amcVendTable index AccountIdx where amcVendTable AccountNum vendTable AccountNum AMC Banking section END element numberSegFormHandler formMethodDataSourceWrite if vendTable orig Currency amp amp vendTable Currency vendTable orig Currency if vendTable existOpenOrders if VendTable promptConvertCurrencyCode vendTable convertCurrencyCode newRecord vendTable orig RecId 0 true false super if newRecord DirParty showHideMessageBar element vendTable AMC Banking sectioni START if amcVendTable RecID 0 amcBankDefaultBankAPI amcBankDefaultBankAPI findDefaultBank amcBankAccountType Vendor if amcBankAPI isVendActiveInAMCbanking vendTable AccountNum amcBankAccountType Vendor amcBankDefaultBankAPI Bank AMCBankAPI createVendInAMCbanking vendTable AccountNum AMCBankAccountType Vendor BMC Banking se
33. ndTable e endTable usr E 9 Methods amp 9 Data Sources RI Designs amp Design Tab Tab 2 ButtonGroup ButtonGroug 4 Methods New Control Button 24 MenultemButton smrr 24 MenultemButton Trar Open New Window CommandButton 24 MenultemButton Veni Rename MenuButton 4 MenuButton MenuBu LA MenuButton TradeA Delete a 4 MenuButton Functior Copy Separator 4 MenuButton Query 51 MenultemButton Fore Duplicate a vendTableListPage Find E la vendTableLookup H e vendTrans Add Ins d a vendTransInvoicePool Properties E 57 vendTransInvnirePaniNatPastedi istPa Expand the element by selecting Designs Design ButtonGroup and right clicking on MenuButton Setup Select New control and MenultemButton Your new menu item will be placed at the bottom of the Setup menu in the vendor table but you can move this by holding down the ALT key and moving the menu item to the required location using the arrow keys To adjust the new menu item setup you have to select properties by right clicking or by pressing ALT ENTER You then have to complete the properties as shown below Control MenultemButton AMC_Banking np Properties Categories E Appearance AlignControl BackgroundColor BackStyle Big Border ButtonDisplay ColorScheme Disabledlmage DisabledResource ForcedT oO verflow ForegroundColor MultiSelect Normall
34. ode void lookup if AmcBankParameters find VendUsePaymModeStandard AmcBankVendTablePaymType lookupPaymentType this ledgerJournalTrans else super Close the window and save the changes
35. ositPaymCancel a7 LedgerJournalTransCost LE CE LedgerJournalTransCustBillofExchange a7 LedgerJournalTransCustPaym a a amp R amp E LedgerJournalTransDaily E LedgerJournalTransElimination E LedgerJournalTransInvoiceRegister usr E Methods E fd Data Sources E a LedgerJournalTrans a D H Edit Override Method New Method Open New Window Find Add Ins Properties Sl delete 3 e EC EC pe pe pr p p EC EE NE B In the new method insert the following code display AMCBankPaymType dispAMC_PaymentType LedgerJournalTrans _ledgerJournalTrans i return AMCBankAPI getPaymentType ledgerJournalTrans AccountNum AmcBankAccountType Vendor ledgerJournalTrans PaymMode ledgerJournalTrans currencyCode Close the method and save the changes EF ARA AM U CONSULT R Saas Once again right click the Methods Methods node and select New Method In the new method insert the following code display AmcBankPaymNum dispAMC_PaymentNumber LedgerJournalTrans _ledgerJournalTrans return AmcBankAPI getPaymentNumber ledgerJournalTrans AccountNum AmcBankAccountType Vendor ledgerJournalTrans PaymMode _ledgerJournalTrans currencyCode Close the method and save the changes You should now see these methods PS AOT Forms be TT T Ledger ourna transo ally E E LedgerJournalTransElimination E LedgerJourna
36. pecially for the AMC module This can be done here Administration Setup User groups Now select Administration Setup Security User group permissions Select the group and domain Id you want to add permissions to then click on the Permissions tab Select the security key called AMC Banking Click on Full control on the right of the screen You can also choose only to allocate partial rights to the user group in question AMC Banking is divided into a number of sublevels which you can see by extending your security key Installing AMC Banking CENE 2 8 CREATE A MENU ITEM lt is necessary to create the AMC Banking menu tab manually in the main menu as automatic installation of this risks overwriting any existing adjustments to the menu Be aware that the existing main menu may be adjusted in a higher development layer than the one you are currently in If this is the case you have to switch to this layer before creating AMC Banking in the menu The menu is added by opening AOT Select Menus then right click on MainMenu Select New followed by Menu reference lolx dc E Basic sys El COSCosting sys Cust sys DevelopmentTools sys GlobalToolsMenu sys L3 HRM sys Invent sys JmgMenu sys ImgSignIn sys KMQuestionnaire sys KMScorecard sys LabelTools sys E RE E a E E E E Menu item A R4 Open New Win
37. the application folder on the server When you download the label files you will receive a zip file which contains files for the languages supported by AMC Banking Unzip the files then copy them directly to your Dynamics AX application library e g X Dynamics AX appl standard You should copy only the languages that are relevant to your Dynamics AX installation The language is obvious from the filename For instance the Danish label file is named axABADa ald 2 3 IMPORT MODULE Start Dynamics AX in the development layer where you want to install AMC Banking The file AMC_Banking_2009_V7 xpo which you have received from AMC Consult should be imported now This is done via AOT CTRL D The import function can be found under Command Import or by selecting the icon on the far right of the AOT toolbar Find the file using the Browse button then select Open Select the boxes as shown below then click OK Run the import at least twice to prevent compile errors later File name p Bank Axaptalep 2009 4 NOT RELEASED AmcBanking_2009_Y4 xpo v Import Options Only application objects Delete table and class members Create labels in the label file O Application objects and labels Import with ID values C Enable data recovery for tables with changed IDs _ O Only labels C Show details When installation is complete you will probably see a number of compile errors Proceed to the next section to resolve these
Download Pdf Manuals
Related Search