应收结账时报收入成本不匹配问题

by limingk 2015.1.4 15:57

客户结账时报收入成本不匹配会导致无法结账,这个问题的直接原因是应收单收入确认行ARBillRCLine和收入成本匹配行ARBillRCMatchLine的数量PUAmount和成本数量CostPuAmount不相等导致。但是这只是结果,并不是原因。

要解决这个问题,首先要看一下销售的发出商品明细表,根据料品、期间、客户、单号查一下成本数量,如果这里的数量没问题,那基本可以确定是应收立账的问题,如果这里的数量也不对则需要找成本的同事协查一下。

如果确认了是应收立账的问题,则打开应收单看一下是否为部分立账,如果是部分立账,则有可能是历史结转数据问题导致,用脚本直接修改应收的数据即可

如果不是部分立账,那最好是让客户把有问题的应收单重新立账一下,看看是否能重现问题,能重现的话远程调试一下,重点看一下收入成本匹配时调用成本的服务时传入的数量以及成本服务返回的数量,来定位问题原因。

修改这个问题的脚本很简单,如下:

update a set a.CostPUAmount=a.PUAmount,a.CostTBUAmount=a.TBUAmount,a.CostTUAmount=a.TUAmount
 from AR_ARBillRCLine a inner join AR_ARBillLine b on a.ARBillLine=b.ID inner join AR_ARBillHead c on b.ARBillHead=c.ID
where c.DocNo='单号'


update a set a.CostPUAmount=a.PUAmount,a.CostTBUAmount=a.TBUAmount,a.CostTUAmount=a.TUAmount
 from AR_ARBillRCMatchLine a inner join AR_ARBillLine b on a.ARBillLine=b.ID inner join AR_ARBillHead c on b.ARBillHead=c.ID
where c.DocNo='单号'

Tags:

F财务

评论 (60) -

soccer news transfers 美国 wrote at 2016/4/6 15:25:57 #

You actually stated that perfectly!

soccer news 美国 wrote at 2016/5/6 14:22:55 #

Seriously loads of terrific information.

شركة تنظيف منازل بالطائف 美国 wrote at 2016/6/24 7:47:55 #

Aw, this was a very nice post. Taking a few minutes and actual effort to make a great article… but what can I say… I hesitate a lot and don't seem to get anything done.

شركة تنظيف خزانات بالطائف 美国 wrote at 2016/6/24 15:43:22 #

I constantly spent my half an hour to read this webpage's articles every day along with a mug of coffee.

شركة تنظيف بالطائف 美国 wrote at 2016/6/28 16:26:18 #

I know this if off topic but I'm looking into starting my own blog and was wondering what all is required to get setup? I'm assuming having a blog like yours would cost a pretty penny? I'm not very internet savvy so I'm not 100% positive. Any recommendations or advice would be greatly appreciated. Many thanks

شركة تنظيف بالطائف 美国 wrote at 2016/6/30 17:37:11 #

Asking questions are truly fastidious thing if you are not understanding something entirely, but this piece of writing gives nice understanding yet.

شركة تنظيف منازل بالرياض 美国 wrote at 2016/7/2 19:37:09 #

Hi! Someone in my Facebook group shared this site with us so I came to take a look. I'm definitely enjoying the information. I'm bookmarking and will be tweeting this to my followers! Wonderful blog and great design and style.

شركة تنظيف فلل بالخرج 美国 wrote at 2016/7/3 9:41:33 #

Hmm it seems like your blog ate my first comment (it was super long) so I guess I'll just sum it up what I submitted and say, I'm thoroughly enjoying your blog. I as well am an aspiring blog blogger but I'm still new to the whole thing. Do you have any recommendations for inexperienced blog writers? I'd genuinely appreciate it.

شركة تنظيف بالطائف 美国 wrote at 2016/7/5 9:28:57 #

Nice answer back in return of this query with genuine arguments and describing everything regarding that.

شركة تنظيف بالطائف 美国 wrote at 2016/7/6 19:25:24 #

My partner and I absolutely love your blog and find most of your post's to be exactly I'm looking for. can you offer guest writers to write content for you personally? I wouldn't mind composing a post or elaborating on a few of the subjects you write concerning here. Again, awesome blog!

شركة تنظيف خزانات بالرياض 美国 wrote at 2016/7/15 9:03:40 #

Hi, every time i used to check weblog posts here early in the dawn, because i like to learn more and more.

شركات تنظيف منازل بالطائف 美国 wrote at 2016/7/20 15:52:29 #

Hi i am kavin, its my first time to commenting anywhere, when i read this paragraph i thought i could also make comment due to this brilliant paragraph.

شركة تنظيف فلل بالخرج 美国 wrote at 2016/7/21 8:38:08 #

Nice post. I learn something totally new and challenging on blogs I stumbleupon everyday. It's always useful to read through content from other writers and practice something from other websites.

شركة تنظيف منازل بالطائف 美国 wrote at 2016/7/22 1:49:53 #

Hello I am so glad I found your web site, I really found you by error, while I was searching on Askjeeve for something else, Nonetheless I am here now and would just like to say kudos for a fantastic post and a all round interesting blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have saved it and also included your RSS feeds, so when I have time I will be back to read more, Please do keep up the superb work.

شركة تنظيف بالطائف 美国 wrote at 2016/7/22 11:34:21 #

Hello there! Do you know if they make any plugins to protect against hackers? I'm kinda paranoid about losing everything I've worked hard on. Any suggestions?

شركة تنظيف بالطائف 美国 wrote at 2016/7/22 14:09:47 #

Fastidious response in return of this difficulty with solid arguments and telling the whole thing concerning that.

شركة تنظيف بالطائف 美国 wrote at 2016/7/22 16:01:37 #

My brother recommended I might like this web site. He was entirely right. This post actually made my day. You can not imagine simply how much time I had spent for this info! Thanks!

شركة تنظيف بالخرج 美国 wrote at 2016/7/22 19:17:08 #

Hello, i believe that i noticed you visited my blog so i came to return the desire?.I am trying to find things to improve my website!I assume its adequate to use a few of your ideas!!

شركة تنظيف خزانات بالطائف 美国 wrote at 2016/7/23 15:06:11 #

A fascinating discussion is definitely worth comment. I do believe that you should publish more about this subject, it may not be a taboo matter but usually people do not speak about these subjects. To the next! All the best!!

شركة تنظيف بالطائف 美国 wrote at 2016/7/25 10:36:59 #

Wow, marvelous blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is excellent, let alone the content!

شركة تنظيف منازل بالطائف 美国 wrote at 2016/7/25 10:53:22 #

Asking questions are truly fastidious thing if you are not understanding anything completely, however this paragraph presents pleasant understanding yet.

شركة تنظيف بالخرج 美国 wrote at 2016/7/25 11:50:04 #

Very good post. I am dealing with a few of these issues as well..

شركة تنظيف شمال الرياض 美国 wrote at 2016/7/25 16:10:49 #

Hi there everyone, it's my first pay a visit at this site, and paragraph is in fact fruitful for me, keep up posting these articles.

شركة تنظيف بالطائف 美国 wrote at 2016/7/25 17:34:32 #

Great post. I was checking constantly this weblog and I am impressed! Very helpful info specifically the last phase 微笑 I handle such info a lot. I used to be seeking this certain info for a very long time. Thank you and good luck.

شركة تنظيف منازل بالخرج 美国 wrote at 2016/7/28 3:49:15 #

I know this if off topic but I'm looking into starting my own blog and was wondering what all is needed to get setup? I'm assuming having a blog like yours would cost a pretty penny? I'm not very internet savvy so I'm not 100% certain. Any suggestions or advice would be greatly appreciated. Kudos

شركة تنظيف بالطائف 美国 wrote at 2016/7/28 10:06:30 #

Hello! This is kind of off topic but I need some help 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 quick. I'm thinking about setting up my own but I'm not sure where to begin. Do you have any ideas or suggestions?  Cheers

شركة تنظيف خزانات بالطائف 美国 wrote at 2016/7/28 11:52:58 #

Hello there! Quick question that's completely off topic. Do you know how to make your site mobile friendly? My website looks weird when viewing from my apple iphone. I'm trying to find a theme or plugin that might be able to correct this issue. If you have any recommendations, please share. Cheers!

شركة تنظيف موكيت بالرياض 美国 wrote at 2016/7/29 18:36:44 #

If you are going for most excellent contents like me, just pay a visit this web page daily because it presents feature contents, thanks

شركة تنظيف بالطائف 美国 wrote at 2016/7/31 19:49:55 #

Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a extraordinary job!

شركة تنظيف خزانات بالطائف 美国 wrote at 2016/8/1 3:58:36 #

It's awesome to pay a quick visit this web site and reading the views of all colleagues concerning this post, while I am also zealous of getting know-how.

شركة تنظيف فلل بالخرج 美国 wrote at 2016/8/2 2:53:21 #

Hello, I read your new stuff daily. Your story-telling style is awesome, keep it up!

شركة تنظيف بالطائف 美国 wrote at 2016/8/3 0:05:01 #

Hi! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing several weeks of hard work due to no backup. Do you have any solutions to protect against hackers?

شركة تنظيف بخميس مشيط 美国 wrote at 2016/8/9 2:14:15 #

Thanks  for any other informative blog. Where else may just I get that kind of info written in such a perfect way? I've a venture that I am simply now operating on, and I've been on the look out for such information.

شركة تنظيف بالطائف 美国 wrote at 2016/8/9 7:22:39 #

It is in reality a nice and helpful piece of info. I am satisfied that you simply shared this helpful information with us. Please stay us informed like this. Thanks for sharing.

شركة كشف تسربات المياه بالرياض 美国 wrote at 2016/8/11 23:12:39 #

Great post.

شركة تنظيف بالطائف 美国 wrote at 2016/8/12 11:52:48 #

Thanks for your marvelous posting! I certainly enjoyed reading it, you are a great author.I will ensure that I bookmark your blog and may come back later on. I want to encourage you continue your great writing, have a nice holiday weekend!

شركة نقل عفش بالرياض 美国 wrote at 2016/8/18 15:14:12 #

Hey there! Someone in my Myspace group shared this website with us so I came to give it a look. I'm definitely loving the information. I'm bookmarking and will be tweeting this to my followers! Terrific blog and superb design and style.

شركة نقل عفش بالرياض 美国 wrote at 2016/8/20 15:34:26 #

I like the helpful information you provide in your articles. I'll bookmark your weblog and check again here frequently. I'm somewhat certain I'll learn lots of new stuff right right here! Best of luck for the following!

شركة تنظيف بخميس مشيط 美国 wrote at 2016/8/27 20:22:55 #

My developer is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the costs. But he's tryiong none the less. I've been using Movable-type on numerous websites for about a year and am worried about switching to another platform. I have heard excellent things about blogengine.net. Is there a way I can import all my wordpress content into it? Any help would be really appreciated!

افزایش فالوور 美国 wrote at 2016/9/16 2:24:55 #

Hurrah, that's what I was seeking for, what a stuff! present here at this website, thanks admin of this web page.

شركة تنظيف بالطائف 美国 wrote at 2016/9/30 10:39:24 #

hello there and thank you for your info – I have certainly picked up something new from right here. I did however expertise a few technical issues using this website, since I experienced to reload the web site many times previous to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will very frequently affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Well I'm adding this RSS to my e-mail and can look out for much more of your respective intriguing content. Ensure that you update this again soon.

شركة تنظيف بالطائف 美国 wrote at 2016/10/1 1:39:22 #

Hi there! I could have sworn I've visited this web site before but after going through many of the articles I realized it's new to me. Nonetheless, I'm definitely pleased I discovered it and I'll be bookmarking it and checking back frequently!

شركة تنظيف بخميس مشيط 美国 wrote at 2016/10/6 17:39:01 #

I blog quite often and I seriously thank you for your content. Your article has truly peaked my interest. I am going to book mark your site and keep checking for new information about once a week. I subscribed to your Feed as well.

شركة تنظيف منازل بالرياض 美国 wrote at 2016/10/22 5:46:40 #

Definitely consider that which you said. Your favourite justification appeared to be on the web the easiest thing to have in mind of. I say to you, I certainly get annoyed at the same time as other people think about worries that they just do not know about. You managed to hit the nail upon the top as neatly as outlined out the entire thing without having side effect , folks could take a signal. Will probably be again to get more. Thanks

شركة تنظيف خزانات بالطائف 美国 wrote at 2016/10/22 5:49:43 #

I like the valuable information you provide in your articles. I'll bookmark your blog and check again here frequently. I'm quite sure I'll learn plenty of new stuff right here! Good luck for the next!

شركة تنظيف منازل بالخرج 美国 wrote at 2016/10/22 8:17:48 #

Paragraph writing is also a fun, if you be acquainted with after that you can write if not it is complex to write.

شركة تنظيف بالطائف 美国 wrote at 2016/10/22 10:29:27 #

This is very interesting, You're a very skilled blogger. I have joined your feed and look forward to seeking more of your great post. Also, I've shared your web site in my social networks!

شركة تنظيف بابها 美国 wrote at 2016/10/24 11:13:57 #

Howdy I am so glad I found your webpage, I really found you by accident, while I was looking on Aol for something else, Regardless I am here now and would just like to say thanks for a remarkable post and a all round exciting blog (I also love the theme/design), I don’t have time to read it all at the minute but I have book-marked it and also added in your RSS feeds, so when I have time I will be back to read much more, Please do keep up the excellent jo.

latest soccer news 美国 wrote at 2016/11/20 21:14:57 #

Good material. With thanks.

شركة تخزين اثاث بتبوك 美国 wrote at 2016/12/23 16:44:49 #

My brother suggested I might like this web site. He was totally right. This post truly made my day. You cann't imagine simply how much time I had spent for this info! Thanks!

نقل عفش مع الفك والتركيب 美国 wrote at 2017/1/5 10:02:46 #

I quite like reading through a post that can make men and women think. Also, many thanks for permitting me to comment!

تنظيف خزانات 美国 wrote at 2017/1/7 22:34:04 #

Great site you have here but I was wondering if you knew of any message boards that cover the same topics talked about in this article? I'd really like to be a part of online community where I can get comments from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Bless you!

نقل عفش 美国 wrote at 2017/1/26 6:19:05 #

Wow! At last I got a blog from where I be able to really obtain valuable data regarding my study and knowledge.

شقق ايجار جديد بالاسكندرية 美国 wrote at 2017/4/14 13:17:04 #

Hi there to all, how is the whole thing, I think every one is getting more from this web site, and your views are fastidious designed for new viewers.

شركة تنظيف خزانات 美国 wrote at 2017/4/22 21:42:56 #

Undeniably believe that which you stated. Your favorite reason appeared to be on the internet the easiest thing to be aware of. I say to you, I definitely get irked while people think about worries that they plainly do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side effect , people can take a signal. Will probably be back to get more. Thanks

نقل عفش بالطائف 美国 wrote at 2017/4/23 3:20:50 #

I was curious if you ever thought of changing the page layout of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or 2 images. Maybe you could space it out better?

بالطائف 美国 wrote at 2017/5/10 1:42:56 #

Hello! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing months of hard work due to no back up. Do you have any methods to protect against hackers?

شركة كشف تسربات المياه 美国 wrote at 2018/7/4 0:48:38 #

Have you ever thought about including a little bit more than just your articles? I mean, what you say is valuable and everything. However think about if you added some great images or videos to give your posts more, "pop"! Your content is excellent but with images and video clips, this blog could definitely be one of the best in its niche. Wonderful blog!

شركة 美国 wrote at 2018/9/6 11:22:05 #

l like  any  top content

sex 美国 wrote at 2020/1/10 13:14:10 #

For latest information you have to go to see internet and on world-wide-web I found this website as a most excellent web page for hottest updates.

添加评论



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


RecentComments

评论 RSS

Statistics

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