业务单据审核或者弃审报负库存错误的处理

by 吴运刚 2012.1.11 17:43

注:脚本执行有风险,对于客户正式环境请在研发指导下执行。

业务单据审核或者弃审核报负库存处理

U9 业务字段非常比,而作为存货数量管理的纬度字段也有40来个,为效率和处理的方面,在查询或者更新时,统一采用业务主键BizKey(通过业务主键按一定顺序组合在一起,然后用一定算加密)匹配。

存货数量对于企业管理来说是非常严格的,需要按各纬度去匹配数量,当不允许负库存时,进行超额出库时,就会报负库存提示。

当出现此错误时,处理步骤如下:

 

 

SQL1:

exec P_InvTrans_TransLineBin_BizKeyRebuild '','在这里录入物料ID,多个物料用,号分开'

exec P_InvTrans_WhQohRebuild  '','在这里录入物料ID,多个物料用,号分开'

 

 

评论 (11) -

zhanggangb1 wrote at 2012/1/17 16:50:10 #

看不懂啊看不懂。

Nissan X-Trail Mobil SUV Tangguh dan Sporty Terbaik 美国 wrote at 2016/3/27 13:45:19 #

Howdy would you mind letting me know which web host you're utilizing? I've loaded your blog in 3 completely different web browsers and I must say this blog loads a lot faster then most. Can you recommend a good web hosting provider at a reasonable price? Thanks a lot, I appreciate it!

dishwasher at home depot 美国 wrote at 2016/4/25 6:42:33 #

At this time it looks like BlogEngine is the preferred blogging platform available right now. (from what I've read) Is that what you're using on your blog?

งานราชการ wrote at 2019/7/18 15:59:45 #

You are very good at that.

https://www.guide-sob.com/

Zeus Male Enhancement Reviews 美国 wrote at 2020/2/11 20:01:52 #

What i do not understood is in fact how you're now not actually much more well-appreciated than you might be now. You're so intelligent. You recognize thus significantly on the subject of this matter, produced me individually imagine it from so many varied angles. Its like women and men are not fascinated except it's one thing to accomplish with Lady gaga! Your personal stuffs nice. All the time deal with it up!  Look into my website:  Zeus Male Enhancement Reviews - www.freecarbootsale.co.uk/.../

http://lanceeperfector.org/ 美国 wrote at 2020/2/12 9:34:44 #

Howdy! This is kind of off topic but I need some advice from an established blog. Is it difficult to set up your own blog? I'm not very techincal but I can figure things out pretty fast. I'm thinking about creating my own but I'm not sure where to start. Do you have any points or suggestions? Appreciate it  Review my page;  http://lanceeperfector.org/ - https://twibler.com/user/profile/6419

Fat Loss And creating Supplements 美国 wrote at 2020/2/13 12:29:52 #

Please let me know if you're looking for a author for your weblog. You have some really good articles  Fat Loss And creating Supplements - forums.dimensionbucket.com/index.php  I think I would be a good asset. If you ever want to take some of the load off, I'd really like to write some articles for your blog in exchange for a link back to mine. Please send me an e-mail if interested. Thank you!

21 Flat Belly Fix Reviews 美国 wrote at 2020/2/15 14:52:36 #

This is the right blog for anybody who wants to find out about this topic. You know so much its almost hard to argue with you (not that I actually will need to...HaHa). You definitely put a brand new spin on a topic that's been discussed for many years. Excellent stuff, just wonderful!  My website ::  21 Flat Belly Fix Reviews - www7a.biglobe.ne.jp/.../fantasy.cgi

To buy a professional deep fryer 美国 wrote at 2020/2/20 9:03:25 #

Hi there! I just wanted to ask if you ever have any issues with hackers? My last blog (wordpress) was hacked and I ended up losing many months of hard work due  To buy a professional deep fryer - www.do-khyi-talk.de/profile.php  no data backup. Do you have any solutions to prevent hackers?

Camera quan sát 美国 wrote at 2020/2/21 9:05:53 #

Ahaa, its pleasant discussion on the topic of this paragraph at this place at this website, I have read all that, so at this time me also commenting at this place.

添加评论



biuquote
微笑得意调皮害羞酷大笑惊讶发呆喜欢可怜尴尬闭嘴噘嘴皱眉伤心抓狂呕吐坏笑漫骂发怒
Loading


RecentComments

评论 RSS

Statistics

989 篇文章
0 个单页
742162 条评论
11 次评分
1175056 次访问
访问统计开始于 2019年12月15日
平均日访问 6994 次
当前 98 人在线