- 博客(7)
- 收藏
- 关注
RSS订阅转载 GMF_RCV_ACCOUNTING_TXNS
In case of OPM Organization, R12, there will not be any entry in rcv_receiving_subledger for PO receipt.Instead the same data is available in gmf_rcv_accounting_txns where the linking column to...
2016-06-02 11:58:00
201
转载 发运例外报表
月初释放销售订单时出现延交的情况，查看库存显示有货品，信贷没有暂挂，查看发运报表出现下图的提示。不单单只有这张订单不能释放订单，关于整个IO的销售订单都能释放。最终查询出来的原因是这个月的库存期间没有打开，等财务结账完成后才能打开本月期间。转载于:https://www.cnblogs.com/CarryLi7938/p/5549605.html...
2016-06-01 14:53:00
164
转载 AR 追溯
SELECT ROW_NUMBER() OVER (PARTITION BY OU.OU_CODE,RCT.TRX_NUMBER ORDER BY XAL.CODE_COMBINATION_ID) LINE_NUMBER,OU.OU_CODE,OU.OU_NAME,SOB.CURRENCY_CODE,RBS.NAME BATCH_SOURCE_NAME,RB.NAME BATCH_NAM...
2016-05-24 17:31:00
132
转载 日记帐类别
设置 >>日记账 >>类别 ((N) >> Setup >> Journal >> Categories)SELECT * FROM GL_JE_CATEGORIES 转载于:https://www.cnblogs.com/CarryLi7938/p/5519286.html...
2016-05-23 11:25:00
181
转载 GL 汇率
--GL_DAILY_RATES_VSELECT primary.from_currency, primary.to_currency, primary.conversion_date, ct.user_conversion_type, ROUND(primary.conversion_rate,18), ROUND(secondary.conver...
2016-05-23 11:12:00
147
转载 集值
路径:设置 >> 财务系统 >> 弹性域 >> 关键字 >> 值 (>>Setup >> Financials >> Flexfields >> Key >> Values) 1 SELECT ffvs.flex_value_set_id ,--集值 2 ffv...
2016-05-23 10:14:00
152
转载 测试连接
//Create the Connection object string connectionString = WebConfigurationManager.ConnectionStrings["Northwind"].ConnectionString; SqlConnection con = new SqlConnection(c...
2016-02-20 11:37:00
143
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人