Re: [WebERP-developers] New release 4.11.4

[Phil D. <ph...@lo...>]

I made it the default file and ditched 4.11.3 now
Regards
Phil
Phil Daintree
Cell: +64 (0) 275 567890
http://www.logicworks.co.nz

On 13 October 2014 8:05:49 AM NZDT, Phil Daintree <ph...@lo...> wrote:
>No not yet. The default file us still 4.11.3 was just waiting for any
>feedback before ditching the old file
>Regards
>Phil
>Phil Daintree
>Cell: +64 (0) 275 567890
>http://www.logicworks.co.nz
>
>On 13 October 2014 2:51:24 AM NZDT, Pak Ricard <pak...@gm...>
>wrote:
>>Hi Phil:
>>
>>Thanks for the roll up!
>>
>>I just tried to download from SourceForge and it's still 4.11.3 zip.
>>Newest
>>file inside the zip is 08/02/2014.
>>
>>Did you update the SF download file?
>>
>>
>>Regards,
>>Ricard
>>
>>2014-10-12 12:12 GMT+08:00 Phil Daintree <ph...@lo...>:
>>
>>> 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-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>
>>
>>------------------------------------------------------------------------
>>
>>------------------------------------------------------------------------------
>>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-developers mailing list
>>Web...@li...
>>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>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-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers