销售日报表英文版
销售工作计划表英文
销售工作计划表英文I. IntroductionThe sales team plays a crucial role in the success of a company. It is responsible for generating revenue and acquiring new customers. In order to achieve these objectives, a well-defined sales work plan needs to be established. This plan outlines the strategies, activities, and targets that the sales team will focus on for a specified period of time. In this essay, we will discuss a comprehensive sales work plan consisting of several key components.II. Setting Sales ObjectivesThe first step in creating a sales work plan is to define the sales objectives. These objectives should be specific, measurable, achievable, relevant, and time-bound (SMART). The sales team needs to have a clear understanding of what needs to be accomplished and how success will be measured. For example, the objectives could include increasing sales by 10% in the next quarter or acquiring 50 new customers within six months.III. Identifying Target MarketsOnce the sales objectives are established, the next step is to identify the target markets. It is important to have a thorough understanding of the customer segments that are most likely to be interested in the products or services being offered. This involves conducting market research, identifying customer needs, and analyzing competitors' offerings. The target markets should be selected based on factors such as demographics, psychographics, and behavioral patterns.IV. Developing Sales StrategiesWith the target markets defined, the sales team can now develop the sales strategies that will be used to reach those markets. This includes determining the most effective channels to reach potential customers, such as direct sales, online marketing, or partnerships with distributors. The team should also consider the pricing strategy, promotional activities, and sales support materials that will be used to influence customers' buying decisions. The sales strategies should align with the overall business strategy and be tailored to meet the needs of the target markets.V. Creating Sales Action PlansOnce the sales strategies are established, the sales team needs to create action plans that outline the specific activities that will be undertaken to implement those strategies. This includes identifying the key tasks, responsibilities, and timelines for each activity. For example, if the sales strategy is to increase sales through direct sales, the action plan may include activities such as prospecting, cold calling, conducting sales presentations, andfollowing up with potential customers. The action plans should be realistic, achievable, and aligned with the sales objectives.VI. Setting Sales TargetsIn order to track the progress and measure the success of the sales work plan, it is important to set sales targets. The targets should be specific, measurable, and time-bound. For example, the targets could include achieving a certain amount of sales revenue, acquiring a specific number of new customers, or increasing the average order value. The sales team should track their performance against these targets on a regular basis and take corrective actions if necessary.VII. Monitoring and Evaluating PerformanceMonitoring and evaluating the performance of the sales team is essential to ensure that the sales work plan is effective. This involves tracking key performance indicators (KPIs) such as sales revenue, conversion rates, customer acquisition cost, and customer satisfaction. Regular sales meetings should be held to review the progress, discuss challenges, and make necessary adjustments to the sales strategies and action plans. The sales team should also receive feedback and training to improve their skills and enhance their performance.VIII. ConclusionIn conclusion, a well-crafted sales work plan is essential for the success of a company's sales team. It provides a roadmap for achieving sales objectives, targeting the right customers, and implementing effective sales strategies. By setting clear objectives, identifying target markets, developing strategies and action plans, setting sales targets, and monitoring performance, the sales team can maximize their productivity, generate revenue, and contribute to the growth of the company.。
销售人员工作日报表·【范本模板】
姓名＿___________＿_部门＿＿_＿______＿＿__日期_______＿______星期＿_＿____
项目
工作时间
工作内容
备注
今日主要工作
8:００——10：0０
１0：00—-11：30
11：30——1３:００
1３:00——15:00
15：00——１7:０0
1７:０0——晚上
11．服从所属部门主管、经理的行政管理工作；
12.完成领导交办的其他工作。
部门总结：
注：员工必须如实填写,发现虚假情况将撤销各类优秀评比资格。
３．拜访新开发客户、平时拜访问候、售后服务工作；
4.销售合同的签订;
5．每工作日填写销售人员工作日报表；
6．熟悉产品性能，应收账款的回收及相关后续工作的跟踪与服务;
7．提供销售报告、销售分析及销售统计;
8.进行相关的市场调查、分析及销售预测;
9．制订销售计划和总结，汇报工作情况；
10.遵守公司的纪律及相关规定；
注：下班时间后因工作需要宴请,要注明宴请人员姓名、时间、地点、费用
今日工作总结
明日工作计划
8:00——１０：００
１0：００——11:３0
11：30——１3:00
13：０0--１5:00
１5：00-—17:0０
部门评分
工作职责
工作范围
完成情况
完成结果
１．发掘及开拓客户资源;
2．制订访问计划及销售计划;
sales report销售报表英文
4.1 Writing P.41 Ex.8 A sales report
8 . Write a sales report (200 words approx).
Writing skills: a sales report • Structural sentences for each section: • Introduction: The aim of this report is to … / This report describes… • Reasons: This is due to … / The reasons for this are as follows … • Prospects: Looking to the future, … • Recommendations: Consequently, I would like to propose … • Notes: Make sure that your report addresses all the points in the task appropriately. (In the BEC exam, students will lose marks for failing to address all the points that are listed in the no Ex.8 A sales report
8 . Write a sales report (200 words approx).
Writing skills: How to write a sales report? Structure: Start with a Summary: aims at informing the receiver what information will be carried in the report; should be brief and clear Report the Numbers: Present the sales figures immediately following the summary; a breakdown of total sales: categories and arrangement vary, e.g. individual salespeople or retail outlets, geographic areas, specific products. Note: Readers of sales reports typically want to know the amount of sales and whether sales goals were met. Explanatory Sections: following the sales figures, provide data from past periods for comparison; if short of a sales goal, identify the reason and state the possible solutions to remedy the situation. Conclusion: summarizes the major findings of the report Recommendation: suggests the future action for strategy making
每日销售报表Daliy Sales Report
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 0 0 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 0 0 0 #DIV/0! 0 0 0
0 #DIV/0!
0 #DIV/0!Fra bibliotek0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 0 0 0 #DIV/0! 0 0 0
0 #DIV/0!
0 0 #DIV/0! 0 0 #DIV/0! 0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0! 0
#DIV/0! 0
#DIV/0! 0
#DIV/0! 0
#DIV/0! 0
#DIV/0! 0
#DIV/0! 0
0 0 #DIV/0! 0 0 #DIV/0! 0
0 0 0 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
英文销售报表(眼睛类)
FRAME ACTIVE BRAND
MIN FRAME IDEAL SETTING CURRENT SETTING VARIENCE SETTING 156 377 -221 MAX 268 865 -597
MIN
EXCLUSIVE TOP 10 INTERNATIONAL EXCLUSIVE TOP 10 OTHER EXCLUSIVE OTHER INTERNATIONAL EXCLUSIVE TOTAL HOUSE BRAND BCP MSI BRAND BCP TOP 10 OTHER BCP TOTAL BCP BRAND TOTAL FRAME MIN 80 50 60 50 240 50 50 37 137 377 MKT COST 4380.00 2290.00 11040.00 3870.00 21580.00 19620.00 6120.00 17805.00 43545.00 65125.00 DAN 120 75 72 60 327 75 75 58 208 535 SETTING MKT COST REP 6570.00 160 3435.00 13248.00 4644.00 27897.00 29430.00 9180.00 31224.00 69834.00 97731.00 100 90 75 425 100 100 76 276 701 MKT COST 8760.00 4580.00 16560.00 5805.00 35705.00 39240.00 12240.00 421ቤተ መጻሕፍቲ ባይዱ0.00 93590.00 ######## MAX 200 125 108 90 523 125 125 92 342 865 MKT COST 10950.00 5725.00 19872.00 6966.00 43513.00 49050.00 15300.00 51236.00 ######## ######## OPENING QTY TOTAL SOLD 218 34 67 27 346 94 266 153 513 859 131 23 23 1 178 42 232 74 348 526 TOTAL PURCHASE 0 0 0 0 0 0 0 0 0 0 CURRENT QTY 140 37 66 39 282 52 34 91 177 459 MIN 175% 74% 110% 78% 437% 104% 68% 246% 129% 566% CURRENT QTY STATUS DAN REP 117% 88% 49% 92% 65% 323% 69% 45% 157% 85% 408% 37% 73% 52% 250% 52% 34% 120% 64% 314% MAX 70% 30% 61% 43% 204% 42% 27% 99% 52% 256% TTL INVESTMENT 6619.00 1685.00 7716.00 2570.00 18590.00 22099.00 5854.00 40966.00 68919.00 87509.00 0 0 0 REPL. QTY TTL REPL ESTIMATE ESTIMATE COST D D PROFIT 60 2239 10340 8101 -13 6 -11 42 0 -16 54 38 80 -605 -3324 -1300 -2990 -23 -266 23161 22872 19882 -3297 -7286 -2929 -3172 -7331 -1985 46492 37176 34004 -2692 -3962 -1629 -182 -16022 -1719 23331 5590 5408
sales report销售报表英文
4.1 Writing P.41 Ex.8 A sales report
8 . Write a sales report (200 words approx).
Writing skills: Expressions - introduction • The purpose of this report is to…investigate, evaluate, study… • The objective of this report is to…recommend, analyze, give… • The aim of this report is to …assess, estimate… Writing skills: Expressions - reasons • This comes from the fact that… • One explanation is… • The reason for this is… • This came as a result of… • This is caused by…
4.1 Writing P.41 Ex.8 A sales report
8 . Write a sales report (200 words approx).
Writing skills: How to write a sales report? Structure: Start with a Summary: aims at informing the receiver what information will be carried in the report; should be brief and clear Report the Numbers: Present the sales figures immediately following the summary; a breakdown of total sales: categories and arrangement vary, e.g. individual salespeople or retail outlets, geographic areas, specific products. Note: Readers of sales reports typically want to know the amount of sales and whether sales goals were met. Explanatory Sections: following the sales figures, provide data from past periods for comparison; if short of a sales goal, identify the reason and state the possible solutions to remedy the situation. Conclusion: summarizes the major findings of the report Recommendation: suggests the future action for strategy making
销售情况日报表范本
Type of call
销售情况
Sales
补充说明
Comments
填表人Completed by:
签名Signature:
销售情况日报表
Daily sales report
销售情况日报表
DAILY SALES REPORT
编号Number:
：你喜欢“走自己的路，让他们说去吧”！但你在班里似乎从不张扬，总是默默无闻的，用自己优秀的学习成绩证明着你的实力。你思维灵活，接受能力较强，勤于思考，作业本上那工整的字迹，是你文静开出的花朵。你文静有余而活动不足，希望你能再接再厉，百尺竿头更进一步日期Date:
：你喜欢“走自己的路，让他们说去吧”！但你在班里似乎从不张扬，总是默默无闻的，用自己优秀的学习成绩证明着你的实力。你思维灵活，接受能力较强，勤于思考，作业本上那工整的字迹，是你文静开出的花朵。你文静有余而活动不足，希望你能再接再厉，百尺竿头更进一步姓名Name:
职务Job title:
顾客
Customer
销售额报告的格式及范文英文
销售额报告的格式及范文英文Sales Report Format and Sample in English.Sales reports are crucial documents that provide an overview of a company's sales performance over a specific period. They help businesses understand their financial status, identify areas of success and improvement, and make informed decisions about future strategies. In this article, we will discuss the format and provide a sample salesreport in English.Sales Report Format:1. Title Page: The report should begin with a titlepage that includes the report's title, the company's name, the report's date, and the author's name.2. Introduction: The introduction section briefly describes the purpose of the report, the time frame covered, and any significant events or trends that occurred duringthe period.3. Sales Overview: This section presents an overview of the sales performance, including total sales, the number of sales transactions, average sales per transaction, and any significant changes compared to previous periods.4. Sales Breakdown: The sales breakdown section provides a detailed analysis of sales by product, customer, or region. This information helps identify which products or customers are generating the most revenue and which regions are performing well.5. Key Metrics: This section highlights key performance metrics such as revenue growth, profit margin, and sales conversion rate. These metrics help assess the overall financial health and performance of the sales team.6. Challenges and Opportunities: In this section, the report discusses any challenges faced during the period, such as competition, market changes, or customer feedback. It also identifies opportunities for improvement and growthin the future.7. Conclusion: The conclusion section summarizes the key findings and recommendations from the report. It should provide a clear picture of the sales performance, identify areas of success and improvement, and outline any future plans or strategies.Sales Report Sample in English:Sales Report for the Quarter Ending December 31, 2023。
销售每日工作计划英文怎么说
销售每日工作计划英文怎么说IntroductionA sales daily work plan is essential for sales professionals to stay organized and focused on achieving their sales goals. It helps them prioritize tasks, manage time effectively, and track progress. In this article, we will discuss how to create a sales daily work plan that can help enhance productivity and boost sales.1. Set Clear Sales GoalsThe first step in creating a sales daily work plan is to set clear and specific sales goals. These goals should be realistic and achievable within the given timeframe. For example, a salesperson might set a goal of closing five deals per day or generating a certain amount of revenue. Having clear goals will provide direction and motivation.2. Identify Priority TasksOnce the sales goals are set, the next step is to identify priority tasks. These are the tasks that directly contribute to achieving the sales goals. For example, making prospecting calls, following up with potential customers, and preparing sales presentations might be high-priority tasks. It is important to focus on these tasks first to maximize productivity and results.3. Plan Time for Prospecting and Lead GenerationProspecting and lead generation are crucial activities for sales professionals. Allocating specific time for these tasks in the daily work plan is necessary to ensure a consistent flow of potential customers. This can include identifying new leads, reaching out to them via phone or email, and nurturing existing leads.4. Schedule Sales Meetings and CallsSales professionals often need to schedule meetings and calls with potential customers. It is essential to include these in the sales daily work plan to ensure no appointments are missed. The schedule should allow for adequate preparation time before each meeting or call, including researching the prospect and preparing necessary materials.5. Follow-Up with Existing CustomersFollowing up with existing customers is a vital part of maintaining relationships and generating repeat business. Including time for follow-up calls, emails, or meetings in the daily work plan is necessary to ensure regular and effective communication with customers. Building strong relationships with existing customers can lead to referrals and additional sales opportunities.6. Allocate Time for Sales AdministrationSales administration tasks, such as updating CRM systems, preparing sales reports, and analyzing sales data, can be time-consuming. Allocating a specific time slot in the daily work plan for these tasks is important to ensure they are not overlooked or rushed. Effective sales administration helps sales professionals stay organized and make informed decisions.7. Continuous Learning and Skill DevelopmentSales professionals should constantly work on improving their skills and knowledge. Allocating time for self-improvement activities, such as reading industry-related articles, attending webinars or workshops, and practicing sales techniques, is essential. This continuous learning will help sales professionals adapt to changing market trends and enhance their selling capabilities.8. Evaluate and Review ProgressAt the end of each day, it is important to evaluate and review the progress made towards the sales goals. This evaluation helps identify areas for improvement, track performance, and make necessary adjustments to the daily work plan. Regularly reviewing progress allows sales professionals to stay on track and make data-driven decisions to drive sales growth.ConclusionCreating a sales daily work plan helps sales professionals stay organized, prioritize tasks, and achieve their sales goals. By setting clear goals, identifying priority tasks, and allocating time for key sales activities, sales professionals can enhance productivity and drive sales growth. Regular evaluation and review of progress ensure continuous improvement and success in the sales role.。
销售每日工作计划英文版
Date: [Insert Date]Sales Representative: [Insert Name]Objective: To achieve daily sales targets, maintain customer relationships, and contribute to the overall success of the team.Morning Session (8:00 AM - 10:00 AM):1. Preparation (8:00 AM - 8:30 AM):- Review the daily sales targets and understand the key products or services to focus on.- Check emails and messages for any customer inquiries or urgent requests.- Update the sales report with the previous day's activities and results.2. Customer Follow-Up (8:30 AM - 9:30 AM):- Reach out to customers who have shown interest in our products or services but have not yet made a purchase.- Follow up on previous quotes or proposals to ensure they are still under consideration.- Schedule follow-up meetings or calls as necessary.3. Prospecting (9:30 AM - 10:00 AM):- Research new potential customers and identify key decision-makers.- Utilize LinkedIn, industry forums, and other resources to gather information.- Prepare a list of potential leads for the day's outreach.Midday Session (10:00 AM - 12:00 PM):1. Product Knowledge Update (10:00 AM - 10:30 AM):- Stay updated with new product features, pricing, and promotions.- Attend any training sessions or webinars provided by the company to enhance product knowledge.2. Outreach Campaign (10:30 AM - 11:30 AM):- Contact the list of potential leads generated in the morning.- Make initial phone calls or send personalized emails to introduce our company and products.- Schedule face-to-face meetings or video calls for those who show interest.3. Meeting with Existing Clients (11:30 AM - 12:00 PM):- Arrange meetings with existing clients to discuss ongoing projects, address any concerns, or present new solutions.- Update the client on any changes or improvements in our products or services.Afternoon Session (12:00 PM - 2:00 PM):1. Lunch Break (12:00 PM - 1:00 PM):- Take a break to recharge and reflect on the morning's activities.- Plan the afternoon's tasks and prioritize based on customer responses and meetings.2. Sales Presentation and Negotiation (1:00 PM - 2:00 PM):- Prepare sales presentations for potential clients.- Conduct presentations and answer any questions or concerns.- Negotiate terms and conditions to close deals.Evening Session (2:00 PM - 5:00 PM):1. Post-Sales Follow-Up (2:00 PM - 3:00 PM):- Follow up with clients who have received the sales presentations.- Send additional information or address any additional questions.- Schedule follow-up calls or meetings as needed.2. Data Entry and Reporting (3:00 PM - 4:00 PM):- Update the CRM system with today's activities, leads, and sales.- Prepare a daily sales report for the team leader.- Analyze the report to identify trends and areas for improvement. 3. Reflection and Planning (4:00 PM - 5:00 PM):- Reflect on the day's successes and challenges.- Plan for the next day, including any additional tasks or meetings.- Set goals for the upcoming week to align with the monthly sales targets.Conclusion:This daily sales work plan is designed to ensure that all necessary tasks are completed efficiently and effectively. By following this structure, the sales representative will be able to maximize their productivity, maintain strong customer relationships, and contribute to the company's overall success.。
销售合同表格怎么做英文版
### Steps to Create an English Sales Contract Table1. Identify the Contractual Parties: Begin by listing the names and contact information of the buyer and seller. This includes full legal names, addresses, phone numbers, and email addresses.2. Define the Product or Service: Clearly specify the product or service being sold. Include a detailed description, model number, brand, and any other relevant information that can help identify the item.3. Specify Quantity and Quality: Outline the quantity of the product or service to be delivered. Also, describe the quality standards or specifications that the product must meet.4. Set the Price and Payment Terms: State the total price for the product or service, including any taxes or fees. Detail the payment terms, such as the payment method, due dates, and late payment penalties.5. Define Delivery Details: Include the delivery address, expected delivery date, and shipping method. If the delivery is to be done in installments, specify the schedule.6. Include Warranty and Return Policy: Mention any warranty periods and conditions, as well as the return policy if applicable.7. Add Legal Clauses: Insert any legal clauses, such as intellectual property rights, confidentiality, and dispute resolution procedures.8. Signatures: Provide space for both parties to sign and date the contract, indicating their agreement to the terms outlined.### Example of an English Sales Contract Table```plaintextSales ContractContract Number: ________Date: _______________Buyer Information:Name: [Buyer's Full Legal Name]Address: [Buyer's Address]Phone: [Buyer's Phone Number]Email: [Buyer's Email Address]Seller Information:Name: [Seller's Full Legal Name]Address: [Seller's Address]Phone: [Seller's Phone Number]Email: [Seller's Email Address]Product/Service Details:1. Product Name: [Product/Service Name]Model Number: [Model Number]Brand: [Brand]Description: [Detailed Description]Quantity: [Number of Units]Quality Standard: [Quality Standards]Price and Payment Terms:Total Price: [Amount in Currency]Payment Method: [e.g., Bank Transfer, Credit Card, PayPal] Due Date: [Date by which payment is due]Late Payment Penalty: [Percentage or Fixed Amount] Delivery Details:Delivery Address: [Full Delivery Address]Expected Delivery Date: [Date]Shipping Method: [e.g., FedEx, UPS, Courier]Warranty and Return Policy:Warranty Period: [Duration of Warranty]Warranty Conditions: [Conditions of Warranty]Return Policy: [Conditions for Returning the Product/Service]Legal Clauses:1. Intellectual Property Rights: [Details of IP Ownership]2. Confidentiality: [Details of Confidentiality Agreement]3. Dispute Resolution: [Details of Dispute Resolution Procedure] Signatures:Buyer's Signature: _______________________Buyer's Date: ___________________________Seller's Signature: _______________________Seller's Date: ___________________________```### ConclusionWhen drafting an English sales contract table, it's crucial to ensure that all terms are clearly defined and understood by both parties. The table should be concise yet comprehensive, covering all aspects of the transaction. It's also advisable to have the contract reviewed by a legal professional to ensure that it complies with relevant laws and regulations.。
K3成长版销售日报表
K3成长版销售日报表.txt老公如果你只能在活一天，我愿用我的生命来延续你的生命，你要快乐的生活在提出分手的时候请不要说还爱我。
K3成长版销售日报表.txt如果青春的时光在闲散中度过，那么回忆岁月将是一场凄凉的悲剧。
杂草多的地方庄稼少，空话多的地方智慧少。
即使路上没有花朵，我仍可以欣赏荒芜。
set Nocount oncreate table #CK(fcustid int,FyesAmount decimal(12,2),FFPAmount decimal(12,2),FSKAmount decimal(12,2),FendAmount decimal(12,2))insert into #CK(fcustid,FyesAmount)select v1.fcustid, sum(isnull(v2.famount,0)) from icsale v1inner join IcsaleEntry v2 on v1.finterid=v2.finterid where v1.fdate<'********'group by v1.fcustidinsert into #CK(fcustid,FendAmount)select v1.fcustomer,sum(isnull(v1.famount,0)) from t_RP_NewReceiveBill v1 where v1.fdate<'********'group by v1.fcustomerinsert into #CK(fcustid,FFPAmount)select v1.fcustid, sum(isnull(v2.famount,0)) from icsale v1inner join IcsaleEntry v2 on v1.finterid=v2.finterid where v1.fdate>='********' and v1.fdate<='########'group by v1.fcustidinsert into #CK(fcustid,FSKAmount)select v1.fcustomer,sum(isnull(v1.famount,0)) from t_RP_NewReceiveBill v1 where v1.fdate>='********' and v1.fdate<='########'group by v1.fcustomercreate table #HK(fcustid int,FyesAmount decimal(12,2),FFPAmount decimal(12,2),FSKAmount decimal(12,2),FendAmount decimal(12,2))insert into #HK select v1.fcustid,sum(isnull(v1.FyesAmount,0)),sum(isnull(v1.FFPAmount,0)),sum(isnull(v 1.FSKAmount,0)),sum(isnull(FendAmount,0))from #CK v1 group by v1.fcustidcreate table #temp(fcustid int,FyesAmount decimal(12,2),FinAmount decimal(12,2),fitemid int,fbatchno varchar(128),fpichi int,dengji varchar(128),fprice decimal(12,2),jingzhong decimal(12,2),famount decimal(12,2),FendAmount decimal(12,2))insert into #temp select v1.fcustid,0,0,v2.fitemid,v2.fbatchno,convert(int,v2.FEntrySelfI0459),v2.FEntryS elfI0460,v2.fprice,sum(isnull(v2.fqty,0)),sum(isnull(v2.famount,0)),0from icsale v1 inner join icsaleEntry v2 on v1.finterid=v2.finteridwhere v1.fdate>='2011-05-27' and v1.fdate<='2011-05-27'group by v1.fcustid,v2.fitemid,v2.fbatchno,v2.FEntrySelfI0459,v2.FEntrySelfI0460,v2.fpricecreate table #end(fcustid int,fyesAmount decimal(12,2),FinAmount decimal(12,2),fnumber varchar(128),fname varchar(128),fmodel varchar(128),fpichi varchar(128),dengji varchar(128),jianshu int,fqty decimal(12,2),fprice decimal(12,2),famount decimal(12,2),fendamount decimal(12,2))insert into #end(fcustid,fnumber,fname,fmodel,fpichi,dengji,jianshu,fqty,fprice,famount)select v1.fcustid,t1.fnumber,t1.fname,t1.fmodel,t2.fname,v1.dengji, count(v1.jingzhong),sum(v1.jingzhong),v1.fprice,sum(v1.famount) from#temp v1inner join t_icitem t1 onv1.fitemid=t1.fitemidinner join t_item_3001 t2 onv1.fpichi=t2.fitemidinner join t_organization t3 onv1.fcustid=t3.fitemidgroup byv1.fcustid,t1.fnumber,t1.fname,t1.fmodel,t2.fname,v1.dengji,v1.fpriceupdate #end set fyesAmount=v2.FyesAmount-v2.fendAmount from #end v1 left join #HKv2 on v1.fcustid=v2.fcustidupdate #end set fendAmount=v2.FyesAmount+v2.FFPAmount-v2.fendAmount-v2.FSKAmountfrom #end v1 left join #HK v2 onv1.fcustid=v2.fcustidupdate #end set FinAmount=v2.FSKAmount from #end v1 left join #HK v2 onv1.fcustid=v2.fcustidcreate table #final(fcustomer varchar(128),fyesAmount decimal(12,2),finAmount decimal(12,2),fnumber varchar(128),fname varchar(128),fmodel varchar(128),fpichi varchar(128),dengji varchar(128),jianshu int,fqty decimal(12,2),fprice decimal(12,2),famount decimal(12,2),fendamount decimal(12,2))insert into #final selectt3.fname,v1.fyesAmount,v1.finAmount,v1.fnumber,v1.fname,v1.fmodel,v1.fpichi,v1.dengji,v1.jianshu,v1.fqty,v1.fprice,v1.famount,v1.fendamount from #end v1 inner join t_organization t3 on v1.fcustid=t3.fitemidinsert into#final(fcustomer,fyesAmount,finAmount,jianshu,fqty,famount,fendamount)select '合计',sum(isnull(v1.fyesAmount,0)),sum(isnull(v1.finAmount,0)),count(v1.fqty),sum(v1.fqty),sum(isnull(v1.famount,0)),sum(isnull(v1.fendamount,0)) from #end v1selectfcustomer as '客户',fyesAmount as '统计前欠款额',finAmount as '收款',fnumber as '物料代码',fname as '物料名称',fmodel as '规格',fpichi as '批次',dengji as '等级',jianshu as '件数',fqty as '重量',fprice as '单价',famount as '金额',fendamount as '统计后欠款额'from #finaldrop table #tempdrop table #enddrop table #CKdrop table #HKdrop table #finalset nocount off出师表两汉：诸葛亮先帝创业未半而中道崩殂，今天下三分，益州疲弊，此诚危急存亡之秋也。