易飞ERP总账期初开账试算不平衡

1、易飞ERP总账期初开账试算不平衡问题:2010-10月份要进行【期初开账】，已将2010-09-30的数据已经整理好，录 入数据已经完毕，但是点击“试算平衡”，显示:试算结果不平衡，该如何处理,附:原始科U余额表（在易飞中没有,是财务给予一个手工EXCEL表作为参考）3NJU末余極酬ii细号贫方贫方Otl10C>00108(100谀行冇苦0坏秋人昆3S3O03M00OC2O26)0065000&性应妆帙枕10M00ioaoo0421110C30010G0O6lii?住乔商品560005C000<601旧龙竟产2OC3OQ200000检2黑计抄旧01QOOO010060赍产4

2、'it：6500010000650001MOO121040000040000长期信社0iaooo01090C仇皈1、计06QOOO050000伽400004MOO加1153OC-3O3QCOO曲IL30090aooo30COO40300生产威苓至半生产感苓5040050000成小计：500005000051G1主g业竟牧人10CD0iaooo53C-1警业外仪人0C30iaooo55&25&D05000籬小计30000300003+13OC5O130000-IOOCOO1OM40100辭徉帯i利巨口K1GO202科目貞外币孕USD切S公烦知000

3、,汇即力£6,慎口才币幻65CO 门皆眉收WSfc科目糸肩月了捋算氐目I齐户I冃屮咅鏡询划为I毎户h 3006審户2i TWO51们主S?业务枚心启团5W项旨.SfHi SinuOCO, KH 27000members from key minority outreach, promote a comprehensive strictly administering the party into the branches, put it into every party member, give full play to each party organization fight f

4、ortress function, each the exemplary vanguard role of party members Is to promote the inner-party education extend from the concentrated education to regular education, in the regular education efforts, real party ideology in the all party members and the party s construction through system Is to bo

5、ost the spirit of all party members, education guide all members of the party in their respective work positions, responsible and dependable officer, make contributions Therefore, we must from the height of political and global, fully aware of "two" learning the importance of education, pu

6、t "two" education as a major political task and practice wel1. All members to active participation, really into, in ，zlearn, and do, and modified, and promoting'' upper and lower really Kung Fu, effective put thought and action unified to XI General Secretary of important indicates

7、 spirit up, unified to Central and provincial of decision deployment up, solid do learning education the work, effective do good accountability, caught in place, see effectiveness, condensed up officer venture, and promoted water the work of powerful power Second, accurately grasp the "two"

8、; educational focus Marxist positions, knowing that good talk show a strong belief in pursuit, history as spirit, sincere feelings for the people, pragmatic style of thinking, enhance the scientific level of the work, and to better promote our work.In terms of learning methods, units of the party or

9、ganization, the partybranch in accordance with the implementation plan, organization members planned and subtopics to learn to combine步骤一:程序逻辑及处理思路1. “试算平衡”的逻辑是什么，如果期初余额借方（本币） > 期初余额贷方（本币）或者本年累计借方（本币） > 本年累计贷方（本币）成立，那么试算结果不平衡2. 根据“试算平衡”的逻辑，查找差异的数据前得知了期初余额借方本币、期初余额贷方本币、本年累计借方、本年累计 贷方的总金额;接下来，只要

10、将实际开账输入的明细科LI及对应金额，与实际账务 的报表信息进行对比，就可以知晓期初开账的作业中是哪些数据录入错误或者漏录 入。步骤二:查出差异数据1、本例的情况（如下图）：期初余额借方（本币）期初余额贷方（本币），只需要分析期初数据即可，不需要分析累讣金额,6片500.oo48300.00 J56,000. 0050, OOT.0Oos70, DD»«(K)成*s.uoo. oo5. OOfr.OO0. OD0.0001, 500. 0030, DOT.CQ no,w»4(jo2、借助SQL语句得出借贷类的明细金额，从而来对比明细信息：（借:1贷:-1）SELE

11、CT LC002 AS 会计科 U, LC004 AS 借/贷,LC015 AS 金额国结果由消息会计科目借金额11502j -110000.0022121140000.0032301-110000.0043131-140000.005314115130000.0061001110000.00710020113500.0081131110000.0091211110000.0010124315000.00111501120000.001241010115000.00FROM ACTLC LEFT JOIN ACTMA ON MA001二LC002WHERE MA008 IN ('2&#

12、39;,' 3') and MA010二'Y'AND LC01500 /条件为:末级科口、科目有效、金额不为0贷方ORDER BY LC004,LC002其中从右侧的图示中，可以看出其借方和贷方金额分别是山哪些明细科LI组成以及开帐输入的金额借方 members from key minority outreach, promote a comprehensive strictly administering the party into the branches, put it into every party member, give full play t

13、o each party organization fight fortress function, each the exemplary vanguard role of party members Is to promote the inner-party education extend from the concentrated education to regular education, in the regular education efforts, real party ideology in the all party members and the party s con

14、struction through system Is to boost the spirit of all party members, education guide all members of the party in their respective work positions, responsible and dependable officer, make contributions Therefore, we must from the height of political and global, fully aware of "two" learnin

15、g the importance of education, put "two" education as a major political task and practice wel1. All members to active participation, really into, in learn, and do, and modified, and promoting" upper and lower really Kung Fu, effective put thought and action unified to XI General Secre

16、tary of important indicates spirit up, unified to Central and provincial of decision deployment up, solid do learning education the work, effective do good accountability, caught in place, see effectiveness, condensed up officer venture, and promoted water the work of powerful power Second, accurate

17、ly grasp the "two" educational focus Marxist positions, knowing that good talk show a strong belief in pursuit, history as spirit, sincere feelings for the people, pragmatic style of thinking, enhance the scientific level of the work, and to better promote our work. In terms of learning me

18、thods, units of the party organization, the party branch in accordance with the implementation plan, organization members planned and subtopics to learn to combine总 账期初 开账试 算不平 衡的处 理方法3、此时要对比其明细的金额，看差异在哪里，把财务原始的科H余额表放在一起对比一下5方老日<2为仝检r1:«3ac010011北刁心庶禺ft 4人工013021)11iHMifit'；仏QH311inm1000

19、0012-11ioioac讼3500001243I5000*15012庐兀艾产 S-t.TIF2MOO00 WOOO1501 时ur11290005UUU注产小计：65咖1<HHX)65500羽曲丸憑0n4DOOC4 TldlUI1502HZ-1仝殺130IJOCHu01UUUUIM*51314DOOO?i?1-1湎02301-1忖OM4DOOO3纳-I4(10002i(rrn 威本小11:生产龙生产50ftfl 50&00 03U11613<W)SW53a舟tr顶2賓地洌It momid&OAO问题:(1) 100202科LI财务给予的参考数据是存在的，但在【期初

20、开帐】却不存在;(2) 314115科U财务的原始报表中是余额方向是借方，而【期初开账】却是贷余;步骤三:解决措施针对问题进行逐一修改:1. 100202启用外币核算，但是没有输入对应美元金额;选择对应的币种-美元，将期初余额正确维护:弓8卩we m： aiE7E1Tfiii.iwjj币 iJiiiJjWnf >2计虫方ssnf 滋和空孩ti刁目修正为:2.314115未分配利润科LI是贷余(科U信息中定义)，但是实际余额是借余，因此期初开账members from key minority outreach, promote a comprehensive strictly admin

21、istering the party into the branches, put it into eve 第 3 页共 5 页 ry party member, give full play to each party organization fight fortress function, each the exemplary vanguard role of party members Is to promote the inner-party education extend from the concentrated education to regular education,

22、in the regular education efforts, real party ideology in the all party members and the party's construction through system. Is to boost the spirit of all party members, education guide all members of the party in their respective work positions, responsible and dependable officer, make contribut

23、ions Therefore, we must from the height of political and global, fully aware of "two" learning the importance of education, put "two" education as a major political task and practice wel1. All members to active participation, really into, in ，zlearn, and do, and modified, and pro

24、moting'' upper and lower really Kung Fu, effective put thought and action unified to XI General Secretary of important indicates spirit up, unified to Central and provincial of decision deployment up, solid do learning education the work, effective do good accountability, caught in place, se

25、e effectiveness, condensed up officer venture, and promoted water the work of powerful power Second, accurately grasp the "two" educational focus Marxist positions, knowing that good talk show a strong belief in pursuit, history as spirit, sincere feelings for the people, pragmatic style o

26、f thinking, enhance the scientific level of the work, and to better promote our work In terms of learning methods, units ofthe party organization, the party branch in accordance with the implementation plan, organization members planned and subtopics to learn to combine时需要输入负数金额，应该为-30000:原:冏IQ阳nlf

27、|人层壬 ZJ iC¥:科8滴R0050C00CMkiiCftcmWfl 制f Ti0 ID)50 (Tr wSU51S芳93为何30.0W 0)3 COO.CCI St, »修正为:对上述的错误需要重新的进行修改，修改完毕后，再次试算平衡，其结果如下图所示:nfi科仄矣 31IW1UW氏面iKJii丽无丐*-t乔*:7：. Z00.W?ozo:o.o:X . II LIB： 7Z.!ill.ll II.II ?ozo:a.o:馆烁代电：h-. IIILIH*MI II.IIC：. ：0&.W沁竝0：戶"gl：t ZOCLWtozu:(i.o?s. HZS

28、JLJI.II；0.0：IE1inW W MJ斗*4 - in no啦:卜"j UPE j "3 I"理1Z?C0 v试算平衡以后，此时就可以结束开账了，期初开账完毕members from key minority outreach, promote a comprehensive strictly administering the party into the branches, put it into every party member, give full play to each party organization fight fortress f

29、unction, each the exemplary vanguard role of party members Is to promote the inner-party education extend from the concentrated education to regular education, in the regular education efforts, real party ideology in the all party members and the party s construction through system. Is to boost the

30、spirit of all party members, education guide all members of the party in their respective work positions, responsible and dependable officer, make contributions Therefore, we must from the height of political and global, fully aware of "two" learning the importance of education, put "

31、two" education as a major political task and practice wel1. All members to active participation, really into, in learn, and do, and modified, and promoting upper and lower really Kung Fu, effective put thought and action unified to XI General Secretary of important indicates spirit up, unified

32、to Central and provincial of decision deployment up, solid do learning education the work, effective do good accountability, caught in place, see effectiveness, condensed up officer venture, and promoted water the work of powerful power Second, accurately grasp the "two" educational focus

33、Marxist positions, knowing that good talk show a strong belief in pursuit, history as spirit, sincere feelings for the people, pragmatic style of thinking, enhance the scientific level of the work, and to better promote our work. In terms of learning methods, units of the party organization, the par

34、ty branch in accordance with the implementation plan, organization members planned and subtopics to learn to combine总 账期初 开账试 算不平 衡的处 理方法补充：一般情况下，都是财务人员进行【期初开帐】，这个时候为了快速查询数据， 可以借助SQL语句来做实现。（财务人员可请资讯人员进行协助，或者让资讯人员 做一个自定义报表来实现均可）如果无法借助SQL查询明细，则可以使用期初开账作业的汇出功能，将数据汇 出EXCEL表（直接汇出路径在:ConductorC_Data用户名文件夹

35、中，也可以在汇 出时直接打开EXCEL表进行另存为其他路径）。这时导出的Excel表是所有科LI 的，包含科目金额为零的，以及一级科目总额，查看不太方便，可以对Excel表进 行整理后在对比。非损益类科LI对比期初余额原币，损益类科LI则需要对比累讣借 方原币、累讣贷方原币，但是都需要注意借贷方向。members from key minority outreach, promote a comprehensive strictly administering the party into the branches, put it into eve 第 5 页共 5 页 ry party me

36、mber, give full play to each party organization fight fortress function, each the exemplary vanguard role of party members Is to promote the inner-party education extend from the concentrated education to regular education, in the regular education efforts, real party ideology in the all party members and the partyJ s construction through system Is to boost the spirit of all party members, education guide all members of the party in their respective work positions, re