upgrade2.9-2.9a.sql

java开源项目源代码

INSERT INTO `Help` VALUES (9, 12, '<font size="+2"><b>Setting Up A System</b></font>\r\n<br><br>\r\nFor the company logo to appear on the each screen, it must be saved in the format of a .jpg file and be copied to the file logo.jpg in the directory with all the other php scripts. The logo needs to have read permissions for the user that the web server is running as normally "nobody" for apache on linux. Permissions issues are a none issue under windows.\r\n<br><br>\r\nCompany parameters need to be set correctly from the company set up screen. Most of these parameters are self -explanatory. Company name, company number, postal address, physical address etc. Also, telephone numbers and the default home currency of the business. If the default currency is not already set up, then from the main menu system set up tab, the link to the currency maintenance form allows new currencies to be defined and for default rates to be updated.\r\n<br><br>\r\nThe company record also provides a convenient place to store default GL codes for:\r\n<br><br>\r\n<ul>\r\n<li>Debtors Control GL Account:\r\n<li>Creditors Control GL Account: \r\n<li>Payroll Net Pay Clearing GL Account:\r\n<li>Goods Received Clearing GL Account:\r\n<li>Retained Earning Clearing GL Account: \r\n<li>Freight Re-charged GL Account: \r\n<li>Exchange Variances GL Account: \r\n<li>Sales Exchange Variances GL Account:\r\n<li>Purchases Exchange Variances GL Account: \r\n<li>Payment Discount GL Account:\r\n</ul>\r\nA default chart of accounts is set up. However, in most cases the company will wish to adopt the chart of accounts it has used traditionally. Chart of accounts maintenance - deletion of accounts and adding of new accounts is done from the General Ledger tab. This would be a starting point for data input of a new system. Where the GL integration features are to be used, setting up the chart of accounts will be a necessary first step.\r\n<br><br>\r\nThe company record also records the GL integration set up:\r\n<br><br>\r\n<ul>\r\n<li>Create GL entries for accounts receivable transactions\r\n<li>Create GL entries for accounts payable transactions:\r\n<li>Create GL entries for stock transactions (at standard cost): \r\n</ul>\r\nNotice that the stock GL integration is a separate flag. If GL integration of accounts receivable is set to yes, then GL journals are created for invoices and credits to sales and debtors but not for cost of sales and stock. For the later integration this requires that the GL entries for stock transactions be set to yes also.', 'S');
INSERT INTO `Help` VALUES (10, 119, '<font size="+2"><b>Adding Inventory Items</b></font>\r\n<br><br>\r\nEntry of new items requires the input of certain base information:\r\n<br><br>\r\n<ul>\r\n<li>Base information about the Code and description together with the category and item type.\r\n<li>Cost information\r\n<li>Supplier purchasing data\r\n<li>Selling prices\r\n</ul>\r\nEntry of the base information is done from the menu, select the inventory tab and click "Add a New Inventory Item". \r\n<br><br>\r\n<font size="+1"><b>Item Code</b></font>\r\n<br><br>\r\nA stock code is required for each stock item, this can be any combination of characters up to 20 characters long. The coding structure of stock items should be considered, to ensure that like stock items appear together. Internally the system looks at the code to order stock items in the various look up tables. A systematic approach to naming stock items can save a lot of time later. Under supplier purchasing data it is also possible to record the supplier\'s part number against an item.\r\n<br><br>\r\nThere is a script that allows for stock codes to be modified retrospectively, the script goes through all the tables necessary, location stocks, bills of material, order details, purchase order details, sales analysis etc to ensure that all history for the new part code follows the change. The script together with all utility scripts is available from Z_index.php (there are no links to this utility menu - due to the dangerous nature of some of the utilities) The stock code change script itself is named, Z_ChangeStockCode.php.\r\n<br><br>\r\n<font size="+1"><b>Part Descriptions</b></font>\r\n<br><br>\r\nA description of the stock item - can be up to 50 characters long. A description is required for each stock item. This description is used in the look up boxes provided each time the stock item is invoiced, credited or adjusted. There is also the facility to enter long descriptions for each part which show on the screens that customers could access to place orders. This field allows very long descriptions or even features and benefits to be described for the item. The intention for this field is that it could be used for producing a company catalogue or for online ordering by customers who may need more information about a product. It is only the description (short) that displays on invoices and credit notes.\r\n<br><br>\r\n<font size="+1"><b>Categories</b></font>\r\n<br><br>\r\nThese categories need to be set up first - from the System Setup tab of the menu. In selecting the stock category, be aware that the system uses the category information for analysis and summary reporting as well as identifying accounts for standard cost general ledger integration, if this option is enabled. There is a link to create new stock categories from the stock item entry page.\r\n<br><br>\r\nA stock category is required for all stock items. The stock category is a text field which groups like stock items together. In selecting stock it is often useful to restrict the search to just the category required. A stock category select box shows on the Select Product screen for this purpose.\r\n<br><br>\r\n<font size="+1"><b>Unit of Measurement</b></font>\r\n<br><br>\r\nThis field describes how the stock is to be maintained and is self-explanatory. It is a compulsory field. The selection list is maintained in config.php as an array variable. To add or delete other units of measurement the array variable called $InventoryUnits defined in config.php must be edited by the system administrator.\r\n<br><br> \r\n<font size="+1"><b>Economic Order Quantity</b></font>\r\n<br><br>\r\nThis is the quantity that new orders are made or purchased in by default. Currently this is purely for memorandum - in future this will be a critical part of the MRP calculations.\r\n<br><br>\r\n<font size="+1"><b>Packaged Volume</b></font>\r\n<br><br>\r\nThis field is required for freight calculations. It records the volume of the one of the item as packaged for dispatch. See the section on freight calculations.\r\n<br><br>\r\n<font size="+1"><b>Packaged Weight</b></font>\r\n<br><br>\r\nThis field is required for freight calculations. It records the weight of the one of the item as packaged for dispatch. The freight calculation takes the higher of the freight costs based on the total weight of the order and the total volume of the order. Most freight companies use a conversion and charge the higher of the two. See the section on freight calculations.\r\n<br><br>\r\n<font size="+1"><b>Units of Measure</b></font>\r\n<br><br>\r\nA select box allows the units applicable to the item to be selected from the array of $StockUnits defined in config.php. The unit of measure will show on all invoices and on stock inquiries.\r\n<br><br>\r\n<font size="+1"><b>Current or Obsolete</b></font>\r\n<br><br>\r\nIf this field is set to obsolete, this indicates that the stock item is no longer used. However, there may be a stock history on invoices and credit notes which are required. The stock item master record is therefore still required. (Deletion is not allowed while stock movements or Sales analysis records exist for the part) However, it will not appear on searches for invoicing, stock items, in addition the item will be flagged as discontinued in stock reports.\r\n<br><br>\r\n<font size="+1"><b>Make Or Buy</b></font>\r\n<br><br>\r\nThis field is compulsory and indicates whether the stock item is:\r\n<br><br>\r\nManufactured\r\n<br><br>\r\nPurchased from an external supplier. \r\n<br><br>\r\nAn assembly of other stock items. An assembly item does not have a physical stock holding itself, nor has it a cost. An invoice for an assembly item creates the stock movements for all the components of the item and the stock of each of the components in proportion to the requirements specified in the bill of material are decremented. The cost of sales entries in the general ledger journals created by an invoice (if the link is active) is created at the sum of the costs of all the items in the bill of material for the assembly as at the time of invoicing.\r\n<br><br>\r\nA kit set of other stock items that should be exploded into its components when ordered. A kit set is not a physical item itself it is just a short cut to entering a number of parts onto an order. Unlike an assembly, the kit set part does not appear on invoices or orders, but "explodes" into its component parts for modification. It follows that kit sets do not have any cost or physical stock quantities associated with them.\r\n<br><br>\r\nA dummy item that has no physical stock associated with it.\r\n<br><br>\r\nThis field is relevant for MRP and production scheduling. This field can also be set to Dummy Inventory Item - which then disables stock quantity tracking at the locations and in total. Dummy stock items are used for invoicing services and labour or even physical items which do not require tracking. The stock movement records are still created and are available to recall on invoicing and credit note inquiries. Inventory adjustments are not allowed for Dummy Inventory Items. Assembly items can have sales analysis records created for them, but no stock quantity is maintained and stock movement records are created for the components. Assemblies would normally be used where the warehouse keeps the components of the item for several different purposes and only assembles the items as they are picked for dispatch.\r\n<br><br>\r\n<b>Setting Up Assembly Items</b>\r\n<br><br>\r\nUsing the example of toilet suites, where the business wishes to keep track of how many sold - i.e. The sales analysis - but only wishes to track the quantities of stock held of the toilet pans and toilet cisterns that make up the suite.\r\n<br><br>\r\nThe business will never want to hold stock of made up suites, when stock is counted only cisterns and pans are counted not suites. If there are any made up suites these would need to be broken down into their components and the components included in the stock counts.\r\n<br><br>\r\nSuch parts are called "Assembly" items by the system.\r\n<br><br>\r\nWhen an assembly item is invoiced, the stock of the components of the assembly are decreased by the quantity in its bill of material multiplied the number of the assembly item sold.\r\n<br><br>\r\neg. A suite that has 2 screws in it to screw the pan to the floor might have a bill of material:\r\n<br><br>\r\n1 x cistern\r\n<br>\r\n1 x White S trap pan\r\n<br>\r\n2 x Pan screws\r\n<br>\r\n1 x pan pac carton\r\n<br><br>\r\nIf the sale was for 10 of these - the stock of the cistern, pan and pan-pac cartons would be reduced by 10 and the stock of the pan screws would be reduced by 20. The stock movement inquiry shows this movement and the reference to the assembly item that it came from and the invoice number it was sent out on.\r\n<br><br>\r\nIt is important to remember that when an assembly item is credited this process happens in reverse - stock is booked back into the components in exactly the same way as it is invoiced out. The credit note must be entered against the correct stocking location otherwise the pan and cistern stocks in the location where the stock did get returned to and the location where the credit note was entered to will be wrong. There is facility to write the stock off at the time of credit note entry also - in this case the stock location is not important.\r\n<br><br>\r\nThis next point is a little confusing. The system also shows the movement of assembly items in the movement inquiry for the assembly item itself. This does have the advantage of showing to whom the assembly items have been sold at a glance. However, there are no stock status inquiries for assembly items since they are not stocking items (only the components are held and picked to make up the assembly item at the time of dispatch).\r\n<br><br>\r\nWhen parts are first set up - the description and stock category needs to be defined and it is at this point that the type of item is defined - from the heading on that screen titled - "Make, Buy, Kit, Assembly or Dummy Part". The choices are "purchased" - the default, "manufactured", "assembly", "kit-set" or "dummy". \r\n<br><br>\r\nConsidering the treatment of assembly items:\r\n<br><br>\r\nIf there is stock of an item as shown on the stock status screen - then it is NOT possible to convert the item to an assembly by changing this flag - the stock must first be adjusted back to nil and the corresponding component stock adjusted up. Also, if there are purchase orders for the item - it cannot be converted to an assembly. Remember the assembly part does not exist as a separate part only as an assembly of real stock items for the purposes of selling.\r\n<br><br>\r\nHaving set the part to be an assembly, then the part will show an option on the "Select Item" menu to show the costed bill of material. This inquiry shows the current Bill Of Material (BOM) for the assembly together with the cost of each of the components and the total of the costs that is used in the sales analysis and general ledger postings.\r\n<br><br>\r\nSetting up an assembly part requires setting up A Bill Of Material - BOM for the item.\r\n<br><br>\r\nFrom the manufacturing tab of the main menu - under the Maintenance section - click the link "Bill Of Material Maintenance". The item search fields show with the option to enter either an extract from the item description or the item code. Having entered the selection click on the "Search Now" button. Not all items will show - only those items that can have a BOM - assembly items, manufactured parts and kit-sets. If the part is not defined as an assembly item - it won\'t show up! \r\n<br><br>\r\nClicking the part code button will then show a screen for entering components to make up the BOM. If a BOM already exists for the item it will show the components already set up. There are two links next to each item shown in the current BOM to enable the line to be edited or deleted.\r\n<br><br>\r\nTo enter a new component into the BOM for an assembly, all that is required is to select the component code from the list - the location and work centre are not used for assembly items so the default can be accepted as is. (The location specified in the sales order is used for all the assembly components stock entries.) The quantity required of the component for each assembly item is required to be entered - it defaults to 1 (and maybe 1 in most cases).\r\n<br><br>\r\nThe effectivity dates - effective to and effective after (also known and engineering change control dates) are the dates between which the component is used in the assembly. If the BOM is due to change and customers have been advised that a new pan will be used in suites effective from 1 Jan 05 then the new pan could be entered as a component from that date. The existing pan effective to would have to be changed to be effective to 31 December 04. The alternative is to change all the BOMs on the day when the change is made.\r\n<br><br>\r\nOnce the component fields have been entered hitting the enter information button adds the component to the BOM there and then. When the BOM is complete just navigate to the main menu of other link to the next task. Be careful not to click enter information button on the default component by mistake - the component must be selected from the list first.\r\n<br><br>\r\n<font size="+1"><b>Controlled</b></font>\r\n<br><br>\r\nThis field denotes whether the item is to have lot control on it. Lot control is known by several terms including, batch control, bundle control, roll control. In short it allows a reference for each batch of the item to be entered at the time of delivery, transfer, stock check, invoicing etc. When booking in controlled items the batch references and the quantities in each batch must be entered. Many quality control systems that require traceability of raw materials need this functionality to establish what batch of raw material was used in a given work order. Or what roll of cloth was sold to a given customer. Other industries call their lots of product by different names a melt, a cut, a run etc. Every time a transaction involving a controlled item is created, the system will accumulate the quantity from a separate form for selecting the batches (Lot/roll/melt/work order/serial numbers).\r\n<br><br>\r\n<font size="+1"><b>Serialised</b></font>\r\n<br><br>\r\nSerialised is a special case of controlled where the batch size is always one. The system will prompt for the serial number of each item of stock being received and stock records will be maintained for all serial numbers separately. Serialised does not have any effect if controlled is not set.\r\n<br><br>\r\n<font size="+1"><b>Bar Code</b></font>\r\n<br><br>\r\nThis field is the unique identifying bar code for this item, typically containing the EAN bar code for the item. This field is used in identifying the item in EANCOM  edi messages.\r\n<br><br>\r\n<font size="+1"><b>Discount Category</b></font>\r\n<br><br>\r\nIs used in the discount matrix of discount categories and sales types. When an order is for an item with a discount category code and a customer of a sales type that has a discount matrix entry and the order is for a quantity more than the matrix quantity break figure, the system automatically enters the discount into the order lines for all items in that discount category. This allows quantity break discounts across a range of similar products.\r\n<br><br>\r\nThe discount category is a 2 character field and there is no error checking on entries.\r\n<br><br>\r\n<font size="+1"><b>Decimal Places</b></font>\r\n<br><br>\r\nSome items of stock require a number of decimal places to be retained and displayed, others do not require any. This field is used throughout the system for invoices, orders and all places where the item quantity is displayed.', 'S');
INSERT INTO `Help` VALUES (11, 104, '<font size="+2"><b>Inventory Costing</b></font>\r\n<br><br>\r\nFrom the menu select the inventory tab and Modify Standard Costs. The item code can be entered directly to show the current cost structure, modifications to costs in this screen are reflected in standard cost journals in the general ledger if the link is active in the Company Preferences page - (menu - System Setup tab). Alternatively, to select the stock item to modify the costs for the costing page can be called from the Select Item page - once an item has been selected - a link to the Select Item page is shown on the title bar of all pages. Maintenance and initial entry of cost data is a critical part of the system set up. Simply defining the item header is not sufficient on its own. The cost information entered here is used for both inventory valuation reports and for the general ledger integration stock journals created for the cost of sales, the cost value of stock adjustments, the value of stock received and so on. It can be omitted only if the user is not interested in the value of stock and no general ledger - stock integration is required.\r\n<br><br>\r\n<font size="+1"><b>Material Cost</b></font>\r\n<br><br>\r\nIf the item is bought in, this field should be the average or expected cost of the item. If the item is manufactured in house, it should be the cost of externally sourced materials plus the total cost of in house manufactured components, from lower levels in the bill. In future this will link to the Bill Of Materials cost roll up. Alterations to this figure affect the value of all stocks of this item held. The system is a standard costing system. When items are purchased the actual purchase cost is compared to this figure and a variance reported to the general ledger account set up in the stock categories record applicable to the item.\r\n<br><br>\r\n<font size="+1"><b>Labour Cost</b></font>\r\n<br><br>\r\nThis field should be the total standard cost of labour included in the cost of this stock item. The labour cost is the labour applicable only to this part not to the manufacture of components at a lower level in the bill of materials. The labour cost of componentry would be included in the material cost. Alterations to this figure affect the stock value of all stock held. See comments for Material Cost. In future, this field will be altered automatically on roll ups of cost.\r\n<br><br>\r\n<font size="+1"><b>Overhead Cost</b></font>\r\n<br><br>\r\nThis field should be the total overhead to be recovered on the sale of 1 unit of the stock item. Its value affects the value of all stock held of this item, as for labour cost and material cost above. Labour cost, Material cost and Overhead cost are all added together to get the total cost standard cost of a stock item. This total is the value applied to stock valuations. In future, the cost roll up will automatically update this field based on the work centre overhead rates and the quantity of labour at each work centre.\r\n<br><br>\r\n<font size="+1"><b>Standard Costing Considerations</b></font>\r\n<br><br>\r\nEach time a stock item is sold, the cost of sales account (specified by the COGS GL Postings table by reference to the stock category and sales area of the branch) is updated with the total of material cost, labour cost and overhead cost, and the stock value (the account specified in the stock category record) is decreased by the total standard cost. \r\n<br><br>\r\n<font size="+1"><b>Actual Cost</b></font>\r\n<br><br>\r\nThe actual cost is the last purchased cost as updated by the system on a purchase. For a manufactured item this is the actual cost as calculated including only efficiency variances (price variances are excluded)\r\n<br><br>\r\n<font size="+1"><b>Alterations To Labour Cost, Material Cost or Overhead Cost</b></font>\r\n<br><br>\r\nSince the system only maintains the one standard cost of items, this is the cost that stocks are valued at. In altering this cost all stock held of the stock item under review will be re-valued or devalued accordingly. If stock journals are being created (the option is set in the company preferences from the System Setup tab) then a system generated journal will be created for the effect on stock value using the general ledger accounts set up for the stock category currently defined for the stock item being changed.\r\n<br><br>\r\nOnly transactions entered after the charge will be created at the new cost. Sales analysis will refer to the costs as at the time when the transactions are created.\r\n<br><br>\r\nThere is a utility available from the Z_index.php page that allows the sales analysis for a specified period to be updated with the current costs. This utility takes the quantity sold and multiplies the current standard cost by the quantity to re-calculate the cost of each sales analysis record in the period selected - the sales analysis data is updated. This will mean that the general ledger costs will then differ to the sales analysis cost for the period since the general ledger postings are created at the time of invoicing/crediting.', 'S');
INSERT INTO `Help` VALUES (12, 91, '<font size="+2"><b>Selecting Inventory Items</b></font>\r\n<br><br>\r\nFrom all pages in the system the main title bar has links to select from the critical tables in the system. Customers, inventory and suppliers. Clicking on the "Select Item" link takes the user directly to the inventory item selection page. In addition, from the menu, the Inventory tab has a link to "Modify or Delete an Inventory Item Or Maintain Pricing". Using either method, the select item or product page will show.\r\n<br><br>\r\nThe search for a particular item can be narrowed by selection of a specific stock Category - a select box allows selection of the category. Also if some element of the code is known this can be entered, alternatively if some element of the description is known this can be entered - the description keywords are used if both a code and description fields are used. Note that the text entered into these fields does not have to be the start of the code or the description. All items with the text anywhere in either the code or the description respectively will be displayed, together with the total stock on hand and the unit of measure for the item. Assembles, kit-sets and dummy parts will all show zero stock on hand. \r\n<br><br>\r\nThe maximum number of resultant items can be defined by a parameter in config.php - this limits the number of records returned so that users over a lower bandwidth connection are not penalised for making too wide a selection. Downloads of significant amounts of data over a slower dial up connection would result in serious degradation in performance. By default this is set at 100 items.\r\n<br><br>\r\nClicking on the button of the code of the item that is required will select it and links to the options applicable to the item will be displayed. \r\n<br><br>\r\nHaving selected an item it is possible to modify:\r\n<br><br>\r\n<ul>\r\n<li>Item master information\r\n<li>Costs\r\n<li>Pricing\r\n<li>Reorder levels \r\n<li>Purchasing data\r\n</ul>\r\nIt is also possible to inquire on:\r\n<br><br>\r\n<ul>\r\n<li>Inventory Movements\r\n<li>Status - showing quantity on hand, on order with suppliers and on sales orders for customers by location\r\n<li>Historical usage by month\r\n<li>Outstanding sales orders\r\n<li>Outstanding purchase orders\r\n<li>Completed sales orders\r\n<li>Bill of Material\r\n</ul>\r\nFurther it is possible to initiate transactions to:\r\n<br><br>\r\n<ul>\r\n<li>Transfer stock between locations\r\n<li>Adjust stock quantities on hand.\r\n</ul>\r\nAt the bottom of this page, there is also a link to perform a fresh search for a different item.', 'S');
INSERT INTO `Help` VALUES (13, 119, '<font size="+2"><b>Amending Inventory Items</b></font>\r\n<br><br>\r\nThe master information is available for amendment. The only field that cannot be altered on the main stock item page, is the code. The code is used in many tables throughout the system and modification of the stock code would require data in many other tables of information to make corresponding changes. A special utility is available that allows stock code changes to be made. The changes to the database are extensive and it is recommended that this facility be run out of normal operating hours since the load on the server for the changes could be substantial in a large database. See special utilities. The following points should be considered when altering data fields:\r\n<br><br>\r\n<font size="+1"><b>Changing a Category</b></font>\r\n<br><br> \r\nThe Category of a stock item can be altered at any time. \r\n<br><br>\r\nHowever, if the stock journals option is active (in the company preferences set up), it should be remembered that the general ledger coding set up for that category can not be amended retrospectively. In other words, general ledger journals created for invoices, credit notes and stock adjustments created using the old category general ledger codes cannot be altered. The general ledger coding could be amended with a manual journal if necessary.\r\n<br><br>\r\nNote: Sales analysis done by Inventory Category is performed with the stock categories as they were when the invoice/credit was created. Inventory Category information is stored in the sales analysis table and cannot be changed retrospectively.\r\n<br><br>\r\n<font size="+1"><b>Alterations to the Make or Buy Flag</b></font>\r\n<br><br>\r\nA stock item that currently has stock cannot be changed to a Dummy stock item, an Assembly item or a kit set item. The system does not maintain stock quantities for these items and it is therefore inappropriate to have an initial stock quantity. The stock must be either invoiced, credited or adjusted to zero for all locations before this can be changed. Similarly, the system will only allow a Bill of Material to be set up for manufactured, assembly or kit set items. Altering a manufactured item (or assembly or kit set) which currently has a Bill Of Material to a purchased item is also disallowed, the BOM must be deleted first.', 'S');