1 / 41

Customer focused. Results-driven. Moving your business to a new level.

DBSi 5.0 Accounting Integration. Customer focused. Results-driven. Moving your business to a new level. February 2011. DBS i 5.0 Accounting Integration Configuration. DBSi5.0 Landscape Company Code Document Type Entry Code Exchange Rate Submit Daily Jobs Menu Submit Monthly Jobs Menu.

dallasj
Download Presentation

Customer focused. Results-driven. Moving your business to a new level.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBSi 5.0 Accounting Integration Customer focused. Results-driven.Moving your business to a new level. February 2011

  2. DBSi 5.0 Accounting Integration Configuration • DBSi5.0 Landscape • Company Code • Document Type • Entry Code • Exchange Rate • Submit Daily Jobs Menu • Submit Monthly Jobs Menu

  3. DBSi 5.0 Finance Landscape

  4. DBSi 5.0 Company Configuration Define Defaults, Balances, Addresses, Fiscal Year, etc for each Company Financials Company Master Maintenance Assign Integration Parameters to Company MNTFNCOCD Company Integration 1000 D43CNVINT 1000 D43CNVINT

  5. DBS 2.3.4 Company Code Menu CODA V4, Option 01

  6. DBSi 5.0 Company Code Parameters (MNTFNCOCD)

  7. Company Master-CODA • Menu Path: Financials/Masters/Company

  8. DBSi 5.0 Currency Code Configuration Assign Home/Dual Currency/Company Master Financials Company Master Maintenance Create Currency Masters Financials Currency Master Maintenance Create Currency Code/Assign Default Currency Per Company MNTFNCURR Maintain Currency Code 1000 CAD to USD 02/19/2007 0.603290000 2000 USD to ARS 01/19/2007 .25 Default 1000 USD Y 1000 CAD 2000 ARS 2000 USD Y 1000- Home Currency USD 2000-Home Currency ARS

  9. DBSi 5.0 Maintain Currency Code (MNTFNCURR) Note: If Default is blank, it is treated as a “N”.

  10. Currency Master-CODA • Menu Path: Financials/Masters/Currency

  11. DBSi 5.0 Document Code Configuration Assign Document Code To System/ Program/ Transaction/Store MNTFNDTCR Document Type X Ref Create Document Masters Financials Company Document Master Maintenance Assign Document Types to Entry Codes MNTFNDIST Entry Code Distribution Assign Sequence Numbers to Document Types MNTFNDSEQ Sequence Numbers EC000 1 ** 500100.STNO…. EMTR R1020 1 ** 130650.STNO.CC32 ..SC33 P4301 1 ** 422300.STNO .....PS00 EMTR SALE SC33 SALE PS00 SALE EM EMC2810 A ..... EMTR EM EMC6601 M ..... EMTR IN EMC7600 CC .....SC33 IN PCC2291 PS .... PS00 EMTR 1 1 9999999 SC33 1 1 9999999 PS00 11 9999999

  12. DBS 2.3.4 Document Type Cross References Option 06

  13. DBSi 5.0 Document Type X Ref (MNTFNDTCR)

  14. DBS 2.3.4 Sequence Numbers CODA Option 14

  15. DBSi 5.0 Sequence Numbers(MNTFNDSEQ )

  16. Document Master -CODA • Menu Path: eFinance/Data Entry/Document Masters

  17. Document Master -CODA • Menu Path:eFinance/Data Entry/Document Masters

  18. Input Template Master-CODA • Menu Path: Financials/Data Entry/Input Template Masters

  19. User Exits-CODA • There are two user exits in CODA that have been set up to support interfacing of information from CODA to DBS. • NRPY • Supports the Notes Payment Interface • Validates Notes Contract, Payment Type (Installment, Late Charge, Payoff) • APEM • Supports EMS AP Cost Interface • Validates EMS ID, Tran Code, Include/Exclude from Book Value, Post To Current Life

  20. DBSi 5.0 Codes Tables System Code Maintenance (MNTFNSYCD)-No Change Program Number Maintenance (MNTFNPGNO)-No Change Transaction Code Maintenance (MNTFNTRCD)-No Change Transaction Indicator Maintenance (MNTFNTRIN)- No Change Document Type Cross Reference (MNTFNDTCR)-No Change Invoicing Entry Code Maintenance(MNTFNCREC)- No Change Document Sequence Number Maintenance(MNTFNDSEQ) )-No change. Division Code Maintenance (MNTFNDIV)-No change. Store Reporting Level Maintenance(MNTFNRLVL)-No Next Level Maintain Info Code-(MNTFNINFO)-New CHLD Info Code

  21. DBS 2.3.4 Tax Code Menu MNTINTAX

  22. DBSi 5.0Tax Code Menu MNTINTAX

  23. DBSi 5.0 Master Update Processing- Elements • There will be eight Elements instead of four. • Each Element will have a limit of 24 characters • It will be possible to concatenate a maximum of four info codes per element. • Element strings may not exceed 79 characters.

  24. DBSi 5.0 Master Update Processing- External References • There will be six External References instead of three. • External References will be 32 characters • External References will be assigned by entry code by sequence in DBS in option MNTFNDIST. • Document Prototypes in CODA V11.3 will determine whether or not External References will be allowed at the line item level for the document type in question.

  25. DBSi 5.0 Master Update Processing- Variables/Quantity Fields • Variables will not be available in DBSi 5.0. • New Quantity fields will be available. • Up to four Quantity fields could be assigned per sequence/element in the entry code. • All quantity fields need to be set up in CODA V11 as well as in DBS. • Quantity fields will contain numeric info codes

  26. DBSi 5.0 Master Update Processing- External TRGLs • External TRGL processing will allow for users to enter 8 elements and 6 external references. • If dealers would like to include Quantity field processing for external TRGLs, entry code will need to be entered for those TRGLs.

  27. DBSi 5.0 Entry Code Configuration Create Balance Codes/Quantities Financials Element Master Maintenance Create Entry Codes MNTFNDIST Entry Code Distribution Create Element Masters/Templates Financials Element Master Maintenance REGH-REGH A4042-151980.CUNO.CC02 External References: AGNO,ARCA Quantities: REGH Document Types: C***, P***, R***,S*** Element 1: 151980 Element 2:1000 Element 3: CC22 *If quantities are set up in core DBSi, they must be set up on the element in CODA * If external references are set up in core DBSi, they must be allowed on the document code in CODA

  28. DBS 2.3.4 Entry Code Distribution Menu CODA Option 11 – Screen 1

  29. DBSi 5.0Entry Code Distribution Menu MNTFNDIST – Screen 1

  30. DBS 2.3.4 Entry Code Distribution Menu CODA Option 11 – Screen 2

  31. DBSi 5.0Entry Code Distribution Menu MNTFNDIST – Screen 2

  32. DBSi 5.0Entry Code Distribution – F11 DBSi 5.0 DBS 2.3.4 Entry Code/Sequence Level Entry Code/Sequence Level

  33. Element Master-CODA • Menu Path: Financial/Masters/Element

  34. Balance Codes- CODA • Menu Path: Financials/Masters/Balance

  35. DBSi 5.0 Master Update • Master Update- Menus • Master Update- FI Batch Processing

  36. DBS 2.3.4 DailyMaster Update Menus CODA Option 30

  37. DBSi 5.0Master Update Menu DBS LSTFNDALY – Screen 1

  38. DBSi 5.0Master Update Menu LSTFNDALY – Screen 2

  39. DBS 2.3.4 MonthlyMaster Update Menu CODA Option 34

  40. DBSi 5.0Monthly Master Update Menu DBS LSTFNMONT

  41. Questions / Comments

More Related