sap特别总账科目调账
时间: 2023-12-27 13:01:15 浏览: 29
SAP特别总账科目调账是指在SAP系统中针对特殊的总账科目进行调整和平衡的过程。在企业日常的财务管理中,可能会出现一些特殊的总账科目需要进行调整,例如坏账准备、营业税、利息等特殊科目。这些特别总账科目需要根据实际情况进行核算和调整,以确保财务数据的准确性和合规性。
在SAP系统中,特别总账科目调账需要经过严格的流程和规定。首先,财务人员需要对需要调整的特别总账科目进行核对和分析,确定调整的原因和金额。然后根据公司的财务政策和SAP系统的规定,填写相应的调整凭证,并经过核准流程。在填写凭证时,必须正确选择特别总账科目的代码和性质,以确保调账的准确性和规范性。
接下来,财务人员需要在SAP系统中进行调账凭证的录入和过账,并进行相应的审核和审批。在过账后,系统会自动更新特别总账科目的余额和账务信息。最后,财务人员需要对调账结果进行核对和复核,确保调账的准确性和完整性。
总的来说,SAP特别总账科目调账是一个严格规范、流程复杂的财务管理工作。只有严格遵守公司和系统规定,确保凭证的准确和合规性,才能保证特别总账科目调账的准确性和有效性。
相关问题
调账审批流 发起 上传附件 保存到单独的oss空间 ,获取预览token 移动端能预览这个excel文件
1. 调账审批流发起人打开调账审批流页面,并选择需要调账的账户和金额,填写调账说明等信息。
2. 在页面上点击上传附件按钮,选择需要上传的Excel文件。
3. 系统将该Excel文件保存到单独的OSS空间中,并返回一个预览token。
4. 将该预览token传递给移动端客户端,供客户端使用。
5. 移动端客户端可以使用该预览token来预览该Excel文件,以便审批人员了解调账详情。
insert table cdata_safe_income_new_day_analysis_item_status with t1 as ( select if(a.app_id is null,b.app_id,a.app_id) as app_id, if(a.product is null,b.product,a.product) as product, if(a.item_code_name is null,b.item_code_name,a.item_code_name) as item_code_name, case when a.app_id is null and (if(a.tiaozhang_cnt is null,0,a.tiaozhang_cnt) + if(b.tiaozhang_cnt is null,0,b.tiaozhang_cnt)) > 0 then '调账影响' when b.app_id is null and (if(a.tiaozhang_cnt is null,0,a.tiaozhang_cnt) + if(b.tiaozhang_cnt is null,0,b.tiaozhang_cnt)) > 0 then '调账影响' when a.app_id is null and (if(a.tuifei_cnt is null,0,a.tuifei_cnt) + if(b.tuifei_cnt is null,0,b.tuifei_cnt)) > 0 then '退费影响' when b.app_id is null and (if(a.tuifei_cnt is null,0,a.tuifei_cnt) + if(b.tuifei_cnt is null,0,b.tuifei_cnt)) > 0 then '退费影响' when a.app_id is null and c.voucher_begin > 0 then '优惠券影响' --- 原:续费使用了代金券 when a.app_id is null and c.voucher_end > 0 and change_order_cnt = 0 then '优惠券影响' --- 原:续费使用了代金券 when b.app_id is null and c.voucher_begin > 0 then '优惠券影响' --- 原:续费由代金券转为正常 when b.app_id is null and c.voucher_end > 0 and change_order_cnt = 0 then '优惠券影响' --- 原:续费由代金券转为正常 else 'item维度正常' end flag_status from (select app_id, product,item_code_name,sum(if(paymode_type = '调账',1,0)) as tiaozhang_cnt, sum(if(instr(paymode,'退费')>0,1,0)) as tuifei_cnt from cdata_safe_income_new_day where ftime = '${YYYYMMDD}' and paymode != '0元订单' and prod_class1_name = '基础安全' and prod_class2_name = '云原生安全' and product is not null and pay_type = '公有云' group by app_id,product,item_code_name ) a full join
cdata_safe_income_new_day_analysis_item_status 表中插入数据的SQL语句是:
```sql
insert table cdata_safe_income_new_day_analysis_item_status
with t1 as (
select if(a.app_id is null,b.app_id,a.app_id) as app_id,
if(a.product is null,b.product,a.product) as product,
if(a.item_code_name is null,b.item_code_name,a.item_code_name) as item_code_name,
case
when a.app_id is null and (if(a.tiaozhang_cnt is null,0,a.tiaozhang_cnt) + if(b.tiaozhang_cnt is null,0,b.tiaozhang_cnt)) > 0 then '调账影响'
when b.app_id is null and (if(a.tiaozhang_cnt is null,0,a.tiaozhang_cnt) + if(b.tiaozhang_cnt is null,0,b.tiaozhang_cnt)) > 0 then '调账影响'
when a.app_id is null and (if(a.tuifei_cnt is null,0,a.tuifei_cnt) + if(b.tuifei_cnt is null,0,b.tuifei_cnt)) > 0 then '退费影响'
when b.app_id is null and (if(a.tuifei_cnt is null,0,a.tuifei_cnt) + if(b.tuifei_cnt is null,0,b.tuifei_cnt)) > 0 then '退费影响'
when a.app_id is null and c.voucher_begin > 0 then '优惠券影响'
when a.app_id is null and c.voucher_end > 0 and change_order_cnt = 0 then '优惠券影响'
when b.app_id is null and c.voucher_begin > 0 then '优惠券影响'
when b.app_id is null and c.voucher_end > 0 and change_order_cnt = 0 then '优惠券影响'
else 'item维度正常'
end flag_status
from (
select app_id,
product,
item_code_name,
sum(if(paymode_type = '调账',1,0)) as tiaozhang_cnt,
sum(if(instr(paymode,'退费')>0,1,0)) as tuifei_cnt
from cdata_safe_income_new_day
where ftime = '${YYYYMMDD}'
and paymode != '0元订单'
and prod_class1_name = '基础安全'
and prod_class2_name = '云原生安全'
and product is not null
and pay_type = '公有云'
group by app_id,product,item_code_name
) a
full join <表名> b on <条件>
)
select * from t1;
```
其中 `<表名>` 和 `<条件>` 表示需要进行全连接的另外一个表的表名和连接条件。请在实际使用时将其替换为正确的表名和条件。