年底的这段时间,财务方面的case特别多。工单关闭的问题、集成交易的问题、盘点的问题、期间的问题等等等等。今天说一下ERP LN里面的这个session:Close Year – Provisional (tfgld6201m000),下面是来自官方的帮助问题。
<br/>Use this session to close a fiscal year provisionally. SSA ERP creates, provisionally:<br/>the closing balance of the current fiscal year<br/>the opening balance of next fiscal year<br/>The balance amounts from profit and loss accounts are accumulated to form the opening balance of the Retained Earnings account.<br/>Note<br/>During provisional year closing SSA ERP does not create or post transactions.<br/>
通过我的学习,我将通过问题的方式对这个Session做一个解释。
1、这个Session的作用究竟是什么呢? 这个Session把上年的年底的期末余额结转到当年的期初余额。 To transfer closing balance of current Fiscal Year to opening balance of next Fiscal Year. This program closes the current financial year provisionally, to determine the opening balances for the next financial year. Changes/adjustments can be made even after intermediate closing, unlike the year-end closing.
2、这里的Current Year怎么更新的? 当最终关闭掉ERP中的财务年度之后,当前财务年度将自动更新为已关闭的财务年度后的1年。 Current year field in provisional closing session is updated automatically after closing year procedure-Final Close. 3、这个Session究竟执行了哪些操作,涉及到的表有哪些? 操作的主要逻辑就是读取出Current Fiscal Year、Next Fiscal Year和Interim Account,然后执行clear.opening.balances.for.next.year()去清空Next Year的Opening Balances,接着连续执行:write.interim.acc.profit.and.loss.tfgld203、write.interim.acc.profit.and.loss.tfgld204、write.interim.acc.profit.and.loss.tfgld206,最后连续执行从历史记录中计算Closing Balances并更新到Current Fiscal Year的Opening Balances的函数:write.opening.bal.tfgld203()、write.opening.bal.tfgld204()、write.opening.bal.tfgld206()、write.opening.bal.tfgld223()、write.opening.bal.tfgld218、write.parent.opening.bal.tfgld203()、write.parent.opening.bal.tfgld204()
table ttccom000 |* Implemented Software Components (Companies) table ttccom112 |* Invoice-to Business Partners table ttccom122 |* Invoice-from Business Partners table ttccom500 |* Planning Board Groups table ttfacp005 |* Ledger Accounts by Supplier Group table ttfacr005 |* Ledger Accounts by Customer Group table ttfgld003 |* Group Company Parameters table ttfgld004 |* Financial Companies table ttfgld006 |* End Dates by Year table ttfgld007 |* Period Status table ttfgld008 |* Chart of Accounts table ttfgld010 |* Dimensions table ttfgld011 |* Transaction Types table ttfgld106 |* Finalized Transactions table ttfgld201 |* History – Ledger Account Totals table ttfgld202 |* History – Dimension/Ledger Account Totals table ttfgld203 |* Opening Balances – Ledger/Currency table ttfgld204 |* Opening Balances – Dimension/Ledger/Currency table ttfgld205 |* History – Dimension/Ledger Account Combination Totals table ttfgld206 |* Opening Balances – Combination of Dimension/Ledger/Currency table ttfgld218 |* Opening Balances – Cash Flow table ttfgld221 |* History – Ledger Account Totals by Business Partner table ttfgld223 |* Opening Balances – Ledger/Business Partner
越来越发现,这些文字是为我自己以后的工作做得一个简单的记录,不是写给读者的。下次我再记录一下Close Year的Session。