What is the difference of PO Charge Account,PO Accrual Account and PO Variance Account

在Oracle ERP云里,PO行分配里面有三个账户如下

对库存物料

1,PO借记账户是放最后接收入库后的借方账户,分录一般是

原材料/材料采购 (inventory/receiving inspection),就是这个原材料的账户

2,先说PO应计账户,这个是放接收PO时的贷方账户,是一个中间账户,在接收还没有放入库存时的一个中间账户

一般接收时的分录是:材料采购/暂估应付账款 (receiving inspection/ap accrual)

3,PO差异账户

采购和匹配发票的差异账户

匹配PO后的分录是:暂估应付账款/应付账款(receiving inspection/ap)

这样,1,2,3连续执行下来,中间账户会对冲掉,只剩下  原材料/应付账款

PO Charge Account: the account to charge for the cost of this item in the purchasing business unit.

   The charge account in your PO distributions will be used as the Debit account during your PO Delivery process.Normally it will be a Material account in case Inventory Item and expense account in case of expense items.

PO Accrual Account: the payables accrual account in the purchasing business unit.

   This is the account used by Purchasing to accrue your payable liability when you receive your items. This account represents your uninvoiced receipts and is usually part of your accounts payable liabilities in the balance sheet. Payables relieves this account when the invoice is matched and approved.

PO Variance Account: the invoice price variance account in the purchasing business unit.

   Invoice price variance is the difference between the purchase order price for an inventory item and the actual invoice price multiplied by the quantity invoiced. Purchasing uses this account on the PO distribution when the purchase order is created.

In addition, The PO Variance Account will consider the same account as PO Charge Account in case if you creating Expense type document.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
以hive的角度检查语法: with cur_dim_comb as (SELECT DISTINCT t.dim_comb ,t.var_sub_class ,t.acc_value FROM gerp.cux_cst_data_alloc_his t WHERE t.top_var_type = '10' AND t.job_ver_id in (SELECT ver.job_ver_id AS p_job_ver_id FROM gerp.cux_cst_dist_jobs_all job INNER JOIN gerp.cux_cst_dist_jobs_vers_all ver ON job.job_id = ver.job_id )) select tp.bd_code --事业部编码 ,tp.bd_name --事业部名称 ,hp.ou_code --OU名称 ,hp.ou_name --OU编码 ,op.main_class_desc --差异大类 ,op.acc_value --科目代码 ,op.acc_desc --科目名称 ,op.dim_comb --区分维度 ,op.begin_amount --期初余额 ,op.accrual_amount --本期发生 ,op.balance_diff_alloc_amount --期末差异结存 ,op.var_sub_class ,op.main_class_value ,op.org_id ,op.period_name ,op.job_ver_id from (select up.* ,q1.* from (SELECT DISTINCT maincl.* ,t.* FROM t inner join (SELECT fv.flex_value ,fv.description FROM fv inner join fs on fv.flex_value_set_id = fs.flex_value_set_id AND fs.flex_value_set_name = 'CUX_CST_VARIANCE_TYPE' AND fv.enabled_flag = 'Y' AND fv.hierarchy_level = '2' AND fv.flex_value LIKE '10%' ) maincl on t.var_main_class = maincl.flex_value inner join cur_dim_comb on cur_dim_comb.var_sub_class = t.var_sub_class and cur_dim_comb.acc_value = t.acc_value WHERE 1 = 1 AND t.top_var_type = '10' AND t.job_ver_id in (SELECT ver.job_ver_id AS p_job_ver_id FROM gerp.cux_cst_dist_jobs_all job INNER JOIN gerp.cux_cst_dist_jobs_vers_all ver ON job.job_id = ver.job_id) ORDER BY maincl.description ,t.acc_value ,cur_dim_comb.dim_comb ) up inner join (SELECT t1.* ,SUM(t1.begin_amount) begin_amount ,SUM(t1.accrual_amount) accrual_amount ,SUM(t1.balance_diff_alloc_amount) balance_diff_alloc_amount FROM gerp.cux_cst_data_alloc_his t1 LEFT JOIN gerp.cux_cst_data_alloc_his t ON t1.top_var_type = '10' AND t1.var_sub_class = t.var_sub_class --p_var_sub_class AND t1.org_id = t.org_id --p_org_id AND t1.period_name = t.period_name --p_period_name AND t1.job_ver_id = t.job_ver_id --p_job_ver_id AND t1.acc_value = t.acc_value --p_acc_value WHERE t1.dim_comb in (select distinct dim_comb from cur_dim_comb) group by t1.org_id,t1.period_name,t1.job_ver_id,t1.var_sub_class,t1.acc_value ) q1 on q1.org_id = up.org_id --p_org_id AND q1.period_name = up.period_name --p_period_name AND q1.job_ver_id = up.job_ver_id --p_job_ver_id AND q1.var_sub_class = up.var_sub_class --p_var_sub_class AND q1.acc_value = up.acc_value --p_acc_value ) op
最新发布
05-26
从 Hive 的角度来检查语法,以下是您提供的 SQL 查询语句: ``` with cur_dim_comb as ( SELECT DISTINCT t.dim_comb, t.var_sub_class, t.acc_value FROM gerp.cux_cst_data_alloc_his t WHERE t.top_var_type = '10' AND t.job_ver_id in ( SELECT ver.job_ver_id AS p_job_ver_id FROM gerp.cux_cst_dist_jobs_all job INNER JOIN gerp.cux_cst_dist_jobs_vers_all ver ON job.job_id = ver.job_id ) ) select tp.bd_code, --事业部编码 tp.bd_name, --事业部名称 hp.ou_code, --OU名称 hp.ou_name, --OU编码 op.main_class_desc, --差异大类 op.acc_value, --科目代码 op.acc_desc, --科目名称 op.dim_comb, --区分维度 op.begin_amount, --期初余额 op.accrual_amount, --本期发生 op.balance_diff_alloc_amount, --期末差异结存 op.var_sub_class, op.main_class_value, op.org_id, op.period_name, op.job_ver_id from ( select up.*, q1.* from ( SELECT DISTINCT maincl.*, t.* FROM t inner join ( SELECT fv.flex_value, fv.description FROM fv inner join fs on fv.flex_value_set_id = fs.flex_value_set_id AND fs.flex_value_set_name = 'CUX_CST_VARIANCE_TYPE' AND fv.enabled_flag = 'Y' AND fv.hierarchy_level = '2' AND fv.flex_value LIKE '10%' ) maincl on t.var_main_class = maincl.flex_value inner join cur_dim_comb on cur_dim_comb.var_sub_class = t.var_sub_class and cur_dim_comb.acc_value = t.acc_value WHERE 1 = 1 AND t.top_var_type = '10' AND t.job_ver_id in ( SELECT ver.job_ver_id AS p_job_ver_id FROM gerp.cux_cst_dist_jobs_all job INNER JOIN gerp.cux_cst_dist_jobs_vers_all ver ON job.job_id = ver.job_id ) ORDER BY maincl.description, t.acc_value, cur_dim_comb.dim_comb ) up inner join ( SELECT t1.*, SUM(t1.begin_amount) begin_amount, SUM(t1.accrual_amount) accrual_amount, SUM(t1.balance_diff_alloc_amount) balance_diff_alloc_amount FROM gerp.cux_cst_data_alloc_his t1 LEFT JOIN gerp.cux_cst_data_alloc_his t ON t1.top_var_type = '10' AND t1.var_sub_class = t.var_sub_class --p_var_sub_class AND t1.org_id = t.org_id --p_org_id AND t1.period_name = t.period_name --p_period_name AND t1.job_ver_id = t.job_ver_id --p_job_ver_id AND t1.acc_value = t.acc_value --p_acc_value WHERE t1.dim_comb in (select distinct dim_comb from cur_dim_comb) group by t1.org_id, t1.period_name, t1.job_ver_id, t1.var_sub_class, t1.acc_value ) q1 on q1.org_id = up.org_id --p_org_id AND q1.period_name = up.period_name --p_period_name AND q1.job_ver_id = up.job_ver_id --p_job_ver_id AND q1.var_sub_class = up.var_sub_class --p_var_sub_class AND q1.acc_value = up.acc_value --p_acc_value ) op ``` 从语法角度来看,该查询语句是有效的。但是,如果您想要确保语句完全符合您的预期,请先测试该语句在您的环境中的执行结果。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值