求指点!之前没有用过财务软件,来这个公司的时候资产负债表的应收应付,预付预收公式是按科目余额填的,我想把它改成按明细余额填,这要怎么设置呢?
用金蝶的麻烦把公式发来参考下!先谢谢大家了!
还有就是如果现在把公式改过来之前那些报表会不会也被改呢?
我还是纳闷吧,不是说资产负债表上的应付是按应付明细科目贷方余额+预收明细借方余额填的吗,所以有以上的提问.我之前的是按应付的最后余额填的.麻烦再点点我这个不明白的人.
ä¾å¦éè¶K3ä¼è®¡ç§ç®1122-åºæ¶è´¦æ¬¾ï¼ä¸è®¾ææç»ç§ç®1122.01-å éå1122.02-å¤éï¼ä¸¤ä¸ªæç»ç§ç®é½æææ ¸ç®é¡¹ç®ç±»å«â客æ·âï¼æ¬æå¨æ»è´¦ä¸ç§ç®ä½é¢è¡¨çæ°æ®æ¾ç¤ºå¦å¾æ示ï¼
1ãéè¶K3ä¸ï¼å ¬å¼ACCT("1122","JY","",0,0,0,"")=1122-åºæ¶è´¦æ¬¾ç§ç®ä¸åæç»ç§ç®çåæ¹ææ«ä½é¢ä¹åï¼æç»ç§ç®ä¸1122.01-å éçææ«åæ¹ä½é¢10ï¼æä»¥å ¬å¼ACCT("1122","JY","",0,0,0,"")=10
2ãéè¶K3ä¸ï¼å ¬å¼ACCT("1122","DY","",0,0,0,"")=1122-åºæ¶è´¦æ¬¾ç§ç®ä¸åæç»ç§ç®çææ«è´·æ¹ä½é¢ä¹åï¼æç»ç§ç®ä¸1122.02-å¤éçææ«è´·æ¹ä½é¢50ï¼æä»¥å ¬å¼ACCT("1122","DY","",0,0,0,"")=50ã
3ãéè¶K3ä¸ï¼å ¬å¼ACCT("1122|客æ·|","JY","",0,0,0,"")=1122-åºæ¶è´¦æ¬¾ç§ç®ä¸åä¸ªæ ¸ç®é¡¹ç®å®¢æ·çææ«åæ¹ä½é¢ä¹åï¼åç §å¾-2ï¼ã
客æ·A å¨æç»ç§ç®1122.01-å éä¸çææ«åæ¹ä½é¢æ¯60ï¼å¨æç»ç§ç®1122.02-å¤éä¸çææ«è´·æ¹ä½é¢æ¯30ï¼åè´·ç¸æµï¼å®¢æ·A çææ«åæ¹ä½é¢ä¸º30ãæä»¥å ¬å¼ACCT("1122|客æ·|","JY","",0,0,0,"")=客æ·A çææ«åæ¹ä½é¢30 +客æ·C çææ«åæ¹ä½é¢80ï¼å³å ¬å¼ACCT("1122|客æ·|","JY","",0,0,0,"")=110ã
4ãéè¶K3ä¸ï¼å ¬å¼ACCT("1122.01:1122.02","JY","",0,0,0,"")=ACCT("1122.01","JY","",0,0,0,"")+ACCT("1122.02","JY","",0,0,0,"")ã
5ãéè¶K3ä¸ï¼å ¬å¼ACCT("1122.01:1122.02","DY","",0,0,0,"")=ACCT("1122.01","DY","",0,0,0,"")+ACCT("1122.02","DY","",0,0,0,"")ã
6ãéè¶K3ä¸ï¼å ¬å¼ACCT("1122.01:1122.02| 客æ·|","JY","",0,0,0,"")=ACCT("1122.01| 客æ·|","JY","",0,0,0,"") +ACCT("1122.02| 客æ·|","JY","",0,0,0,"") ï¼åç §å¾-2ï¼ã
å¨æç»ç§ç®1122.01-å
éä¸ï¼å®¢æ·Aææ«åæ¹ä½é¢ä¸º60ãå¨æç»ç§ç®1122.02-å¤éä¸ï¼å®¢æ·C ææ«åæ¹ä½é¢ä¸º80ãæ以ACCT("1122.01:1122.02|客æ·|","JY","",0,0,0,"")=60+80=140ã
7ãACCT("1122.01:1122.02| 客æ·|","DY","",0,0,0,"") 表示为ACCT("1122.01| 客æ·|","DY","",0,0,0,"") +ACCT("1122.02| 客æ·|","DY","",0,0,0,"") ä¹åï¼åç §å¾-2ï¼ã
å¨æç»ç§ç®1122.01-å éä¸ï¼å®¢æ·Bææ«è´·æ¹ä½é¢ä¸º50ãå¨æç»ç§ç®1122.02-å¤éä¸ï¼å®¢æ·A ææ«åæ¹ä½é¢ä¸º30ã客æ·D ææ«è´·æ¹ä½é¢ä¸º100ï¼æ以ACCT("1122.01:1122.02|客æ·|","JY","",0,0,0,"")=50+30+100=180ã
æ©å±èµæï¼
éè¶K3æ¥è¡¨åæ°å ¬å¼è¯¦è§£
C表示æåä½é¢ã
JC表示åæ¹æåä½é¢ã
DC表示贷æ¹æåä½é¢ã
AC表示æåç»å¯¹ä½é¢ã
Yææ«ä½é¢ã
JY表示åæ¹ææ«ä½é¢ã
DY表示贷æ¹ææ«ä½é¢ã
AY表示ææ«ç»å¯¹ä½é¢ã
JF表示åæ¹åçé¢ã
DF表示贷æ¹åçé¢ã
JL表示åæ¹æ¬å¹´ç´¯è®¡åçé¢ã
DL表示贷æ¹æ¬å¹´ç´¯è®¡åçé¢ã
SY表示æçæ¬æå®é åçé¢ã
åèèµæï¼ç¾åº¦æåº-éè¶K3æ¥è¡¨åæ°å
¬å¼è¯¦è§£