From: <reg...@gm...> - 2014-10-12 14:48:58
|
Wow! And I'm still playing using 4.07.3 but playing with 11.3 in test. Kudos to you all and the community as well. Russ Sent from my BlackBerry® device from Digicel -----Original Message----- From: Phil Daintree <ph...@lo...> Date: Sun, 12 Oct 2014 17:12:57 To: webERP Developers<web...@li...>; For the general discussion of webERP project<web...@li...> Reply-To: For the general discussion of webERP project <web...@li...> Subject: [webERP-users] New release 4.11.4 I've rolled up the latest into a new release. Rafael has been busy - quite a big contribution from Rafael in this release - adding context sensitive links to the manual from whatever page the manual is called from as well as tidy up and consistency work. Also modifications to allow system database data to be translated for transaction types Andrew Galuski's work to allow only certain users to see specific inventory locations that they have been allowed. Users need to be given specific access now to each location. Also Andrew's dashboard comes up on login now to give an over-view of current order, inventory etc. Exson, Ricard, Paul T, icedlava and I continue to fix the odd annoyances and there are a few fixed here. There is a nice new Xenos theme from Khwunchai J Thanks to everyone who contributed. Always amazes me how quickly the changes mount up - the change log since 4.11.3 is below: 12/10/14 Version 4.11.4 release 09/10/14 RChacon: Add transaccion type name translation, transaccion type number and link to GL transaction inquiry in DailyBankTransactions.php. 06/10/14 Exson: Fixed the prices or line total variance in invoice for foreign currencies. 4/10/14 Andrew Galuski: defaulted factory location from WO record 30/09/14 Exson: Fixed the purchase order details status to be right when the PO is recovered from Cancelled status. 29/09/14 Exson: Change charset from latin1 to utf8 for supplierdiscounts. 27/09/14 RChacon: Add ascending class to have sortable columns, complete table-heads and add documentation. 21/9/14 Phil: Tidy up Dashboard to remove redundant code etc 20/9/14 Phil: Move the DB Maintenance/GetConfig/Exchange rates update/audit trail purge inside UserLogin.php to ensure they do no add unecessary overhead to every page 20/9/14 Bob Thomas: StockStatus incorrectly displaying quantity on order extended by conversion units 19/09/14 RChacon: Add ascending class to PaymentMethods.php to have sortable columns. 17/9/14 Phil: Moved the audit log purge to occur if DB_Maintenance is set to run 16/9/14 Phil: Added BNZ GIFTS format for bank account transaction imports 15/09/14 Exson: fixed the date format errors in WorkOrderEntry.php. 13/9/14 Phil: Added new MT940 - SCB - Siam Comercial Bank Thailand style - a bit different to ING's style. Modifications to BankAccounts.php to allow the transaction file format for imports. ImportBankTrans.php must now select the bank account to determine the file import format to use. It now uses an include for the file parsing so other formats can easily be accomodated with a new include. 11/09/14 RChacon: Adds gettext() to line 402 of CustomerAllocations.php. Reported by Harald. 11/09/14 Exson: Code tidy up to make it meet coding guidance in CustomerInquiry.php. 11/09/14: Exson: Fixed the prnMsg bug in CustomerReceipt.php and add an inquiry link in it and make a status selectable in Customer inquiry and removed those rowstring definition which caused printf parameters missing. 31/8/14 RChacon: In general: Replaces code to determine background colour with TableRows(). Adds comments to ManualNewScripts.html. Fixes manual.css format. In GLTransInquiry.php: Adds $ViewTopic and $BookMark and sorts columns, and minor improvements. Minor translation improvements. 31/8/14 RChacon: Standardizes page_title_text to main-menu-option, standardizes bottom tax-menu, adds $ViewTopic and $BookMark, completes table header columns, formats data columns in Tax* scripts. 30/8/14 RChacon: In TaxAuthorities.php, adds $ViewTopic and $BookMark, completes table headings, formats number columns to fix sort order, and minor improvements. 30/8/14 Phil: WorkOrderEntry.php didn't handle no item returned from search correctly - fixed. 29/8/14 RChacon: In TaxAuthorityRates.php and TaxCategories.php: adds $ViewTopic and $BookMark; Uses gettext() to translate 'Exempt', 'Freight' and 'Handling'. 29/8/14 Exson: Fixed the StockLocStatus Serial Number link column shift problem. 28/8/14 RChacon: In Tax.php: Fixes SQL select order-by from transaction-date to record-number (primary key). Minor improvements. 28/8/14 Exson: Fixed the csv file aligned abnormal when there are commas in fields strings. 28/8/14 RChacon: In Tax.php: Adds code comments, clean-up unneeded variables, simplies and reorder SQL select, reduces if() calls, replaces addTextWarp-left-align with addText, replaces line-drawing a box with Rectangle(), fixes start-date for 'Y/m/d' format, adds start-date for 'Y-m-d' format, adds a summary section for the report, adds ViewTopic and BookMark, adds more NoOfPeriods. 26/8/14 RChacon: In PDFPriceList.php: Adds code comments, adds PageHeader() print for currabrev and categoryid, replaces addTextWarp-left-align with addText, replaces line-drawing a box with Rectangle(), adds 'Prices excluding tax' warning. 15/8/14 RChacon: Fixes double line feed in PDFQuotationPortrait.php reported by Arwan Galaya. Uniforms code between PDFQuotation.php and PDFQuotationPortrait.php. 14/8/14 RChacon: In CustomerInquiry.php and SupplierInquiry.php makes translatable the systypes.typename. 14/8/14 RChacon: In SupplierInquiry.php: Reorganizes columns Date, Type, Number, Reference and Comments, and regroups table-datacel format-strings as in CustomerInquiry.php code. 13/8/14 kelo: SupplierBalsAtPeriodEnd.php fix calculation to take into account fx differences on after date transactions 13/8/14 RChacon: includes/DatabaseTranslations.php used to store the fields of tables that are used from the database so that they can be translated in particular systypes for the types of transactions invoice credit note payment receipt etc. Can be extended for scripts and other tables where the data from the table is static and used to display 13/8/14 RChacon: In CustomerInquiry.php: Adds class ascending and reorganizes columns Date, Type, Number and Reference; Regroups table-datacel format-strings, completes the datacel quantity by table-row; makes translatable the systypes.typename. 12/8/14 RChacon: In SupplierInquiry.php: makes the field systypes.typename be translatable. 12/8/14 RChacon: In Z_poRebuildDefault.php: extends title, improves comments, sets file to pot, updates $FilesToInclude, renames old pot file to bak extension. Minor improvements. 08/8/14 Andrew Galuski: Add SQL and maintenance screens for Location based security. added new report aged controlled stock. additional scripts to follow as time allows 2/1/14 Tim: Change columns around on SelectWorkOrder.php 31/7/14 RChacon: Corrects the bottom line of the rectangle. Adds comments (info for developers). 29/7/14 RChacon: In PDFPriceList.php: Adds comments (info for developers), ViewTopic and BookMark, and currency name in locale language; deletes unused lines; reformats for legibility; adjusts column sizes to field sizes; improves printing of stockmaster.longdescription; improves code to reduce execution time (calculation out of loops); links right column positions to right margin; corrects IF for CustomerSpecials (deletes translation). In ManualSalesTypes.html: Adds help info about Print a price list by inventory category. 27/7/14 Exson: Fixed the PO header lost initiator bugs when locations changed. Report by Akits from www.minghao.hk/bbs/. 25/7/14 Phil: Allow dummy - labour stock type items to be added to purchase orders. 17/7/14 RChacon: Adds ViewTopic and BookMark, adds bullet for class ascending columns, repositions columns Type and Trans, add class number to Trans, completes printf. 16/7/14 Andrew Galuski: Add standard cost to stock movement record for stock adjustments 03/07/14 Exson: Make status comments available in PO_OrderDetails.php to ensure that some important data such as grn reversing can be viewed. And add a return previous page link. 27/06/14 RChacon: Add code-comments, $ViewTopic, $BookMark, page_title_text and code to update NewStockID if OldStockID and SelectedStockItem are the same in Z_ChangeStockCode.php. Add id to the "Change An Inventory Item Code" topic anchor in ManualSpecialUtilities.html. 27/6/14 Exson: Make tel length in PO_Header.php is as same as field definition in sql. 26/6/14 Exson: Fixed the bug that Select Customers search result inconsistence with Customer receipt search result in SelectCustomer.php. 24/6/14 RChacon: Add $ViewTopic, $BookMark to Prices.php and minor improvements. 23/6/14 Tim: Fixed the GL account validation pop up error in MiscFunctions.js. 23/6/14 Exson: Fixed the bug that the sales order line's quantity will be update to zero but it show no change in appearance in SelectOrderItems.php. 22/6/14 Tim: Replace now() with CURRENT_TIMESTAMP in MRP.php to get time stamp to meet ANSI standard. 22/6/14 Exson: Fixed the mrp parameters runtime to datetime instead of date format since MRP running records need more precision. 22/6/14 Benjamin (bpiltz2302) from web-ERP-users mail list report and provide the solution for MRP LevelNetting unusual exit bug. The details can be found here: http://weberp-accounting.1478800.n4.nabble.com/MRP-Error-LevelNetting-td4657425.html 21/6/14 Exson: Add location check in StockAdjustments.php to prevent from users selecting controlled items based on one location but changed the location before submit it to server which make serial not exist check absolutely failed. 17/6/14 Exson: Add Z_ImportDebtors.php into Utilities menu and scripts table. 15/6/14 Akits from minghao.hk/bbs/ fixed the bugs that www_Users.php allowed modules does not matched the one displayed in index.php. 11/6/2014 Exson: Fixed the exported csv files with wrong aligned fields due to comma as part of fields content. 09/6/2014 Exson: Fixed the Delivery Date lossing bugs when change Warehouse. Reported by akits from minghao.hk(weberp) bbs. 2/6/14 Phil: Added bom effectivity dates into work order creation cost calculations - as spotted by Andrew Galuski 1/6/14 Phil: Fixed bug in POItems.php that resulted in an SQL error when the number of items from the search was zero after previous searches had returned records 27/05/14 RChacon: Add page title text and icon to import scripts. Page title text = menu option. 27/05/14 RChacon: Regroups the import scripts in the utility menu. 27/05/14 Exson: Add Sales man login control for PDFOrderStatus.php 26/05/14 Thumb: Fixed discount modifier missing bug in SelectOrderItems.php. 26/05/14 rchacon: Fixes other problems related to updating translations of the items description.. 22/05/14 newuser990(from webERP forum): fixed bugs in MRP.php that quantity which stated in PO with lines not completed but PO status marked Completed are calculated as supplies. Exson add PO order lines checked to avoid same problem. 22/5/14 Tim: Currencies.php now allows FunctionalCurrency to be modified 22/5/14 Phil: Prevent use of enter key - experimental - in number fields - prevents users from losing data in big forms where they are entering large amounts of data e.g. purchase ordering - maybe we should consider for integer fields too? 22/5/14 Ricard/Phil: Tidy up SQL in StockClone.php 19/5/14 Exson: Tidy up code of SelectOrderItems.php. 18/5/14 Thumb: Fixed the bug in ConfirmDispatch_Invoice.php for Balance quantity canceled policy by line no instead of by stockid since webERP allow same stock appeared in one order multiple times. 18/5/14 Exson: Tidy up SelectSalesOrder.php SQL code and add Thumb's salesman login control and fixed bugs caused by no group by statements for customer and items selected. 17/05/14 Phil: sales invoice and credit scripts all check for 0 exchange rate before updating sales anlaysis now 17/05/14 Phil: Fixed Z_ChangeStockCode.php which was orphaning stockdescriptiontranslations without changing them to the new code 14/05/14 Exson: Fixed typo in MRPReport.php which make some supplies not to be shown on the report and use itemdue instead of deliverydate in MRP to ensure that requirements are calculated correctly for items due on different date. 3/5/14 Khwunchai J.: New Xenos theme 3/5/14 Phil: StockCostUpdate.php now allows updates to manufactured items. 29/4/14 Exson: Make price matrix workable including GetPrice.inc, MainMenuLinksArray.php,SelectOrderItems_IntoCart.inc,PriceMatrix.php, SelectProduct.php,StockDispatch.php. 20/04/14 Exson: Fixed undefined variable bugs in PDFWOPageHeader.inc and PDFWOPrint.php and remove some redundant codes in PDFWOPrint.php 17/04/14 Exson: Update zh_CN.utf8 translation. 09/04/14 Tim: Fixed the table sort failure bugs in SelectSalesOrder.php reported by Andrew Agaluski. 07/04/14 Exson: Add InOutModifier to input Quantity when there whole batches are removed. Otherwise, it will create a wrong quantity left in Add_SerialItems.php. 07/04/14 Exson: Fixed the bug in Prices_Customer.php. MySQL strict mode not allowed a date is a white space. 06/04/14 Exson: Fixed the quote date and order confirmed date has not been retrieved for orders to modify in SelectOrderItems.php. 6/4/14 Andrew Galuski: Extensions for printing WO documentation new labels and links to print 05/04/14 rchacon: Fixes the bug that emptied ItemDescriptionLanguages. 05/04/14 Exson: Add decimal places check for controlled items quantity input in Add_SerialItems.php and InputSerialItems.php.The wrong decimal places will make this sections quite buggy and problem prone. 05/04/14 Exson: Add a decimal places check in StockAdjustments.php to prevent from wrong decimal places input. 04/04/14 Exson: Fixed the bug that controlled items can be dispatched more than order balance in ConfirmDispatch_Invoice.php. 2/4/14 Andrew Galuski: Get Credit available when modifiying an existing order 28/03/14 Exson: Fixed the Expiry Date not handled right during stocks adjustments by manual key in or bar code scan in Add_SerialItems.php, DefineSerialItems.php,InputSerialItems.php and InputSerialItemsKeyed.php. 26/3/14 Serakfalcon: fixed findLogoFile function in includes/session.inc 24/3/14 Phil: Removed DefaultTheme configuration parameter - unecessary as noted by Serafalcon 23/03/14 Exson: Fixed the no defined variable bugs in WorkOrderIssue.php. Reported by Tim. 23/03/14 Exson: Fixed the bug that the search results shows only limited to DisplayRecordsMax which does not make sense due to pagination in WorkOrderIssue.php. 23/03/14 Exson: Fixed that currency name not available in Prices.php. 22/03/14 Exson: Fixed the stock searching function failure when items setup in system less than DisplayedRecordsMax in WorkOrderEntry.php. 21/03/14 Exson: Fixed that bugs in WorkOrderIssue.php that the issued non BOM materials not shown. And fixed bugs in WorkOrderStatus.php failed to retrieve item description. 20/3/14 Exson: Fixed the bugs in StockCounts that Location set does not work and link typo. 19/3/14 Tim: Fixed the bug Items Other than those in BOM are not listed in Status of Work Order even if issued. Exson made a little revision to keep SQL query only once for those additional issued materials. Reported by newuesr990 from weberp forum. 18/03/14 Exson: Fixed the bugs in GoodsReceived.php which will leads to duplicated goods receiving. 17/3/14 rchacon: Allow translations of tax category Freight 15/3/14 Phil: Z_ChangeStockCategory.php was not updating sales analysis records correctly - fixed 15/3/14 Andrew Galuski: Auto Supplier number functionality 14/3/14 Jiro Akits: Updated zh_TW.utf8 translation 14/3/14 Phil: removed htmchars in DB_escape_string() functions as suggested by Tim 05/03/14 icedlava: Ensure there are no unescaped characters in existing data when updating purchorders after reversing GRN. This fixes a symptom of a more widespread bug and therefore temporary until more general fix is applied. 05/03/14 icedlava: Remove input fields (Country and Language) and display this data instead on customer view page 03/03/14 Exson: Remove redundant code in CustomerAllocations.php 03/3/14 icedlava: WhereUsedInquiry.php will no longer accept StockID with dash (-) as input allowed has changed. Still need to check for consistency for StockId input elsewhere in code. 2/3/14 Paul T: Div swap in footer to simplify CSS for Gel and Silverwolf themes. Some other themes will see a basic position swap of the date and version info where these vertically appeared together at the far left end. 1/3/14 Paul T: Correct variable spelling error. [reported in forums by serakfalcon] 24/2/14 Exson: Make negative integer allowable in MiscFunctions.js and make negative integer inputable for PastDueDays in SystemParameters.php. 22/2/14 Exson: Fixed the wrong error messages displayed while input date data manually in MiscFunctions.js. 19/2/14 icedlava: GLTrialBalance_csv.php -Remove set AllowAnyone variable and prevent TB display - temp solution. 18/2/14 Exson: Remove redundant code in StockLocStatus.php and InventoryPlanning.php. 17/2/14 Exson: Tidy up variable overwrite to if else structure in WorkOrderReceive.php scripts according Tim's comments. 17/2/14 icedlava: CopyBOM.php - SQL fix for insert to bom and locstock tables - ensure column counts match values even when zero. 16/2/14 icedlava: StockCounts.php - Enter by Category only counts and enters 10 items maximum - fix to allow any number that are input. 15/2/14 Exson: Make perishable control available in WorkOrderReceive.php. 15/2/14 Phil: Stock check comparison report now shows the bin location after the item code 15/2/14 Phil: Customer statement now shows bank account number for payments based on the defined default bank account 15/2/14 Andrew Galuski: Reverse HTML5 input type="date" as this will not use the webERP javascript date picker used everywhere else - better be consistent as html5 date picker functionality varies between browsers - AddCustomerNotes.php and AddCustomerTypeNotes.php 15/2/14 Vitaly: Fix PO_SelectOSPurchOrder.php date selection functionality 15/2/14 Phil: Fixed POSDataCreation script to send all current prices in the POS currency including debtorno info so the POS can now deal with customer specific prices correctly. 15/2/14 Andrew Galuski: WorkOrderStatus.php now shows requirements for multiple parent item works orders. 12/2/14 Andrew Galuski: WOSerialNos.php - added filter number format on quantity 12/2/14 Exson: Fixed the Earliest date calculation when is over Friday cutoff Time in DateFunctions.inc. -- Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://p.sf.net/sfu/Zoho _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-users |