410 likes | 426 Views
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.
E N D
DBSi 5.0 Accounting Integration Customer focused. Results-driven.Moving your business to a new level. February 2011
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
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
DBS 2.3.4 Company Code Menu CODA V4, Option 01
Company Master-CODA • Menu Path: Financials/Masters/Company
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
DBSi 5.0 Maintain Currency Code (MNTFNCURR) Note: If Default is blank, it is treated as a “N”.
Currency Master-CODA • Menu Path: Financials/Masters/Currency
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
DBS 2.3.4 Document Type Cross References Option 06
DBS 2.3.4 Sequence Numbers CODA Option 14
Document Master -CODA • Menu Path: eFinance/Data Entry/Document Masters
Document Master -CODA • Menu Path:eFinance/Data Entry/Document Masters
Input Template Master-CODA • Menu Path: Financials/Data Entry/Input Template Masters
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
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
DBS 2.3.4 Tax Code Menu MNTINTAX
DBSi 5.0Tax Code Menu MNTINTAX
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.
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.
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
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.
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
DBS 2.3.4 Entry Code Distribution Menu CODA Option 11 – Screen 1
DBSi 5.0Entry Code Distribution Menu MNTFNDIST – Screen 1
DBS 2.3.4 Entry Code Distribution Menu CODA Option 11 – Screen 2
DBSi 5.0Entry Code Distribution Menu MNTFNDIST – Screen 2
DBSi 5.0Entry Code Distribution – F11 DBSi 5.0 DBS 2.3.4 Entry Code/Sequence Level Entry Code/Sequence Level
Element Master-CODA • Menu Path: Financial/Masters/Element
Balance Codes- CODA • Menu Path: Financials/Masters/Balance
DBSi 5.0 Master Update • Master Update- Menus • Master Update- FI Batch Processing
DBS 2.3.4 DailyMaster Update Menus CODA Option 30
DBSi 5.0Master Update Menu DBS LSTFNDALY – Screen 1
DBSi 5.0Master Update Menu LSTFNDALY – Screen 2
DBS 2.3.4 MonthlyMaster Update Menu CODA Option 34
DBSi 5.0Monthly Master Update Menu DBS LSTFNMONT