微软官方教材财务Financial II

1、microsoft business solutions axapta 3.0 financial series ii microsoft axapta 3.0 financial series ii agenda financials ii agenda budgeting cash flow management multi-currency advanced payments audit trail intercompany accounting financials ii agenda (cont.) consolidated accounting financial statemen

2、ts collection letters and interest month-end run via axapta: gl reports transactions periodic financial statement view budget balances debit bank) later when an invoice is to be settled with this prepayment, the amount is transferred from the deposit a/c to ar a/c; then offsetting ar a/c against the

3、 invoice (e.g. dr deposit a/c, cr ar; dr ar, cr sales) microsoft axapta 3.0 financial series ii intercompany accounting intercompany accounting setup for ledger transactions between 2 companies intercompany accounting a/c e.g. “due to” (credit) and “due from” (debit) suggest to setup another journal

4、 name (type = “daily”) especially for intercompany transactions, so that by the voucher number user could distinguish these transactions from the other normal transactions within the company microsoft axapta 3.0 financial series ii consolidation consolidation initial setup first create a special com

5、pany account for “consolidation” reporting (no direct posting to this company account) in consolidation company account specify the company is a consolidation company consolidation initial setup create consolidate chart of accounts in consolidation company axapta: gl chart of accounts consolidation

6、initial setup in subsidiary company accounts, iin subsidiary company accounts, if the account is different from consolidation account, specify consolidation account of the selected account consolidation processing processing axapta: gl periodic consolidate consolidation, on-line (if the consolidatio

7、n company account is not in the same database of the subsidiary company, first use axapta: gl periodic consolidate “export” from the subsidiary company; then in consolidation company use axapta: gl periodic consolidate “import” specify range of accounts, date of transactions, whether to include budg

8、et models for consolidation specify % of shares from the company you would like to consolidate transactions are transferred in the subsidiarys default currency consolidation processing “exchange adjustment”: if selected, revaluation will first be performed before converting to consolidation reportin

9、g companys functional currency with the rate effective at “to date” will be used; if not selected, the rate effective at transaction will be used and hence no exchange adjustment is performed (only effective for those subsidiary ledger account with “monetary” enabled) subsidiary company has enabled

10、“monetary” = use with “exchange adjustment” when consolidation (as above explanation) and perform exchange adjustment for subsidiary before consolidation when consolidation, convert from subsidiary to consolidation companys functional currency, always use “fixed rate” when consolidation, unless 0.00

11、 is specified at monetary or non-monetary rates (no effect no whether account in consolidation company is monetary or not), then use effective rate at exchange conversion table amount in transactional currency amount in subsidiary currency amount in consolidation company currency consolidation requi

12、re to perform up-to-date revaluation b4 consolidation? - if yes, enable the ledger account “monetary” setup in sub coa - also enable “exchange adjustment” when running consolidation use monetary rate or non-monetary rate? determine by “monetary” checkbox in consolidation company coa; if no rate defi

13、ned, use rate in currency table consolidation processing example: -subsidiary (default eur) transaction = cad100 (=eur65 at tranx time) -subsidiary exchange rate on mar 15; eur40 = 100cad; -consol. (default usd); mon exchange rate (eur to usd): eur100= usd500; non-monetary rate: eur100 = usd101; eff

14、ective rate in currency table: eur100=usd86.8961 -carry out consolidation to mar 15 -conclusion -if monetary / non-monetary rate(s) is defined, the system will look at the related currencys monetary setup (whether rates for monetary and non-monetary accounts are defined); the system will look at the

15、 exchange table only when the monetary or non-monetary = zero rate -when “exchange adjustment” is selected in consolidation prompt screen, the system will perform exchange adjustment of original transactions currency to subsidiarys currency for those accounted selected “monetary” exchange adj in sub

16、sidiarys coa (so eur40 is retrieved instead of eur65 when it is selected) -note -exchange gain occurs for usd25 when eur40 is used for reporting to consolidation monetary checkbox in ledger account s: n c: n s: c: s: c: n s: n c: select “exchange adjustment” when consolidation (carry out exchange ad

17、j for subsidiary tranx before consolidation) n and has rate in monetary eur65 = usd65.65 eur65 = usd325.00 eur65 = usd65.65 eur65 = usd325.00 and has rateeur65 = usd65.65 eur40 = usd200.00 eur40 = usd40.4 eur65 = usd325.00 n and zero rateeur65 = usd56.48 eur65 = usd56.48 eur65 = usd56.48 eur65 = usd

18、56.48 and zero rateeur65 = usd56.48 eur40 = usd34.76 eur40 = usd34.76 eur65 = usd56.48 consolidation processing example microsoft axapta 3.0 financial series ii financial statement financial statement - setup financial statement row axapta: gl setup financial statement rows (name) financial statemen

19、t column axapta: gl setup financial statement sales report q1 balance q2 balance difference sales sales parts13,800.0015,000.00-1,200.00 sales watch234,000.00200,000.0034,000.00 sales bands52,000.0090,000.00-38,000.00 sales maintenance62,000.0020,000.0042,000.00 sales others2,500.0010,000.00-7,500.0

20、0 total sales364,300.00335,000.0029,300.00 financial statement row financial statement (=column) financial statement - setup financial statement row -define accounts to be displayed on the report -may create manually, or use “insert accounts” function to copy from chart of accounts financial stateme

21、nt - setup specify the alignment and display of each accounts figures (can be default from chart of accounts or specified in here) financial statement - setup financial statement (i.e. “column”) -define columns of figures to be displayed and specify which financial statement row is included printing

22、 financial statement run via axapta: gl reports transactions periodic financial statement may specify to print new page by dimension(s), or breakdown by a dimension printing financial statement example microsoft axapta 3.0 financial series ii collection letter if late for another 14 days, send anoth

23、er letter with warning; etc) might incur fee together with collection letter (e.g. as administration charge for issuing the letter, or as “penalty”) collection letter - setup define text on collection letter axapta: ar setup forms form note collection letter - setup setup collection letter sequence

24、axapta: ar setup forms form note for # of letters to be sent within certain late timeframe below example: -collection letter 1 is created 1 day after invoice due date; it must be printed and posted before the 2nd letter will be created -collection letter 2 is created only if another 3 days is overdu

25、e from the 1st letter creation date collection letter - setup setup whether “posting” of collection letter is considered as “confirmed” axapta: ar setup parameters (so according to collection letter sequence if next timeframe is due the next letter will be generated) collection letter - setup collec

26、tion letter - setup attach which collection letter sequence apply to invoice by its posting profile axapta: ar setup posting profiles collection letter processing create collection letter axapta: ar periodic interest and collection letter creation of collection letter collection letter processing pr

27、inting and posting collection letter axapta: ar periodic interest and collection letter collection letter note collection letter processing collection letter processing must print the letter before posting in order to update collection letter as “confirmed”, it must be “posted” (no matter it include

28、s fee or not) collection letter processing interest note generate interest charge for any late payment and overdue invoices might setup to generate interest charge for customer interest note - setup interest note code: define monthly interest rate, minimum amount to generate interest, how often it is calculated, any extra fee incur in the interest note, days of grace for generating interest after due date, ledger account for interest received, etc axapta: ar setup interest and collection letter interest note below examp