Home

IDEP for Windows

1. Manually to OneGate All List Entries Automatically to OneGate Select Returns Select Retums From Number 111 To Number 111 Clicking on Select Returns will take the current header selection from the Header list to fill in the range fields From Number To Number Clicking All List Entries will fill in the range from the first till the last approved declaration that is not sent From Number To Number allows to manually select a range of Returns Clicking on the arrow buttons will present a list of approved declarations ready to be sent 9 Jan 15 65 IDNet15manE doc IDEP for Windows IDEP User Manual 8 4 3 1 OneGate When using the Intrastat output option an XML file will be created that will be put in the directory the User has defined in Administrative parameters see Chapter 5 2 The unique filename is composed of the PSI identification or the TPD identification combined with the interchange number Once the file is created depending on the User s choice it will either be uploaded maually or automatically If you prefer to upload Manually to OneGate a message will be displayed showing the name and the location of the XML file to be uploaded Siu i l D i To be manually sent OneGate nbb Jocal usr MOORTGA Documents idep_Cn8 OUT OneGate_150105_09290_BE0000000097 xml In the following screen you can click Connect to OneGate in orde
2. Diagnostics This is of course only possible if IDEP CN8 could be installed NOTE The user interface language of the tool is English IDEP Diagnostic Tool 9 8 2 0 IDEP Diagnostix IDEP 5 1 0 1 found MAPI Email for IDEP available S Restat SEND logs to helpdesk 13 3 Options 9 Jan 15 99 IDNet15manE doc IDEP for Windows IDEP User Manual IdepTest collects a lot of more or less relevant information This is carried out very quickly Once this collection has completed the tool displays the collected information in a scrollable window and one or more buttons are available Button Purpose Show Log Starts the system s default editor on the produced log file Explore Log Starts the Explorer in the exact location where the log file resides If possible the log file name is pre selected This should help the user in locating the log file of interest for sending it to the CNA for instance Repair Repairs the registration of DLLs if this is necessary and possible DLLs this button is not available if this is not possible This option is equivalent to executing REGSVR32 on the suitable DLLs Uninstall Uninstalls IDEP if this is possible this button is not available if there is nothing to uninstall The un installation does not remove the data and may leave shortcuts in place Restart Restarts the application e g after uninstall or repair Send logs to Helps you to send the log files of your Id
3. by clicking the Modify Button or by the F5 key 9 Jan 15 36 IDNet15manE doc IDEP for Windows IDEP User Manual User ID Hans Password 70 Supervisor Editor e Consult O User Name Hans Worst Contact Nr 322 221 44 43 Department Function Default PSIID BEOO00 000 097 TestCo Now the User can be defined by filling in all requested data Mandatory fields to be entered are as follows e User ID the name used on the Login screen e The choice of the type of user Supervisor Editor or Consult if Yes this User has access to all functions If No his access is restricted to those functions required to create declarations see Chapter 6 2 2 Types of Users e Modify if Yes this User is allowed to use Add Modify on the functions he is allowed to access If No he can only Consult them Optional fields are as follows e Password if filled in this password will be requested on the Login screen e User Name e Contact Number Department Function e Default PSI ID if a User often makes declarations for the same PSI he can fill in the field by selecting a PSI from the pick list When the User logs on to IDEP he will immediately have this PSI as his current PSI 7 2 2 Types of Users Users can be limited in their access rights to Functions and or in their rights to Modify data There are three Types of Users 1 Supervisor with Modify authority the default User IDEP
4. option is the default and the range is pre set with the selection in the Header list The process of generating INTRASTAT Output for All PSI s is identical to that for One PSI However no range of Returns can be entered as this range would be different for each PSI Third Declarants can approve one or more declarations for one or more PSI s All approved declarations for all PSI s will be automatically processed in the official output For a Third Declarant the Overview Declarations screen see Chapter 8 6 Overview Declarations allows the presentation of all declarations for all PSI s that are Approved After the transfer of the declaration to OneGate the overview Returns just sent presents all declarations sent for all PSI s With the indicated ticket numbers you can follow the registration procedure in OneGate PSI ID BEO000 000 295 ikke Output OneGate auto 201409 _ Yes Ticket 186652 BE0000 000 097 AA000111 iia Yes Ticket 186654 BE0000 000 196 AA000020 amp Connect to OneGate Close 9 Jan 15 69 IDNet15manE doc IDEP for Windows IDEP User Manual 8 5 Output Log The Output Log function is selected by Return Output Log A log of all official output is kept The User can consult this log under the Menu option Return 9 Output Log Z Output Log x Rx amp z Time Stamp MessageText Correct Output Path a 25 09
5. Declarant Ref Nr CN8 Goods Code Partner Country Descrip A Model 1 UK 01019019 Model 2 AT 01019090 AT a ees 9 Jan 15 50 IDNet15manE doc IDEP for Windows IDEP User Manual STEP 2 Select the Model to be used for the data entry of the return line and press Enter or click OK All values of the Model will be automatically entered in the return line fields The cursor will be positioned on the first entry field of the return line screen 8 2 3 5 Copy Lines from another Return This Chapter explains the use of the facility to copy lines from one return to another return On the Return Overview screen the return to copy lines into is selected Then the Copy Lines function is started via Actions Copy by clicking on the Copy Button or by the SHIFT F6 Keys On the Copy screen a selection of the declarations to copy from can be made using the F2 Key PSIID BE0000 000 196 MACHO amp Co 7 MACHO Co Return Number 2 From Line Return Number ne 1 oi 90 Ce e e For the selected return the User can specify the range of return lines he wants to copy into the new return By default all the lines are copied NOTE 1 Return lines can be copied from any return a Flow other than the current return which could mean that too much or too little information is copied or codes with validity dates are outside the current range Therefore a valid
6. Change current PSI function is selected by Parties Change current PST or by clicking the Change current PST Button B The User always works with data from one PSI at a time except for producing INTRASTAT output or archiving returns for all PSI s To change from one PSI to another simply select the PSI that must become the default from the list of PSI s by clicking on it and then clicking on the OK button or by double clicking on this PSI All the information related to that PSI is now active i e the returns all information under the Menu option PST Info The identification of the actie PSI appears in the Idep title bar wy Intrastat Data Entry Package BEO000 000 097 TestCo Return Actions PSIInfo Parties Import System Syst Maintenance CNS Window Help Re SFO amp fk of Eel 9 Jan 15 39 IDNet15manE doc IDEP for Windows IDEP User Manual 8 RETURN 8 1 The Life Cycle of a Return All actions related to the INTRASTAT return can be executed by activating the Menu bar option RETURN The following scheme gives an overview of all main actions that can be performed on a return The use of the corresponding Menu options and function keys in the software are described in the following Chapters 1 Create a new return gt New header 2 Modify existing return gt add modify delete lines oY 3 Approved return gt Aggregated information return cannot be modified anymore
7. Chapter 11 CN8 1 2 2 Experienced Users The following gives the list of Chapters and Sections which explain the more advanced features Chapter 5 System 5 1 Exchange Rates 5 2 Administrative Parameters 5 3 Select Printer 5 4 Setup Display Chapter 7 Parties 7 2 Users optional only if more than one user 9 Jan 15 2 IDNet15manE doc IDEP for Windows IDEP User Manual Chapter 8 Return 8 2 Edit Returns 8 2 3 Adding Return Lines to the Header 8 2 3 4 Data Entry through Models 8 2 3 5 Copy Lines from another Return 8 2 3 6 Usage of the Import Function 8 2 4 Multi PSI Import 8 2 6 Save Return Line as a Model 8 2 7 Delete Change and Replace Returns 8 5 Output Log 8 6 Overview Declarations optional 8 7 Reports Chapter 9 PSI Info 9 1 Net Mass Calculation Factors 9 2 Line Models 9 3 PSI Goods Codes 9 4 Copy PSI Information Chapter 10 System Maintenance Chapter 12 IDEP CN8 in a multi user LAN Environment 9 Jan 15 3 IDNet15manE doc IDEP for Windows IDEP User Manual 1 3 Terminology used Before installing the package this Chapter will explain some basic concepts 1 3 1 Parties involved in INTRASTAT Data Collection CNA Stands for Competent National Administration This is the statistical office of the User s country in Belgium this is the National Bank of Belgium In case of questions or problems with INTRASTAT or the use of the IDEP CN8 software
8. has been defined as Digit grouping symbol A value of 123 45 will result after import in a value that is 100 times higher i e 12345 The IDEP import process will detect this problem and mark imported lines in this case as Incorrect However when these lines are consulted they will look correct only some values will be 100 times too high The import log file needs to be consulted in System View Import Log to see exactly which errors occurred The Quality Check on maximum and minimum values connected to the CN8 Codes is also carried out during import If a line contains values outside the limits the line is marked incorrect The reason will be shown if the PSI opens and closes the erroneous line See Section 8 2 3 2 for more details on this check When a CN8 Code is imported all spaces are removed from this code This is done because in some cases the CN8 Codes used in import files contain spaces that separate the different CN8 levels This behaviour does not apply to the SDF import format 8 2 4 Multi PSI Import In addition to importing the lines for one declaration at a time IDEP CN8 offers also the possibility to import the information of multiple PSI s for multiple Statistical Periods and both Flows in one session This Multi PSI Import facility is described in full in Section 6 2 Multi PSI Import 8 2 5 Modify Delete or Consult Return Information Modifying Deleting or Consulting a return can be related to the header
9. mules and hinnies excl pure bred for breeding 01019011 Horses for slaughter Number of items 01019019 Live horses excl those pure bred for breeding and for slaughter Number of items 01019030 Live asses excl pure bred For breeding Number of items 01019090 Live mules and hinnies Number of items 0102 Live bovine animals 010210 Pure bred breeding bovines 01021010 Pure bred breeding heifers female bovines that have never calved Number of items _ 01021030 Pure bred breeding cows excl heifers Number of items 01021090 Pure bred breeding bovines excl heifers and cows Number of items 010290 Live bovine animals excl pure bred for breeding _ 01029005 Live domestic bovines of a weight lt 80 kg excl pure bred breeding animals Number of items 01029021 Domestic bovines of a weight of gt 80 kg and lt 160 kg for slaughter Number of items 01029029 Live domestic bovines of a weight of gt 80 kg and lt 160 kg excl animals for slaughter and pure bred breeding animals Number of items _ The User can return the highlighted CN8 Code to the return line data entry screen in IDEP by pressing lt ALT S gt or the Return this code to IDEP Button ES or by double clicking on the selected code The system will ask if the User wants to return the selected value to IDEP or not Special cases are CN8 Codes 99450000 repairs 99500000 small transactions 99600000 discounts and credit notes and 99700000 debit notes
10. via Actions Add or by clicking the Add button or by the F4 key The function Modify Import Format is started in System Format by double clicking on the Import Format or via Actions Modify or by clicking the Modify Button or by the F5 key Note The specification of the import format is explained for Return lines Setting the import format for the other import types PSI Goods Codes Exchange Rates is very similar 9 Jan 15 25 IDNet15manE doc IDEP for Windows IDEP User Manual 2 Modify Import Format New Format 2 x Name Format New Format Descrip Type Of Format Return lines z File Format Excel Path name d users dbtv xls E Rows to skip at start of import 1 Goods Code Mode CNS Goods Code z Unused Field Used Fields Name Order Mame La Declarant Ref Nr a 1 Partner Country __ Goods Description 2 Mode Of Transport Currency Code ae 3 National Region Inv al Foreign Curr gt 7 4 Goods Code seit fe 5 Suppl Units sS 6 Net Mass 4 _ 7 Invoice Value Fj 8 Terms OF Delivery i P 9 Nature Of Transaction bo a The following fields are mandatory e The Name of the Import format used for identification when the actual import action is performed Note that for technical reasons a single quote will be replaced by e The Type of Import Format i e Return Lines Lines Multi PSI PSI G
11. without having to leave the screen Clicking on the left or right part of these Buttons will jump to the top respectively the end of the list 8 2 5 3 Totals by Reference Overview When a return is selected on the Return Overview either in Modify or Consult mode via the SHIFT F7 Key the Totals by Reference Button or Actions Totals by Reference an overview is presented of the total values of the selected return accumulated by Declarant Reference Number This overview enables an easy comparison between the INTRASTAT data entered and the PSI s financial administrative data This function is only available for detailed return lines not for aggregated lines 9 Jan 15 56 IDNet15manE doc IDEP for Windows IDEP User Manual HE Totals By Reference J 2x Declarant Ref Nr Tot Inv Value Number OF Items A sorted presentation on Reference Number can also be made in the detailed return lines overview by clicking on the column header of the Reference Number column Please note that the sorting is in alphabetical order rather than numerical order This means that purely numerical Reference Numbers may not be correctly sorted 1 2 10 11 will be ordered 1 10 11 2 21 8 2 5 4 Error Overviews It is possible that lines containing incorrect values are imported or that lines in which data are missing are saved If a return line contains an error it is marked as incorrect The User can reco
12. 2014 09 49 OneGate auto Yes nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_140925_09490_BE0000000097xm https onegate standard nbb be be 25 09 2014 10 02 OneGate auto Yes _ nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_140925_10020_ gt ml https onegate standard nbbbe a 25 09 2014 10 24 OneGate auto Yes nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_140925_10240_BE0000000097ml_https onegate standard nbbbe bad 25 09 2014 10 38 OneGate auto Yes _ nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_140925_10380_BE0000000097xml https onegate standard nbb be E 25 09 2014 10 58 OneGate auto Yes nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_140925_10580_BE0000000097xm https onegate standard nbb be mi 16 12 2014 14 36 OneGate auto No nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_141216_14360_BE0000000196xml_https onegate standard nbbbe Lei 16 12 2014 15 21 Onegate manual Yes _ nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_141216_15210_BE0000000196xmi oa 17 12 2014 08 17 Onegate manual Yes nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_141217_08170_BE0000000097xml ERI 17 12 2014 08 19 Onegate manual Yes nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_141217_08190_BE0000000097xml E 17 12 2014 08 20 Onegate manual Yes nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_141217_08200_BE0000000097xml z 05 01 2015 10 16 OneGate auto Yes nbb local usr MOORT
13. After the User has entered the those CN8 codes only the applicable fields are presented on the screen The value 6 for Nature of Transaction is automatically filled in when CN8 Code 99450000 is entered and also CN8 Code 99450000 is automatically filled in when Nature of Transaction 6 is entered When the user selects the field Invoice Value while CN8 Code 99450000 is selected a warning will be shown Specify cost of repairing service only not the value of the goods More information about these special codes is available in the Intrastat manual 9 Jan 15 48 IDNet15manE doc IDEP for Windows IDEP User Manual Changed CN8 codes Idep will check changed CN8 codes If you use a code that is no longer valid Idep will replace it by the new correct code or will propose a selection list with possible codes click on to display the options Code 48139000 invalid in 2007 select another CNS Goods C Descrip gt 48139010 Cigarette paper in rolls of a width gt 5 cm but lt 15 cm 48139090 Cigarette paper whether or not cut to size excl in the Form of booklets or tubes and in rolls of a width lt 15 cm Nature Of Transaction 1 AI transactions involving actual chang w Net Mass Partner Ca National Region 1 Flanders v Currency Code PSI Goods Code v CNS Goods Code 48139000 v Invoice Value Code 48139000 invalid in 2007 select another 4 4 Db DP Modify Cancel Net Mass The User can add a maximu
14. Code see Chapter 9 3 PSI Info PSI Goods codes If this is the case the Net Mass is automatically calculated when the number of Supplementary Units is entered e If the User entered a PSI Goods Code but changes the CN8 Code the PSI Goods Code field is cleared 9 Jan 15 47 IDNet15manE doc IDEP for Windows IDEP User Manual e The Net Mass is not automatically calculated when the Supplementary Units are entered because the Net Mass Calculation Factor is linked to the PSI Goods Code that has been cleared Access to CN8 If the User does not wish to work with PSI Goods Codes he can find the correct CN8 Goods Code by the F2 Key on the field CN8 Goods Codeor by clicking on the fal button If the corresponding texts are not installed yet Idep proposes to do it The User now has access to all the CN8 search facilities see the CN8 User manual for details about using the CN8 program Hp Intrastat Data Entry Package BEO000 000 097 TestCo Return Actions PSIInfo Parties Import System Syst Maintenance CNS Window Help Oa ee Al O 5 kt E COMBINED NOMENCLATURE CN8 Self explanatory Texts 2006 A SB S g 21x CNCODE 1 CNCODE Description SUPPL UNIT a gt 0101 Live horses asses mules and hinnies 010110 Pure bred breeding horses and asses 01011010 Pure bred breeding horses Number of items 01011090 Pure bred breeding asses Number of items 1010190 Live horses asses
15. Remove bansuage A a E E KAE IPETO A AAAS ARAGAAAGARANAR ANAL 94 11 MOINS vcdinssentsscitacacsesnceactabuteesisnatcscuas tonswenesscnc nasenndsnscteeatsanbanuncnekseatondtatneassensseuacssaveancsnuaduenteausenes 95 12 IDEP CNS8 in a multi user LAN Environment scccsccsssssssssscsssssssssssscsssssssssesesssssesees 96 T2 1 Introduction oe eee E E E E OS 96 12 2 Functions accessible when only one User logged on sesssssesssreisssrersssreesssreesssrrerssrrerseres 96 12 3 Functions accessible by one User at a time sseeessseeeeessresessresssrrerssrrerssrrerssrrresssrrerssrrersses 97 12 4 Accessing information with multiple Users eee ee eeseeceessneeceeeseeeceesneeeeeessaeeesessaeeeeens 97 13 Di dP NOStICS RRE 99 TSE trOMU CON arrive ce conte cues EAEE TA 99 13 2 CRummingeldepTestic c ccsccttatetctsletetete la totetbeboactehebeandchalssatetalessteleletdelstatedersbebeteteietelbccitite 99 13 3 OPHOMS cies A cor teuct cerca a a a a ML Ma ar aaa uct 99 TSA LOS AME 3 acts bin suc hei b Rt EE AAEE 100 13 5 Collected M ora ON i t r r a lei shal a rE eke ere Terere EEE alata ata aati 100 t36 REPA 000 et ete AA ee oe eee 102 13 7 oWnmstall AA AA AAA AAAA ANAA AARNA AANA AAAAN AAA RANAAARANAAARAN A AAE 102 13 80 IDEP Helpdesk irensten dates On oe Ge Gan A ten Aa ae 08 oe Oe ta La fa le 102 Windows is a registered trademark of Microsoft Corporation Other brand and product names are trademarks or registered trade
16. Retum Creation of a new retum LastUpd 19 12 2006 14 57 idep Declarant Ref Nr Suppl Units 3 ha Partner Country AT Austria Number of items Nature Of Transaction 1 lll transactions involving actual change gt Optional Net Mass 1350 v Mode Of Transport 3 Transport by road e Currency Code F National Region 3 Brussels x Terms Of Delivery CFR Cost and Freight C amp F F Invoice Value 1600 PSI Goods Code 7 CNS Goods Code 01019030 Esel lebend ausg reinrassige Zuchttiere al Be TALDI Case e Copy values of a previously created return line When adding a second return line in the same session it is possible to copy the values of a previously created return line for the same declaration This is possible by using the F6 Key or the Copy Button 3 on the Return Line detail screen The numerical values such as Supplementary Units Monetary Values etc of the return line are made zero in the new return line PSI Goods Codes The in house PSI Goods Codes can be used within the package instead of the official CN8 Goods Code list It is possible to define a relationship between a PSI Goods Code and the corresponding CN8 Goods Code see Chapter 9 3 PSI Info PSI Goods Codes Please note the following e If the User has not yet defined any PSI Goods Codes the field is skipped when using the TAB key e It is possible to connect a Net Mass Calculation Factor to a PSI Goods
17. The returns will be uniquely identified in the whole EU by the PSI Enterprise Number Workstation ID Return Sequence Number e g BEO123456789 AA 000001 CN8 Goods Codes Combined Nomenclature The 8 digit goods codes that are used within all the Member States of the EU The CN8 part of the package provides user friendly facilities to find the correct CN8 Code for the goods the User is Importing Exporting It is possible for a PSI to specify a table within the package that defines a relationship between the goods codes he is familiar with in house and the official CN8 Goods Codes 9 Jan 15 5 IDNet15manE doc IDEP for Windows IDEP User Manual 2 INSTALLATION AND UPGRADE 2 1 Installation and Upgrade as a stand alone Application IDEP CN8 is distributed via the Internet Even though the installation upgrade procedures are quite similar they are described in separate Sections hereafter Minimum requirements for the installation or upgrade are as follows e IDEP requires NET V2 0 or NET V2 0 SP1 SP1 is thus optional This can be installed on the following systems Windows XP SP1 or higher with Windows Installer V3 0 or higher To install NET V2 0 SP1 you need Windows Installer V3 1 and Windows XP SP2 Windows 2000 SP3 or higher Windows 2003 Windows Vista Windows 7 Windows 8 e A monitor with a minimum resolution of 800 x 600 1024 X 768 recommended 20 MB of free Hard disk space O
18. Unlock F9 A j Output INTRASTAT 4 Sent return gt return excluded from second INTRASTAT output Maintenance Dearchive A A y Maintenance Archive 5 Archived return gt return lines deleted in IDEP y Maintenance Delete Headers 6 Return completely removed from IDEP The various steps in the life cycle of a return are as follows STEP 1 STEP 2 Create a return header which identifies a new return see Chapter 8 2 2 Modify the return by changing the return header or by adding deleting or modifying lines Note that lines can be added Manually see Chapter 8 2 3 2 By means of Line Models see Chapter 8 2 3 4 By copying information from other returns see Chapter 8 2 3 5 Via the import facility see Chapter 8 2 3 6 The complete return can be deleted in which case no further steps can be taken 9 Jan 15 40 IDNet15manE doc IDEP for Windows IDEP User Manual STEP 3 STEP 4 STEP 5 STEP 6 Approve the return before INTRASTAT output can be completed see Chapter 8 4 1 At the moment of approval the return lines are aggregated Once the return is approved it can not be modified or deleted anymore If the User still wishes to make modifications the return can be dis approved An approved return can be processed as official output sent to the CNA see Chapter 8 4 3 only once then it is locked from being processed again A return can be unlocked in case the data in the
19. Usage of the Import Function The Multi PSI Import function is selected by System Multi PSI Import The option is only enabled if there is at least one PSI and if the current User has Modify rights Multi PSI Import allows the User to perform a single import function for different declarations Statistical Periods and Flows and different PSIs During the import process Returns are automatically created for the required Statistical Periods and Flows for the indicated existing PSI s if they don t exist yet The Import Format for this type of import therefore includes the PSI Identification Statistical Period and Flow for each Return Line see Section 6 1 Import Format The following screen is presented to start up this function Name Format My MultiFormat Text CS 7 Path name D Users 19112006 1TX 5 Statistical Period format AAAY MM Return Flow format A D OK Cancel Help e Name is selected from the defined Multi PSI Import Formats e Path Name the default name and location of the import file this field may be pre set in the Import Format Definition The Path Name may refer to a WEB location a WEB file the name of the web file must start with HTTP domain or FT P domain thus HTTPS is not supported As soon as the minimal required part of a web file name URL is entered in the pathname field e g HTTP domain somefile txt the field will be marked as correct I
20. ara a a a soni o OEE REST e aoe EOE E O e 55 8 2 5 Modify Delete or Consult Return Information eeeseseeeesseeeesrerserreesssrresssrrerssrrerseres 55 8 23 The Return Header os eis t seere ree ore EErEE EEEE SEEE Eene O SEEE svicadesvtsesaee ETE aE 55 S252 RetUMmMLMes 5 s hicsetstatetetesabetcceteteledetebsteletelabetetetsbatedstebetetetebetedetebatets A aeaaee ea keah 56 8 2 5 3 Totals by Reference Overview seessssseesssrersssreesssrresssrrerserierssrreererreesssrressstreeset 56 O24 ETTOR MEL D AEEA A A 57 8 2 6 Save Return Line as a Line Model t a a ratae aaeeea Erka TSi ka 58 8 2 7 Replace Returns eneinio oe a och stig sated sh ener eae tee 58 83 Draft Output tAE Ai ia REE AA AA AAA AA AAA AAAA AAT 60 8 3 1 Dra Output Formate a ta tie lh itil ihe Cl el ely 60 8 3 2 Draft Output Printic t 3 cc2 cic peecsigs eed been A EEAS O NVE O EEEa O oun nese 61 8 3 3 Draft Output Disks 4A AA AN A AAG GARE AAG ANA ANAR AN ARAN AMAN AU AN Baan 61 8 4 INTRASTAT Output Returns cscsccecsces eet sees ce sect ores eet arero facets 61 8 4 1 Return Approval Disapproval cv as crane ate wi ele ee tea atin 61 8 4 2 ANS Oresated Dats fn i 6 beth EEE T rie te tie te fi 63 8 4 3 Generate INTRASTAT Output 200 eesscecceesnceeceesseeecessaeeeseesaeeseesaeeseeenaeeeeees 65 S43 ONEGA r TEE AAE A mms T 66 8 4 4 INTRASTAT Output All PSI s Third Declarants only oe eeeseeeeeesseeeeeeeseeeeees 68 8 5 Output Bore ea EE E EAE A E
21. as foreign currencie anymore Calculations are done automatically after the User has entered the Currency Code and the Invoice Value in Foreign Currency 9 Jan 15 20 IDNet15manE doc IDEP for Windows IDEP User Manual See the return line data entry screen as an example g Modify Return Line 2 AA000001 Ly x TAE Statistical Period 200612 Thresh Standard Return Corect Yes Flow Arrival Introduction Type Of Retum Creation of a new retum LastUpd 21 12 2006 08 31 idep Declarant Ref Nr Partner Country Nature Of Transaction Net Mass 3244 z National Region Currency Code GBP F PSI Goods Code Inv Val Foreign Cur 17000 CN8 Goods Code 39219019 hdl Invoice Value 25758 E ie ted L boil When a Currency Code is selected from the list the Invoice Value Euro will be automatically calculated after entering the Invoice Value in Foreign Currency The Invoice Value Euro on the Return line and the PSI Model data entry screen is calculated as follows Invoice Value Euro Invoice Value in Foreign Currency divided by lt Exchange Rate of the selected Currency Code gt 5 2 Administrative Parameters The Administrative Parameters function is selected by System Administrative Parameters e oas kn oneer it Manually to OneGate Ga v Automatically to OneGate Output Path Work Station ID Last Interchange Number Enable Archiving 9 Jan 15 21 IDNet15manE
22. calculate values in euro from the value in foreign currency see Chapter 5 1 System Exchange rates This applies to the Invoice Value The User selects the applicable Currency Code in the corresponding field when hovering the Mouse pointer over this field he will see a ToolTip text showing the full description of the Currency The Invoice Value in Foreign Currency can be entered with two decimals to obtain a better precision National Region If a default value for the National Region has been entered in the PSI Parameters screen see Section 7 1 1 Create Modify PSI then the field will be pre set with that value 8 2 3 4 Data Entry through Models Most of the time a PSI has a number of fixed Trading Partners The transactions for these Partners will often be very similar with the exception of values and quantities In order to avoid entering the same data over and over again the User can define a number of Line Models that already contain the field values which are always the same e g Partner Country CN8 Goods Code See Chapter 9 2 PSI Info Line models The following procedure describes the use of the PSI Models see also Chapter 9 2 2 STEP 1 When adding a return line from the Return Overview list press the F9 Key or click x my on the Model Button The list of Models defined for the given Flow of the current PSI is now shown Ex Select Model Name 2 x Search Model Name
23. correct Import format in the list of all defined Import Formats for the import of return lines Select the name of the Import file The name may refer to a WEB location a WEB file the name of the web file must start with HTTP domain or FTP domain thus HTTPS is not supported As soon as the minimal required part of a web file name URL is entered in the pathname field e g HTTP domain somefile txt the field will be marked as correct IDEP will not check if the file actually exists It will not be possible to browse for such a file using the file selection dialog that is normally used therefore the following Specify Path dialog is skipped 9 Jan 15 52 IDNet15manE doc IDEP for Windows IDEP User Manual LT rx Look in 8 My Documents gt e e EB Fe Access My Pictures J D ascout Promedia MEE OCDWORKSC Reflection Documents faoa Qsdfout E D ediout users email Bh o9 csv SS GIVI excel JC GIVI word so instructies ixe My Documents f LAN i Media media_net My Computer y eBooks My Music ie S EZE File name x Open Places Files of type Csv csv 7 Cancel 23 In the box Files of Type a selection can be made between the default type for the selected format or all files This can be useful if the file doesn t have the default extension STEP 3 For a normal file the following procedure applies for a WEB based file see below When the path and name of th
24. field can be clicked on or the F2 key can be pressed which will present a choice of all possible values The User can choose a value from this list by clicking on the desired value Depending on the size of the list two different presentations are used by default e a so called Dropdown Box for short lists clicking on the desired entry puts its value immediately in the field e a selection Window for longer lists an entry is selected by clicking on it and its value is put in the field by clicking on the OK Button In both cases also the up and down arrow keys can be used on the field in which case the possible values will be shown one by one 9 Jan 15 16 IDNet15manE doc IDEP for Windows IDEP User Manual 4 8 2 Field Colours De status of the fields is represented by their colour e Optional field can be filled in not obliged white Field that can only be consulted gray Obliged field yellow Field with errors red Correct field green These are the default settings and can be changed via System Setup Display E Add Return Line 1 AA000001 2 xl S ig lt 2 Statistical Period 200612 Thresh Standard Return Correct No Flow Anival Introduction Type Of Return Creation of a new return Declarant Ref Nr Partner Country FI Finland m Nature Of Transaction 1 All transactions involving actual change Net Mass 56 ha National Region 1 Flanders e Currency Code ai PSI
25. function allows the User to consult the list of Collecting Centers iz A Collecting Center on Collecting Center PRD PSI Name National Bank of Belgium Address DE BERLAIMONTLAAN 14 Post Code 1000 Postal District BRUSSELS Contact Person Telephone Nr 02 221 44 11 NL 44 33 FR FAX Number 02 221 32 99 Contact E mail Address Support Email idep nbb be Routing Address BNBNBB BE amp 6 IMPORT IDEP provides Users interfaces to allow import of Complete Returns Return lines PSI Goods Codes and Exchange Rates The purpose of the import facility is to avoid double data entry when using other applications that already contain the necessary information The import functionality is supported by two functions 1 A function to specify the import format Multiple physical import formats are supported The logical file layout field order field length can also be defined by the User All defined import formats are available to all PSIs 2 A function to perform the actual import Once the User has defined the import formats for a given PSI they can be used each time the import facility is called on the Return lines PSI Goods Codes or Exchange Rates or through the Menu option System Multi PSI Import 9 Jan 15 24 IDNet15manE doc IDEP for Windows IDEP User Manual Both functions are explained in the following sections 6 1 Import Format The Import Format function is selected by
26. header of a return which has been archived remains in IDEP as a reference Only the return lines have been removed from the database The return now has the status Archived Yes 9 Jan 15 86 IDNet15manE doc IDEP for Windows IDEP User Manual If more than one PSI has been created you can archive all sent declarations for all PSI s in one file The features for the archiving process for all PSIs are identical to those of a single PSI However no range of Returns can be entered as this range would be different for each PSI 10 1 2 De archive The function De archive is started in System Maintenance Declaration Maintenance De archive Returns which have been archived can also be moved back into the IDEP database This option is useful in case the User has archived some information and he now wants to restore it in his system It is possible to de archive information from previous releases The procedure for de archiving returns is described in the following steps When the function is started the Overview of Archives is presented g A xE Time Stamp Operation BE enterprise nr 1 User ID Archive file name 18 12 2006 12 35 Archived BE0000 000 097 IDEP LANPRD DFS MNG USERS HOME SCHOLLA aaa BEO000000097_18122006 mdb 04 01 2007 13 55 Archived BEOO00 000 097 idep H USERS PETER BEO000000196_04012007 mdb Search Close Help Every Archive that has been made
27. message are corrupted If a return is not needed on line anymore it can be archived This means that the return is put on disk and the return lines are deleted in the database see Chapter 10 1 1 The archived return can still be put back in the database via the de archiving function see Chapter 10 1 2 After STEP 5 the header of an archived return remains accessible for reference purposes If however this reference is not needed anymore it can be deleted see Chapter 10 1 3 8 2 Edit Returns 8 2 1 Introduction to Data Entry of INTRASTAT Information Actions related to the creation and updating of INTRASTAT returns are started under the Menu option Return Edit Returns or by clicking the Edit Returns Button m i A return consists of one return header and several return lines Therefore the creation of a return basically consists of two steps 1 First the Return Header is created in which the Statistical Period and Flow are specified see Chapter 8 2 2 2 Once the header is created the Return Lines can be added to this return header see Chapter 8 2 3 Return lines can be added in several ways Manual data entry is the simplest way see Chapter 8 2 3 2 By means of Line Models see Chapter 8 2 3 4 By copying information from other returns see Chapter 8 2 3 5 Via the import facility see Chapter 8 2 3 6 Modifying an existing return see Chapter 8 2 4 can be related to modifying
28. of these Users try to modify the same Return on which the other User is working he will get the following message Function already in use Only one User can have access at a time The second User cannot modify the data it is locked by the first User 9 Jan 15 97 IDNet15manE doc IDEP for Windows IDEP User Manual If for some reason for instance a power failure the IDEP package isn t closed properly some data may still be locked when the package is re started A special function takes care of the unlocking of all data in the databases see Chapter 10 4 An automatic refresh mechanism makes sure that multiple Users consult the same data even if they look at the same window for a longer period A refresh is done every 15 seconds 9 Jan 15 98 IDNet15manE doc IDEP for Windows IDEP User Manual 13 Diagnostics 13 1 Introduction In some cases the installation or execution of IDEP CN8 fails Often this is caused by specific conditions on the User s platform Given the almost infinite possible system configurations it is difficult for the Idep Calldesk who wants to provide help to this user to find out the reason for the failure For this reason a tool IdepTest AKA Diagnostics or Diagnostix has been implemented This tool does not require any kind of installation and runs on all Windows platforms 13 2 Running IdepTest The tool named IdepTest exe can be invoked from within IDEP via the Help menu option
29. output the User must first approve the declaration s concerned In the list of PSI Returns the declaration to be approved must be selected It is possible to select a range of declarations to be approved which could be a mix of approvable and non approvable declarations You have the possibility to invoke the Approve All function which approves all eligible declarations for all PSIs 9 Jan 15 61 IDNet15manE doc IDEP for Windows IDEP User Manual The function Approve is executed via Actions Approve by clicking the Approve button v or by the FS key The function Approve All is executed via Actions Approve All available when PSI Returns overview is selected via Parties Approve All always available or by clicking the Approve all button Y If a range of returns is being approved a confirmation message will be issued for each return being processed In the list of PSI returns the flag Return Approved is now set to Yes for the return s concerned CE 2ixl a e IT OSH N E EE Return Number Type Of Return Flow Statistical Period Invoice Value Correct Return Approved Sent Date Sent Time Sent Reference Number Return Archived AA000001 1 A 200512 5 610 Yes Yes ves 15 12 2006 11 49 Yes AAD00014 1 A 200610 384 932 No No No No j 44000015 1 a 200611 418 008 No No No No 44000016 D 200611 65 614 Yes Yes Yes 1
30. sure it is Correct If the user answers Yes the applicable limits for this CN8 Code are automatically updated for the current PSI If the user answers No the cursor jumps to the field likely to be corrected The validation is carried out again when the line is closed In PSI Info Minimum and Maximum Ranges the maximum and minimum values connected to CN8 Codes can be added or modified Refer to Section 9 5 for details The Clear Button can be used to clear all fields on the screen A new screen will be provided automatically for data entry To stop adding lines simply press lt ESC gt or click on the Cancel Button The last still empty Line will not be added to the declaration 9 Jan 15 45 IDNet15manE doc IDEP for Windows IDEP User Manual STEP 2 After having added lines the Return overview screen is presented the User now sees that the new line is added to the list a 79 AxA t G Statistical Period 200612 Type Of Return Creation of a new retum Return Approved No Flow Dispqstatistical Period Thresh Extended Return Correct Yes Item Number Declarant Ref Nr CN8 Goods Code Partner Country Invoice value Correct LastUpd Last Upd By 01019030 1 600 Yes 19 12 2006 14 57 IDEP Search Close Help The list is presented to the User in modify mode If he wishes to Modify information for a specific line he has to select t
31. the User the guidelines as to the order in which the different Chapters in the manual should be read based on the User s experience and interest in the package 1 2 1 First Time Users The following gives a list of the Chapters that are essential for a basic understanding of the package Chapter 1 Introduction on the usage of the package and the terminology The User should start up the package and then follow the order of the Chapters as described Chapters indicated optional are not essential for the usage of the package Chapter 2 Installation and Upgrade Chapter 3 Starting the Package Logon Screen 9 Jan 15 1 IDNet15manE doc IDEP for Windows IDEP User Manual Chapter 4 The Graphical User Interface GUI Chapter 5 System 5 5 Proxy Settings Chapter 7 Parties 7 1 PSI s Attention You have to create at least 1 PSI to be able to use all functions in Idep 7 3 Third Party Declarant optional 7 4 Change current PSI optional only if more than one PSI Chapter 8 Return 8 1 The Life Cycle of a Return 8 2 Edit Returns 8 2 1 Introduction to Data Entry of INTRASTAT Information 8 2 2 Create the Return Header 8 2 3 Adding Return Lines to the Header 8 2 3 1 Introduction 8 2 3 2 Manual Data Entry of Return Lines 8 2 3 3 Utilities for Manual Return Line Data Entry 8 2 5 Modify Delete or Consult Return Information 8 3 Draft Output Returns optional 8 4 Intrastat Output Returns
32. validity dates If the logon date is outside the range of validity dates then the PSI Goods Code is marked with an asterisk which means that the code is not valid for that logon period 9 Jan 15 82 IDNet15manE doc IDEP for Windows IDEP User Manual 9 3 3 Checking validity of Goods Codes Only Valid PSI Goods Codes are presented on the F2 Key and can be selected in the PSI Goods Codes field in a Return Line The validity of PSI Goods Codes is checked at start up of the package after an upgrade In a 2 year package the validity is set as follows e CN8 Code doesn t exist in both years Invalid The User needs to find another CN8 Code for this product e CN8 Code exists in both years Valid e CN8 Code exists in new year but not in the previous Valid Note however that if this PSI Goods Code is used for a declaration of the previous year the CN8 Code will be invalid e CN8 Code exists in the previous but not in the new year the User needs to find the correct CN8 Code for the new year e Inthe List of PSI Goods Codes the column Validate shows these codes e Inthe Modify PSI Goods Code screen the indication Validate is shown Note that if this PSI Goods Code is used for a declaration of the new year the CN8 Code will be invalid In a 1 year package only the first two apply 9 4 Minimum and Maximum Ranges per CN8 code The Minimum and Maximum Ranges function is selected by PS
33. visualise the log file The confirmation message will display a summary of PSIs processed an asterisk is added to new PSIs The log file can be inspected It can be shown at any time via the menu option System Maintenance Download Log Important note Given that declarations are appended running the merge operation again will append the source declarations again After a successful Download operation the Stand alone installation can be removed and a Client Installation can be performed on the former Standalone PC see Chapter 2 2 The procedure can be repeated to combine the data of several Standalone installations into one server 9 Jan 15 92 IDNet15manE doc IDEP for Windows IDEP User Manual 10 6 Download Log The function Download Log is started in System Maintenance Download Log This function presents the log file resulting from a Download Merge operation see Capter 10 5 for details Through this log the User is informed about any re numbering actions performed during the Download operation 10 7 Check for upgrades The function Check for Upgrades is started in System Maintenance Check for Upgrades It will check on the Intrastat web site if any components of the IDEP CN8 package have been replaced by later versions If so a partial re installation of the package will be done in the same way as described in Section 2 The package will be re started afterwards If no upgra
34. 19 5 1 1 Specifying Exchange Rates E E RAEE EE ae 19 5 1 2 Usage of Exchange Ratesinnnu n pies pies pied pied ded n LE sted aed PODON OG GN a 20 S2 Administrative Parameters Stona moone ao oe ao ya I VT SE E eE EE ROTA 21 5 3 SAE O ma i LES ay are EEEE AE EE EE T 23 5 4 Setup D8 Pla ynares reesi te es STe E e SEES SET EESE SEO TET SES SE SEE E EATE Spenenentbeawhee gees 23 Ded SPLOXY Seti SA AAA AA A AAAA AAA AAAA AAA AA AAT 23 5 6 Collecting Centers rs anen TaT oN NE ENEA EEE ES EE E E E NEN EAEN ENE 24 6 IMPORT sisssessssassbssacasstscstssotesstecadecsencadunstonsdoncsonsdacsbassbasubaned sushensteasuanatucssanatunsbeuedeuussustenstasadseus 24 6 1 Import Formate a Akash sat a atid et Tare inet ar Eao kEi eani onsi 25 6 1 1 Specifying the Import F rM t siessiersosrsceroriresdpersroerootpoetiootpsdpeeisostpesi sevir sd peep ir Bets 25 6 1 2 Usage of the Import FUN O a a a a a a hilt a a a aaa a a lets aa a a eaaa ile abate 29 6 2 MultiePSihimports cae ee eh a a a a ae eeo ena Se 31 6 32 gt View MPO OS oi E oh TE AO TOAS ONEN e AENA P E TE ETETEA ERETO as 32 T PARES ren enar EEE EEE R 34 PSD E e E E E E EEE 34 7 1 1 Create Modify PSP ee merre tyetits Ba a ee ree one e Ve EE RO ent 34 bled Copy Information from another PSI oo eee eeeceeesseeeeeesseeeceeseeeceesaeeeeessaeeesessaeeeees 36 Ped E E to se E ested ca pagel t eden tea tee tid eta ged oben seta platen poeta 36 7 2 1 Create Modifya Usei 1 5 5 0s ee ieie oo e
35. 5 22 IDNet15manE doc IDEP for Windows IDEP User Manual 5 3 Select Printer The Select Printer function is selected by System Select Printer Current Printer HP Lasenet 2300 Series PCL 6 Page Orientation Portrait Landscape O Basic font Test printer This option allows the User to select a printer that is installed in his system and to modify its settings If no printer is selected by the User then the Windows Default Printer is selected Without changing the printer s original settings printing in Portrait or Landscape can be selected The Printer Setup button allows the User to change the settings for the printer in the same way as via the Windows Settings Printers option Note that changes made here are applied throughout the entire Windows system 5 4 Setup Display Refer to Chapter 4 6 The Graphical User Interface Setup Display 5 5 Proxy Settings In some companies the internet access passes through a proxy If necessary in the sheet Proxy you can configurate Idep to allow access to the Internet through a proxy f i to upgrade Idep TT 6 zx Email Settings Proxy Address http tstpxy lanprd nbb 8080 ell Username scholla Password Domain lanprd 9 Jan 15 23 IDNet15manE doc IDEP for Windows IDEP User Manual 5 6 Collecting Center The Collecting Centre function is selected by System Collecting Center This
36. 5 12 2006 11 49 Yes EJ aacooai7 D 12 952 aacooots 1 A 200608 833 692 Yes Yes Yes 15 12 2006 11 49 Yes De 44000019 1 A 200608 417 720 No No No No e 44000020 1 D 200612 2 250 Yes Yes Yes 03 01 2007 16 18 No 4a000021 1 D 200612 0 Yes No No No Note the following points e A return can only be approved if it does not contain any errors Correct Yes e The User can approve more than one return if he wants to include multiple returns in one intrastat output e A return can not be modified anymore once it has been approved If however the User still wants to modify information for that return he has to use the function Disapprove which is executed via Actions Disapprove by clicking the Disapprove button or with the key combination Alt F6 It is possible to select a range of declarations to be disapproved which could be a mix of disapprovable and non disapprovable declarations 9 Jan 15 62 IDNet15manE doc IDEP for Windows IDEP User Manual 8 4 2 Aggregated Data Return lines will be available in both detailed as entered by the User and aggregated form once the return is approved This means that the numeric values of return lines with the same code values such as CN8 Code Partner Country etc are accumulated into one aggregated line e g a return of 100 return lines can be reduced to an aggregated return with 30 return lines After Approval and aggregatio
37. 5manE doc IDEP for Windows IDEP User Manual After entry of the CN8 Code the Supplementary Unit Qualifier is presented including a field for the selection of a Net Mass Calculation Factor a Add PSI Goods Codes 2 xj PSI Goods Code New Shoes Ret Goods Desc Yes z CNS Goods Code 64029190 Number of pairs Net Mass Calc Fac e Goods Description Footwear covering the ankle with outer soles and uppers of rubber or plastics excl incorporating a protective metal toecap waterproof a Only the Net Mass Calculation Factors with the same Supplementary Unit Qualifier as the CN8 Code are displayed on the list The Factor specified will automatically be applied to the Return line or Line Model when the particular PSI Goods Code is selected to calculate the Net Mass Clicking the column header Correct sorts on validity showing all the correct PSI Goods Codes first and the incorrect ones at the end 9 3 2 Usage of PSI Goods Codes The PSI Goods Codes function is used during data entry in the following functions e On the Return line and Line Model data entry screen on the field PSI Goods Code using F2 e When importing return lines A PSI Goods Code which is imported is validated against the list of PSI Goods Codes The data CN8 Code Goods Description Net Mass Calculation Factor is taken from the first valid PSI Goods Code in the list 9 Jan 15 81 IDNet15manE doc IDEP for Windows IDEP User Ma
38. DEP will not check if the file actually exists It will not be possible to browse for such a file using the file selection dialog that is normally used The procedure for importing a WEB file is described in Section 8 2 3 6 Usage of the Import Function e External Name to specify the default name of the table in a database for instance in Access or the name of the Worksheet in a spreadsheet for instance in Excel This field may be pre set in the Import Format Definition e Statistical Period Format a valid period consists of 2 or 4 characters for the Year allowed characters are Y J A V A and 2 characters for the Month allowed characters are M T K Valid examples YYMM YYYYMM MMAAAA AAMM KKJJ 9 Jan 15 31 IDNet15manE doc IDEP for Windows IDEP User Manual e Return Flow Format the User must enter here the characters used in his import file to identify Arrival and Dispatch separated by a for instance IE 1 2 A D After clicking the OK Button the import process will start Independently of the fact if the Import Log is seen see next Section 6 3 after the completion of the Import process depending on the results the following screens will be shown e If no errors have occurred the Returns overview of the first PSI for which data has been imported in case data for more than one PSI was present in the import data e Iferrors have occurred the Returns overview of the first PSI for which the errors have
39. E 70 8 6 Overview Declarations enne onesies tes sees oben ses Shen dbs iesite oroesi Sisesti t iseit oe iea 71 Bair REPOTS A AAAA AAAA AA AA AAAA AA AAAA AAA AAA AA AAE 72 BS CEM yoo E aus sacbans oust ous teesbeustauatenabgustensteustensiauetanstnachiarhaasteacucuelea oath 73 D SPSEINE Os viccsicesisatasadassdscensdstvsatessdacgencasacsconsdoncdansdacssasadenstacodsunenstuasuanateessauatunsbensdeuussustanseanadzens 74 9 1 Net Mass Calculation Factors cccesssscccessssccecesssceeceessaceecsssaeeecesssaeeceessaeeesesssaeeseessaeees 74 9 1 1 Specifying Net Mass Calculation Factors ce eessccccesssececeesseeeeesseeeseeseeeseesaeeeeees 74 9 1 2 Usage of Net Mass Calculation Factors ecsceessseeceessseeeceesneeeceesseeeceessaeeesensaeeesees 75 D2 eme Model seinen cis tier a ce MaMa ia BM Bl iat ie alate el 77 I T A SP 77 Specifying Line KoT E REENE faa AAR AAR ARAN AMSH ARGH ARGH ANGHANGH AMAR ANA AMAL 77 9 2 2 Usage of Eme Models tin norin e a ae Tear Aae Na a A aE O EN 79 93 IPSI Goods Codes a oa as ereer e te PRA A RR AR PT AW ss 79 9 3 1 Specifying PSI Goods Codes soseseesseeeessseressseressseeresssseressseeessseteressereseseresereressseees 80 9 3 2 Usage of PSI Goods Codes e r iii in in en nas tenets E 81 9 3 3 Checking validity of Goods Codes 0 eeeeeesssccceessneeceessnceecesseeeceessaeeseesaeeseeenaeeeeees 83 9 4 Minimum and Maximum Ranges per CN8 code 0 0 0 eeeeeeeeesseeeeeesneeeceese
40. GA Documents Idep_Cn8 OUT OneGate_150105_10160_BE0000000097xml_https onegate a2a nbb be crs esb weak invoke uploadFlev1 0 05 01 2015 10 41 OneGate auto Yes nbb local usr MOORTGA Documents Idep_Cn8 OUT OneGate_150105_ 10410 2ml https onegate a2a nbb be crs esb weak invokejuploadrilev1 0 jams Search Close Help The Message text column merely shows if you have prepared the declarations in order to upload them Manually to OneGate or if you have uploaded them Automatically to OneGate Manually to OneGate means that you have to login to OneGate and upload the XML file yourself The success or failure of this particular output is indicated in the Correct column The Output column shows the file name and location The column Path contains the path information After having selected an interchange by Actions Consult by clicking the Button Consult Q or the F6 Key or by double Clicking on the interchange the User will see a list of the messages in the interchange One message corresponds to one return for a given PSI The most essential data of the selected return is presented in the lower window This information corresponds to that shown in the Returns Just Senf overview that is shown immediately after performing the Official Output 05 jan 2015 10 41 You can logon to OneGate via connect to OneGate to check the status of your declarations in OneGate nbb local us
41. Goods Code CNB Goods Code 545454547 l Invoice Value 78554 i be Invalid value CNS Goods Code 4 8 3 TAB Order Users who prefer to work with Keys rather than the Mouse can use the following options If Enter as TAB in Setup Display is disabled then the TAB Key is used to jump from one field to the next and to the Buttons The Enter key can be used to activate a Button If Enter as TAB in Setup Display is enabled then the Enter key will move the focus to the next element field or button that can get the focus Pressing Enter on the last element will move the focus back to the very first element The original behaviour of the Enter key Enter is equivalent to pressing the OK button is disabled in all windows except lists Pressing Enter on a button e g OK or Cancel will activate the button instead of moving the focus Pressing Shift Enter will move the focus to the previous element just like Shift TAB would do The original behaviour with the Shift TAB key is unchanged 9 Jan 15 17 IDNet15manE doc IDEP for Windows IDEP User Manual 4 8 4 Sort Order In many lists presented in IDEP clicking on the Column Header will perform a Sort function For instance clicking on the Correcf Column Header will sort on Correct Yes and Incorrect No entries in the list 4 9 Notations used in the next Chapters of this Manual From the previous Sections of this Chapter it wi
42. I Info Minimum and Maximum Ranges The maximum and minimum values connected to CN8 Codes can be added modified consulted deleted and printed by the User They are automatically updated or created when during manual entry of return line data the user has indicated that certain values are within the accepted limits for his trade operations see Section 8 2 3 2 for more details 9 4 1 Specifying Minimum and Maximum Ranges The function Add Minimum and Maximum Ranges is started in PSI Info Minimum and Maximum Ranges via Actions Add or by clicking the Add button or the F4 key 9 Jan 15 83 IDNet15manE doc IDEP for Windows IDEP User Manual The function Modify Minimum and Maximum Ranges is started in PSI Info Minimum and Maximum Ranges by double clicking on the Goods Code or via Actions Modify or by clicking the Modify Button or the F5 key Modify Minimum and Maximum Ranges 01019030 2 x CNS Goods Code 01019030 Number of items Live asses excl pure bred for breeding Minimum Yalue per Suppl Unit Maximum Value per Suppl Unit Minimum Yalue per Kilogram Maximum Value per Kilogram Minimum Kilogram per Unit Maximum Kilogram per Unit The User can enter here his own figures for the Maximum and Minimum values connected to the CN8 Code that are used to quality check each declaration line after it is completed These figures overwrite the ones that are pro
43. I Returns I Rv Saee la 4 4 Window Menu The Window Menu option allows manipulation of the open windows It offers the following possibilities e Cascade open windows e Tile Vertical of open windows e Close All open windows A list of all open windows allows the activation of a selected window 9 Jan 15 13 IDNet15manE doc IDEP for Windows IDEP User Manual 4 5 Help Menu The Help Menu provides the general Help items Table of Contents of all available Help Information On this Screen Support information With the Diagnostics option a dedicated diagnostic tool called IdepTest is run This tool collects information which can be sent to the NBB Calldesk in case of problems installing or running IDEP CN8 The tool can also be run directly from the installation CD ROM Please refer to Section 12 Diagnostics of this Manual for more details on IdepTest The About option provides information relating to IDEP CN8 itself Help on specific Topics is provided through the Table of Contents or the Help button presented on the various IDEP CN 8 screens The Help form is a so called modal form which allows switching the focus back to the Main application The Help window may be maximised and minimised For subsequent invocations its last location size will be restored e g if the User has moved sized it If the Main window is minimised the Help window wil
44. IDEP FOR WINDOWS USER MANUAL Version 2015 BE National Accounts Institute National Bank of Belgium External statistics Boulevard de Berlaimont 14 B 1000 Brussels IDEP for Windows IDEP User Manual Table of contents 1 INTRODUCTION sicssisnsicscdsontesnscsusesctssnsdnscesscesesutesuoescaedoneacuesecesusndensissssusssusedesecasesucasusedeandepencte 1 1 1 Important Remarks on the Software Package eeeeeeseesesseesesreesssrrerssrrerssrrerssrresrssrrerssreeesse 1 1 2 How to use the Mata rrera E eaaa E a aE aa ia e A ha ri rE oraren 1 1 2 1 irst Vine UR AAAA AAAA AAAA AAA AA AAA 1 1 2 2 Experienced USerS yot ran e E T E EE EAEI E TEA STE O NENA 2 Lore e VELMINOIOS y USE sne ern a a aa a hot foo Ooh hun a aa tus Stas 4 1 3 1 Parties involved in INTRASTAT Data Collection seseeeeeeeeeeeeeeeeseereeserrrerssrresssrrerseree 4 1 3 2 Main Data involved in INTRASTAT Declarations eeeeeeeeeeeeeseeeeeerreessrreerssrrerssrrerseree 5 2 INSTALLATION AND UPGRADE esseseeeseesceroreeeeseesorsceereeeseesoreoreeeeseesoreoreceesersoreereeeeeeesorssreeee 6 2 1 Installation and Upgrade as a stand alone Application eeeeeeeeeeeeeeeeesesreeserrrrssrrrerssrrerssrrees 6 2 1 1 Installation and upgrade from the Internet eeeseeneeeeseeessseeesssrresserrerssreerssreesssrrerssree 9 2 2 Installation and Upgrade in a Local Area Network LAN esseesessssesssssersssrresssrresssrrerssrrerssree 9 2 3 Download of Standalone Installa
45. Import Format 6 1 1 Specifying the Import Format Select the Menu option System Format The list is pre set with Default Formats the Import Format can be modified They can be used to perform import and they may serve as examples for User defined Formats 2 xi 7 A x G z Name Format Type Of Format File Format Delimiter Path name a Return Lines IT sc Return lines Text k Return Lines ITX tab Return lines __ Return Lines SDF Return lines Text __ Return Lines SDV Return lines Text __jAllImp Return lines Text 5 H TESTASC File OUT April 2006 txt CTRL list Draft Print Order Excel TAB LANPRD DF5 MNG USERS HOME SCHOLLA aaalintgebruik xls __ Draft Print Order Draft Print Order Text TAB __ Eigen Formaatintern Draft Print Order Excel TAB d users Intra xls _ Import 2 Return lines Text 3 __ Import QR Return lines Excel TAB __ My Multi Format Lines Multi PSI Text 5 D Users 19102006 itx New Format Return lines Excel TAB d usersidbtv xls mel back favna ab Makwe linne Curent TAD d Defining a new Import Format will allow the User to specify the Type of Import for which the format is intended i e Returns Return Lines PSI Goods Codes Exchange Rates and the physical format dBase Text Excel Furthermore the User can specify the default name and location if there is one of the file containing the import data The function Add Import Format is started in Import Format
46. LL is available and has the required version If the DLL is not correctly registered it is possible to correct repair this by using the built in repair feature of IdepTest This will execute an operation similar to REGS VR32 If the tool did not encounter any repairable problems with the DLLs the repair feature is not available 13 7 Uninstall A complete de installation of IDEP including any system files that may have been installed is normally done by the Windows Installer via the Control Panel Add and Remove Programs If this fails for some reason it is considered extremely dangerous to try uninstalling with another tool as this could render the system useless if shared system files are removed it is very difficult if not impossible to detect if a system file is shared on a system where the Windows Installer based de installation failed in the first place If IdepTest detected IDEP uninstallation information the uninstall feature will be enabled If this feature is invoked only the uninstallation information and DLLs installed by IDEP s Install program will be removed Any user data and shortcuts that may be available will not be deleted 13 8 IDEP Helpdesk 32 2 221 4411 NL EN 32 2 221 44 33 FR email idep nbb be 9 Jan 15 102 IDNet15manE doc
47. MOLLUSCS AND OTHER AQUATIC INVERTEBRATES v CHAPTER 4 DAIRY PRODUCE BIRDS EGGS NATURAL HONEY EDIBLE PRODUCTS OF ANIMAL ORIGIN N v CHAPTER 5 PRODUCTS OF ANIMAL ORIGIN NOT ELSEWHERE SPECIFIED OR INCLUDED v SECTION Il VEGETABLE PRODUCTS v CHAPTER 6 LIVE TREES AND OTHER PLANTS BULBS ROOTS AND THE LIKE CUT FLOWERS AND ORNA v CHAPTER 7 EDIBLE VEGETABLES AND CERTAIN ROOTS AND TUBERS iv CHAPTER 8 EDIBLE FRUIT AND NUTS PEEL OF CITRUS FRUIT OR MELONS v CHAPTER 9 COFFEE TEA MATE AND SPICES v CHAPTER 10 CEREALS v CHAPTER 11 PRODUCTS OF THE MILLING INDUSTRY MALT STARCHES INULIN WHEAT GLUTEN v CHAPTER 12 OIL SEEDS AND OLEAGINOUS FRUITS MISCELLANEOUS GRAINS SEEDS AND FRUIT INDUS v CHAPTER 13 LAC GUMS RESINS AND OTHER VEGETABLE SAPS AND EXTRACTS v CHAPTER 14 VEGETABLE PLAITING MATERIALS VEGETABLE PRODUCTS NOT ELSEWHERE SPECIFIED Ol v SECTION III ANIMAL OR VEGETABLE FATS AND OILS AND THEIR CLEAVAGE PRODUCTS PREPARE i CHAPTER 15 ANIMAL OR VEGETABLE FATS AND OILS AND THEIR CLEAVAGE PRODUCTS PREPARED EDI v SECTION IY PREPARED FOODSTUFFS BEVERAGES SPIRITS AND VINEGAR TOBACCO AND MANU lt gt 9 Jan 15 95 IDNet15manE doc IDEP for Windows IDEP User Manual 12 IDEP CN8 in a multi user LAN Environment 12 1 Introduction In a LAN environment where several Users can access the same functionality and the same data at the same time it can be necessary to restrict the use of some of the functions and simu
48. N IDEP CN8 can be used in an environment where more persons are working on Intrastat declarations at the same time on different work stations but on the same installation of the program This so called Client Server environment is created by first installing the program on a Server system and then installing the Client systems A Client installation can be seen as a Reference to the IDEP CN8 installation on a Server The procedure to install or upgrade an IDEP CN8 Server is completely identical to the installation or upgrade of IDEP CN8 Standalone as described in the previous section An IDEP CN8 Client is installed by following the same procedure however e only minimal hard disk space is required e the Client option must be selected e the Destination location to be entered must be the location where the Server is installed e this procedure will only perform the copying of some Windows system files For details and restrictions on the use of the Client Server concept see Chapter 12 2 3 Download of Standalone Installations to a Server IDEP provides the possibility to convert Standalone Installations into a Client Server configuration This means that the individual databases of the Standalone Installations are combined into one database on a Server system which in fact may be one of the original Standalone systems This function is provided as a Menu option in the System Maintenance Menu and fully described in Chap
49. SI name 9 Jan 15 12 IDNet15manE doc IDEP for Windows IDEP User Manual The Menu bar presenting the main options Sub options are shown by clicking on a main option e The Toolbar giving fast access to the major functions via Buttons e The second Toolbar with context dependent buttons which appear and disappear when applicable corresponds with the Actions Menu So called ToolTips provide brief information when the mouse pointer is positioned on a Button In the example the mouse pointer is positioned on the Tool bar button Intrastat Output E Intrastat Data Entry Package BE0000 000 097 xX Return Actions PSIInfo Parties Import System Syst Maintenance CNS Window Help cna Of Sele Intrastat Output e The IDEP information area e The Status bar 4 3 Actions Menu Toolbar The Actions Menu option is disabled when the package is started for the first time It becomes active when another Menu option is selected and then shows all possible actions in the current conditions The same options become available as those buttons in the context dependent buttons area Holding down the right mouse button anywhere on the screen presents the User with the Actions Menu The example shows the Actions Menu Toolbar after selection of the Edit function W Intrastat Data Entry Package BEO000 000 097 x Return Actions PSIInfo Parties Import System Syst Maintenance CNS Window Help OA ie ee HH PS
50. This User can perform all functions in the package 9 Jan 15 37 IDNet15manE doc IDEP for Windows IDEP User Manual 2 Editor Normal User with Modify authority This User can perform the functions for every User except some functions that are resered for the Supervisor He can Consult the Supervisor functions 3 Consult Normal User without Modify authority This User can Consult the functions for every User 7 3 Third Party Declarant Note This point is only of interest to a Third Declarant The Third Party Declarant function is selected by Parties Third Party Declarant With this function a Third Declarant can enter his Identification data Third party declarants who wish to upload intrastat returns of their clients automatically into OneGate can fill in here their own OneGate user name and password if the intrastat reporting of these clients is linked as a result of procurations of these clients see www onegate be FAQ ty nos mrs pary oea ee a Third Party Decl Declarant ID BEO000000196 Name Test TP Address Coronation Street 10 Post Code Postal District Contact Person Telephone Nr FAX Number Contact E mail Address hans schollaert nbb be OneGate Username OneGate Password a Refer to the Chapter 7 1 Parties PSIs for the explanation of the various fields 9 Jan 15 38 IDNet15manE doc IDEP for Windows IDEP User Manual 7 4 Change current PSI The
51. al To add an Exchange Rate the User needs to specify e A unique Currency Code the User can not enter his local currency e An optional Description e Either the Exchange Rate of the new Currency 1 NEW Currency x Euro or 1 Euro x NEW Currency Exchange Rates can also be imported from outside IDEP The Import Exchange Rates function is called from the Exchange Rates screen via Actions Import or by clicking the Import Button ac or by the F9 key Read Section 6 Import for guidelines on how to define the import format and use the Import function A Correct Indicator is shown on the Exchange Rates overview because currencies entered via the Import function may contain errors Note that imported Exchange Rates will update the correct Rates that already exist Exchange Rates can also be exported to a file The Export Exchange Rates function is called from the Exchange Rates screen via Actions Export or by clicking the Export Button or by the Control F9 key Possible output formats are MS Access MS Excel Text TAB XML and HTML The output format is selected by choosing the appropriate extension in the Save As function of the output file selection 5 1 2 Usage of Exchange Rates The Exchange Rates are used to perform currency conversions e Inthe Return line data entry screen e Inthe return line Model data entry screen The old EMU currencies can t be selected
52. alone installation to the Server e All data of PSIs that didn t yet exist on the Server e Exchange rates that didn t yet exist on the Server e If the Stand alone installation contains another language than the Server installation the new language is added to the Server If Download is completed a message is presented 9 Jan 15 91 IDNet15manE doc IDEP for Windows IDEP User Manual Merging the data of a PSI For a PSI that occurs in both the source and target installations i e the currently running IDEP IDEP will attempt to merge the PSI data Declarations from the source PSI will be appended to the list of declarations of the destination PSI The Last Return Number will be used to assign a new declaration number to the added declarations The new assigned numbers will be reported Duplicate declarations that are Archived or Sent will be ignored and reported The PSI s Information Data Models PSI Goods Codes etc will be copied and duplicates will be silently ignored PSIs that to do not exist in the destination installations will be upgraded into the destination It is possible to merge any previous installation There is no restriction on the version number of IDEP to be downloaded into the current IDEP version After the merge of PSI data IDEP will check the validity of line models A log file will contain detailed information about the merge operation Once the operation has completed the user gets the choice to
53. ation process is carried out Redundant information is blanked out Missing or in correct information marks the return line as in correct Note that lines can also be copied from one area of the same return to another area NOTE 2 Lines for a replace return see Chapter 8 2 5 are automatically copied from the original return on creation of the Header The numeric entry fields are always copied Invoice Value Net Mass The reason is as follows The replace return should replace the return from which the lines are copied Almost all information should be identical 9 Jan 15 51 IDNet15manE doc IDEP for Windows IDEP User Manual 8 2 3 6 Usage of the Import Function The Return Lines can be imported for a given return from a file outside IDEP The import format specifying the physical format and logical file layout has to be defined before this function can be used see Chapter 6 Import All lines in an import file have to be related to the same return i e same Statistical Period and Flow The following procedure describes the use of the import function STEP 1 STEP 2 Call the Import function for the selected return via Actions Import by clicking on the Jmport Button ac or by the F9 Key in the Modify Return Overview screen or in the Import menu through Import in current Declaration or Import in new Declaration Name Format ifs Text CSV F Path name Select the
54. been reported there could have been errors for more than one PSI e If no data has been imported at all no declarations have been created the Returns overview of the current PSI This also happens if the multi PSI dialog was dismissed without importing anything at all e In any case the most appropriate Returns overview As usual the last declaration will be pre selected If import lines contain no or incorrect PSI Identification Statistical Period or Flow they can t be connected to any Declaration A LOG file is produced which shows the eventual errors that occurred during the process The LOG file can be presented at the end of the process see next Section 6 3 View Import Log A special record where all fields except PSI Identification Statistical Period and Flow are empty creates a NILL return In fact the PSI Identification can also be left blank if it is defined in the Import definition If a return already exists for the given PSI Identification Period and Flow combination then no extra NILL return is created 6 3 View Import Log The View Import Log function is selected by System View Import Log It can also be presented at the end of an import session The Import Log is of particular interest for the Multi PSI Import function as Return Lines without or with incorrect PSI Identification Flow or Period can t be imported in IDEP and are only listed in this log Information stored in th
55. ctor Descrip ee e The Net Mass on the Return line and the Line Model data entry screen is then calculated as follows Net Mass Supplementary Units lt Calculation Factor selected from the table gt 9 Jan 15 76 IDNet15manE doc IDEP for Windows IDEP User Manual When no Supplementary Unit Qualifier is attached to the CN8 Code entered then the Supplementary Units cannot be entered in the Return line or Line Model When a Net Mass Calculation Factor defined for the Qualifier is applied on the field Net Mass no multiplication is done but the Factor is copied into the Net Mass field as if the number of Supplementary Units was 1 Note A Net Mass Calculation Factor can be connected to a PSI Goods Code This allows IDEP to calculate the Net Mass automatically when the number of Supplementary Units is entered and a PSI Goods Code is used in a Return Line or a Line Model that specifies a Net Mass Calculation Factor This automatic calculation is also done during Return Line import See section 9 3 for the definition of PSI Goods Codes To calculate the number of Supplementary Units from the Net Mass the same procedure as described above is followed with the focus on the Supplementary Units field The calculation done is Supplementary Units Rounded value of Net Mass lt Calculation Factor selected from the table gt 9 2 Line Models The Line Models function is select
56. data the PSI Returns list or to the list of return lines the Return Overview A return can only be modified or deleted if it has not yet been approved Consultation of the return is always possible Select the PSI Returns list under the Menu option Return Edit or by clicking the Edit Returns Button m 8 2 5 1 The Return Header To Modify Headers select the return that has to be modified and use Actions Modify Header or click the Modify Header button T4 f Note that only the Flow and Statistical Period can be modified In all other cases a new Return Header has to be created the line data may be copied from the original return using the Copy function see Chapter 8 2 3 5 To Delete Headers select the return that has to be deleted and use Actions Delete or click the Delete Button or the F7 Key 9 Jan 15 55 IDNet15manE doc IDEP for Windows IDEP User Manual It is possible to select a range of returns to be deleted which could be a mix of delete able and non delete able already Approved returns To Consult Headers select the return that has to be consulted and use Actions Header or click the Header Button Q or the F11 Key 8 2 5 2 Return Lines To Modify Return Lines or Delete Return Lines double click on the return that has to be modified Instead of double clicking Actions Modify or the Button Modify or th
57. de is available the following message appears Intrastat Data Entry Package Message Number 500 Gi No new IDEP CN8 upgrade available at CNA Web site Note the check box Proxy with Login in System Display Setup should be switched on if Check for Upgrades doesn t work due to security restrictions of a Proxy server 10 8 Install extra features The function Install extra features is started in System Maintenance Install extra features It allows the User to add GUI languages to his IDEP CN8 installation if they are available on the Intrastat Web site It also replaces missing or possibly defective components it detects and thus performs a repair function A partial re installation of the package will be done in the same way as described in Section 2 The package will be re started afterwards If no extra Features are available still some components will be replaced 9 Jan 15 93 IDNet15manE doc IDEP for Windows IDEP User Manual 10 9 Remove Language The function Remove Language is started in System Maintenance Remove Language If there is only one single language this option is not available it will be hidden or greyed if the last removable language has been deleted A language selection dialog will be shown with the languages that can be deleted BE Remove Language Help a Only one language can be deleted at a time The current
58. der in the field Type of Format Which fields appear on the printout or the output on disk can either be defined by the User or he can use the available default format re a Add Import Format 2 xi Name Format New draft Descrip Type Of Format Draft Print Order File Format Excel Path name d users intra xls Unused Field Name IA PSI Goods Code Goods Description Currency Code Inv al Foreign Curr Correct RIESE b 2 iC Used Fields v Order Name 1 Partner Country 2 Nature OF Transaction 3 National Region 4 CNS Goods Code 5 Net Mass 6 Suppl Units 7 Invoice Value 8 Mode Of Transport 9 Terms Of Delivery J Add The User can specify if he wants to include a Correct Indicator in the output for each Return Line When creating Draft Output the User selects if the output appears on paper or in a file on disk If he selects Paper all defined formats can be applied only the Draft Print Order is used to define what is printed and in which order If he selects Disk the output will be in the selected Import Format 9 Jan 15 30 IDNet15manE doc IDEP for Windows IDEP User Manual 6 2 Multi PSI Import For a good understanding of the Multi PSI Import function please read first the description of the normal Return Line Import function used to import Return Lines for one single Declaration found in Section 8 2 3 6
59. doc IDEP for Windows IDEP User Manual The administrative parameters consist of a set of values that allow the User to specify the following 1 INTRASTAT Output The ser can select the way s in which the output of an INTRASTAT return can be uploaded in OneGate manually or automatically In case of Manually to OneGate users should specify the location where they want the information to be placed prior to uploading If this path does not exist on the system it will be created automatically during the creation of the output file 2 The workstation ID It is necessary to specify a different value for the Workstation ID for every installation of the package when INTRASTAT returns for the same PSI are created In a LAN environment the workstation ID has to be set for each server installed The workstation ID will then be the identifier that will uniquely identify the returns see also Chapter 1 3 2 3 Last Interchange Number The number of the Last Interchange message by email or diskette sent to the CNA will be presented here 4 Enable Archiving Yes No This option allows you to disable the archive functions Archive functions can be found under System Maintenance Declaration Maintenance see chapter 10 1 Declaration Maintenance When archiving is disabled it is possible to delete sent declarations under Return Edit without prior archiving Attention deleted declarations can not be recovered 9 Jan 1
60. e a regular Clean Up improves the performance of the system 9 Jan 15 90 IDNet15manE doc IDEP for Windows IDEP User Manual 10 5 Download The function Download is started in System Maintenance Download as Upload IDEP provides the possibility to convert Standalone Installations into a Client Server configuration This means that the individual databases of the Standalone Installations are combined into one database on a Server system which in fact may be one of the original Standalone systems or a new clean installation Download is only possible if both installations i e the Server and the Stand alone installation have the same Version of IDEP installed of the same Member State To perform this operation the function must be started on the intended Server system In addition to the general rule that no second User may be logged in when performing a System Maintenance function as described in the introduction of this Chapter to execute this function it is also required that no User is logged in on the Stand alone system The User must indicate the path where the Member State directory of the IDEP for Windows Stand alone installation is found Please select the directory where IDEP TNG is installed F O Common Files a Lt C BEL D BIN 5 CNSDATA D Loc ieee z d corel Z After clicking OK the following data is downloaded from the Stand
61. e F5 Key can be used after selecting a return from the list The Return Overview is now presented in modify mode for that return e To Modify Return Lines double click on the return line that has to be modified The Detailed Return Line screen is presented in modify mode for that line Instead of double clicking the Button Modify f the F5 Key or Actions Modify can be used after selecting a return line from the list The Buttons Nex and Previous can be used to select other lines in modify mode without having to leave the screen Clicking on the left or right part of these Buttons will jump to the top respectively the end of the list To Delete Return Lines the Button Delete the F7 Key or Actions Delete can be used after selecting a return line from the list To Consult Return Lines Actions Consult the Button Consult Q or the F6 Key can be used after selecting a return from the list The Return Overview is now presented in consult mode for that return e To Consult Return Lines double click on the return line that has to be consulted The Detailed Return Line screen is presented in consult mode for that line Instead of double clicking the Button Consult Q or the F6 Key or Actions Consult can be used after selecting a return line from the list The Buttons Nex and Previous can be used to select other lines in consult mode
62. e import file have been selected the import selection screen re appears If the import format type requires an External Name i e the name of the database table in Access or the Tab name in Excel format see Section 6 2 1 Import Format an additional field is presented in which this Name can be entered The name is pre set if it was already defined in the import format or if there is only one table or Tab name found in the given import file a 1 Import Name Format New Format Exce Pathname H USERS PETER annex2005 xls fe External name F nenna 9 Jan 15 53 IDNet15manE doc IDEP for Windows IDEP User Manual STEP 4 This STEP is different in case a WEB based file has been selected For a WEB based file the following procedure applies Once the URL has been entered in the file name field it will not yet be possible to present a list of tables or sheet names as the file must be downloaded first to be able to present this list If in the import dialog an URL has been typed as file name to import the browse button E will change into the button Ej Name Format New Format Excel Path name http www intrastat be annex2006 xls Cancel Help To download the file simply press this button If the file could not be downloaded the URL will be shown in red and a message will be displayed As long as the browse button has not been pressed with success the OK button will re
63. e log includes Start of Import Start Date and Time of the import Importname Filename and Tablename if applicable Lines with incorrect or missing PSI Flow or Period up to a maximum of 100 PSI Id Line number in Import Source File Name of Field containing the error Value of the Field in Error 9 Jan 15 32 IDNet15manE doc IDEP for Windows IDEP User Manual Lines that are otherwise incorrect up to a maximum of 100 PSIId Declaration Nr Line number in Import Source File Line number in Return Name of Field containing the error Value of the Field in Error End of import Date and Time List of Declarations for which lines were imported PSI Id Declaration Nr Lines Imported Imported Lines in Error 9 Jan 15 33 IDNet15manE doc IDEP for Windows IDEP User Manual 7 PARTIES This Menu deals with the different parties involved in the system e Providers of Statistical Information PSPs IDEP can handle any number of PSPs either as independent entities or under the umbrella of a Third Party Declarant see Chapter 7 3 e Users who have certain rights to create change or consult the PSPs data to modify system parameters or to perform system functions e Third Party Declarants who create INTRASTAT declarations for a number of PSI s e Third Party Declarants have an additional function Approve All which is also available from the Actio
64. ed by PSI Info Line Models or by clicking the Line Models Button i Most of the time a PSI has a number of fixed Trading Partners The transactions for these Trading Partners will very often be similar except for values and quantities In order to avoid entering the same data over and over again field by field for every return line the User can define a number of Models that already contain the field values which are always the same e g Partner Country CN8 Goods Code 21x Yr R Model Name Flow Declarant Ref Nr CNS Goods Code Partner Country Descrip Correct I Horses cz 01019019 __ Pony 1 D Yes Search Close Help 9 2 1 Specifying Line Models The function Add Line Models is started in PSI Info Line Models via Actions Add or by clicking the Add button or the F4 key 9 Jan 15 77 IDNet15manE doc IDEP for Windows IDEP User Manual The function Modify Line Models is started in PSI Info Line Models by double clicking on the Line Model or via Actions Modify or by clicking the Modify Button or the F5 key Line Models are created for a specific Flow Arrival or Dispatch a ModelName pony 1 Flow A Arrival Introduction Descrip Correct Yes Thresh Standard Return Declarant Ref Nr Partner Country X Nature Of Transaction Net Mass x National Region E Br
65. ee ois tE Err ie eei E nth innate EAEE TE 36 T22 IRA LRI N DE KEE EEE EEEE EE 37 9 Jan 15 i IDNet15manE doc IDEP for Windows IDEP User Manual HS Third Party Declarants 5 5 tit tot te tat totete is lotete ht otebs te lalate tat state a a a aa Ena a 38 TA Change current PS Daio a a a O O snes sensaeas ues E E E 39 8 ARE BURN E AE ER 40 8 1 The Lite Cycle of a Rem a e aen an anera raTa rS ATSE Ea nana nan aaL 40 8 26 Edit REUS onnsa Re ea a ETT EEE EEE ETE T T T Bee ae 41 8 2 1 Introduction to Data Entry of INTRASTAT Information eeeeeeeeeeeeeeeereeeerrrrserreeseeee 41 8 2 2 Create the Return Header eee eceeesssecccsesneeeceessaceceessaeeecesseeeceesaeecsessaeeeseesaeeeeees 42 8 2 3 Adding Return Lines to the Header eeseeeessneeceessneeecessneeeceesseeecsessaeeesessaeeeeees 43 823 1 Introductions sa AA AAG AAU SA AU AR ANAS ANAM ARN AMGH AM aN AMAR Awan 43 8 2 3 2 Manual Data Entry of Return Limes cece eeeennececeeeeeeesnnneeeeceeeeeeesnnneeeeeeeeeeees 44 8 2 3 3 Utilities for Manual Return Line Data Entry eee eeeeeceeeesseceeeesneeeeeesseeeseesaes 46 8 2 3 4 Data Entry through Models eee seeesssceceessnceeceeseeeceessaceeceesaaeeceessaeeseessaeeeseesaes 50 8 2 3 5 Copy Lines from another Return 2 0 0 eeeeseeeceesneeeesessaceecessaeeeceesaeeesessaeeeseesaes 51 8 2 3 6 Usage of the Import Function esssseesssssresssreesssrresssrresssrrerserierssreeesssreerssrresssrreeset 52 8 2 4 Mut PS Imports a a
66. eeeeesaeeeeessaeeeeees 83 9 4 1 Specifying Minimum and Maximum Ranges 0 cc eeeseceesssneeeeeesneeeeeesseeeeeeesaeeeeees 83 9 5 Copy PSLINOPMAUOM secs ss cded cece ceseceescdescecbcpeecverdecasecesseucveadetesdce0deecveatetecdeesteedseatetecdeesbeaceeed 84 10 SYSTEM MATIN PENANCE aisssesncssussszssnsbonsoonsosssncndvonsecssbvsdncetbeesnsusssnonsntscnuscndsonsounivenssonsvee 85 10 1 Declaration Maintenance ce eeeceeessscceeessneeecessseeeceessaeeccessaeeeeesseeesessaeeesessaeeesesaeeesee 85 O WA A Arehive VoiDisk 3ts ci3 tos fotetiss Set stuostetebvostotetuasfots E A 85 10 127 Deae a as a GG BAG a A Ea TT A TT ate tae a a aa oe 87 9 Jan 15 ii IDNet15manE doc IDEP for Windows IDEP User Manual 101 3 Delete Headersis cc s stctetitetetetacetetatoietetalotebetetolebetelataletelatatesetatatetstatetetstateteietitete tt teteat 88 10 2 Backtip dep datars o ssctsscicactevian e r S lays bin bans bin EE EE Lenehan dors e A 89 10 3 Restore BackUprs s 3 6 4 0 8 fosfeictiofeistiofeictioletstieletetee iaon iea aoa aeea aa hea aaaea oaea fetta as 90 10 4 Cle UP E Adan Adan AMAR ARG RAM N AS A ON A ENEI AEE Aandi 90 LOD Download sersa ana aA TT T TTT TE E AE Bik 91 O6 Download OSet tetetete tere lete tenteko kenetet teearete teen tete tetetete eneket tetetete ene hetete retete tnakebetnrntetaleiat 93 107 Check forpr S a aa a a a a dai a 93 10 8 Install x tha featUre Suninn a ocean AT AE E a O a A a Oi 93 10 9
67. entry will be made in the Archives table The de archived returns now have the status Archived No again De archiving for more than one PSI is exactly the same as described in the case of one PSI except that he can choose to De archive All PSI s or the Current PSI only 10 1 3 Delete Headers The function Delete Headers is started in System Maintenance Declaration Maintenance Delete Headers When the User is sure that the data he has archived will not be needed anymore he can remove the return headers by using this option Even after having executed this option it will still be possible to restore the return data by De archiving After having selected this function an overview appears showing the returns that are archived 9 Jan 15 88 IDNet15manE doc IDEP for Windows IDEP User Manual 33 Delete Headers 0000 000 097 44000016 0 Og 44000017 E 0000 000 097 44000018 The procedure for deleting headers of archived returns is as follows Specify the Statistical Periods of the archived returns for which the particular header in IDEP should be removed Note that only return headers with the status Archived Yes can be deleted via this function Other returns will be ignored even if their identification number is within the range You can delete all headers presented in the list or a selection can be made 10 2 Backup Idepdata The function Backup Idepdata is started in Sy
68. ep installation to the helpdesk helpdesk Cancel Exits the application or interrupts the collection process 13 4 Log file Each time IdepTest is run a log file is produced in TEMP IdepTest_DDMMYYYY txt note the txt extension in stead of the log extension this should ensure that the system s default text editor can be used for viewing the file The log file can be viewed with any text editor Notepad or Word The log file is appended to If the tool is restarted the collected data is appended to the file A summary of the collected data is displayed in the GUI 13 5 Collected Information Detailed information about the operating system and installed software is collected Interesting information collected is summarised in the GUI From the information collected it is possible to infer if an internet connection is available if IDEP is correctly installed if IDEP could use email to send declarations etc Summary description of the collected information 9 Jan 15 100 IDNet15manE doc IDEP for Windows IDEP User Manual Type of information Data Collected Miscellaneous Date version of IdepTest Detailed OS and System Information Version number service pack CPU memory User information User name company name administrator status Desktop and local settings Fonts colours screen resolution system language regional settings Disk drives and network shares Drive a
69. es via Actions Add or by clicking the Add button F or the F4 key The function Modify PSI Goods Codes is started in PSI Info PSI Goods Codes by double clicking on the Goods Code or via Actions Modify or by clicking the Modify Button or the FS key PSI Goods Code new shoe Ret Goods Desc Yes CNS Goods Code 7 CNS Goods Code Goods Description Add Cancel Hep The Goods Description is automatically copied from the CN8 Self Explanatory Texts when the CN8 Goods Code is entered if the field Return Goods Description on this screen is also set to Yes The PSI Goods Code list can be imported from outside IDEP The Import PSI Goods Codes function is called from the PSI Goods Codes screen via Actions Import or by clicking the Import Button lt or the F9 key Read Chapter 6 2 1 for guidelines on how to define the import format In the import format it is possible to define the Net Mass Calculation Factor If a name is given in the import file it must exist in the corresponding Table The PSI Goods Code list can also be exported to a file The Export PSI Goods Codes function is called from the Goods Codes screen via Actions Export or by clicking the Export Button EB or the Control F9 key Possible output formats are Access Excel Text XML and HTML The whole list is exported the Field Order is fixed 9 Jan 15 80 IDNet1
70. ew after selecting a file a button Preview appears Pressing it starts reading in the file and the column Field Value shows the content of a complete row of the import file Data row in file this is a record selector which allows you to browse the import file Try mapping fields after using the button Preview this button appears By pressing it an attempt is made to map the fields of the import definition to the columns of the import file The result of this attempt needs to be checked and can be adapted by the user 9 Jan 15 27 IDNet15manE doc IDEP for Windows IDEP User Manual Ea Add Import Format Name Format New Format Descrip test format Type OF Format Return lines Path name H Sidepcursus bijlagen201 0 xls External name File Format X Rows to skip at start of import Goods Code Mode CN8 Goods Code Unused Field Used Fields Data row in file is Name Order Name Currency Code gt Terms Of Delivery Goods Code Goods Description Invoice Value Inv al Foreign Curr Net Mass Partner Country National Region Suppl Units __ Nature OF Transaction Mode OF Transport 90301000 2 3 4 5 6 7 8 Y Y NNNNN me e e ee ml neU N e OF WANA AO AHWON YY OC Lencel 9 Jan 15 28 IDNet15manE doc IDEP for Windows IDEP User Manual Special comments on some of the import fields 1 Either the CN8 Goods Code or the PSI Goods Code is imported The PSI Goods Code is expected i
71. formation to be printed in portrait or landscape format 8 3 3 Draft Output Disk This option provides draft output on hard disk All defined Draft Formats can be applied The User has to specify the filename and path Except for Excel and Access Draft Formats always two files are created one file for the selected headers prefix H_ and another file for the return lines corresponding to the selected headers prefix L_ The prefixes are automatically assigned For Excel one spreadsheet is created with TABs Headerlist and Linelist for Access one database is created with Tables Headerlist and Linelist Note that if the User selects the Draft Format HTML it is only possible to create draft output for one declaration 8 4 INTRASTAT Output Returns These functions allows the User to create the official declaration for the CNA The medium the User is allowed to use to send the official output OneGate in Belgium is determined by the CNA The User can restrict the allowed official output to the default type used by his company in the System Administrative Parameters screen INTRASTAT output can be processed for the current PSI or in the case of a Third Declarant for all PSI s at once The process of generating INTRASTAT output consists of two steps 1 Approval of the returns ready for INTRASTAT output 2 Generation of the INTRASTAT output 8 4 1 Return Approval Disapproval To create the official
72. g the Model he wishes to apply from the list The procedure for the usage of line Models when adding a return line is described in detail in Chapter 8 2 3 4 9 3 PSI Goods Codes The PSI Goods Codes function is selected by PSI Info PSI Goods Codes or by clicking the PSI Goods Codes Button 5 The PSI can use his own PSI Goods Code list instead of the official CN8 Goods Code list The Goods Codes facility connects this PSI defined Goods Code to the official CN8 Goods Code 2 x 7 Ahal xa ARES Goods Code CN8 Goods Code Goods Description 01021010 fokvaarzen vrouwelijke Fokrunderen die nog niet gekalfd hebben van zuiver ras Correct Validate Net Mass Calc Fac __ My Code 64029910 schoeisel met buitenzool van rubber of van kunststof en bovendeel van rubber m u Yes No New Shoes _jshoes 69089093 plavuizen vloer en wandtegels van Faience of van fijn aardewerk verglaasd of gegl Yes No Search Close Help If the User has a long list of PSI Goods Codes the search facility can be useful if he knows the PSI Goods Code he wishes to access Just type the first letters of the PSI Goods Code and the first PSI Goods Code of which the identification starts with these characters will be selected 9 Jan 15 79 IDNet15manE doc IDEP for Windows IDEP User Manual 9 3 1 Specifying PSI Goods Codes The function Add PSI Goods Codes is started in PSI Info PSI Goods Cod
73. gnise the erroneous lines by the flag Correct Y N in the Return Overview for each line in a declaration or the List of Returns for the whole declaration A list of erroneous returns is presented on the Return Overview Declarations screen after selection of the heck box Not valid see Chapter 8 6 Overview Declarations amp From Period v Retum Approved Correct To Period O Sent NOT Valid DAlPsI s Number Of Items 4 Return Archived BE enterprise nr a Return Number Type Of Return Flow Statistical Period Correct Return Approved Sent Return Archived Date Sent Time Sent 4 BE0000 000 097 AAD00014 1 A 200610 No No No No _ BE0000 000 097 44000015 1 200611 No No No No __ BE0000 000 097 44000017 1 D 200610 No No No No __ BE0000 000 097 44000019 1 4 200608 No No No No Search Close Help A list of erroneous lines is presented when an erroneous return is selected in the PSI Returns list Modify or Consult is chosen see above and the Error list option is selected via Actions Errlist or the Erroneous Lines Button or the F8 Key 9 Jan 15 57 IDNet15manE doc IDEP for Windows E Modify Return Overview 44000014 Erroneous Lines 21 x 7 Ax B Arl1 Ge Statistical Period 200610 Type Of Return Creation of a new retum Return Approved No Flow Arrival Introduction Thresh Standard Retum Co
74. has been recorded in the Archive table including Date and time of archival Operation Archive or De archive Third Declarant ID or current PSI ID User ID Archive file name The Overview of Archives list offers the following functionality invoked in the Toolbar the Actions menu the Context menu or by Function keys Display the Archive Details for the currently selected archive entry This will display a separate sortable read only list The title area of this list will include the file name if it exists The Archive Details are shown when the User double clicks on an Archive or has selected an Archive and then clicks the Consult button Q or via Actions Consult or by the F6 key 9 Jan 15 87 IDNet15manE doc IDEP for Windows IDEP User Manual ax BE enterprise nr 1 Work Station ID Return Number Type Of Return Flow Statistical Period Date Sent Time Sent A BE0000 000 097 44000001 200512 15 12 2006 11 49 BEOO000 000 097 aa 44000016 1 D 200611 15 12 2006 11 49 BE0000 000 097 AA 44000018 1 4 200608 15 12 2006 11 49 Archive Details a a I The information presented in this list includes PSIID Selected declaration details o Return number amp Workstation o Flow o Period o Send date Restoring the archive will add a new record where the Operation field is set to De Archived If no returns have been retrieved no
75. hat line and press Enter double click on the line use Actions Modify or click on the Modify Button or use the F5 Key The function Consult Header is started via Actions Header by clicking on the Header Button a or by the F71 Key Here the User can consult the updated Header information To get back to the PSI Returns overview press lt ESC gt or close the Return Overview window or select the desired window in the Window Menu Also from here the function Consult Header can be started via Actions Header or clicking on the Header Button S or by the F11 Key When the User wishes to return to the Main Menu he has to press lt ESC gt twice or Close all open windows or select the option Windows Close all Windows 8 2 3 3 Utilities for Manual Return Line Data Entry Note that the following utilities are provided on the Return Line data entry screen Pick lists When positioned on a field where it is obliged to enter a code the Arrow Button at the right hand side of the field can be clicked on which will present a choice of all possible values The User can choose a value from this list by clicking on the desired value 9 Jan 15 46 IDNet15manE doc IDEP for Windows IDEP User Manual E Modify Return Line 1 AA000020 2 x rial Statistical Period 200612 Thresh Extended Return Corect Yes Flow Dispatch Expedition Type Of
76. he CNA s limits are not zero See also Section 7 2 3 Adding Return Lines to the Header For the current default PSI the Line Models defined in the package will be checked on codes CN8 Codes Country Codes old EMU Currency Codes etc that are no longer valid Line Models that have become invalid for the years supported by the new package will be marked and a list will be presented The Line Models for other PSIs if defined in the package will be checked when they are selected as the current PSI during the usage of the package Finally a check is made if this is a first time installation of IDEP CN8 for Windows In that case the Add PSI Parameters screen is automatically presented no PSI s exist in the package yet See Section 6 1 1 for details of the information to be entered Add PSI Parameters P es BE enterprisenr 1 BEL Contact Person PSI Name Telephone Nr FAX Number 1 BE enterprise number with 10 positions Click on the help button for more information about this screen Carta Esra Y A E National Region X Address Post Code Threshold Cat Arrival Postal District reshold Cat Arrival X Threshold Cat Dispatch OneGate Username ispa OneGate Password Add Cancel Help 4 2 Screen Layout Once the application is started the graphical user interface GUI shows the default application screen containing the following information e Application name active PSI identification and P
77. he Flow of the current Return and save all data entered so far in the Return Line It will prompt for the name of the model this prompt can be cancelled If an existing name is entered or selected from the available picklist it will update the fields of that line model after confirmation by the user 8 2 7 Replace Returns After a return has been sent as INTRASTAT output see Chapter 8 4 some information may appear to be in correct or in complete Errors can be corrected by sending another return with a reference to the original one in which the corrections are included A Replace Return is a return with a reference to a previous return which has already been sent to the CNA and which should be substituted with the new return The type of return is entered in the field Type of Return in the return header 9 Jan 15 58 IDNet15manE doc IDEP for Windows IDEP User Manual A list of possible candidate returns is provided for the Reference Number field in order to easily select the correct reference return fi Add Return Header AA000022 21 xi f Return Number 44000022 Type Of Return 5 Replacement of a previous retum v 44000017 44000020 Reference Number ee The reference to the previous return has to be an existing return for the given PSI with the status Sent Yes When the Reference Number is entered the Flow and Statistical Period in the current header are copied from the referenced re
78. hen the IDEP CN8 package as a whole doesn t function anymore In this case the User should install a new IDEP CN8 package from CD ROM and in this package run the Restore Backup function When the restore function is invoked IDEP will present a list of known backups that are stored in the maint log file The list will only show backup files that really exist w x amp z Date Action File to restore version PSI S 09 11 2006 08 29 Backup Idepdata LANPRDIDFSIMNGIUSERS HOMEISCHOLLA saalIDEPBAK_09112006 zip 2 1 2 BEO000 000 097 11 12 2006 09 12 Backup Idepdata 5 EX4 Peter IDEPBAK_11122006 zip 2 3 0 BEO000 000 097 21 12 2006 10 38 Restore Backup S EX4 aa IDEPBAK_21122006 zip 2 3 0 BE0000 000 097 Search Close Help The list shows Date of backup File name of the backup Version of IDEP used to backup List of PSI databases available in the backup At the end of the restore procedure a message is displayed to indicate whether the restore was successful or not 10 4 Clean Up The function Clean Up is started in System Maintenance Clean up This function invokes the so called Compact and Repair database functions It makes lost space in the database which is caused by changes the User makes Add Delete Modify information available again Furthermore it is capable to repair in most cases corrupted databases Besides freeing up disk spac
79. ice versa The User can call this function by pressing F2 on the field Net Mass after entering the number of Supplementary Units for calculation of the Net Mass or on the field Supplementary Units after entering the Net Mass for calculation of the number of Supplementary Units This can be done e On the return line data entry screen e On the return line Model data entry screen 9 Jan 15 75 IDNet15manE doc IDEP for Windows IDEP User Manual The list of Net Mass Calculation Factors that is shown depends on the Supplementary Unit Qualifier of the CN8 Goods Code that is entered Only the Factors with the corresponding Qualifier are shown Example of the calculation of the Net Mass in the return line data entry screen EE Add Return Line 1 AA000021 2 x Statistical Period 200612 Thresh Extended Return Corect No Flow Dispatch Expedition Type Of Return Creation of a new return Declarant Ref Nr Suppl Units 2 Ral Partner Country Number of items Nature Of Transaction Optional Net Mass x Mode Of Transport Currency Code z National Region Terms Of Delivery Invoice Value PSI Goods Code CN8 Goods Code 01021010 Pure bred breeding heifers female bovines that have never calved Al Ce ee Pressing F2 on the Net Mass field presents a Factor selection list containing only the entries that have p st as a Supplementary Unit Qualifier Search Net Mass Calc Fac Fa
80. ich is common for all the return lines Hi Add Return Header AA000022 21x Return Number 44000022 Type Of Return es A Anival introduction F Thresh Standard Return Statistical Period 200612 December2006 ele After having entered all fields click on OK to save the information NOTE 1 When the User creates or modifies a return header and there is no declaration with the same Flow created and sent for the previous month a message is displayed to warn him that he didn t produce and or send a declaration for the previous month This message is not displayed when the first declaration is created 9 Jan 15 42 IDNet15manE doc IDEP for Windows IDEP User Manual NOTE 2 It is not possible to create a return for a Statistical Period outside the validity years of the package NOTE 3 It is not possible to create a return with a Statistical Period after the current month STEP 3 Now that the return header is created for a certain flow and period the return lines can be added 8 2 3 Adding Return Lines to the Header 8 2 3 1 Introduction When the return header is created return lines can be added for all types of returns except for returns which by definition have no lines Modify Return for a new or existing return is either automatically started after creation of the header or it can be manually started by selecting the return click on it and clicking the Modify B
81. ill be marked as Incorrect 9 Jan 15 44 IDNet15manE doc IDEP for Windows IDEP User Manual Quality checks are performed automatically in relation with a CN8 Code on Value Net Mass Value Supplementary Units and Net Mass Supplementary Units for all transactions with an Invoice Value higher than 10 000 euro The quality check is performed as follows When a new Return Line is closed and the line includes a CN8 Code for which checking is enabled the values to be checked are calculated Invoice Value Supplementary Unit if Supplementary Units are required Invoice Value Net Mass if Net Mass is required for this CN8 code Net Mass Supplementary Unit if supplementary units are required and the optional net mass has been filled in The above results are then checked against the maximum minimum values connected to the CN8 Code If any of those are outside the limits 6 possible different messages are presented depending on the different cases Oy Or A value of A value of A value of A value of A value of A value of for for for for units seems too low Are you sure it is Correct units seems too high Are you sure it is Correct kilos seems too low Are you sure it is Correct kilos seems too high Are you sure it is Correct kilos for units seems too low Are you sure it is Correct kilos for units seems too high Are you
82. ion allows the User to define conversion factors in order to calculate the Net Mass from the value supplied for the Supplementary Units and vice versa The function Add Net Mass Calculation Factors is started in PSI Info Net Mass Calculation Factors via Actions Add or by clicking the Add button or by the F4 key 9 Jan 15 74 IDNet15manE doc IDEP for Windows IDEP User Manual The function Modify Net Mass Calculation Factors is started in PSI Info Net Mass Calculation Factors by double clicking on the specific Net Mass Calculation Factor via Actions Modify or by clicking the Modify Button or by the F5 key Net Mass Calc Fac New shoes Suppl Units Number of pairs pa Factor 0 89 Descrip a te te The Supplementary Unit Qualifier is selected from the list of qualifiers defined in the Combined Nomenclature Net Mass Calc Fac New shoes Suppl Units E Factor Hundred items ck ck giF S giF S Descrip g g GT GT kgC5H14CINO kgC5H14CINO kg H202 kg H202 Note that it is possible to enter Net Mass Calculation Factors for the qualifier which means No Supplementary Unit Qualifier These Factors are applied in a special manner as shown in the next section 9 1 2 Usage of Net Mass Calculation Factors The Net Mass Calculation Factors are used to calculate the Net Mass from the Supplementary Units and v
83. is may cause a message This change could impact one or more registered programs The User can confirm this message 2 5 Log Files All IDEP CN8 for Windows programs log problems in log files A part of these log files can be found in the sub directory named LOG of the Member State directory of the IDEP CN8 installation The filename is XXXX_date log where XXXX the application name see example below C Program Files Eurostat IDEP_CN8 BE LOG IDEP_05111999 log If problems are reported to the National Administration the User is encouraged to supply these log files as they contain all information required to solve the problem quickly In case of problems the program Ideptest collects all relevant log files and sends them to the Idep helpdesk zie chapter 13 Diagnostics 9 Jan 15 10 IDNet15manE doc IDEP for Windows IDEP User Manual 3 STARTING THE PACKAGE LOGON SCREEN Idep can be started via the Windows Start button by selecting IDEP CN8 under Programs by double clicking the file Idep exe in Windows Explorer or by double clicking on the IDEP Shortcut put on the Desktop by the installation program The following so called splash screen will appear Belgi Belgique Deutsch English Fran ais Nederlands OcNa IDEP CN8 for Windows IDEP ry National Bank of Belgium External statistics Intrastat Data Entry Package National Bank of Belgium Intrasta
84. is Import Format Definition The Path Name may refer to a WEB location a WEB file The name of the web file must start with HTTP domain or FTP domain thus HTTPS is not supported As soon as the minimal required part of a web file name URL is entered in the pathname field e g HTTP domain somefile txt the field will be marked as correct IDEP will not check if the file actually exists It will not be possible to browse for such a file using the file selection dialog that is normally used e External Name to specify the default name of the table in a database for instance in Access or the name of the Worksheet in a spreadsheet for instance in Excel If there is only one table or Worksheet name found in the given import file its name is automatically pre set If the Path Name or External Name are not set here by default they must be entered when the actual Import is performed see Section 7 2 3 6 The default can always be overruled when the Import is performed Now specify the logical file layout order of fields in the file to be imported lengths etc for the physical format that has just been selected The position of the fields can be determined by moving or dragging the fields to the right used fields Used fields can be moved to another position by moving them up or down by dragging or by typing another order enter or use the arrow buttons This features can help you to create an import format Previ
85. l PSI s have been created the User can change from one to another via Parties Change Current PST or by clicking the Change current PST Button Bo f 9 Jan 15 35 IDNet15manE doc IDEP for Windows IDEP User Manual 7 1 2 Copy Information from another PSI After clicking on the OK button a window is displayed that allows the User to copy the PSI specific tables from another PSI Note that this window is not displayed when creating the first PSI Eg Copy PSI Information gt BE0000 000 493 2 xj PSIID BE0000 000 394 My PSI My PSI W Net Mass Cale Fac M PSI Goods Codes M Line Models M Minimum and Maximum Ranges Select the PSI from which the tables should be copied and use the check boxes to indicate which tables ought to be copied 7 2 Users The Users function is selected by Parties Users 7 2 1 Create Modify a User This screen allows the definition or modification of different Users with different authorisations If there is only one User of the package he can always work with the default User called IDEP and the rest of this Chapter is of no further interest to him The function Add Users is started in Parties Users via Actions Add or by clicking the Add button or by the F4 key The function Modify Users is started in Parties Users by double clicking on the User s Identification via Actions Modify
86. l be minimised along with it If the Help window is minimised invoking help again will restore the Help window to its most recent size location All Help texts can be printed individually through the Print Button on each Help screen 9 Jan 15 14 IDNet15manE doc IDEP for Windows IDEP User Manual 4 6 Setup Display The Setup Display function is selected by System Setup Display This option allows the User to change the colour scheme used to identify the status of data entry fields It also defines the layout of the Toolbars and the cursor behaviour of certain fields aa Setup Display Field Colours These settings apply to the lists M Center columns M Show currency Y Coloring Defaults The check box Automatic TAB controls the behavior of the cursor during data entry in a Return Line For a new IDEP installation by default this function is switched on If this function is switched on the cursor will automatically move to the next field if the required data is entered correctly in the current field This only applies to fields with a fixed data length Also see Section 5 8 3 TAB Order The check box Enter as TAB allows the User to use the Enter key instead of the TAB key in most screens See Section 5 8 3 TAB Order for a full description The check box Save Restore Workspace enables the following behaviour When IDEP CN8 quits the current screen size and position are stored A
87. language can of course not be deleted and is not shown in the language selection dialog The removal of a language cannot be undone other than via re installing the language by CD ROM or through the above Install extra Features function 9 Jan 15 94 IDNet15manE doc IDEP for Windows IDEP User Manual 11 CN8 More information about the CN8 module is also available in the Manual CN8 for Windows Note that there are four possibilities to access the CN8 tables CNS 1 Via the option CN8 or by clicking the CN8 Button 8 2 When making a declaration by pressing F2 on the CN8 Code field of the Return line data entry screen or of the Line Model data entry screen 3 When specifying the CN8 Goods Code for which a Report by Goods Code should be done 4 When specifying a PSI Goods Code by pressing F2 on the CN8 Code field of the PSI Goods Code data entry screen In the first case the User can consult the tables of CN8 In the other cases the User can consult and select a CN8 Goods Code and return it to the corresponding field in IDEP By default all texts of all chapters are installed unzipped Via CN amp Add Remove chapters this selection can be changed afterwards Chapter Selection Invert Selection Select the chapters you require SECTION I LIVE ANIMALS ANIMAL PRODUCTS CHAPTER 1 LIVE ANIMALS v CHAPTER 2 MEAT AND EDIBLE MEAT OFFAL v CHAPTER 3 FISH AND CRUSTACEANS
88. lder cE N z E Recent Places Name Date modified Type m 2 OneGate_150102_14300_BE0000000097 xmI 2 01 2015 14 30 XML Document OneGate_150102_15000_BE0000000097 xml 2 01 2015 15 00 XML Document OneGate 150105_09290_BE0000000097 xmI 5 01 2015 9 29 XML Document EE Desktop De Libraries Documents Music Pictures Videos Ba p ma OneGate_150105_09290_BE0000000097 xml Date modified 5 01 2015 9 29 Date created 5 01 2015 9 29 XML Document Size 431 bytes You can consult the status of the upload under Exchanges File exchange log More information is available on www onegate be under Documentation 9 Jan 15 67 IDNet15manE doc IDEP for Windows IDEP User Manual The second option is to upload Automatically to OneGate In this case Idep logs in to OneGate and uploads your return s automatically if you have entered the OneGate user name and password under Parties PSI s see also 7 1 PSI s DEP Message Number 3302 Sent Automatically to OneGate lt gt nbb Jocal usr MOORTGA Documents Idep_Cn8 OUT OneGate_150105_09490_BE0000000097 xml https onegate a2a nbb be crs esb weak invoke uploadFile v 1 0 E After the upload of the INTRASTAT declaration an overview of the Returns just Sent is automatically presented on the screen To leave this overview click the Close button or use the Esc key With the received ticket number yo
89. lines when the User checks the appropriate box Aggregated information is only available for Approved returns From Number 15 7 To Number 15 x Print Disk O Erroneous Lines Only O Agaregate M Show Unit Qualifier Draft Output Format m m Page Orientation HP Laserdet 2300 Series PCL 6 Portrait Landscape Cancel Help It is also possible to invoke Draft Output Returns directly from within the Header list by the Alt FI1 key or Actions Draft Output In that case the range of return numbers From Number To Number is initialised with the return number range of a selection made in the Header list or the current return number if there is only one return selected 8 3 1 Draft Output Format This option is fully described in Chapter 6 2 2 It allows the definition by the PSI of the type of output for instance Text Access or Excel and the fields to be included in the output Multiple formats can be defined which can be selected at the creation of draft output 9 Jan 15 60 IDNet15manE doc IDEP for Windows IDEP User Manual 8 3 2 Draft Output Print This option provides draft output in printed form The program automatically inserts line breaks if the fields defined in the format don t fit on the same line All defined Draft Formats can be applied only the Draft Order is used for the layout The User can choose if he wants the in
90. ll be clear that most functions of the package can be started in more than one way For instance e The function Line Models is started by e selecting the Main Menu option Info PST Sub option Line Models e or by a Mouse Click on the Button Line Models on the Main Tool bar e On the Line Model screen itself the function Add Line Models can be performed by e selecting the Main Menu option Actions or by calling the Action list via a click on the right Mouse Button Sub option Add e or by a Mouse Click on the Button Add on the context dependent Tool bar e or by pressing the Function Key F4 In the next Chapters for each Function the way it is invoked is indicated in a more brief way For the above example the notation is e The function Line Models is started by Info PSI Line Models or by clicking the Line Model Button e The function Add Line Models is started in Info PSI Line Models via Actions Add or by clicking the Add Button or by the F4 Key Other conventions are e Function names are written in Bold amp Italic Function e Menu options Button names etc to start functions are written in Italic Menu e Field names are written in Bold Field 9 Jan 15 18 IDNet15manE doc IDEP for Windows IDEP User Manual 5 SYSTEM System functions influence the behaviour of the complete IDEP CN8 application and th
91. lso the maximised state is stored A list of active list screens e g Returns list Exchange Rates etc is saved When IDEP CN8 restarts the screen layout and the active list screens are restored only their position not their size If the mechanism is switched off IDEP CN8 will start with the Returns list displayed as usual 9 Jan 15 15 IDNet15manE doc IDEP for Windows IDEP User Manual 4 7 Function Keys Users prefering to work with keystrokes instead of Mouse clicks can use the following function keys e FI Shows the help text for the currently selected function e F2 When pressed on a data entry field this function key will display a list from which a value can be selected e F3 Exit from IDEP F4 Add F5 Modify F6 Consult F7 Delete F8 Print F12 Refresh ENTER The functionality of the Enter key is controlled by a User preference see Section 4 6 Setup Display ESC This key will return to the previously selected function or to the Menu e TAB Shift TAB Moves to the next entry or button in a data entry screen The behavior of the TAB key is controlled by a User preference see Section 4 6 Setup Display e Alt Arrow Down Alt Arrow Up Same as TAB Shift TAB 4 8 Data Entry and Presentation Facilities 4 8 1 Pick lists When positioned on a field where it is obliged to enter a pre defined code from a list either the Arrow Button J at the right hand side of the
92. ltaneous access to data From a functional perspective three cases can be considered The first is the most restrictive 1 Functions accessible when only one User logged on 2 Functions accessible by one User at a time 3 Accessing information with multiple Users The different cases will now be explained in more detail 12 2 Functions accessible when only one User logged on Most system maintenance functions can be only be executed when only one User is logged on to the system Two possible conflict situations can occur 1 A User tries to log on to the system while another user is executing a function which requires only one User to be logged on The User who tries to log on will see the following message A system maintenance function is being executed You cannot log on right now Try again later The User leaves the system 2 A User tries to execute a function which requires only one User to be logged on while already another User is logged on The User who tries to execute the function will see the following message This function can only be executed when no other Users are logged on to the system The User leaves the function 9 Jan 15 96 IDNet15manE doc IDEP for Windows IDEP User Manual Functions which can only be executed when only one User is logged on to the system are the following e System Maintenance Backup Idepdata e System Maintenance Restore Backup e Syste
93. m Maintenance Clean up e System Maintenance Reindex e System Maintenance Download 12 3 Functions accessible by one User at a time Some functions can only be executed by one User at a time Multiple Users can be logged on to the system When a User is accessing a one User at a time function and another User tries to access the same function then this second User will see the following message Function already in use Only one User can have access at a time The second User cannot access the function Functions which can only be executed by one User at a time while multiple Users are logged on to the system are as follows Return Edit Add System Administrative parameters Parties Third Party Declarant Import Multi PSI import Return INTRASTAT Output System Maintenance Return Maintenance Archive to Disk System Maintenance Return Maintenance De archive e System Maintenance Return Maintenance Header Deletion 12 4 Accessing information with multiple Users The previous two paragraphs dealt with functions which cannot be executed by multiple users due to the nature of the functionality In many cases multiple Users are using the same information in functions which can be accessed by multiple Users at the same time For instance two Users can be entering Return data for the same PSI at the same time but only for different Returns Should one
94. m of 3 decimals to obtain a better precision CN8 Codes that have a Supplementary Unit Qualifier require no Net Mass If the User has entered one of these codes in the CN8 Code field the text Net Mass on the screen changes into Optional Net Mass and it is no longer required to enter a value in the Net Mass field Net Mass Calculation Factors The User can define a list of Net Mass Calculation Factors in order to calculate the Net Mass in Kg from the value for the number of Supplementary Units see Chapter 9 1 PSI info Net Mass Calculation Factors The User can call the list of Net Mass Calculation Factors by pressing F2 on the field Net Mass If a Net Mass Calculation Factor is attached to a PSI Goods Code that is entered in the line the Factor is automatically applied when the number of Supplementary Units is entered Supplementary Units The field Supplementary Units has a prompt F2 function and a button This allows the User to select a Net Mass Calculation Factor corresponding to the Supplementary Unit Qualifier of the CN8 Code Once the User has entered the Net Mass the number of Supplementary Units will be calculated after selection of the Net Mass Calculation Factor Net Mass Net Mass Calculation Factor The number will be rounded The calculation is executed once 9 Jan 15 49 IDNet15manE doc IDEP for Windows IDEP User Manual Exchange Rates The User can define a list of Exchange Rates in order to
95. main disabled If the file is ready to be downloaded into a temporary file the file name field will be shown in green Furthermore if more information is required to start the import the appropriate fields will be enabled See above for the selection of the external name for a normal file The import process starts after clicking the OK Button When the data from the import file are imported into IDEP every field is validated When the import process has finished the import log file can be consulted in Import View Import Log to see if any error occurred NOTE For the fields Invoice Value and Net Mass automatic calculation can take place during import provided that the data is available in the import file to perform these calculations Details are given in Chapter 6 2 1 Import Format If a default value for the National Region has been entered in the PSI Parameters screen see Section 7 1 1 Create Modify PSI and National Region is empty in the import file then the field will automatically be filled with that value If values in the User s import file are provided with decimals and the decimal separator symbol in the import file is equal to the Digit grouping symbol defined in Windows Regional Settings the import results will be wrong 9 Jan 15 54 IDNet15manE doc IDEP for Windows IDEP User Manual Et For instance the import file uses the comma as a decimal symbol and in Windows the comma
96. marks of the respective holders 9 Jan 15 iii IDNet15manE doc IDEP for Windows IDEP User Manual 1 INTRODUCTION 1 1 Important Remarks on the Software Package The software package IDEP CN8 INTRASTAT Data Entry Package Combined Nomenclature 8 digits was developed for the Providers of Statistical Information PSI s in order to assist them to create statistical declarations for their Competent National Administration CNA The main functions of the package are data entry and the validation of that data An additional function of the package is the importation again with validation of the necessary data from existing information systems in a company The package will transform this data to the official format accepted by the User s CNA The IDEP CN8 package can also be used by Third Declarants who will create the statistical declarations for several PSI s declarants Several functions have been included in the package to facilitate the creation of declarations including pick lists standard values and calculations Extra functionality has been included for the use of the CN8 Goods Codes The official INTRASTAT output generated by the package is an XML file that can be uploaded in OneGate 1 2 Howto use the Manual The manual has basically been set up according to the Menu structure of the package This implies that the Chapter Titles within the manual refer to the Menu Options in the package This Chapter will give
97. n the User can choose to either consult the aggregated information or the detailed information To Consult Return Lines choose Actions Consult or click the Consult button Q or the F6 Key after haing selected a return from the list The User will be asked if he wants to consult Aggregated or Detailed Return Lines The Return Overview is now presented in consult mode for the aggregated or detailed lines of that return e To Consult Return Lines double click on the return line that has to be consulted The detailed or aggregated return line screen is presented in consult mode for that line Instead of double clicking the Button Consult Q or the F6 Key or Actions Consult can be used after selecting a return line from the list In the example that shows the Consult Detailed Return option it can be seen that 6 return lines have originally been entered RA t82 Statistical Period 200612 Type Of Retum Creation of a new retum ReturnApproved No Flow Dispatch Expedition Thresh Extended Return Correct Yes Item Number Declarant Ref Nr CN8 Goods Code Partner Country Invoice Value Correct Last Upd Last Upd By al 1 invoice 1 01019030 AT 1 600 Yes 03 01 2007 15 40 idep _ 2 invoice 2 84672290 CY 650 Yes 04 01 2007 09 02 idep il 3 invoice 1 01019030 AT 3 200 Yes 04 01 2007 09 03 idep i 4 invoice 1 01029021 AT 8 320 Yes 04 01 2007 09 00 idep 5 i
98. n the import file if the Goods Code Mode PSI Goods Code The applicable fields are taken from the PSI Goods Code list if import is done in PSI Goods Code Mode 2 Special remarks on Net Mass and Invoice Value in Foreign Currency and the use of decimals e The maximum length of the Net Mass is 10 digits a maximum of 3 decimals a total of maximum 14 characters long 1 character for the decimal sign included e The maximum length of the Invoice Value in Foreign Currency is 12 digits a maximum of 2 decimals a total of maximum 15 characters long character for the decimal sign included The decimals are only used as a facility for the User to be able to enter more accurate information on the return line level whether it concerns manual data entry PSI Models or input via the import facility 3 The field Currency Code can be used to calculate the Invoice Value in Local Currency and the Invoice Value in Euro via the imported Invoice Value in Foreign Currency and the table of Exchange Rates 4 For certain CN8 Goods Codes the Net Mass is not required and a zero value is accepted during import 5 In a Line Multi PSI Import Format the following additional fields can be defined the PSI Identification the Flow of the Return and the Statistical Period of the Return by default on position 1 2 and 3 If one or more of these fields are not included in the format the User will be prompted for their value s at the start of the Import
99. nd file system type available and used space maximum filename length Networking Domain name hostname IP address networking internet connections dial up Windows Installer MSI location and version Policy settings W2K or higher service status Running services NT or higher Interesting directories TEMP Windows Common Environment TEMP PATH variables Startup programs From start up directory in Windows registry IDEP CN8 Information Availability of user settings uninstallation information validity and suitability of installation path summary directory listing of installation path Mail Clients Installed clients default client email settings MAPI Internet software Default browser version internet settings for browser firewall VB amp VBA Settings To see if any other Visual Basic like applications have been run Office components Office versions and what office components are installed Software development Microsoft development software installed environments DLLs required by Availability version check registration IDEP CN8 Log files Listing of any IDEP GetRelease MSI IdepTest log files 9 Jan 15 101 IDNet15manE doc IDEP for Windows IDEP User Manual 13 6 Repair The tool for registering DLLs is available on most Windows versions REGS VR32 For every DLL that IDEP CN8 requires IdepTest checks if the required D
100. nly upgrade existing users can upgrade Idep from inside the program via the function System Maintenance Check voor Upgrades see chapter 10 7 in this manual Other ways of upgrading are described below 1 Go to http www intrastat be choose your language and then Declarations and IDEP CN8 for Windows Click on Online Installation and follow the instructions remark if an online installation should not be possible the complete installation package can be downloaded via a zip file on the same page 2 When the download procedure is started and depending on your Windows version one of the following dialogs appear select Run this program from it s current location or Run File Download x You have chosen to download a file from this location websetup exe from users skynet be What would you like to do with this file Save this program to disk Jv Always ask before openna tis wpe orhe Cancel More Info IDEP for Windows IDEP User Manual File Download Security Warning Do you want to run or save this file i leat ee exe From WWI wine be Bun Save de S Mee dasi While files from the Internet can be useful this file type can potentially harm your computer IF you do not trust the source do not run or save this software What s the tisk 9 Jan 15 Ta IDNet15manE doc IDEP for Windows IDEP User Manual Internet Explorer Security Warning The publisher could n
101. ns Menu in case the PSI Returns overview is presented This function is described in Section 8 4 1 Return Approval Disapproval e The Change current PSI option allows to select and work for another PSI defined in the system 7 1 PSI s The PSPs function is selected by Parties PSP s 7 1 1 Create Modify PSI This screen allows the definition or modification of the data of a PSI Provider of Statistical Information The function Add PSI s is started in Parties PSP s via Actions Add by clicking the Add button or by the F4 key The function Modify PSI s is started in Parties PSPs by double clicking on the PSPs Identification via Actions Modify by clicking the Modify Button or by the F5 key Modify PSI Parameters BE0000 000 097 ee BE enterprise nr 1 BE0000 000 097 Contact Person Hans Schollaert PSI Name Testco Telephone Nr FAX Number 1 BE enterprise number with 10 positions Click on the help button for more information about this screen Contact E mail Address hans schollaert nbb be National Region 1 Flanders Address Post Code ae Threshold Cat Arrival 2 Standard Return v Postal District h Di 3 Extended Return X OneGate Username 800 00059917 72 Threshold Cat Dispatch OneGate Password Last Return Number 111 me 9 Jan 15 34 IDNet15manE doc IDEP for Windows IDEP User Manual No
102. nual For instance on the return line data entry screen EJ Add Return Line 1 AA000021 2 x Ea 0 2 Statistical Period 200612 Thresh Extended Return Corect No Flow Dispatch Expedition Type Of Return Creation of a new return Declarant Ref Nr Partner Country ES Spain M Nature Of Transaction 1 ll transactions involving actual changi v Net Mass x Mode Of Transport 1 Transport by sea Currency Code x National Region 3 Brussels hd Terms Of Delivery CIF Cost Insurance Freight a Invoice Value PSI Goods Code F CNS Goods Code i Tode shoes aj gi l Add Cancel Help The CN8 Code and its associated data will be automatically entered after selecting the PSI Goods Code from the list If there is a Net Mass Calculation Factor connected to the selected PSI Goods Code the Net Mass is calculated automatically after the Supplementary Units are entered This is also done during import of the return data Note the concept of validity dates CN8 Goods Codes are only valid between a given start year and a given end year The validity dates that are associated with a CN8 Goods Code are assigned to the PSI Goods Code once the CN8 Goods Code has been entered If the User logs on to the package for a year different than his previous logon year then all the PSI Goods Codes are checked for their validity dates PSI Goods Codes that are correct status Correct Y are checked for their
103. nvoice 2 84672290 cy 980 Yes 04 01 2007 09 02 idep 6 invoice 1 01019030 04 01 2007 09 04 Search Close Help 9 Jan 15 63 IDNet15manE doc IDEP for Windows IDEP User Manual If the User chooses to view Consult Aggregated Info the following example shows that the 6 detailed return lines have been aggregated into 3 aggregated lines E Consult Aggregated Info 44000020 2 xj REAS Z Statistical Period 200612 Type Of Retum Creation of a new retum Retum pproved Yes Flow Dispatch Expedition Thresh Extended Return Correct Yes Agg Item Declarant Ref Nr CN8 Goods Code Partner Country Invoice Yalue Correct Last Upd Last Upd By 1 01019030 AT 5 800 Yes 2 01029021 AT 6 320 Yes Search Close H elp When the User consults an aggregated return line he will see that only the fields which are sent to the CNA have values not the fields that are optional g3 Consult Aggregated Info 2 A4000020 2 xi Statistical Period 200612 Thresh Extended Return Flow Dispatch Expedition Type Of Return Creation of a new return Declarant Ref Nr Suppl Units 5 Partner Country Number of items Nature Of Transaction Optional Net Mass 0 F Mode Of Transport Currency Code F National Region Terms Of Delivery Invoice Value 8320 PSI Goods Code k CNS Goods Code 01029021 F i Ta A De e Press Escape
104. oods Codes Exchange Rates e The Import Format i e the physical structure such as different Text formats dBase Excel MS Access e For Return Lines the PSI Goods Code Mode identifying if the CN8 Code or the User defined PSI Goods Code is used in the import file e If the value PSI Goods Code the system expects the PSI Goods Codes in the import file An automatic translation will be done to the CN8 Codes based on the PSI Goods Code table If the PSI Goods Code includes a reference to a Net Mass Calculation Factor then the Net Mass is automatically calculated during import e Ifthe value CN 8 the system expects the CN8 Goods Codes in the import file e For certain Import Formats for instance Excel it must be specified if the Import file includes Column Headers or not If it does the field Rows to Skip appears which defines the number of irrelevant rows It is pre set on 1 e For all Text formats it must be indicated if the Import file uses the ANSII character set or not It is recommended to keep this field on its pre set value unless it appears that the import procedure doesn t recognise certain special characters in text fields for instance the Danish characters a and 9 Jan 15 26 IDNet15manE doc IDEP for Windows IDEP User Manual The following fields are optional e Description used for the User s own identification of the format e Path Name the default name and location of the import file for th
105. or click on Close to return to the list of aggregated lines 9 Jan 15 64 IDNet15manE doc IDEP for Windows IDEP User Manual Special remarks on aggregation e When aggregation is carried out the aggregated Net Mass values are rounded to integers scientific rounding 0 5 becomes 1 0 4 becomes 0 e Ifa return is being disapproved the aggregated information for that return is deleted 8 4 3 Generate INTRASTAT Output The Generate INTRASTAT Output function is selected by Return INTRASTAT Output or by clicking the INTRASTAT Output Button e It is also possible to invoke Generate INTRASTAT Output directly from within the Header list by the Alt F10 key or Actions INTRASTAT Output Returns In that case the range of return numbers From Number To Number is initialised with the return number range of a selection made in the Header list or the current return number if there is only one return selected The official output will process all approved returns within the selected range Processed declarations will be locked and can not be modified anymore The selected output will become the default If Generate INTRASTAT Output is invoked from within the Header list two option buttons on the right hand side of the dialog appear see picture below These buttons are All List Entries and Select Returns r g 3 Intrastat Output D o ie t p Output Select Retums
106. or every PSI defined in the system has his own set Every PSI can have his own set of functionality as follows e Net Mass Calculation Factors for calculation of the Net Mass e Line Models for quick manual data entry e Good Codes internal codes can be used instead of the official CN8 Codes A Search field is provided for each of these tables in which the cursor is automatically positioned Information entered for one PSI can be copied to another PSI at the time of creation or afterwards using the option e PSI Info Copy PSI Information 9 1 Net Mass Calculation Factors The Net Mass Calculation Factors function is selected by PSI Info Net Mass Calculation Factors or by clicking the Net Mass Calculation Factors Button fx Net Mass Calculation Factors are used to e Calculate the Net Mass from the product of the number of Supplementary Units and the Factor defined in the Net Mass Calculation Factor selected by the User when the focus is on the Net Mass field e Calculate the number of Supplementary Units from the Net Mass by dividing the Net Mass by the Net Mass Calculation Factor and rounding the result when the focus is on the Supplementary Units field A x amp 2z Net Mass Calc Fac Suppl Units Factor Descrip Correct La New Shoes Number of pairs 0 89 prod 1 2 25 Yes __ prod 2 3 65 Yes Close Help 9 1 1 Specifying Net Mass Calculation Factors This funct
107. ot be verified Are you sure you want to run this software Name websetup_nl exe Publisher Unknown Publisher should only run software From publishers you trust How can I decide what rx This file does not have a valid digital signature that verifies its publisher You software to run 4 Follow the instructions of the installation program e Select the user interface languages to be installed and the installation program s language The language selection dialog serves two purposes 1 It allows installing or removing the available language versions of the User Interface of IDEP CN8 2 It allows selecting the language of the User Interface of the installation program itself Selecting the IDEP CN8 User Interface language is simply done by clicking on the appropriate buttons All available languages are pre selected If an existing IDEP CN8 installation is updated only the already installed languages are pre selected A de selected language will be removed from an existing IDEP CN8 installation The User Interface language of the installation program is automatically set to the last selected language Click several times on the various language options in order to select the desired dialog language The language is immediately switched the chosen language is shown in brackets in the title bar e Choose a Stand alone or Server installation Note that in a Client Server configuration the Server must be installed or u
108. pgraded first Installation of a Server is identical to a Standalone installation For the Client installation see the next section e Choose the destination location either take the default or select another destination Please refer to Section 2 1 4 for more information on appropriate Installation Folders When performing an upgrade the actual installation directory is shown It is possible to move an existing installation by selecting another directory an empty directory or a directory with another Idep installation or by typing the name of a new directory The required and available disk space are shown 5 Now the installation program will start copying Note that the copying of the CN8 databases may take some time 6 Click finish to leave the installation program Note It is possible to cancel the installation process at any time The user will be asked for confirmation 9 Jan 15 8 IDNet15manE doc IDEP for Windows IDEP User Manual 2 1 1 Installation and upgrade from the Internet The User will now find the IDEP CN 8 program installed or upgraded in the selected directory and the subdirectories created by the installation process in the languages provided by the NBB The ee is started by either the Windows Start Menu by double clicking on the IDEP Shortcut F put on the Desktop by the installation program or by double clicking on Idep exe in the root directory 2 2 Installation and Upgrade in a Local Area Network LA
109. process This format contains a super set of the fields used for Arrival and Dispatch Return Lines in all Threshold Categories 6 1 2 Usage of the Import Function The functionality is similar for Return Lines PSI Goods Codes and Exchange Rates The import function is called by Actions Import by clicking the Jmporf Button FAY or by the F9 Key e for Return lines from the Modify Return Overview list see Chapter 8 2 3 6 or in the Import menu through Import in current Declaration or Import in new Declaration e for PSI Goods Codes from the PSI Goods Codes list see Chapter 9 5 e for Exchange Rates from the Exchange Rates list see Chapter 5 1 The Lines Multi PSI import function is called by System Multi PSI Import see Section 6 2 Multi PSI Import A special case is the Import of a WEB based file This is described once for all above Import types in Section 8 2 3 6 Usage of the Import Function for Return Lines Draft Output is a means for the User to check his declaration before producing the INTRASTAT output How to create Draft Output is described in Chapter 8 3 The default Draft Order definition is found as one of the formats provided in the Import Format Menu 9 Jan 15 29 IDNet15manE doc IDEP for Windows IDEP User Manual The User can add his own Draft Order definition in the same way as described above for the Import Formats by selecting Draft Print Or
110. r to open the Windows explorer map in which the output file has been saved and the OneGate login page PSI ID BEO000 000 097 bob From Number 111 To Number 111 Output Onegate manual Press the link Connect to OneGate to upload declarations Anbb Jocal usr MOORTGA Documents idep_Cn8 OUT OneGate_150105_09290_BE0000000097 xml PSIID Return Number Type Of Return Flow Statistical Period Yes Ticket 0 BEO000 000 097 AA000111 0 201409 9 Jan 15 66 IDNet15manE doc IDEP for Windows IDEP User Manual You can login to OneGate with a user name and password or with an electronic certifcate al NationalBa OneGate GIUM Statistics NBB Login NL ER EN DE SECTIONS ia nas R E Login to the OneGate application Documentation z i e with Electronic Certificate e with Username and Password Click on the link in the frame to gain access to OneGate HELP WITH THE ONEGATE APPLICATION e The users manual for the declarers can be found in the section Documentation e Contact e Frequently Asked Questions FAQ The Upload tab allows you to upload the XML file prepared by Idep OneGate 1 Profile Reports Exchanges Upload About N NationalBonk Upload ae Declarer KBO 0000000097 User 1 File Upload Browse File gO a nbb local usr MOORTGA My Documents Idep_Cn8 OUT Search OUT P Organize v 88 Open X New fo
111. rchived Note that only returns with the status Sent Yes can be archived Other returns will be ignored even if their identification number is within the selection By Archive to Disk all declarations as presented are archived or a selection can be made Select the drive and path where the archived output should be placed IDEP will suggest a new name for the archive lt PSI ID gt _DDMMY YY Y MDB The directory for archive files must be outside of the Idep_CN 8 installation folder It will be derived from information stored in the Windows Registry during a previous archival operation this will ensure that all archive files will in principle be stored in the same directory The user is free to choose another name The database name for the Access output database can be entered by the User the table names for the three tables involved are assigned by the system The tables involved are Detailed Headers Detailed Lines Aggregated Lines The file layout of these files field order and length is the same as in the IDEP database Now IDEP generates the archive database in the selected path with the specified file name If the archive has succeeded the necessary information will be recorded in the Archive and Archive Details tables see Section 10 1 2 De Archive If no returns have been archived no entry will be made in the Archives table It is up to the User to take a backup of the database files Note that the
112. riMOORTGA Documents ldep_Cn8 OUT OneGate_150105_10410_ xml Awe e be PSIID ReturnNumber Type Of Return Flow Statistical Period gt AA000110 201409 i Yes Ticket 186652 BE0000 000 097 AA000111 201409 wy Yes Ticket 186654 BE0000 000 196 AA000020 201405 9 Jan 15 70 IDNet15manE doc IDEP for Windows IDEP User Manual 8 6 Overview Declarations The Overview Declarations function is selected by Return Overview Declarations or by clicking the Return Overview Button 2 The check boxes allow the application of selection criteria for the presentation of the list By clicking on combinations of check boxes the presentation criteria are narrowed For Third Declarants the overview presents the declarations of all PST s if chosen 9 Jan 15 71 IDNet15manE doc IDEP for Windows IDEP User Manual 8 7 Reports Four kinds of reports can be obtained via Return Report All of these reports provide information about the total invoice value for a PSI over a certain period By Partner Country Flow Arrival Introduction Totals for a PSI From Period 200401 January 2004 F O By Goods Code To Period 200701 January 2007 e By Declarant Ref Nr Return Number r By Partner Country gj Austia M Show Unit Qualifier HP Laserdet 2300 Series PCL 6 Portrait Landscape Cancel Help When generating a report returns tha
113. rrect No Item Number Declarant Ref Nr CNS Goods Code Partner Country Invoice Yalue Correct Last Upd Last Upd By La 11 IT 1 No 06 12 2006 14 41 IDEP 2 15 NL i No 06 12 2006 14 41 IDEP il 16 91059100 NL 435 No 06 12 2006 14 41 IDEP B 26 IT i No 06 12 2006 14 41 IDEP al 37 IT 1 No 06 12 2006 15 00 IDEP al 41 NL 1 No 06 12 2006 15 00 IDEP El 42 91059100 NL 435 No 06 12 2006 15 00 IDEP 52 IT i No 06 12 2006 15 00 IDEP Search Close Help Closing this list via the Close Button Cross Button Cancel key or System Exit CONTROL F4 will return the list to its normal state i e showing all lines Correct the lines one by one in the same way lines without errors would be modified Once the line is corrected it will disappear from the list of erroneous lines Once all erroneous lines have been corrected the return will become correct The Buttons Nex f and Previous can be used to select other erroneous lines in modify mode without having to leave the screen Clicking on the left or right part of these Buttons will jump to the top respectively the end of the list 8 2 6 Save Return Line as a Line Model The function Save As Line Model is started via Actions Save As Line Model by clicking the Save As Line Model Button or by the F12 Key The function is only available in the Detailed Return Line Screen This function will create a model for t
114. stem Maintenance Backup Idepdata It allows the User to create a backup of ALL PSI dependant information for all PSI s In order to do a backup the following must be specified e Destination drive and path e File name for the backup ZIP file All the database files concerned are zipped into this file All backup restore and upgrade operations are logged in a file maint log This file is also included in any backup archive Note that the version number of the IDEP package that made the backup is kept with the Backup information to enable the correct Restore of the information At the end of the backup procedure a message is displayed to indicate whether the backup was successful or not 9 Jan 15 89 IDNet15manE doc IDEP for Windows IDEP User Manual 10 3 Restore Backup The function Restore Backup is started in System Maintenance Restore Backup This option allows the User to restore a previously made backup The complete PSI data are restored all PSI dependant information present in the system is overwritten It is possible to restore a backup from an earlier version The Restore facility can be used in two cases e When the User accidentally has removed PSI dependant information In this case simply Restore the most recent Backup Information that was entered between the moment of making the Backup and the Restore operation is lost It is therefore important to make a Backup regularly e W
115. stical Period for the given Flow of goods is contained in a return A return is composed of 1 header and one or more lines A return header of a given PSI is basically identified by the following 1 The Statistical Period month 2 The Flow arrival or dispatch of goods 3 The type of information new information corrections to a previous return A return line can be seen as transaction e g information on an invoice A return line can also contain information aggregated for several transactions A return line is identified by a unique number NOTE A PSI can send several returns of the same type i e Arrival of goods for the same Statistical Period i e January 2007 That s why the identification of the returns requires some special attention The following two situations should be considered 1 A User creates several returns of the same type for the same Statistical Period and Flow on the same PC In order to uniquely identify the return it is identified by a Sequence Number e g return 1 and 2 2 The same PSI generates returns from several PC s On every PC the return can be identified by for instance the sequence number 1 Beside the sequence number another qualifier is necessary to uniquely identify the return This qualifier is called a Workstation ID in the package If for instance PSI X generates INTRASTAT returns from three PC s then he should identify the PC s by e g AA BB and CC
116. t This screen allows the User to select the following e The Member State if more than one package is installed e The language if more than one language is included by the National Administration that prepared the package e The Application Name CN8 or IDEP When you have selected the IDEP application Idep will be started up with the default User Name IDEP This default User cannot be removed from the system It is possible to create other users with passwords and with specific authoritisations You can also select the CN8 application List of Commodity Codes By clicking on the OK button the User will enter the selected package By clicking on the Canceel button the User will leave the Login screen If the User has installed Internet facilities clicking on the link will establish a connection with the WEB site of the National Bank of Belgium 9 Jan 15 11 IDNet15manE doc IDEP for Windows IDEP User Manual 4 THE GRAPHICAL USER INTERFACE GUI 4 1 Status Check The PSI Goods Codes defined in the package will be checked Goods Codes for which the CN8 code has become invalid for one of the years supported by the new package will be marked in the PSI Goods Codes list When IDEP is upgraded to a new annual version the maximum minimum limit values connected to CN8 Codes are updated with the limit values of the previous year but only if the PSI s limits are higher than those supplied by the CNA and t
117. t are referenced in a replace return are skipped A report can be previewed on the screen If you wish to make a hardcopy on paper click on the Print Button amp The four report types are the following 1 Report by Partner Country This option will give you a report for the selected Partner Country per Goods Code of a given PSI showing all totals for the specified flow over the specified time interval 2 Report by Goods Code This option will give you a report for the selected Goods Code per Partner Country of a given PSI showing all totals for the specified flow over the specified time interval 3 Report by Declarant Ref Nr This option will give you a report by Declarant Ref Nr of a given PSI showing all totals for the specified flow over the specified time interval 4 Report of Totals for a PSI This report presents for the selected PSI over the specified time interval and Return Flow the Total Invoice Value for each Statistical Period within the time interval 9 Jan 15 72 IDNet15manE doc IDEP for Windows IDEP User Manual 8 8 End This option closes the program and returns to the Login splash screen where the User can select another option or program or choose to leave the package 9 Jan 15 73 IDNet15manE doc IDEP for Windows IDEP User Manual 9 PSI INFO The Menu PSI Info is related to functions which are used for the maintenance of data which are PSI specific i e data that f
118. ter General remarks for data entry are The data can be entered in a random order Note however that certain items have influence on the behaviour of other items The TAB key or the Enter key if enabled by the User in the System Setup Display function see Section 4 8 3 TAB Order or the mouse can be used to jump from one field to another When data is entered manually through the keyboard IDEP can be instructed to automatically jump to the next field when the data that has been entered was correct In this case the User doesn t have to enter the TAB after entering the value Of course this mechanism only works for fields in which data with a fixed length must be entered The facility is enabled or disabled by clicking on the check box Automatic TAB in System Setup Display When a field value that was previously entered is selected by double clicking or by using the TAB key a new value that is entered replaces the previous one If the User just wants to add a character to the field he has to position in the field using the mouse or arrow keys After filling in the last field on the screen the information is saved by clicking the Add button If some of the required information is still missing or one of the so called quality checks on big transactions fails the program will present a warning message regarding the missing data However the User can also choose to save an in complete line in this case the line w
119. ter 10 5 Download 2 4 Un install the Package The IDEP CN8 for Windows packages can be un installed simply through the usual Windows un install feature Open Add and Remove Programs Start Control Panel Add and Remove Programs Choose IDEP CN8 and click the Add Remove Programs button Confirm the question Do you want to remove On the question Remove the IDEP Executables and Data as well answer Yes if you want to completely remove IDEP CN8 or No if you want to keep the complete installation but just want to remove the registration short cuts etc 9 Jan 15 9 IDNet15manE doc ame ae ae IDEP for Windows IDEP User Manual Please note that this cleanup procedure will not delete any files from the installation directory if It concerns the Root of a drive e g C V It concerns the Root of Windows Program Files directory A subdirectory called WINDOWS WINNT SYSTEM Program Files local name exists The installation directory is somewhere in the Windows or System directory It concerns an installation directory with more than 12 sub folders and or 7 files A warning message will be displayed Due to some limitations of the installation product not all files are removed To see which files directories have not been removed press the Details button on the Add Remove Programs dialog Remaining files can be removed manually using the Windows Explorer Doing th
120. the CNA should be contacted New versions of the software should always be received via the CNA in order to ensure the integrity of the data OneGate The NBB online application in which INTRASTAT returns are collected www onegate be PSI Stands for Provider of Statistical Information These are Importers Exporters who are obliged to make INTRASTAT returns to the CNA The PSI is identified by his enterprise number Third Party Declarant or Agent A company that makes INTRASTAT statistical declarations to the CNA on behalf of one or more companies i e PSI s User A person who is defined in the IDEP CN8 package and who can access and use the package Different Users of the package can have different authorisations The authorisations specify whether a user has access to a given set of functions or all functions Three types of Users can be defined 1 Supervisor the default User IDEP This User can perform all functions in the package 2 Editor Normal User with Modify authority This User can perform the functions for every User but not the functions that are reserved for the Supervisor 3 Consult User without Modify authority This User can consult the functions for every User 9 Jan 15 4 IDNet15manE doc IDEP for Windows IDEP User Manual 1 3 2 Main Data involved in INTRASTAT Declarations Return All statistical information for a given PSI in a given Stati
121. the maintenance of the return information Return maintenance can be done for the current PSI only or in the case of a Third Declarant for all PSI s at once The process of archiving returns is supported through the following features that are discussed in the following Chapters 1 Archive to disk Move return data to another disk 2 De archive Move archived data back into IDEP 3 Delete headers Remove the headers which stay as a reference in IDEP 10 1 1 Archive To Disk The function Archive to Disk is started in System Maintenance Declaration Maintenance Archive to disk When the User wants to make space available on his hard disk or the returns he has kept in his system are not required on line anymore he can Archive the returns which have been sent After selecting this function an overview appears showing the returns that are ready to be archived 9 Jan 15 85 IDNet15manE doc IDEP for Windows IDEP User Manual ax A amp From Period 200404 April 2004 7 To Period 200612 December 2006 O All PSIS Number Of Items 3 BE enterprise nr 1 Return Number Type Of Return Flow Statistical Period Date Sent Time Sent J BE0000 000 097 AAD00017 200610 04 01 2007 13 51 BE0000 000 097 aaoo00zo 200612 04 01 2007 10 32 BE0000 000 097 44000021 200612 04 01 2007 13 51 The procedure for archiving returns is as follows Select the period or the declarations to be a
122. the return header or adding deleting or modifying return lines 9 Jan 15 41 IDNet15manE doc IDEP for Windows IDEP User Manual 8 2 2 Create the Return Header STEP 1 Select Return Edit Returns or click on the Edit Returns Button EJ The PSI Returns overview is presented Note that after creation of a PSI the PSI Returns overview is presented by default after starting up the package 9p Intrastat Data Entry Package BE0000 000 097 Testto er Return Actions PSIInfo Parties Import System Syst Maintenance CN8 Window Help f CNS f ry oa x OA xX HOGS kG ely GH PSI Returns Ed E A EEE SOE EE Return Number Type Of Return Flow Statistical Period Invoice Value Correct Return Approved Sent Date Sent Time Sent Reference Number Return Archived eal 44000001 1 a 200512 5 610 Yes Yes Yes 15 12 2006 11 49 Yes 4A000014 A 200610 384 932 No No No No E AA000015 4 200611 418 008 No No No No ie 44000016 1 D 200611 65 614 Yes Yes Yes 15 12 2006 11 49 Yes AA000017 1 D 200610 12 952 No No No No a 44000018 1 4 200608 833 692 Yes Yes Yes 15 12 2006 11 49 Yes 8A000019 1 lal 200608 417 720 No No No No 44000020 1 D 200612 1 600 Yes No No No 44000021 1 D 200612 Search Ose Help S T EP 2 To Add a Return to the list of returns of the current PSI use Actions Add or click the Add button or press F4 Enter the Header information wh
123. tions to a Server eseeeeesessseesssressssreesssreessrreesssreesserressses 9 2 4 Un install the Package innen nrt nre rr rer ree ee e e e E EE E Oh ee ee A 9 S a MOOSE a A E E E E T T A A TEN te 10 3 STARTING THE PACKAGE LOGON SCREEN sessessseeesseesoceseoessoeesocesoeesooessoeesosesoeesoesee 11 4 THE GRAPHICAL USER INTERFACE GUD eeseeesseerseeesoeesoceseoessoeesoeesocesooessoeesosesoceseosee 12 4 1 Status Checker niea EE EE E ENEE E EE E E OE E E O NE EE E 12 4 2 Sereen Layouten snorren E E a E EEE E AEE TEE TE T T Te I EEn 12 43 Actions Menu Toolbar snr sees sees ezes sees tes coca otesetea etere riete o r obeseusl obexeusssdenezeecdeaouenctervevtcucts 13 AA Waindow Mente AA AAA AAAA AAAA AAA AT 13 AS Help M ENU TE SE TIE TE A NE AATA 14 AcOH SetuP IIS Pla yin Snae t a het hes naaien oaen Roh hes atean Aai aien naa ea het it tc 15 A PUNO E ES e san hat te A aT aE a e A are A e EAEE A h ane ae 16 4 8 Data Entry and Presentation Facilities eeeeseeeeeeseeeseseeesssrresssrrerssrrerserreessresssreesssreerssrees 16 4 8 1 eita AEEA A AAA AA AAA AAAA AAA AAA AA AA A AAAA 16 4 8 2 Field Colours aea e eA a e a ie a e Al enaa 17 4 8 3 TAB Ordem e ds oie io OU A DUE GROUT SSS Got ol T O Suton 17 4 8 4 Sort Orders sis Wak A A A AAA AA A AA A Ae aaa 18 4 9 Notations used in the next Chapters of this Manual eeeseecceesneeeceesseeesesseeeeeesaeees 18 D gt SYS PEM A S A E 19 5 1 Exchange Rates AET A T A AAAA E A T T
124. turn They cannot be modified anymore Once the return has been created it is not possible to modify the Reference Number anymore for a Replace return if the number of items is greater than 0 Returns with a status of Archived cannot be used as reference to the previous return for Replace Returns because the line data is not available anymore When a Replace Return is created all the return lines are automatically copied from the original referenced return For a Replace Return the validation rules on line level are the same as for a new return remark if you created and sent a standard while it had to be an extended declaration this can be corrected as follows In this screen you have to change the treshold category to extended declaration Then you create a new declaration for the same period see chapter 8 2 2 with type of return 5 replacement of a previous return Now it is possible to add the missing data and to resend the declaration 9 Jan 15 59 IDNet15manE doc IDEP for Windows IDEP User Manual 8 3 Draft Output Returns The Draft Output Returns function is selected by Return Draft Output or by clicking the Draft Output Button The draft output functions allow the User to extract a range of returns for a given PSI either on paper or on disk Note that this kind of output is only for internal use It should not be sent to the CNA Draft output includes detailed return lines or aggregated return
125. u can now verify the status of the uploaded declarations in Onegate under Exchanges File exchange log PSI ID BE0000 000 097 bob From Number 111 To Number 111 Output OneGate auto PSI ID Return Number Type Of Return Flow Statistical Period 201409 If for some reason e g telecommunication problems the User has lost the information to be sent to the CNA he can use the Unlock function via Actions Unlock the Unlock Button or the F9 Key to resend the declaration Then he will have to start the official output process again It is possible to select a range of declarations to be Unlocked which could be a mix of Unlockable and non Unlockable declarations 8 4 4 INTRASTAT Output All PSI s Third Declarants only The INTRASTAT Output All PSPs function is selected by Return INTRASTAT Output or by clicking the INTRASTAT Output Button and then selecting the Radio Button All PSP s if the system is set up for a Third Declarant see Chapter 7 1 Parties Third Party Declarant The Third Declarant can choose between All PSP s and Current PSI 9 Jan 15 68 IDNet15manE doc IDEP for Windows IDEP User Manual ee Output Retums Manually to OneGate All PSI S Automatically to OneGate Current PSI O Select Returns However if the INTRASTAT output is invoked directly from the Header list the Select Returns
126. us apply to all PSI s defined in the system Functions on the system level are Exchange Rates Administrative Parameters Select Printer Setup Display this function is described in Chapter 4 Graphical User Interface Proxy Settings only applicable for sending declarations via Email Collecting Centre 5 1 Exchange Rates The Exchange Rates function is selected by System Exchange Rates or by clicking the Exchange Rates Button The Exchange Rate table allows the User to convert amounts in Foreign Currencies automatically or manually into amounts in Euro The Exchange Rates overview will only show the non EMU currencies However in this case the Checkbox Show EMU Rates still allows the User to consult these rates as shown in the following example Without the old Local EMU Currencies 7 RH eK ae Currency Code Exch Rate Descrip LastUpd Correct Yes Yes 1 515152 Pound Sterling 20 12 2006 15 49 0 8 US DOLLAR 20 12 2006 15 51 5 1 1 Specifying Exchange Rates The function Add Exchange Rates is started in System Exchange Rates via Actions Add or by clicking the Add Button or by the F4 Key The function Modify Exchange Rates is started in System Exchange Rates via Actions Modify or by clicking the Modify Button A or by the F5 Key 9 Jan 15 19 IDNet15manE doc IDEP for Windows IDEP User Manu
127. ussels v Currency Code 7 PSI Goods Code e CN8 Goods Code E Invoice Value zi When entering data in a Model the same utilities are available as for return lines see Chapter 8 2 3 3 There are however three extra fields on the Model data entry screen e Model Name to uniquely identify the Model e Flow Arrival or Dispatch e Model Description If the User has a long list of Models the search facility can be useful if the Model Name he wishes to access is known Just type the first letters of the name of the Model and the cursor will jump automatically to that Model Another way to define Line Models is in the Line Details screen through the Save As Line Model function described in Section 8 2 6 Save Return as a Line Model This function will create a model for the Flow of the current Return and save all data entered so far in the Return Line It will prompt for the name of the model this prompt can be cancelled If an existing name is entered or selected from the available picklist it will update the fields of that line model after confirmation by the user 9 Jan 15 78 IDNet15manE doc IDEP for Windows IDEP User Manual 9 2 2 Usage of Line Models When adding a return line the User can select a Model via Actions Model or by clicking the Line Model Button The values of the Model will be automatically entered in the return line fields when the User clicks on OK after selectin
128. utton or selecting Actions Modify or by the F5 key The User will now see the Return overview of the return lines which is still empty in this stage Summary header information is displayed E Modify Return Overview AA000021 Return lines can now be added in several ways e Manual data entry is the simplest way see Chapter 8 2 3 2 e By means of Line Models see Chapter 8 2 3 4 e By copying information from other returns see Chapter 8 2 3 5 e Via the import facility see Chapter 8 2 3 6 9 Jan 15 43 IDNet15manE doc IDEP for Windows IDEP User Manual 8 2 3 2 Manual Data Entry of Return Lines STEP 1 The function Add Return Lines is started via Actions Add by clicking on the Add button or by the F4 Key to add a return line manually This will present the detailed Return Line entry screen ig 2 Statistical Period 200612 Thresh Extended Return Corect No Flow Dispatch Expedition Type Of Return Creation of a new return Declarant Ref Nr Partner Country SaaS Nature OF Transaction Net Mass x qi s Mode Of Transport National Region 3 Brussels 3 Mode Of Transport Terms Of Delivery Y Invoice Value Currency Code 7 PSI Goods Code CN8 Goods Code lv ry 4 Ei Add Cancel Help IDEP provides utilities to make the manual entry of data easier They are described in the following Chap
129. vided by the NBB 9 5 Copy PSI Information The Copy PSI Information function is selected by PSI Info Copy PSI Information This option allows the User to copy the PSI dependent tables from one PSI to the current PSI e Arrival and dispatch Models table e PSI Goods Code table e Net Mass calculation factors table When creating a new PSI see Chapter 7 1 2 the same function is available The check box Discard Duplicates allows the User to copy only the information from another PSI that is not yet available in his own PSI tables This function is only available when copying the tables to an existing PSI as a new PSI still has empty tables and duplicates can not occur 9 Jan 15 84 IDNet15manE doc IDEP for Windows IDEP User Manual 10 SYSTEM MAINTENANCE If working in a LAN environment System Maintenance functions can only be performed when the databases are exclusively available to one User or in other words when there are no other Users logged on to the system The second User who logs on during maintenance by the first User will receive a message to try to logon again later 10 1 Declaration Maintenance The Declaration Maintenance function is selected by System Maintenance Declaration Maintenance Remark these functions are not available when archiving is disabled under System Administrative parameters see chapter 5 2 Administrative parameters This Menu option allows the User to do
130. w the PSI can be defined by filling in all the data that are requested on the screen Mandatory fields to be entered are e BE Enterprise number the identification number of the PSI BE the 10 digit identification number of the declarant in the Crossroads Bank for Enterprises e PSI Name e Threshold Category Arrival select the category that is applicable for the PSI e Threshold Category Dispatch select the category that is applicable for the PSI remark if you created and sent a standard while it had to be an extended declaration this can be corrected as follows In this screen you have to change the treshold category to extended declaration Then you create a new declaration for the same period see chapter 8 2 2 with type of return 5 replacement of a previous return Now it is possible to add the missing data and to resend the declaration Optional fields are as follows e Name and Address Info Postal Code Postal District City of the PSI e Contact Person Telephone Number FAX Number of the PSI e A default value can be selected in National Region on the PSI Parameters screen This value is automatically copied to each Return Line created by the PSI or by the import process e The OneGate user name and password ought to be filled in if you want to upload the output automatically into OneGate see 8 4 3 Intrastat output Note that the PSI that is just created or modified has now become the Current PSI When severa

IDEP for Windows

Contents

Download Pdf Manuals

Related Search

Related Contents