Declaration and Statement Module – Fat Client User Manual
Contents
1. 13 FIGURE 16 PS9DECL VAT DECLARATIONS SELECTION SETUP REVISION OPERATOR LIST OF VALUES sees ennemis nasa nis 13 FIGURE 17 PB9DECL VAT DECLARATIONS SELECTION SETUP REVISION REVIEWING AN EXISTING SELECTION csscsscceccecceccesccscceccaeceecesceseeseeeceees 14 FIGURE 18 P59DECL VAT DECLARATIONS SELECTION SETUP REVISION COPYING AN EXISTING SELECTION sceccssccsccecceccscccsccecceececeecesceeseeceseeees 15 FIGURE 19 PSSDECLEV VAT DECLARATIONS BROWSE cie tux Sk ERST UE Ss Up ER MER ERR eU S pus UU CUR bn keen uu ER addo dor FUA UE Rey bsp 16 FIGURE 20 PB9DECLV VAT DECLARATIONS BROWSE NAVIGATION nennen nennen she sne rures sse ses ea esses sese 16 FIGURE 21 PSSDECLV VAT DECLARATIONS ag sons NK IF ette AI ag eo QU URDE MERE a 17 FIGURE 22 PBO9DECLV VAT DECLARATIONS SEARCH AND SELECT DECLARATION c esee nennen essei seis ea sean 18 FIGURE 23 PB9DECLV VAT DECLARATION CREATE NEW ADDING A NEW DECLARATION c eese rne senses seas ee sse stes esses sees 19 FIGURE 24 PB9DECLV VAT DECLARATIONS BROWSE LIST OF DECLARATIONS ssesseeeene enne nennen nennen nnne2. Figure 22 P59DECLV VAT Declarations Search and Select Declaration Select required declaration setup and confirm by clicking the Select button You will be returned to the previous screen and the name of the selected setup will appear in the Declaration Name field in the header After the declaration setup is selected click the Add button to create a new declaration P 9D CLV TVA De laratic rea New File Edit Preferences Window Help Links Displ OK Can Dis Abo w Displ 9 internet Company 00001 Declaration Name demo Demo Declaration Declaration Frequency M Monthly Fiscal Year Period 5 Declaration Number o Declaration and Statement Module Fat Client User Manual 18 z 2 7 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts Figure 23 PS9DECLV VAT Declaration Create New Adding a new declaration All blank fields need to be populated a Company the Company number for which the declaration will be created b Declaration Name declaration setup based on which the declaration will be created c Declaration Frequency this parameter indicates how the declaration will be recurring It is based on the setup d Fiscal Year Period the fiscal year and period for which the declaration will be created e Declaration Number unique next number of the declaration If there is no previous declaration created it is set to O f
3. exisihe Ete petite iia dud ette 14 2 4 Copying anexi tine Selection erisera ENE EN 14 2 5 Deleting anexistig selection sores saranda nrar E eA ENA 15 2 6 e 15 2 7 lo m 15 3 Working with declarations Pb9DECLV eessseeeeeeeeennnennnnnne enne enne nnne nnne snnt 16 3 1 Creating mew declarat lO 17 3 2 Calculating declaration nnn aE EE NEE EE 19 3 3 Reviewing and overriding declaration values cccccccssscccceessececseseceeseseceseusseceueceseueceeseusecessagnsess 20 3 4 Me din CC Cie AOI aa 23 3 5 Recalculdate COI e inp S Canes HN bE eee Oed De eruUd 23 3 6 25 LOTOR FI GORE t HH 27 Declaration and Statement Module Fat Client User Manual 117 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts PREFACE The following document describes the functionality of the VAT Declarations solution in JDE E1 i e PS9DECL and P59DECLV programs The solution may be used not only for VAT declarations but also for other calculations for example balance sheets
4. ses ea ee esses sese sees ans 19 FIGURE 25 PSODECLV VAT DECLARATIONS BROWSE ROW 20 FIGURE 26 PB9DECLV VAT DECLARATION BROWSE VALUES REVIEWING A REVISING AN EXISTING DECLARATION esee 21 FIGURE 27 PB9DECLV VAT DECLARATION VALUE DETAIL 5 see sse ses see senses 22 FIGURE 28 PB9DECLV VAT DECLARATION BROWSE VALUES OVERRIDDEN VALUES ccsccescsscceccsccesccscceccsecseceecescseceeceecescsseseeaeseecescssesaeceeenes 22 FIGURE 29 PSSDECLV VAT DECLARATIONS BROWSE POSTING 23 FIGURE 30 PSODECLV VAT DECLARATIONS BROWSE POSTING CONFIRMATION sees enne nennen nennen nne nenne te seats ea ees se ses nns 23 FIGURE 31 PSSDECLV VAT DECLARATIONS BROWSE REPORT RECALCULATE ueemsisba e REPERI ARS e ER ETKMER KERN qu C pe RO RETI Yd Reen a URS p URS 24 FIGURE 32 P
5. Below is a list of valid values EQ Equal GE Greater or Equal GT Greater HNDL Table Handle LE Less Than or Equal LIKE used as wildcard e g LT Less Than NE Not Equal NRANGE Not Between RANGE Between UDC User Defined Code VALUE In a List ZLNGTH Allocated Length VARLEN flds Figure 16 PS9DECL VAT Declarations Selection Setup Revision Operator list of values d Value a parameter that specifies the value of the Data Item used in the current line e Line ID unique line number of current record in the grid After populating all required field click the OK button to save the selection and return to VAT Declaration Selection Setup Browse screen Declaration and Statement Module Fat Client User Manual 1317 2 7 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts By clicking the Select button on VAT Declaration Selection Setup Browse screen users can review and revise an 2 2 Reviewing an existing Selection existing selection which is currently highlighted in the list of records VAT Declaration Selection Setup Revision screen is opened t JP59DECL VAT Declarations Selection Setup Revision File Edit Preferences Window Help v W x d R Links w Disp s OLE s Internet OK Find Del Can New Dis Abo Configuration Name JETO Table Name Period YTD Inception Balance Calculated Field Data Figure 17
6. cash flows and others As the solution is general users can define own calculations without any restrictions use tables or even views to select data from the database Moreover the solution can work with account balances It is possible to implement algebraic calculations and also decide using an IF clause which value is valid After the calculation is performed the solution can format the output based on the parameters specified by the user Declaration and Statement Module Fat Client User Manual 2 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts To create a new declaration users need to prepare a new declaration setup first The declaration setup is a generic layout of a declaration based on which a declaration will be created This is done in the application PS9DECL VAT Declarations Master Setup Browse 1 Declaration Setup P59DECL v 8g x JF SG 9 Select Find Add Copy Del Close Seg New Dis Abo Effective Date Declaration Effective Description Name Date Selection Setup 01 01 2010 Deklaracia VAT BALBYCATCODE j 01 06 2005 Balance by Category Code 01 06 2005 Account Balances 01 07 2010 Declaration D1 01 01 2010 Test DMA 01 06 2010 My first declaration 01 07 2008 Demo Declaration TEST1JCI 20 07 2010 Test Jarka Figure 1 PS9DECL VAT Declarations Master Setup Browse The list of existing declaration setups is shown in the grid Nav
7. Calculate immediately If it is necessary to immediately recalculate the amounts on the declaration this checkbox needs to be checked After populating all required fields click the OK button to save the declaration and return to VAT Declarations Browse screen The declaration has been created but no values have been calculated yet 3 2 Calculating declaration values Click the Find button on VAT Declarations Browse screen to refresh the grid and display the list of existing declarations Users are now able to find newly created declaration P59DECLV VAT Declarations Browse S File Edit Preferences Row Window Help da A g x I amp 9 Links Select Find Add Del Close Seg New Dis Abo Y Repor AOLE elinten Company Fiscal Year values Declaration Name Period Number Recalcu Boman 00001 BALANCES Account Balances 00001 Balance by Category Code Recreate TEST1JCI Testi Jarka Deklaracja VAT 7 Deklaracja VAT 7 00001 demo Demo Declaration Demo Declaration Figure 24 PS9DECLV VAT Declarations Browse List of declarations The declaration has been created but no values have been calculated yet Declaration and Statement Module Fat Client User Manual 1917 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa P59DECLV VAT Declarations Browse File Edit Preferences Row Window Help Reset
8. PS9DECL VAT Declarations Selection Setup Revision Reviewing an existing selection An existing selection is shown It consists of the header Configuration Name Table Name Calculated Field Period YTD Inception Balance For an existing selection all fields in the header can be changed except Configuration Name The records in the grid below the header are fields that create the selection Each line can be freely modified according to users needs The detailed process of adding a new selection was described in the paragraph 2 1 After reviewing and revising the current selection click the OK button to save changes and return to VAT Declaration Selection Setup Browse screen 2 3 Inquiring on an existing Selection By clicking the Find button on VAT Declaration Selection Setup Browse screen users can refresh and display the list of existing selections 2 4 Copying an existing Selection By clicking the Copy button on VAT Declaration Selection Setup Browse screen users can copy and modify an existing selection VAT Declaration Selection Setup Revision screen is opened Declaration and Statement Module Fat Client User Manual 1417 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa P oD CL TVi Dei laratio t Sele File Edit Preferences Window Help A Ww x SF Wu w Disp s OLE s Internet OK Find Del Can New Dis Abo Configuration Name cory Table Name Periods YT
9. Period Number 00001 BALANCES Account Balances BALBYCATCODE Balance by Category Code TEST1JCI Testi Jarka Deklaracja VAT 7 Deklaracja VAT 7 demo Demo Declaration Demo Declaration Figure 31 PS9DECLV VAT Declarations Browse Report Recalculate After selecting the Recalculate Report option from the Row menu a dialog box is opened Declaration and Statement Module Fat Client User Manual 24 z 2 7 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa E N E P59DECLV Report Output Destination Lew les File Edit Preferences Window Help IB x v x R OK Can Dis Abo Links w Disp s OLE 9 Internet Report Destination Output Stream Access OSA Interface Name To Printer C Exportto CSV Figure 32 PS9DECLV VAT Declarations Browse Report Recalculate Report Destination Confirm Report Destination by pressing OK The output record of current declaration values calculation is sent to the screen RS9DECLV Worldwide Company 26 07 2010 14 51 10 VAT Declaration Recalculate Values Page Declaration Name demo Effective Date 01 07 2008 Company 00001 Fiscal Year 10 Period Number 2 Declaration ID 0 Field Row Value Name Description F01 First LIne Heacer This is the first line of the declaration header F02 Second Line Header Year 2010 F03 Third Line Header Company 00001 F04 Net Value 6178 09 F05 Calculated Tax 7 863 51 Calculation time jac
10. by the following steps First it is necessary to create the lines of declaration for a given period and fiscal year based on the declaration setup In the second step users can calculate the values for each line also based on the declaration setup In the next step users may override values that are flagged as valid for adjustment The last step is the posting of the declaration This is done in the application PS9DECLV VAT Declarations Browse JP59DECLV VAT Declarations Browse amp File Edit Preferences Row Window Help v 8 x D G amp G d Select Find Add Del Close Seg New Dis Abo Row Reset values Declaration Name Period Number Recalcu Report Recalcu 00001 BALANCES Account Balances 00001 BALBYCATCODE Balance by Category Code Recreate B i TEST1JCI Testi Jarka Post i iDeklaracja VAT 7 Deklaracja VAT 7 00001 demo Demo Declaration Figure 19 PS9DECLV VAT Declarations Browse The records in the grid show existing declarations Records highlighted with green colour are marked as posted and therefore cannot be altered or deleted Navigation is done by standard JDE navigation buttons JP59DECLV VAT Declarations Browse File Edi Preferences Row Window Help Y 8 x 92 FSF S wR Select Find Add Del Close Seq New Dis Abo Figure 20 PS9DECLV VAT Declarations Browse Navigation buttons Declaration and Sta
11. dw Ww w Recal s Internet Find Add Close Seq New Dis Abo Company 00001 Fiscal Year Period No A EE Declaration Name demo Declaration Number B lv Show formula and format Declaration Frequency Monthly co Override alil Language Domestic Language First Line Header Overriden This is the first line of the dec 271071201 Second Line Header Year 2009 Calculated Year YEAR 27 07 201 Third Line Header Company 00001 Calculated Company CO j 27 07 201 Net Value 6178 09 Calculated SELECT PLRNETOT 271071201 Calculated Tax 796 863 51 Calculated i SELECT PLRVATOT 1 27 07 1201 Figure 28 PS9DECLV VAT Declaration Browse Values Overridden values After reviewing and revising the values on the declaration click the Close button on VAT Declarations Browse Values screen and finalize the declaration Declaration and Statement Module Fat Client User Manual 2217 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts After working with the declaration is completed and the values are correct the declaration must be posted Posted 3 4 Posting declarations declarations are highlighted with green colour and cannot be altered or deleted Reset values Recalculate Report Recalculate Recreate Fiscal Year Reset Post values Save to SD Period Number Recalcu Declaration Declaration Report Nam
12. the format starts with Y M or D and the type is date 11 the system will format the date based on the specified format Y 4 digits year M 2 digits month D 2 digits day all other characters are copied from the format so for example YYYY MM DD will be 2010 07 21 DD MM YYYY will be 21 07 2010 etc g Adj Allow if this parameter is set to 1 users may override the calculated value h Tab ID a unique number to identify a group of fields in the grid Additionally any number of supported languages translation may be added for the current field This is done by selecting the Translation Declaration and Statement Module Fat Client User Manual 6 z27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa File Edit Preferences Window Help Links w Displ 3 amp Can New Dis Abo Displ Internet Declaration Name aero Field Name Fo Effective Date o 107 206 Field Description irst LIne Header Figure 8 VAT Declarations Field Translations Current line for which the translation is prepared is shown in the header The language is selected from the grid and field translation is entered in the grid Any number of supported languages translation may be added for the current field Click the OK button to save the field translation and return to VAT Declarations Master Setup Revisions screen After populating all required fields on the declaration setup click the OK button to save the
13. values iF 8 K Links w Repor OLE Interi Recalculate se Seg New Dis Abo p 9 9 Report Recalculate Recreate Fiscal Year Reset Post values 4 SavetoSD Period Number Recalcu EA 00001 BALANCES Account Balances i 00001 BALBYCATCODE Balance by Category Code Recreate TEST1JCI Testi Jarka Deklaracja VAT 7 Deklaracja VAT 7 00001 demo Demo Declaration Demo Declaration Row exits Figure 25 PS9DECLV VAT Declarations Browse Row Menu Next users have several options to choose from the Row menu 1 Reset values this option resets all calculated values to blanks except the manually overridden values 2 Recalculate recalculates all values except the manually overridden values 3 Report Recalculate recalculates values and exports them to a report in a chosen format 4 Recreate rebuilds all records of declaration completely all overridden values are set to blank 5 Post posts created declaration 6 Save to SD copies data form JDE tables to supplemental database To calculate the values on the declaration choose the Recalculate option from the Row menu All values will be calculated based on the declaration setup Users are now able to review revise and post the declaration 3 3 Reviewing and overriding declaration values By clicking the Select button on VAT Declarations Browse screen users can review and modify an existing dec
14. 1 and used to retrieve transactions selections based on G L Cat Codes V59DECLP joined tables F0018 and F74P412H used for AP specific purposes selections based on Tax Liability Date V59DECLR joined tables F0018 and F74P3B1T used for AR specific purposes selections based on Tax Liability Date c Calculated Field a parameter that specifies which field will be accumulated for numeric fields or picked the first found for string char date d Period YTD Inception Balance this option needs to be checked if the user requires retrieving Account Balances When all fields in the header are filled properly the records in the grid need to be populated Declaration and Statement Module Fat Client User Manual 1217 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa File Edit Preferences Window Help Y A F x AS Links OK End Can New DIS w Disp OLE s Internet Configuration Mame 1 PNETO Table Name Period YTD Inception Balance Calculated Field Figure 15 PS9DECL VAT Declarations Selection Setup Revision Adding records in the grid a Condition this parameter defines the conditions in each line to be met in the selection the first row must have AND AND has higher priority than OR b Data Item a parameter indicating a field in the specified Table Name c Operator a parameter that specifies an operand used for Data Item and Value specified
15. 10 PS9DECL VAT Declaration Master Setup Revisions Copying an existing declaration All header information for the copied declaration need to be populated All information in the grid is copied from the previous declaration and may be freely modified by the user After populating all required field click the OK button to save the declaration 1 5 Deleting an existing declaration By clicking the Delete button on PS9DECL VAT Declarations Master Setup Browse users can delete an existing declaration setup 1 6 Close By clicking the Close button on P59DECL VAT Declarations Master Setup Browse users can close the current application and return to previous menu 1 7 Form By clicking the Form button on P59DECL VAT Declarations Master Setup Browse users can access the applications from the Form menu 1 8 Tools By clicking the Tools button on PB9DECL VAT Declarations Master Setup Browse users can access various tools in the JDE system i e data browser tool export tools grid formatting tools etc Declaration and Statement Module Fat Client User Manual 9 7 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts Selections are used by all commands intended to select data from the database SELECT PERIODBALANCE YTDBALANCE INCEPTIONTODATE 2 Selection setup PBb9DECL Created Selection may be used in the Calculation Formula entered in the declaration layout The pr
16. 7 Pb9DECL VAT DECLARATIONS MASTER SETUP REVISIONS ROW MENU cccscceccsscecceccssceeceeccsccseceecaeeseesecaeceeceecssesseeaesaeseseeeeaecaeeeeees 6 FIGURES VAT IDECIARATIONS FIELD TRANSLATIONS cicissione cane 7 FIGURE 9 Pb9DECL VAT DECLARATION MASTER SETUP REVISIONS REVIEWING AN EXISTING DECLARATION SETUP sccscceccssceceeccescesceecescesceseeaeees 8 FIGURE 10 PS9DECL VAT DECLARATION MASTER SETUP REVISIONS COPYING AN EXISTING DECLARATION 2ccesceeccscceccscceeccsccsccseceeceeceseeseaeceeeees 9 FIGURE 11 PS9DECL VAT DECLARATION MASTER SETUP BROWSE FORM MENU scceccsccsecesccsccssceecescceccsecseceeceececeecescescsseseseseecesesesaeceeenes 10 FIGURE 12 PS9DECL VAT DECLARATION SELECTION SETUP BROWSE siwsxpkensadiu deba pr unda ema Ras da duda eR dai ouv PSU On RP U rogo YF bx DER ERU IT PU 11 FIGURE 13 PS9DECL VAT DECLARATION SELECTION SETUP BROWSE NAVIGATION BUTTONS ceseseeeee nennen nnne nnn enses ses ea nasse sensere senis 11 FIGURE 14 PS9DECL VAT DECLARATION SELECTION SETUP REVISION ADDING A NEW 5 12 FIGURE 15 PS9DECL VAT DECLARATIONS SELECTION SETUP REVISION ADDING 5
17. B9DECLV VAT DECLARATIONS BROWSE REPORT RECALCULATE REPORT DESTINATION esses nennen nennen renis 25 FIGURE 33 PS59DECLV VAT DECLARATIONS BROWSE REPORT RECALCULATE RECALCULATE VALUES OUTPUT REPORT IN PDF 25 FIGURE 34 PSSDECLV VAT DECLARATION IN SUPPLEMENTAL 26 Declaration and Statement Module Fat Client User Manual 27 z2 27
18. D Inception Balance Calculated Field EQ AND VALUE IDEN MWST iDCTO VALUE Po PPP PP Figure 18 PS9DECL VAT Declarations Selection Setup Revision Copying an existing selection All header information for the copied selection need to be populated All information in the grid is copied from the previous selection and may be freely modified by the user After populating all required field click the OK button to save the selection and return to VAT Declaration Selection Setup Browse screen 2 5 Deleting an existing selection By clicking the Delete button on VAT Declaration Selection Setup Browse screen users can delete an existing selection 2 6 Close By clicking the Close button on VAT Declaration Selection Setup Browse screen users can close the current application and return to previous menu 2 7 Tools By clicking the Tools button on VAT Declaration Selection Setup Browse screen users can access various tools in the JDE system i e data browser tool export tools grid formatting tools etc Declaration and Statement Module Fat Client User Manual 15 z27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts After the setup is finished users can start creating a declaration for the given fiscal year and period 3 Working with declarations PS9DECLV The process of creating a declaration is covered
19. Figure 33 PS9DECLV VAT Declarations Browse Report Recalculate Recalculate Values Output Report in PDF 3 6 Save to SD Save to SD is used to copy the data from the Fb9DECL3 table to the Supplemental Database F00092 The reason for this is to be able to print the reports using BI Publisher After selecting the Save to SD option from the Row menu VAT Declaration in Supplemental Database screen is opened The header and details of the screen show which data have been extracted to the Supplemental Database F00092 Declaration and Statement Module Fat Client User Manual 25 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa i aration in Supplemental De File Edit Preferences Window Help x 8 iS d Rinke w Disp s OLE Internet Find Del Close Seq New Dis Abo Supplemental DB Code DECL Company 00001 Declaration Name demo Type Data A Num Key 1 1 Year Period ID 90200 ipis Key iid Remarks Hasc Line 2 B is the first line ofthe declaration header Year 2008 Company 00001 6178 09 863 51 Figure 34 PS9DECLV VAT Declaration in Supplemental Database Primary key fields of the F00092 are described below SDB DECL TYTD A SBN1 unique number for each export from P59DECLV similar to next number SBN2 0 SBA1 first 10 chars from Field Name SBA2 next 10 chars from field name MCU last 10 chars from field name can be up to 30 chars MCU should norma
20. JDExperts Sp z 0 0 Declaration and Statement Module Fat Client User Manual JD Edwards EnterpriseOne O9 Gxpert 2010 10 01 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa TABLE OF CONTENTS PREFA E H 2 1 Declaration Setup P 59D EC MEE 3 1 1 Adding 3 1 2 Reviewing an existing declaration SCTUP cscccccssseccceesecccccescceceusececeuseceseeucceseunecessuneceesenceeeeeneeeetes 7 1 3 Inquiring on an existing declaration SCCUP cccccssseccccssecccccesscceceesececeuseceseeecceseusececsuaecesseeceeesegeeeetes 8 1 4 Copying an existing declaration sehr ues ndis o UotA d c beru ca s xenon t eniti te bb kde prb Leu bote tbaslt 8 1 5 Deleting anexstinge Cle aa UO tae asd tc mo 9 1 6 Sr 9 1 7 O RE o 9 1 8 9 ES eine Se o se OE aoe E TE 10 2 1 Adding a new Selection s ccescssserscoussecccnsescueossueseucusssencussscnecuesectonsscneussressoussscneussscuseousrestenssseneees 11 2 2 Reviewing an existing Selection cccccccsssccccesececceeccceceeecceesesececeeneceeeeuseeseusecessusecessuaeeeesseuecetsunecss 14 2 3
21. Sales Tax Tax Authori PLRNETO F0018 Taxes Taxable PLRVATO7 F0018 Taxes STAI Amount Sales Tax Tax Authori Figure 12 PS9DECL VAT Declaration Selection Setup Browse Navigation is done by standard JDE navigation buttons File Edit Preferences Window Help v t 5 8Wg x R amp R Select Find Add Copy Del Close Seg New Dis Abo Figure 13 PS9DECL VAT Declaration Selection Setup Browse Navigation buttons 2 1 Adding a new Selection To add to a new Selection click the Add button on VAT Declaration Selection Setup Browse screen VAT Declaration Selection Setup Revision screen is opened Declaration and Statement Module Fat Client User Manual 117 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa v amp x 9 Ok Find Del Can New Dis Abo Configuration Name Table Name Periods YTD Inception Balance Calculated Field Figure 14 PS9DECL VAT Declaration Selection Setup Revision Adding a new Selection All values in the header need to be populated a Configuration Name a name to be used for current configuration selection b Table Name a JDE database table or business view from where the data will be selected A list of currently available views is listed below V59DECLB joined tables F0911 and F0902 used to retrieve account balances selections based on G L Cat Codes V59DECLG joined tables F091
22. anged in the header If the users check the Show formula Format checkbox it is possible to see the Calculation Formula and Format that was created in the declaration setup The records in the grid below show fields and values calculated based on the declaration setup If the users check the Show formula and format checkbox it is possible to see the Calculation Formula and Format that was created in the declaration setup It is possible to manually override calculated values on the declaration It is only valid for the fields that have the Adj Allow option set to 1 in the declaration setup The Override Allowed field indicates whether adjustment for current line is possible To override calculated values for the current line on the declaration select the line and choose Override value from the Row menu on VAT Declaration Browse Values screen Declaration and Statement Module Fat Client User Manual 2117 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa P59DECLV VAT Declaration Value Detail File Edit Preferences Window Help OK Can Dis Abo KS V Disp 9 Intemet Field Name Figure 27 PS9DECLV VAT Declaration Value Detail Overriding values Enter a new value for the overridden field and confirm by pressing OK button Overridden values are highlighted in yellow colour JP59DECLV VAT Declaration Browse Values Edit Preferences Row Window Help a x 5
23. declaration setup and return to VAT Declarations Master Setup Browse screen 1 2 Reviewing an existing declaration setup By clicking the Select button on PB9DECL VAT Declarations Master Setup Browse users can review and modify an existing declaration setup which is currently highlighted in the list of records VAT Declarations Master Setup Revisions screen is opened Declaration and Statement Module Fat Client User Manual 7 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa JP59DECL VAT Declarations Master Setup Revisions File Edi Preferences Row Window Help T v B e amp Links i OK Find Del Can New Dis Abo v Fieid SOLE B Internet Row Declaration Name BALANCES Description Account Balances pina M Effective Date 01 06 2005 Frequency Date Date Thru From ol i slo Assets Numeric 001 2000 i Declar Selection Be ae ar ES RENE DIETE IRA eR eM A EE RIE ee a E EA ban HORTUS Current Assets Numeric f 100 1200 1300 1400 1800 i Condition UDC Fetch Period YTD Balance Balance Inception Translat To Date ssesesssessosesesssstessessssessessesessstessesssssssecesesssstesesesesesssssssessetessesessessessesesss Liabilities and Equity Numeric Figure 9 PS9DECL VAT Declaration Master Setup Revisions Reviewing an existing declarati
24. e Description Recalcu BALANCES Account Balances B Balance by Category Code Recreate TEST1JCI Testi Jarka Deklaracja VAT 7 Deklaracja VAT 7 00001 dem 0 D emo Declaration Demo Declaration Figure 29 PS9DECLV VAT Declarations Browse Posting To post a declaration choose the Post option form the Row menu on VAT Declarations Browse screen Are you sure to Post this declaration This operation cannot be undone Figure 30 PS9DECLV VAT Declarations Browse Posting confirmation Confirm the posting in the Message box Posted declarations cannot be altered so if users need to make a correction afterwards a new declaration for the same period needs to be created It will have next available ID Only the last declaration ID is the valid one The process of adding a new declaration is described in the paragraph 3 1 3 5 Recalculate report Recalculate report is used to recalculate values on the declaration based on the declaration setup Declaration and Statement Module Fat Client User Manual 2317 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts Additionally an output in a form of report is submitted onto the screen Recalculate report is submitted from the Row menu of the on VAT Declarations Browse screen Select Find Add Del Close Seg New Dis Abo Company Fiscal Year Declaration Name
25. ield will be using It can be numeric text date etc Below is a list of valid values 1 Character 11 Date 15 Integer 17 Character Blob 18 Binary Blob 2 String 20 Variable String 55 JDEUTime 7 Identifier ID 9 Numeric Figure 6 PS9DECL VAT Declarations Master Setup Revisions Data Type list of values d Data Type Description a field populated automatically depending on the data type chosen e Calculation Formula a calculation formula for the current field on the declaration is entered here Depending on the data type various values may be used in conjunction with simple mathematical operations Below is a list of valid values 1 XX refers to another field in the same declaration where XX is Field Name 2 8XX refers to a field of declaration from a previous period 3 FROM THRU begin and end date of the period calculated automatically 4 EFFDATE date effective of the setup defined in header 5 TODAY today s date 6 PN FY YEAR period fiscal year 4 digits fiscal year 7 DECL Declaration description Declaration and Statement Module Fat Client User Manual 5 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts 8 ID Declaration ID zero based offered automatically 9 CO Company of the declaration 10 NAME SURNAME FIRSTNAME name of the current user NAME full name 11 SELECT
26. igation is done by standard JDE navigation buttons Fie Edit Preferences Form Window Help v 5 Wg x R amp R Select Find Add Copy Del Close Seq New Dis Abo Figure 2 PS9DECL VAT Declarations Master Setup Browse Navigation buttons 1 1 Adding a new declaration setup By clicking the Add button on P59DECL VAT Declarations Master Setup Browse users can create a new declaration setup VAT Declarations Master Setup Revisions screen is opened Declaration and Statement Module Fat Client User Manual 3 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa i NEC n Neclarations Master Setun R J File Edi Preferences Row Window Help Links OK Find Del Can New Dis Abo v Field sS OLE g Intemet Declaration Name Description Field Field Previous Date Date Thru Field Field Data Data Type Calculation Format Adj From Name Description Type Description Formula Allow Effective Date Frequency Declar Selection Condition UDC Fetch Period YTD Balance Balance inception Translat To Date Figure 3 PS9DECL VAT Declarations Master Setup Revisions Adding a new declarations setup First all field in the header need to be populated a Declaration Name a name for current declaration setup needs to be entered in this field This field is limited to 30 characters b Description additionally to the name a descri
27. laration setup which is currently highlighted in the list of records Declaration and Statement Module Fat Client User Manual 20 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa JP59DECLV VAT Declaration Browse Values File Edit Preferences Row Window Help Fr f Recalculate Value e ox Find Override Value aw Dis Abo Company 00001 Fiscal Year Period No c Declaration Name demo Declaration Number o Iv Show formula and format Declaration Frequency M Monthly Language Domestic Language Links w Recal 9 8 Internet First Line Header This is the first line of the declaration head Cale ulated Yes This is the first line of the dec 27 07 2010 Second Line Header Year 2009 Calculated j Year YEAR j j 27 07 2010 Third Line Header Company 00001 Calculated i Company CO 27 07 2010 Net Value 6178 09 Calculated SELECT PLRNETOTY 27 07 2010 Calculated Tax 796 863 51 Calculated SELECT PLRVATOT 1 27 07 2010 Row exits Figure 26 PS9DECLV VAT Declaration Browse Values Reviewing a revising an existing declaration An existing declaration is shown It consists of the header Company Declaration Name Fiscal Year Period No Declaration Number Declaration Frequency Language For an existing and unposted declaration Fiscal Year Period No and Declaration Number fields may be ch
28. lly be blank as we don t use that long texts KCO company of the declaration UKID incremented ID of records Value in fields RMK RMK2 RMK3 each 30 chars After reviewing values click the Close button return to the previous menu and work with declarations on P59DECLV VAT Declarations Browse Declaration and Statement Module Fat Client User Manual 26 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts LIST OF FIGURES FIGURE 1 Pb9DECL VAT DECLARATIONS MASTER SETUP eene nennen sen she she ea ee see see senses esses esa ea ea ee see sse ses essere seas 3 FIGURE 2 Pb9DECL VAT DECLARATIONS MASTER SETUP BROWSE NAVIGATION BUTTONS ssesseseeeee nennen nnne nnne sns sie sea sne sre ssa ea ease anna sean 3 FIGURE 3 Pb9DECL VAT DECLARATIONS MASTER SETUP REVISIONS ADDING A NEW DECLARATIONS SETUP sscssccsccecceccseccsccscceceeceecescesceecescees 4 FIGURE 4 PS9DECL VAT DECLARATIONS MASTER SETUP REVISIONS FREQUENCY LIST OF VALUES esses eene nnne nennen nennen nenne tense n tenter 4 FIGURE 5 Pb9DECL VAT DECLARATIONS MASTER SETUP REVISIONS ADDING RECORDS IN THE GRID esses enean sre rens 5 FIGURE 6 Pb9DECL VAT DECLARATIONS MASTER SETUP REVISIONS DATA TYPE LIST OF VALUES ccsccsccecceecceceeccseceeceeceeccecseesaessesseeaeeaeceeceeeees 5 FIGURE
29. ocess of creating a declaration layout is described in the paragraph 1 1 Users may access the Selection Setup Browse application from the Form menu as shown on the Figure 11 VAT Declaration Selection Setup Browse screen is opened The list of existing declarations is shown in the grid Select Find Add Copy Del Close Seq New Dis Abo Effective Date Selection Setup VAT i 01 01 2010 Deklaracja VAT 7 BALBYCATCODE 01 06 2005 Balance by Category Code 01 06 2005 Account Balances 01 07 2010 Declaration D1 01 01 2010 Test DMA 01 06 2010 My first declaration 01 07 2008 Demo Declaration 20 07 2010 Testi Jarka Form exits Figure 11 P59DECL VAT Declaration Master Setup Browse Form menu To configure new selection criteria user needs to setup a new Selection This is done in application P59DECL VAT Declaration Selection Setup Browse Declaration and Statement Module Fat Client User Manual 10 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa t OW x 8 Links w Displ 9 OLE Select Find Add Copy Del Close Seg New Dis Abo Configuration Name Table Name Calculated Field cere Name VS9DECLG VAT Declaration View of F09 AA Amount 8 Declaration Work Join of F0902 Account Balances ANOS Amount Net Posting 06 PLPNETO F018 Taxes Amount Taxable PLPVATO F 0018 Taxes STAI Amount
30. on setup An existing declaration setup is shown It consists of the header Declaration Name Description Effective date and Frequency For an existing declaration setup only the description field can be changed in the header The records in the grid below the header are fields that create the declaration setup One line per each field of the declaration setup needs to be created It is discussed in detail in the paragraph 1 1 Each line can be freely modified according to users needs 1 3 Inquiring on an existing declaration setup By clicking the Find button on P59DECL VAT Declarations Master Setup Browse users can refresh and display the list of existing declaration setups 1 4 Copying an existing declaration setup By clicking the Copy button on P59DECL VAT Declarations Master Setup Browse users can copy and modify an existing declaration setup VAT Declarations Master Setup Revisions screen is opened Declaration and Statement Module Fat Client User Manual 8 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa iG P Field S OLE 9 Internet OK Find Del Can New Dis Abo Declaration Name Description Demo Declaration Copy Field Field Effective Date 017061201 0 Frequency M Date Date Thru From Declar Selection Condition UDC SELECTPURVATOT 4 Fetch EE Period YTD Balance Balance Inception Translat To Date Figure
31. ption needs to be entered This field is limited to 30 characters c Effective Date a date when current declaration setup becomes effective d Frequency this parameter indicates how often a recurring declaration is generated Below is a list of valid values Annually Bi weekly Daily Monthly Monthly Last day of month Quarterly Semi monthly 1st and 15th Weekly noo Z E O DiE Figure 4 P59DECL VAT Declarations Master Setup Revisions Frequency list of values When all fields in the header are filled properly the records in the grid need to be populated Declaration and Statement Module Fat Client User Manual 4 z27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa Links T OK Find Del Can New Dis Abo v Field 01 a Internet Declaration Name igo Description rame Declaration Field Field m Previous Effective Date 7 2008 Frequency Mo Date Date Thru ee Data Type Calculation Adj From T deus vacent Formula Allow First Line Header k B Declar Selection E Condition UDC Fetch Period YTD Balance Balance Inception Translat Figure 5 PS9DECL VAT Declarations Master Setup Revisions Adding records in the grid a Field Name a name to distinguish the current field b Field Description a short description to describe the current field c Data Type a parameter that indicates the type of data that the current f
32. select name performs select from a table or view see details below 12 PERIODBALANCE select name period retrieves period balance from FO902 table for a specified period 13 YTDBALANCE se lect name period Year to date balance from F0902 table 14 INCEPTIONTODATE se lect name period Inception to date balance from FO902 15 UDC system code user def code value retrieves description from a UDC 16 IF condition value if true value if false Excel like IF condition All calculation formulas can be entered manually or from the Row menu Links w Field 3 OLE Intemet Field Previous Date From Date Thru demo Description Demo Declaration Field Field Declaration 01 07 2008 Frequency Previous Selection i Condition Date Date Thru UDC Fetch Field Data Data Type Calculation From l escription Formula Period Balance YTD Balance Declar Selection To Date NE j fures SELECTEERT Condition UDC Fetch Period YTD Balance Balance Inception Translat To Date Figure 7 PS9DECL VAT Declarations Master Setup Revisions Row menu f Format the parameter indicates how the current field output is displayed Below is a list of valid values 1 Rnn round to nn decimal places if nn omitted round to zero decimal places only for numeric 2 Znn adds zeros on left to the size of nn characters 3 Bnn adds blanks on left to the size of nn characters 4 YMD if
33. tement Module Fat Client User Manual 16 z 27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa O9 Gxperts First it is necessary to select a declaration setup that was prepared earlier and based on which the declaration will be created It is possible to select an existing declaration form the grid and add a declaration for the next period or to prepare a new declaration that is not yet on the list 3 1 Creating a new declaration t T x S Select Find Add Del Close Seq New Dis Abo Company Fiscal Year Reset values Declaration Name Period Number Recalcu Report Recalcu 00001 BALANCES Account Balances 00001 BALBYCATCODE Balance by Category Code Recreate gt TEST1JCI Testi Jarka iDeklaracja VAT 7 Deklaracja VAT 7 00001 demo Demo Declaration Figure 21 PS9DECLV VAT Declarations Browse Visual Assist In the application PS9DECLV VAT Declarations Browse go to the Declaration Name field in the header and press the Visual Assist button to open the list of all declaration setups Declaration and Statement Module Fat Client User Manual 17 z27 JDExperts Sp z o o ul Migdalowa 4 02 796 Warszawa i 5 ue cs Find Close Seq New Dis w Displ S OLE 9 Interet Account Balances j Balance by Category Code Declaration D1 My first declaration Test DMA Testi Jarka Deklaracja VAT 7 Demo Declaration
Download Pdf Manuals
Related Search