国产精品影视在线观看_正在播放国产精品_精品久久国产_黄色日本视频_人人天天操_精品无码久久久久国产

網站首頁 會計課程 授課老師 會計實操 會計考證 名師解答 會計資訊 關于我們

怎么查看會計分錄表

2023-02-18 10:06:44深圳會計培訓

  kj.yyrjxz.com 小編在本篇文章中要講解的會計分錄知識是有關會計分錄怎么查看數據和會計分錄信息的內容,詳細請大家根據目錄進行查閱。

  1、金蝶軟件,去年的會計分錄序時賬簿怎么查找。

2、oracle怎樣從ap發票查會計分錄

3、如何從用友中導出憑證,就是可以看到借貸方科目的會計分錄

4、在金蝶軟件里 怎么查看以前月份的賬務處理

5、如何引出會計分錄序時簿

點擊“憑證——憑證查詢——會計分錄序時薄——在第一個選擇框里選擇“會計期間"——選擇需要的月份。這樣打開就能找到要的所有憑證。

  --1.發票創建時生成數據如下表

  --發票主表

  SELECT * FROM AP_INVOICES_ALL A WHERE A.INVOICE_NUM = '20111213001';

  --發票分配表

  SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL B WHERE B.INVOICE_ID = 697444;

  --發票付款計劃表

  SELECT * FROM AP_PAYMENT_SCHEDULES_ALL C WHERE C.INVOICE_ID = 697444; --From ap_invoices_all.invoice_id

  --2.發票驗證并創建會計科目時產生的數據如下表

  --發票驗證時產生的數據

  SELECT *

  FROM AP_ACCOUNTING_EVENTS_ALL D

  WHERE D.SOURCE_ID = 697444

  AND D.SOURCE_TABLE = 'AP_INVOICES'; --From ap_invoices_all.invoice_id

  --發票創建會計科目時產生的分錄

  SELECT * FROM AP_AE_HEADERS_ALL E WHERE E.ACCOUNTING_EVENT_ID = 1093101; --From AP_ACCOUNTING_EVENTS_ALL.souce_id = invoice_id

  SELECT * FROM AP_AE_LINES_ALL G WHERE G.AE_HEADER_ID = 1088969;

  --3.發票分錄查詢(SOURCE_TABLE欄位分別是AP_INVOICE_DISTRIBUTIONS和AP_INVOICES,代表發票的分錄和發票分配的分錄)

  SELECT AAL.SOURCE_TABLE

  ,AAL.*

  FROM AP_INVOICES_ALL AIA

  ,AP_ACCOUNTING_EVENTS_ALL AAE

  ,AP_AE_HEADERS_ALL AAH

  ,AP_AE_LINES_ALL AAL

  WHERE AIA.INVOICE_NUM = '20111213001'

  AND AIA.INVOICE_ID = AAE.SOURCE_ID

  AND AAE.SOURCE_TABLE = 'AP_INVOICES'

  AND AAH.ACCOUNTING_EVENT_ID = AAE.ACCOUNTING_EVENT_ID

  AND AAH.AE_HEADER_ID = AAL.AE_HEADER_ID;

  --4.發票付款時產生的數據如下表

  SELECT * FROM AP_INVOICE_PAYMENTS_ALL F WHERE F.INVOICE_ID = 697444;

  --CHECK_ID From AP_INVOICE_PAYMENTS_ALL

  SELECT * FROM AP_CHECKS_ALL H WHERE H.CHECK_ID = 2357756; --CHECK_ID From AP_INVOICE_PAYMENTS_ALL.CHECK_ID

  --ACCOUNTING_EVENT_ID From AP_INVOICE_PAYMENTS_ALL.ACCOUNTING_EVENT_ID

  SELECT *

  FROM AP_ACCOUNTING_EVENTS_ALL D

  WHERE D.ACCOUNTING_EVENT_ID = 1086193; --ACCOUNTING_EVENT_ID From AP_INVOICE_PAYMENTS_ALL.ACCOUNTING_EVENT_ID

  --5.付款分錄查詢

  SELECT AAL.*

  FROM AP_CHECKS_ALL ACA

  ,AP_ACCOUNTING_EVENTS_ALL AAE

  -- ,AP_INVOICE_PAYMENTS_ALL AIP

  ,AP_AE_HEADERS_ALL AAH

  ,AP_AE_LINES_ALL AAL

  WHERE ACA.CHECK_ID = AAE.SOURCE_ID

  AND AAE.SOURCE_TABLE = 'AP_CHECKS'

  AND AAE.ACCOUNTING_EVENT_ID = AAH.ACCOUNTING_EVENT_ID

  AND AAH.AE_HEADER_ID = AAL.AE_HEADER_ID

  -- AND AAL.SOURCE_ID = AIP.INVOICE_PAYMENT_ID--負債科目

  --AND AAL.SOURCE_ID = ACA.CHECK_ID--現金科目

  AND AAH.ACCOUNTING_DATE = TO_DATE('20110907'

  ,'yyyymmdd')

  AND AAH.ACCOUNTING_DATE TO_DATE('20110908'

  ,'yyyymmdd')

  AND AAH.GL_TRANSFER_FLAG = 'Y'

  AND AAH.ORG_ID = 236;

  --6. 發票核銷預付款發票的金額

  SELECT AID1.ROWID ROW_ID

  ,AID1.INVOICE_ID INVOICE_ID

  ,AID1.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID

  ,AID1.PREPAY_DISTRIBUTION_ID PREPAY_DISTRIBUTION_ID

  ,AID1.DISTRIBUTION_LINE_NUMBER PREPAY_DIST_NUMBER

  ,(-1) * AID1.AMOUNT PREPAY_AMOUNT_APPLIED

  ,NVL(AID2.PREPAY_AMOUNT_REMAINING

  ,AID2.AMOUNT) PREPAY_AMOUNT_REMAINING

  ,AID1.DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID

  ,AID1.ACCOUNTING_DATE ACCOUNTING_DATE

  ,AID1.PERIOD_NAME PERIOD_NAME

  ,AID1.SET_OF_BOOKS_ID SET_OF_BOOKS_ID

  ,AID1.DESCRIPTION DESCRIPTION

  ,AID1.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID

  ,AID1.RCV_TRANSACTION_ID RCV_TRANSACTION_ID

  ,AID1.ORG_ID ORG_ID

  ,AI.INVOICE_NUM PREPAY_NUMBER

  ,AI.VENDOR_ID VENDOR_ID

  ,AI.VENDOR_SITE_ID VENDOR_SITE_ID

  ,ATC.TAX_ID TAX_ID

  ,ATC.NAME TAX_CODE

  FROM AP_INVOICES_ALL AI

  ,AP_INVOICE_DISTRIBUTIONS_ALL AID1

  ,AP_INVOICE_DISTRIBUTIONS_ALL AID2

  ,AP_TAX_CODES ATC

  WHERE AID1.PREPAY_DISTRIBUTION_ID = AID2.INVOICE_DISTRIBUTION_ID

  AND AI.INVOICE_ID = AID2.INVOICE_ID

  AND AID1.AMOUNT 0

  AND NVL(AID1.REVERSAL_FLAG

  ,'N') != 'Y'

  AND AID1.TAX_CODE_ID = ATC.TAX_ID(+)

  AND AID1.LINE_TYPE_LOOKUP_CODE = 'PREPAY'

  AND AID1.INVOICE_ID = 676404; --發票ID

  --6. 預付款發票核銷發票的金額

  SELECT AID1.ROWID ROW_ID

  ,AID1.INVOICE_ID INVOICE_ID

  ,AID1.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID

  ,AID1.PREPAY_DISTRIBUTION_ID PREPAY_DISTRIBUTION_ID

  ,AID2.DISTRIBUTION_LINE_NUMBER PREPAY_DIST_NUMBER

  ,(-1) * AID1.AMOUNT PREPAY_AMOUNT_APPLIED

  ,AID1.DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID

  ,AID1.ACCOUNTING_DATE ACCOUNTING_DATE

  ,AID1.PERIOD_NAME PERIOD_NAME

  ,AID1.SET_OF_BOOKS_ID SET_OF_BOOKS_ID

  ,AID1.DESCRIPTION DESCRIPTION

  ,AID1.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID

  ,AID1.RCV_TRANSACTION_ID RCV_TRANSACTION_ID

  ,AID1.ORG_ID ORG_ID

  ,AI.INVOICE_NUM INVOICE_NUM

  ,AI.VENDOR_ID VENDOR_ID

  ,AI.VENDOR_SITE_ID VENDOR_SITE_ID

  ,ATC.TAX_ID TAX_ID

  ,ATC.NAME TAX_CODE

  ,AID2.INVOICE_ID PREPAY_ID

  FROM AP_INVOICES_ALL AI

  ,AP_INVOICE_DISTRIBUTIONS_ALL AID1

  ,AP_INVOICE_DISTRIBUTIONS_ALL AID2

  ,AP_TAX_CODES ATC

  WHERE AID1.PREPAY_DISTRIBUTION_ID = AID2.INVOICE_DISTRIBUTION_ID

  AND AI.INVOICE_ID = AID1.INVOICE_ID

  AND AID1.AMOUNT 0

  AND NVL(AID1.REVERSAL_FLAG

  ,'N') != 'Y'

  AND AID2.TAX_CODE_ID = ATC.TAX_ID(+)

  AND AID1.LINE_TYPE_LOOKUP_CODE = 'PREPAY'

  AND AID2.INVOICE_ID = 676444 --預付款發票ID

  AND AI.INVOICE_TYPE_LOOKUP_CODE NOT IN

  ('PREPAYMENT'

  ,'CREDIT'

  ,'DEBIT');

  --發票是否被驗證的腳本

  /*BEGIN

  fnd_client_info.set_org_context(236);

  END;*/

  SELECT AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID

  ,AI.INVOICE_AMOUNT

  ,AI.PAYMENT_STATUS_FLAG

  ,AI.INVOICE_TYPE_LOOKUP_CODE) --發票是否已驗證,已驗證的狀態為APPROVED

  ,AI.*

  FROM AP_INVOICES_ALL AI

  WHERE AI.INVOICE_NUM IN ('2011110888'

  ,'20111202001');

  --應付發票及付款日記賬分錄追溯

  --日記賬分錄

  SELECT AAL.*

  ,GJL.*

  FROM AP_AE_HEADERS_ALL AAH

  ,AP_AE_LINES_ALL AAL

  ,GL_JE_HEADERS GJH

  ,GL_JE_LINES GJL

  WHERE AAH.AE_HEADER_ID = AAL.AE_HEADER_ID

  AND GJH.JE_HEADER_ID = GJL.JE_HEADER_ID

  AND GJL.GL_SL_LINK_ID = AAL.GL_SL_LINK_ID

  AND GJH.JE_SOURCE = 'Payables'

  AND GJH.PERIOD_NAME = 'Dec-11'

  AND AAH.AE_HEADER_ID = 1097269;

  --發票匹配接收時與接收的關聯關系

  SELECT A.RCV_TRANSACTION_ID--rcv_transactions.transaction_id

  ,A.PO_DISTRIBUTION_ID

  ,A.*

  FROM AP_INVOICE_DISTRIBUTIONS_ALL A
希望本篇文章能夠對正準備參加

廣州會計培訓

, 的小伙伴們有所幫助。想要了解更多

惠州會計培訓

、

東莞會計培訓

、

深圳會計培訓考試

、 相關知識記得關注學樂佳會計培訓官網。最后祝愿小伙伴們考試成功!
主站蜘蛛池模板: 久久久久久国产精品免费无码 | 福利三区 | 国产精品精品国产一区二区 | 911亚洲精品国内自产 | 日韩在线高清视频 | 蜜芽亚洲av无码精品色午夜 | 欧美大狠狠大臿蕉香蕉大视频 | 精品国产自在现线看 | 国内精品久久久久久影院 | 久久精品国产亚洲av蜜臀色欲 | 亚洲国产tv | 中文字幕乱码人妻一区二区三区 | 热99re久久精品精品免费 | 一级特黄aaa大片大全 | 国产精品18久久久久网站 | 亚洲综合色视频在线观看 | 特级黄色免费片 | 精品久久久久久无码人妻 | 亚洲av日韩av高潮潮喷无码 | 久久久久免费精品国产小说 | 日本高清视频在线播放 | 婷婷在线综合 | 久久不射电影 | 国产丝袜在线视频 | 久久久综合网 | 欧美亚洲啪啪 | 日韩国产欧美精品综合二区 | 亚洲欧洲无码一区二区三区 | 国产精品原创视频 | 欧美日韩在线国产 | 四虎影院在线观看 | 欧美艳星nikki激情办公室 | 免费无码不卡视频在线观看 | 狠狠精品干练久久久无码中文字幕 | 精品视频二区 | 国产成人亚洲精品老王 | 两口子交换真实刺激高潮 | 日韩欧美高清一区 | 亚洲av日韩av永久无码下载 | 国产农村妇女毛片精品久久 | 日产精品久久久久久久性色 |