upgrade2.9-2.9a.sql

java开源项目源代码

INSERT INTO `Help` VALUES (14, 102, '<font size="+2"><b>Inventory Categories</b></font>\r\n<br><br>\r\nInventory Categories are the natural groupings which apply to certain types of stock. A business will normally have several distinct categories. E. g. A manufacturing jeweller might have stock categories for gold chain, silver chain, diamonds, rubies etc.\r\n<br><br>\r\n<font size="+1"><b>Inventory Category Code</b></font>\r\n<br><br>\r\nThis is a six character text field which is the reference used internally by the system. The category code must be unique between different categories. It cannot be changed retrospectively and cannot be deleted where stock items are set up to use the category, or sales analysis records exist using the category. The category code is stored against sales analysis records for reporting. All stock items must be defined as belonging to a category and has the appropriate category code stored against it in the StockMaster table.\r\n<br><br>\r\n<font size="+1"><b>Inventory Category Description</b></font>\r\n<br><br>\r\nThis description is used in searches for stock items and in sales analysis reports to describe the category of stock referred to. Up to 20 characters of text can be entered, although on some reports less than the full description will appear. \r\n<br><br>\r\n<font size="+1"><b>Balance Sheet Inventory GL Account</b></font>\r\n<br><br>\r\nThis is the general ledger account where system-created standard costing journals will post the balance sheet entry. It is possible to set up a GL account for each stock category or to post all raw material stock categories to a raw material general ledger account and similarly for finished goods stock categories. The select box lists all the available balance sheet accounts - profit and loss accounts will not show. If a new general ledger account needs to be set up this should be done first. This field will not be used if the company preferences flag for "Create GL entries for stock transactions (at standard cost)" is not enabled.\r\n<br><br>\r\n<font size="+1"><b>Inventory Adjustments GL Posting Account</b></font>\r\n<br><br>\r\nThis is the general ledger account where the system created standard costing journals will post the profit and loss entry to for stock adjustments. It can be different for any or all stock categories. The select box lists all available profit and loss accounts. This field will not be used if the company preferences flag for "Create GL entries for stock transactions (at standard cost)" is not enabled.\r\n<br><br>\r\n<font size="+1"><b>Purchase Price Variance Account</b></font>\r\n<br><br>\r\nThis general ledger account is used by accounts payable invoice entry to post variances between standard cost and the actual cost of stock items of this category. Price variances are calculated when the purchase invoice is entered, unless the purchase order item is on a shipment. Shipment purchase price variances are calculated when the shipment is closed. This field will not be used if the company preferences flag for "Create GL entries for stock transactions (at standard cost)" is not enabled.\r\n<br><br>\r\n<font size="+1"><b>Material Usage Variance Account</b></font>\r\n<br><br>\r\nNOT YET IMPLEMENTED: \r\n<br><br>\r\nThis general ledger account is used by the works orders to post the variances between the actual material issued to a work order and the standard requirements of the work order based on the number of finished items resulting from the work order. This field will not be used if the company preferences flag for "Create GL entries for stock transactions (at standard cost)" is not enabled.\r\n<br><br>\r\n<font size="+1"><b>Type of Resource</b></font>\r\n<br><br>\r\nNOT YET IMPLEMENTED: \r\n<br><br>\r\nThis field declares the type of resource that the stock category represents and is one of Finished Goods, Raw Materials, Labour or Dummy Inventory. This field is used to distinguish labour type stock items from other components for the purposes of calculating work centre overhead in the cost roll up. It is also used for ordering stock reports to ensure raw materials and finished goods are grouped together.', 'S');
INSERT INTO `Help` VALUES (15, 48, '<font size="+2"><b>Inventory Location Maintenance</b></font>\r\n<br><br>\r\nA table of locations is maintained which contains a location code of 5 characters and the location description (up to 20 characters). The description is the field used in lookups on invoicing and crediting. To keep the database as compact as possible it is the code which is stored against stock movement transactions. As many locations as required can be set up. When a new location is defined, location records for all items in the database are created. When a location is deleted, so too are all the item location records. However, a location record cannot be deleted if there are stock movements or stock held for any part in the location. Since the location represents the physical location from where goods/services are supplied it is important for determining the tax applicable on a sale. The governing tax authority must specified with the location record. It is used in the calculation of the applicable rate of tax in conjunction with the tax authority of the customer branch being delivered to and the tax level of the item being sold.\r\n<br><br>\r\nNote: Location codes cannot be modified retrospectively. Neither can they be deleted if there are stock movements, users (default location) or customer branch records set up to receive stock from the location.', 'S');
INSERT INTO `Help` VALUES (16, 100, '<font size="+2"><b>Inventory Adjustments</b></font>\r\n<br><br>\r\nInventory can be written on or off for individual stock items using this option. Corrections to physical stocks and deliveries of stock can be entered using this option. Adjustments can be entered by selecting the link on the SelectProduct.php page or directly from the menu under transactions. Using the second link, the item code must be known, there is no facility to select an item code from this page. \r\n<br><br>\r\nIf Stock GL integration is enabled from the company preferences page (under the setup tab), then the system creates the necessary journals in the general ledger to update the stock account and the profit and loss account stock adjustment account specified in the stock category record. (see Inventory Categories above and also see General Ledger Integration later)\r\n<br><br>\r\nNote: Inventory Adjustments are not possible with kit set, assembly or dummy stock items since no stock record is maintained for these items.\r\n<br><br>\r\nInventory adjustments for controlled items must select the batches/serial numbers being adjusted.', 'S');
INSERT INTO `Help` VALUES (17, 117, '<font size="+2"><b>Inventory Location Transfers</b></font>\r\n<br><br>\r\nTransfers of inventory between locations need to take stock off the sending location and increase the stock in the receiving location. This is effected in one transaction by entering a stock transfer. In the same way as adjustments these can be accessed either from the SelectProduct.php page which is linked to from every page on the top header banner or directly from the menu - inventory tab under the transactions section. All that is required is the location from and to, the date and the quantity being sent. If the business wishes to record inventory in transit an additional in transit location needs to be established and a transfer to the transit location performed when the stock is dispatched and a further location transfer from the transit location to the receiving location when the stock is received. Stock location transfers are shown on stock movement inquiries.\r\n<br><br>\r\nNote: Inventory Location Transfers are not possible with kit set, assembly or dummy stock items since no stock record is maintained for these items.\r\n<br><br>\r\nBulk inventory transfers consisting of many parts can be set up effective from 2.9. These allow a docket to be produced to be sent with the dispatch of the goods. The transfer is not actually effected until the transfer is received in by the receiving stock location.', 'S');
INSERT INTO `Help` VALUES (18, 115, '<font size="+1"><b>Inventory Status inquiries</b></font>\r\n<br><br>\r\nShows the detail of how much stock is held and where the stock is (i.e. how much at each location) together with the total quantity of sales orders for the part outstanding and the quantity of the item on outstanding purchase orders can also be viewed from this inquiry. Not only are outstanding sales orders for this part accumulated but all the demand for parent assembly parts as extended by the quantity required per unit of the parent. This ensures that all demand for the part is shown.\r\n<br><br>\r\nThis - and all stock inquiries are called from the SelectProduct.php page - this page is linked to from every page in the system from the header links "Select Item". Once an item is selected the relevant inquiry options are displayed. As  with all web pages produced by the system most browsers have good facilities to print them. \r\n<br><br>\r\nIf the item selected is a controlled item then the status inquiry will also show a link to show the batches. If the item is serialised, the link will refer to the serial numbers rather than batches. ', 'S');