Sage_ERP_X3_ETO_module introduction

一个根文件夹（Root Folder）是一个标准版本应用，其他的文件夹
是“客户”文件夹，它们由根文件夹产生，每个都代表一个独立的应
用。
注：文件夹在 Oracle 对应为表空间。
应用服务器
它授予访问所有构成应用的元素（处理，屏幕，报表）的权限。这些 元素按照文件夹被组织在目录中，子文件夹的元素可以继承自母文件 夹，并拥有自己独立的特征。
Sage ERP X3 系统的数据库数据量和连接数量特征
数据量 连接数量
安装完成 1.5G 4
基本数据登记完毕 2.5G 4+n [n：X3 客户端数量]
每年增长
1-2G 客户端连 接的增长
特征 数据量和交易量成正比 连接数量可以调整
我们对 X3 系统的数据库，突出两点： 数据安全：数据库实施完成，马上要实施完整的备份方案，确保业务数据的安全； 运行效率：随着业务系统的运行，用户量和连接数量等的变化，要适时调整数据库。
Sage ERP X3 信息技术基础架构实施和运行维护技术白皮书 | 上海蒙马软件技术有限公司
Sage ERP X3 信息技术基础架构实施和运行维护 技术白皮书
2008 年 8 月 版本：2.0
目录
一、Sage ERP X3 信息技术基础架构 .........................................................................................2 二、Sage ERP X3 数据库运行特性 .............................................................................................4 三、Sage ERP X3 信息技术基础架构配置建议 .........................................................................5 四、Sage ERP X3 数据库规划和配置建议 .................................................................................6 五、Sage ERP X3 扩展性和远程接入配置建议 .........................................................................8 六、Sage ERP X3 数据备份配置建议 .......................................................................................10 七、Sage ERP X3 数据库灾备配置建议 ...................................................................................11 八、Sage ERP X3 信息技术基础架构维护建议 .......................................................................12 九、Sage ERP X3 基础架构服务项目 .......................................................................................14 十、培训课程列表.........................................................................................................................15 十一、成功案例.............................................................................................................................16

警示灯项目状态矩阵
Criticality Project Project line Bill of materials Purchase order 0
Total budget=0
By default
White 1
Green 2
Yellow 3
Orange 4
Red 5
According to lower levels According to lower levels (available stock + expected stock) >= requirement Expected date of receipt = today (past start date) AND (the WO has not commenced) (available stock + expected stock) >= requirement Expected date of receipt overrun
Budget
ቤተ መጻሕፍቲ ባይዱ
Gap
Invoice
• Version • Schedule • Phase
• Purchace • WO • Sub Contract
• Invoicing • Time • Lots
• Analyze
• Monitoring Progress
3 I Date
Title of the Presentation
-
-
By default
(End date = today) AND (the WO is in progress) past dispatch date (DN validated) AND (past dispatch date)

Sage ERP X3 FinanceFinanceSage ERP X3 Finance covers financial, personal, cost, and budget accounting, commitments, and fixed assets.The finance capabilities of Sage ERP X3 can handle transfers and reporting of information from one country to another, and between subsidiaries and their headquarters. Sage ERP X3 combines decentralized and international company financial management. The flexible accounting structure (multiledger and multichart of accounts) guarantees a real-time global vision while responding to local operational requirements such as legal, analytical, and reporting preferences.Particularities relating to different legislations are integrated as early as the product design stage: Predefined accounting systems, with payment entries involving up to four accounting steps; user definition of bank files, open-ended and adapted to national format; management of fiscal and excise taxes and associated returns (hard-copy or magnetic format according to legislation); fee and sales returns; closing of financial periods in successive stages or simplified form; and more.Local particularities are centralized and packaged to provide a single solution irrespective of working language or country. Functional comprehension and maintenance of these environments are simplified.Sage ERP X3 offers multicurrency processing features that provide the ability to calculate transaction amounts, produce reports, and restate values in different currencies. Amounts can be expressed in the currency of the company, the business partner, or a user-defined reporting currency. Sage ERP X3 maintains all currencies and exchange rates in a single table and provides immediate conversion to alternate values on demand within any business transaction. Invoices and payments can be accepted and issued in varying currencies. Sage ERP X3 provides full accounting of exchange rate variances and automatically posts them to the appropriate general ledger (GL) gain or loss accounts.General LedgerMulti-LedgerSage ERP X3 associates a company to an “accounting model,” which can be used by several companies. Each model consists of up to ten sharable ledgers, each one associating one currency, one sharable chart of accounts, and up to ten user defined analytical sharable dimensions. The ability to parameterize and apply flexible rules allow the generation of multiple GL entries, helping to avoid restatements and double entries.GL Accounts and Fiscal CalendarsSage ERP X3 General Ledger supports multiple companies and sites and allows an unlimited number of fiscal calendars to be defined with up to 24 open periods per calendar. A special period can be used for year-end postings. Account numbers can be expressed in fixed or variable lengths and can be identified by a short mnemonic. Accounts can also be defined as “collectives,” permitting customer and supplier sub-ledger information to be fully integrated within the GL.Automatic JournalsSage ERP X3 supports manual, simulated, template, recurring, and reversing journal entries. Entries can be saved in a temporary state prior to final posting. Simulated journals can be active or inactive, allowing for different levels of “what-if” scenarios. Recurring journals can be fixed by period or variable with the ability to allocate an amount according to monthly weighted distributions. Accruals can be defined to reverse automatically on a predefined date. User-defined allocation structures and formulas can also be defined and processed automatically, with multipass capability.Intercompany TransactionsIntercompany customer and supplier invoices and intercompany GL journal entry functions are valuable to any organization that shares resources between legal entities. Managing intercompany customer and supplier invoices within Sage ERP X3 increases productivity for users by creating a single document that automatically generates the necessary journal entries and recording the financial transaction for both companies.Analytical DimensionsSage ERP X3 supports user-defined analytic dimensions for budgeting, allocations, and analysis. Dimensions can be both financial- and quantity-based. Dimension views can be defined to be analyzed from a specific standpoint, such as sales by channel or by product line. Dimensions can support any number of groupings of up to 99 levels to permit access to varying levels of account information with drill down for a cumulative to a detailed view.BudgetingBudgets can be defined based on dimension views, at various grouping levels, in the company currency or multiple currencies, in financial and quantity form, and with an unlimited number of revisions. Sage ERP X3 supports commitment accounting with budget comparisons against pre-committed and committed amounts from Purchasing.Budget control allows users to check the balance between expenses and commitments in order to make sure that forecasted expenses will not exceed the budget. The associated workflow can follow different approval rules according to the amount, the user, or other company specific criteria. This provides a continuous view of internal and external projects. Budgets can be manually entered, uploaded from spreadsheets, or calculated online with user-defined formulas based on elements such as previous budgets and actual prior period amounts, adjusted according to seasonal distributions.Account InquiriesSage ERP X3 provides the ability to research financial activity easily through a number of account, account balance, dimension, and dimension balance inquiries. Users can zoom in on selected accounts to view varying levels of detail. All business partner collective account activity is fully integrated in the general ledger so users are not obligated to look in different sub-ledgers to locate the information they need. Bi-directional auditing allows users to track of any transaction from origin to posting or vice versa.Financial Extraction and ReportingSage ERP X3 provides a powerful, financial-oriented data extraction for all inquiry and reporting needs. Used in conjunction with a solution like Sage Intelligence-Financial Reporting, users can easily design and generate all company-specific operating statements, balance sheets, and other financial reports and inquiries. Sage ERP X3 provides a number of report-building tools, such as row and column content and formatting flexibility, as well as content restriction facilities such as reporting and company group codes.Sage ERP X3Accounts Receivable and Accounts PayableBusiness PartnersSage ERP X3 provides the ability to define a business partner and identify relationship types including customer, supplier, carrier, and sales rep. For each type, the various roles and associated information can be defined, such as customer ship-to, bill-to, and pay-by as well as supplier buy-from, invoice-from, and pay-to information. Any number of partner contacts and addresses can be identified, such as supplier return-to locations. By maintaining all relationship data and financial business transactions in concerted fashion, companies can view business activity for a given business partner across all aspects of the relationship, thereby improving their ability to fully assess the value of their relationships.AR Item and Collections ManagementSage ERP X3 supports comprehensive item management and control over prepayments, installment payment due dates, statements, and past-due invoices. A flexible payment application function is provided, permitting users to enter payments on account, apply them fully or partially against specific invoices, or across a range of invoices based on user-defined criteria. Automatic matching is also supported. The cash collection process can be streamlined by allowing entry fields and the timing and sequence of steps—bank selections, deposit slips, and GL postings—to vary by payment type. This allows credit cards, EFTs, and checks to have their own processing rules. Sage ERP X3 also accommodates returned checks and full reinstatement of the original items.Recurring Customer and Supplier InvoicesRecurring customer and supplier invoicing is ideal for regularly scheduled payments, such as installment payments, subscriptions, leases and rent (AP/AR) as well as fixed cost expenses including ISP charges or insurances within AP. Sage ERP X3 users can take full control over how and when these payments take place in order to improve renewals and reduce late payments.Automatic Financial IntegrationSage ERP X3 AR/AP provides parameters that control the flow of information from other Sage ERP X3 functional domains. Customer and supplier invoices automatically generate open items that form the basis for ensuring optimal cash management. Miscellaneous sales and purchases are recorded using a full-featured manual invoice entry function.AP Disbursements ManagementSage ERP X3 provides complementary functionality in Accounts Payable for supporting prepayments, installment payments, and user-defined payment entry and processing steps by payment type. Users can easily locate invoices to pay based on their own selection criteria, such as due date, minimum and maximum payment amounts, and currency. Check writing, bank account selections, payment voiding, and bank statement reconciliation are also fully supported. Purchases are recorded using a full-featured manual invoice entry function. Accounts Payable and Accounts Receivable Terms DiscountsIncrease customer loyalty and be more competitive by using the new Accounts Payable (AP) and Accounts Receivable (AR) Terms Discounts functionality. These enhancements provide you with the ability to apply early payment discounts, such as 2% 10 Net 30, to both AP and AR using a specified date range, or to always apply the discount. You can also set discounts based on the number of allowance days, or the grace period, that you want to continue to allow the discount to be taken. You have the option to discount the total amount including, or excluding, any additional charges such as freight and sales tax.Sage ERP X3 Fixed AssetsSage ERP X3 Fixed Assets provides an international solution for maintaining all the information required to track and manage a firm’s property, plant and equipment, and associated costs. The system calculates depreciation based on commonly used formulas and tables required for many non-US companies. Implementing Sage ERP X3 Fixed Assets can result in significant time savings so you can focus on more critical operational areas. It is fully integrated with Sage ERP X3 Purchasing, Accounts Payable, and General Ledger. Companies looking for U.S. Tax law depreciation updates can choose to integrate Sage Fixed Assets to update the appropriate GL accounts.Sage Fixed Asset IntegrationIf your business requires more than the base fixed assets management capability included in Sage ERP X3, integration is now available with Sage Fixed Assets. Not only does Sage Fixed Assets help eliminate redundant data entry, increase accuracy, and reduce costs, it also helps guard against regulatory noncompliance—a particularly important point if you need to depreciate your fixed assets. With over 300,000 IRS tax and GAAP rules built in, as well as more than 50 depreciation methods and an intuitive interface, Sage Fixed Assets offers comprehensive depreciation calculations for financial and tax reporting.For a detailed listing of finance functionality available through Sage ERP X3 please reference the Sage ERP X3 Solution-In-Detail.About The Sage Group plcWe provide small and medium-sized organizations with a range of easy-to-use, secure, and efficient business management software and services—from accounting and payroll to enterprise resource planning, customer relationship management, and payments. Our customers receive continuous advice and support through our global network of local experts to help them solve their business problems, giving them the confidence to achieve their business ambitions. Formed in 1981, Sage was floated on the London Stock Exchange in 1989 and entered the FTSE 100 in 1999. Sage has over 6 million customers and more than 12,700 employees in 24 countries covering the UK & Ireland, mainland Europe, North America, South Africa, Australia, Asia, and Brazil.For further information please visit .©2014 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are the property of their respective owners. Sage ERP X3Fixed Assets。

SAGE x3 库存管理声明本文所含信息代表了SAGE 公司在本文公布时的观点。

因为SAGE 必须响应持续变化的市场条件，这些信息不应被视为SAGE 方面的承诺，同时SAGE 也不能保证本文公布之后其他任何信息的准确性。

本文档仅供参考。

SAGE 对本文档中的信息不提供任何形式的（包括明示或暗示的）保证。

版权用户有责任遵守所有适用的版权法。

在版权法所给予权益的前提下，未经SAGE 明确的书面许可，任何人不得将本文复制、储备或引入可检索系统，或是以任何形式或通过任何方式（电子、机械、影印、录制或其他方式）传播本文的任何部分。

商标本文主题可能涉及SAGE 的专利、专利申请、商标、版权或其它知识产权。

除非获得SAGE明确的书面许可，否则提供本文档并不代表许可您使用这些专利、商标、版权或其它知识产权。

目录1 差不多介绍51.1 库存治理的内容5 1.2 与其他模块的联系51.3 常用参数设置52 基础设置52.1 产品52.2 库位52.2.1 库位类型52.2.2 库位的分配82.2.3 分拣库位的补货93 存货的属性103.1 批次和次级批次11 3.2 序列号123.3 货盘号及容器号134 存货的状态134.1 状态及子状态13 4.2 质量操纵134.3 技术列表144.4 状态变更174.5 浓度治理174.6 过期治理185 存货入库185.1 介绍185.2 入库交易195.2.1 采购收货195.2.2 其他收货195.3 存货储备196 存货出库206.1 介绍206.2 存货分配和出货规则20 6.3 出库交易206.3.1 销售出货206.3.2 其他出货217 存货装配217.1 存货装配217.2 存货反装配218 存货移库228.1 内部移库228.2 分包商移库229 存货调整239.1 库存变化2310 库存盘点2311 会计接口2512 查询2613 外协业务处理2613.1基础数据2613.2业务处理2813.3 成本运算291 差不多介绍1.1 库存治理的内容1 按照企业结构定义库存组织结构2 定义和爱护物料3 操纵和跟踪物料4 采购订单同意和销售订单发货5 处理采购退货和销售退货6 进行物理盘点和周期盘点以检验现有量 1.2 与其他模块的联系1.3 常用参数设置2 基础设置2.1 产品参见《基础数据功能手册》“产品表”一章。