随笔- 285 文章- 47 评论- 3 阅读- 37万

11 2014 档案

Read a Text File with VBA in Excel, and Write the Text to a Spreadsheet

摘要：VBA can read a text file and then write it to your spreadsheet. Here's an example of a VBA program that shows how to do it.http://exceluser.com/excel_... 阅读全文

posted @ 2014-11-30 20:14 jefflu99 阅读(421) 评论(0) 推荐(0) 编辑

Excel Skill two

摘要：" =IF(LEN(B3)=23,B3,A3&" "&B3&REPT(" ",23-LEN(B3))&C3) &&&&&&& verify the char length of material " =IF(LEN(A3)=5,A3,A3&REPT(" ",5-LEN(A3))) *********... 阅读全文

posted @ 2014-11-30 19:56 jefflu99 阅读(286) 评论(0) 推荐(0) 编辑

news 100

摘要：20世纪上半叶，作家王实味遭遇或许可以代表那整整一代人的苦难，1942年，在恶名昭著的延安文艺座谈会之前，自愿投奔延安的王实味发表了一篇几千字的文章，批评延安的“衣分五色，食分三等”，然后被批斗、被拷打、被长期监禁，最后被一刀砍死，尸体沉入枯井。在这篇致命的文章中，王实味说“要尽一切力量走向光明”。... 阅读全文

posted @ 2014-11-27 23:26 jefflu99 阅读(318) 评论(0) 推荐(0) 编辑

Cross-plant material status in Material Master (Basic data 1)

摘要：1.Is Blocking Key assigned to material master in basic data 1 view in X plant material status, if yes, remove blocking key and create PR & PO. Or chec... 阅读全文

posted @ 2014-11-27 16:12 jefflu99 阅读(2056) 评论(0) 推荐(0) 编辑

SAP FI Month End and Year End Activities

摘要：1 - Maintain Activity prices - KP262 - Release of Standard Cost Estimate - CK40N3 - MM period close and open - MMPV - Prevent Inventory Back Postingto... 阅读全文

posted @ 2014-11-27 13:58 jefflu99 阅读(348) 评论(0) 推荐(0) 编辑

Steps for Monthly-end closing and Yearly-end Closing

摘要：http://www.sap-basis-abap.com/fico/sap-fi-month-end-and-year-end-activities.htmFirst you will have to close the Posting period in the Materials Manage... 阅读全文

posted @ 2014-11-27 13:56 jefflu99 阅读(605) 评论(0) 推荐(0) 编辑

Cancel --- Reverse the production order :

摘要：Follow the below steps to reverse the Production Order,1. First check your Production order is settled. If its reverse the settlement using KO88 t-cod... 阅读全文

posted @ 2014-11-26 12:20 jefflu99 阅读(485) 评论(0) 推荐(0) 编辑

Special Procurement Type for Costing (Costing View in Material Master )

摘要：http://help.sap.com/saphelp_470/helpdata/en/7e/cb7f5643a311d189ee0000e81ddfac/content.htm Special Procurement in Costing UseA BOM can include material... 阅读全文

posted @ 2014-11-21 14:00 jefflu99 阅读(830) 评论(0) 推荐(0) 编辑

PFCG-ROLE MAINTENANCE ( PFCG Role and authorization)

只有注册用户登录后才能阅读该文。

posted @ 2014-11-20 11:43 jefflu99 阅读(1) 评论(0) 推荐(0) 编辑

How to Password protect a particular Column OR Row in Excel?

摘要：How to Password protect a particular Column OR Row in Excel? http://www.excel-formulas.com/sample-question/Password-Protect-Particular-Column-or-Row-i... 阅读全文

posted @ 2014-11-18 15:05 jefflu99 阅读(287) 评论(0) 推荐(0) 编辑

VBA编程常用语句(转载）

摘要：1、Option Explicit '强制对模块内所有变量进行声明Option Private Module '标记模块为私有,仅对同一工程中其它模块有用,在宏对话框中不显示Option Compare Text '字符串不区分大小写Option Base 1 '指定数组的第一个下标为 12、On ... 阅读全文

posted @ 2014-11-18 13:04 jefflu99 阅读(673) 评论(0) 推荐(0) 编辑

SAP MRP strategy group 策略组探讨

摘要：How Strategy 40 - Planning with Final Assembly Works 40： MTS ; normally , it is for standard parts . Strategy 40 :-1. Stocks on hand reduces the PIR d... 阅读全文

posted @ 2014-11-17 22:09 jefflu99 阅读(3062) 评论(0) 推荐(0) 编辑

Physical Inventory Process (ERPGreat)

摘要：Physical Inventory ProcessWhat are the step to do physical inventory process? I want to make zero stock and then upload the actual stock?First you ca... 阅读全文

posted @ 2014-11-02 21:36 jefflu99 阅读(418) 评论(0) 推荐(0) 编辑

MM - Physical Inventory Concept

摘要：Physical Inventory is a Process in which Company Stops all his Goods Movements and Do a Physical inventory Manually.To avoid Inconsistencies which may... 阅读全文

posted @ 2014-11-02 21:28 jefflu99 阅读(456) 评论(0) 推荐(0) 编辑

How to do Physical inventory process in Warehouse SAP仓库盘点流程

摘要：Please go with following transactionMI01>Create physical inventory document>Enter Document Date>Planned count date>Plant Code>Storage Location>Click o... 阅读全文

posted @ 2014-11-02 20:17 jefflu99 阅读(1062) 评论(0) 推荐(0) 编辑

^^^ 存货盘盈盘亏的账务处理 Accounting for Inventory Profit and Inventory Loss with Goods Stock

摘要：Accounting for Inventory Profit and Inventory Loss with Goods Stock 第一，存货盘盈的处理。企业发生存货盘盈时，借记“原材料”、“库存商品”等科目，贷记“待处理财产损溢”科目。再按管理权限报经批准后，借记“待处理财产损溢”科目，贷记... 阅读全文

posted @ 2014-11-02 18:58 jefflu99 阅读(904) 评论(0) 推荐(0) 编辑