upgrade2.9-2.9a.sql

java开源项目源代码

INSERT INTO `Help` VALUES (19, 111, '<font size="+1"><b>Inventory Movement inquiries</b></font>\r\n<br><br>\r\nInventory movements for the item show with the most recent movements at the top of the screen in descending order of date.\r\n<br><br>\r\nThis inquiry shows the movements of the stock item for a specified location with further links to the transaction detail that created the movements such as the invoice or credit note. By default only the last 3 months stock movements show but the date from which stock movements are displayed can be modified from the inquiry page.\r\n<br><br>\r\nNote: Inventory movement inquiries are possible on dummy and assembly stock items. However, since dummy items are not physical stock items, no record of the amount of stock and the location of where held (there is none held) are maintained. The location inquiry will always be zero for a dummy/assembly and kit set items. When a dummy stock item, or an assembly or kit set item is selected the link to the stock status inquiry is not available.\r\n<br><br>\r\nIf the stock movement was an invoice or a credit the customer and the price in the currency invoiced or credited will show. ', 'S');
INSERT INTO `Help` VALUES (20, 118, '<font size="+1"><b>Inventory Usage inquiries</b></font>\r\n<br><br>\r\nThis inquiry shows the quantity of the stock item that has been consumed either in sales net of credit notes and adjustments by month from each location. Transfers between locations are ignored as are deliveries. Usage of an item adds all the stock movement quantities for the part so that stock movements related to the sale of assembly items requiring the part under review as a component are included. Usage can be seen by location and also the total usage from all locations.\r\n<br><br>\r\nThere is a user modifiable flag which determines how many months of stock usage should be maintained for the item.', 'S');
INSERT INTO `Help` VALUES (21, 47, '<font size="+1"><b>Inventory Valuation Report</b></font>\r\n<br><br>\r\nThis report shows the stock on hand at the time the report is run as extended at the current standard cost. Both reports show the total quantity of stock held by Location and by Inventory Category. The detail report lists the individual stock items and value of each. Inventory items with no stock on hand are not printed out. This report can be run with only a selected inventory category and location, to reconcile the stock general ledger accounts.\r\n<br><br>\r\nA separate script is included in the distribution that can be set to run the stock listing report and email it to predetermined email addresses. To take advantage of this facility, the script must be called by wget under a linux distribution from a crontab entry on the last day of each month. The script is called MailInventoryValuation.php. This script will need to be edited with the email address of the user to receive the report and any parameters necessary to run the report. By default it produces a detailed report for stock at all locations. The entry in crontab in a linux installation that would send the report at 0:0 on the first day of each month (assuming wget is installed in /usr/bin/wget and that the web server is on the same machine) would be:\r\n<br><br>\r\n# Scheduled email of monthly Inventory Valuation report\r\n<br><br>\r\n-0 0 1 * * root /usr/bin/wget <a href="http://localhost/web-erp/MailInventoryValuation.php">http://localhost/web-erp/MailInventoryValuation.php</a>\r\n<br><br>\r\nsince the page has no output - it would be pointless running it in a web browser although it would initiate another email to the defined recipients.', 'S');
INSERT INTO `Help` VALUES (22, 46, '<font size="+1"><b>Inventory Planning Report</b></font>\r\n<br><br>\r\nThis report shows the usage of stock items over the previous four months together with the current stock, outstanding sales orders and outstanding purchase orders. It suggests a re-order quantity based on a number of months times the maximum of the previous four months monthly stock usage (from all stock locations), less the on hand stock and purchase orders. It will not suit all purposes but certainly does provide good information from which to base purchasing decisions.\r\n<br><br>\r\nThe Inventory Planning Report is run from the Inventory tab of the main menu under the Inquiries and Reports section.', 'S');
INSERT INTO `Help` VALUES (23, 103, '<font size="+1"><b>Inventory Checks</b></font>\r\n<br><br>\r\nScripts are available to automate the stock check adjustments necessary following a stock check. However, this feature does not work with controlled items .... yet. The procedure for there use and for stock checks in general is as follows:\r\n<br><br>\r\n<b>Step 1:</b>\r\n<br><br>\r\nEnsure invoicing is complete for all product dispatched.\r\n<br><br>\r\n<b>Step 2:</b>\r\n<br><br>\r\nFrom the main menu - inventory tab, click on the link to print out the stock check sheets.\r\n<br><br>\r\nThis page allows selection of the stock location to be checked and a range of stock categories to check. Note there is a new field called:\r\n<br><br>\r\nAction for stock check freeze. \r\n<br><br>\r\nBy default this is set to list the items to be counted. Before a stock starts this must be run selecting " make a new stock check data file". This copies the quantities on hand as at the time the report is run. If the stock check sheets are run for another location and it is set again to make a new stock check data file, then the previous stock check data file is over-written and lost. If there is a stock check in progress in one location and another location wishes to initiate one too, then the second person to run the stock check sheets needs to print them with the Action for Stock Check Freeze field set to Add/update existing stock check file. Similarly if another stock category is to be added to the stock check then - Add/update existing stock check file is the correct option.\r\n<br><br>\r\n<b>Step 3:</b>\r\n<br><br>\r\nOnce the stock check data file is created - the stock should be counted.\r\n<br><br>\r\n<b>Step 4:</b>\r\n<br><br>\r\nThe counts should be entered - the system will only accept count entries for parts that were included in the categories selected for stock taking in step 2. The system allows many counts for each item and totals all counts to work out the required adjustment. Also, the initial of the counter or reference to the count sheet can be entered to provide a trail of where the stock was that is entered. As soon as there are counts to enter - the counters should pass on the count sheets to the data entry team so that the data entry can be completed as soon as possible after the counting is complete.\r\n<br><br>\r\n<b>Step 5:</b>\r\n<br><br>\r\nHaving completed the entry of the counts the Comparison report can be run. \r\n<br><br>\r\nThis is run from the Inventory tab of the main menu:\r\n<br><br>\r\nCompare Counts Vs Stock Check Data\r\n<br><br>\r\nThere are number of options for running this report. The default is to run the report without making any adjustments. It should be run in this mode initially so that a review of the proposed adjustments is undertaken. Any adjustments that seem incorrect can now be double checked (i.e. counted again) as necessary.\r\n<br><br>\r\n<b>Step 6:</b>\r\n<br><br>\r\nOnce happy that the adjustments to be made are correct the report can be run again with the option to Report and Close the Inventory Comparison File and Process Adjustments as Necessary. \r\n<br><br>\r\nThere is no going back on this process - if you didn\'t mean to process these adjustments they must all be reversed manually. Be very sure when running the comparison in this mode.', 'S');