Friday, November 24, 2006

OFBiz Development r478944

50 new commits this week.k SVN r 478944 builds and installs successfully. Significant changes include:
  1. POS has been moved to a new specialpurpose/ directory.
  2. Fixed bug with canceling order items where order adjustments were being removed improperly. Now a new adjustment for tax difference is calculated.
  3. Improvements to the sending of emails to a contact list.
  4. Proper xml formatting for all XSL:FO pdf documents
Accounting
  • Fix invoice pagination erorr in list items form (r 476481)
  • Fixed NPE that could happen for offline credit card authorisations (r 476790)
  • Fix bugs with re-calculation of tax when removing order adjustments. Now, instead of removing all the order adjustments, it recalculates tax and then adds it as an additional adjustment (r 477773)
  • Moved a view entity (TaxAuthorityGlAccountBalance) which should be in accounting/ and whose entitygroup definition is in accounting/ from order to accounting (r 478318, 478319, 478321)
  • Filter agreement terms by date when calculating commissions (r 478318)
  • I18n & I10n changes for gender at least in latin languages (r 478512, 478514)
  • insert the escape tag into all fo.ftl files to avoid rendering errors caused by characters not valid for xml that are pulled from the db (r 478784)
Base and Framework
  • Created new specialpurpose directory for special purpose components that are based on the more general components under the applications directory, but reuse resources in order to create applications meant for a special purpose, or a particular type of user or task; also adjusted build files, component load files, etc Moved the POS comonent there. (r 476486, 476517, 476667, 477043)
  • Form widget now supports defining time formats in CommonFormatDate, CommonFormatDateTime, CommonFormatTime, and the calendar icon widget in CommonViewCalendar. (r 476606)
  • implement include by location from one controller.xml file to another. The syntax is Anything defined in event blocks of the current controller will replace the ones from the included controller (r 476610, 476624)
  • escape spaces in classpath entries, which should resolve problem with jdk location on Windows (r 477801)
  • UtilValidate.isEmail now has the default isEmail(string) method which accepts formats such as sichen@localhost and isEmail(string, requireDot) which requires formats like sichen@somewhere.com (r 478901)
Content
  • various improvements for processing incoming email to avoid NPE at bad content of emails. (r 477480)
  • output the communicationevent status from storeIncomingEmail service to be able to run a eca on the value and extended the description (r 477596)
  • add a parammeter to be able to limit the maximum size of an incoming email message (set to 1Mb) in ofbiz-containers.xml (r 477691)
  • system now accepts incoming email messages with multilevel multiparts (r 478781)
  • insert the escape tag into all fo.ftl files to avoid rendering errors caused by characters not valid for xml that are pulled from the db (r 478784)
Entity Model
  • Added SurveyResponseAnswer.sequeceNum field, which is nice for ordering the response answers (usually in same sequence as the questions themselves) (r 476400)
  • Added CustRequest.fulfillContactMech and a screen to view the related address/phone/email. (r 477453)
  • changed supplierproduct.lastprice to currency-precise so it is consistent with productprice.price (r 478307)
Manufacturing
  • insert the escape tag into all fo.ftl files to avoid rendering errors caused by characters not valid for xml that are pulled from the db (r 478784)
Marketing
  • Improved sending of email to contact lists to better handle cases where email addresses are bad or if the email aborts in the middle (r 478902)
Order
  • Slight improvement to order agreements to avoid highly improbable NPE if cart.getOrderType comes back null (r 476685)
  • Fix bad controller survey request in order manager (r 476792)
  • Added CustRequest.fulfillContactMech and a screen to view the related address/phone/email. (r 477453)
  • Some french labels corrections (r 477631, 478299)
  • Fix bug with emptying cart in ecommerce (r 477896)
  • Moved a view entity (TaxAuthorityGlAccountBalance) which should be in accounting/ and whose entitygroup definition is in accounting/ from order to accounting (r 478318, 478319, 478321)
  • introduced a new parameter countNewReturnItems to getOrderAvailableReturnedTotal which controls whether newly created return items are counted, so that quick refund order works again (r 478417)
  • fix the logic that allows the configuration (shown/hidden) of top & bottom minicart links in ecommerce. (r 478780)
  • insert the escape tag into all fo.ftl files to avoid rendering errors caused by characters not valid for xml that are pulled from the db (r 478784)
Party
  • the delete communicationEvent service now also deletes the related workeffort if this commubication event is the only one attached to the woreffort. (NOTE: This may change later) (r 478095)
  • Small forms to create cust requests in party view page for the contact mechs (addresses, phone numbers, etc.) displayed (r 478277)
  • Changed the pagination handling in the findParty service to be consistent with the form widget's pagination. (r 478807)
  • Improved sending of email to contact lists to better handle cases where email addresses are bad or if the email aborts in the middle (r 478902)
Point Of Sales
  • Initial implementation of a POS Cash/Paid in and out of drawer feature. (r 476442)
  • New property names for TM-T88III and StarTSP600 printers (r 477640)
  • Fix potential slow printing in POS (r 477655)
  • Minor changes to allow more place for Date and Total on display for customer (aka journal) (r 478296)
Product
  • Some french labels corrections (r 477631, 478299)
  • insert the escape tag into all fo.ftl files to avoid rendering errors caused by characters not valid for xml that are pulled from the db (r 478784)
  • Missing a UI label for can drop ship on supplier product page. Added it. (r 478944)
Seed Data
  • Add a price for the PROD_COST product so it can be purchased (r 478308)
  • an example of product name and description i18n for the Round Gizmo (GZ-2644). (r 478365, 478482, 478498) Much thanks to Jacques and Jacopo for correcting my attempts at French and Italian.
Web Tools
  • escape certain characters to avoid problems in the XML export/import (r 476469, 476472)
eCommerce
  • Created ecomclone webapp in the ecommerce component that uses the new include stuff, and acts as a test case for it (r 476650, 476652, 476681)
  • Fix bug with emptying cart in ecommerce (r 477896)
  • fix the logic that allows the configuration (shown/hidden) of top & bottom minicart links in ecommerce. (r 478780)

Friday, November 17, 2006

OFBiz Development r476275

41 new commits this week. SVN r 476275 builds and installs successfully. Important changes are:
  1. Minilang "while-compare" changed to "while"
  2. Migrated entity maintenance pages to screen widget
  3. Fixed many bugs, including payments being applied at the wrong time, facility manager's contact mechs page, problems with losing inventory reservations, and some issues with returns and refunds.
Accounting
  • Allow PAID -> READY status for invoices. Clear paidDate when status set to READY (r 474485)
  • Set the invoice.paidDate to now if none specified when status set to PAID. (r 474485)
  • Modify createInvoicesFromShipment so that additional shipping charges are authorized and captured along with rest of order amount. (r 474623)
  • Refactored and created new service to release an individual order payment preference. (r 474623)
  • This should fix pagination bug with multiple invoice items (r 475272)
  • Change allocation of payment applications to invoices so that only those which are SENT or RECEIVED are applied to DISBURSEMENTS or RECEIPTS respectively. Previously, the allocation was blind and would apply any PaymentApplication to its invoice without checking status or paymentTypeId. The use of PaymentAndApplication simplified some related code, this whole section of InvoiceServices could use a good refactoring. (r 475329)
Base and Framework
  • Better error message when Unable to bind RMIDispatcher to RMI (r 473893)
  • Changed new minilang "while-compare" to a "while" (r 473333, 473334, 474048)
Content
  • Fix for ListFindSurvey that was not returning any result, due to the missing list-name="listIt" attribute in the form definition. (r 473897)
  • Fix potential bug with a null delivered-to on email header when storing incoming emails (r 474595)
Order
  • Added field to view entity OrderItemQuantityReportGroupByProduct for selecting according to date issued. (r 473455)
  • Fix for bug in room booking (r 473963)
  • Fix typo in OrderReadHelper for getting variant products' weight (r 474717)
  • Fix typo of "Customer PO#" (r 474751)
  • made refund the default option when creating return items from order. (r 475351)
  • Fix bugs in returns where requested return items would be added to return totals, preventing some returns from being accepted. ofbiz-463 (r 475819)
  • when a return header is updated to canceled, all return items will be updated to canceled. (r 476018)
  • The "processOrderPaymets" service now internally gets a ShoppingCart instance by calling the "loadCartFromOrder" service instead of the "loadCartForUpdate" method. (r 476251)
Party
  • French UI labels for Party manager (r 476275)
Point Of Sales
  • Formatting and getting rid of tabs and spaces at end of lines (r 474258)
  • Added a dialog box with a list box to select a product when there are multiple bar code matches (r 474660, 474667)
Product
  • Fix problems with creating new contact information in facility manager (r 473451, 473456, 473460, 473503, 473745)
  • fixed bug where scheduling page did not screen out voided route segments (r 473585)
  • Fix missing tab entries in catalog manager's search box (r 473749)
  • Use POST instead of GET methods in facility contact mech forms. GET was causing problems with non ASCII chars. (r 474678)
  • Made the transaction timeout for copyProductCategoryMember service 10 minutes. (r 475889)
Seed Data
  • Suppression of demo categories descriptions to allow i18n at least for the moment in english/italiano/français. (r 473691)
  • added a new mime type for zip documents (r 474694)
  • new gl account and account type to support undeposited receipts or funds classification (r 475907)
Web Tools
  • Migrate entity maintenance to screen widget (r 473992, 474005)
eCommerce
  • i18n of product search and search by catalog (r 473652)
  • Fix NOBR tags (r 474173)
opentaps Financials
  • Support for "undeposited receipts" general ledger account to collect received checks, CODs, and cash waiting to be deposited to bank.
  • Transactions summaries report showing accounting activity during a time period.
  • Credit card settlements report showing credit card transactions which have been settled.
  • Payment receipts report showing payments received in a particular account.

Friday, November 10, 2006

OFBiz Development r473442

70 new commits this week. SVN r 473442 builds and installs successfully. Significant changes this week:
  1. Massive cleanup of the content management application, including removing and refactoring of many unused files.
  2. Fixes to anonymous checkout sequence
  3. Support for turning global transaction on or off during service-multi
  4. A new "while-compare" operation for minilang
Accounting
  • new gl account types for f/x gain loss and for writeoffs. (r 472343, 472577)
  • reclassified customer returns as revenue accounts instead of cogs (r 472580)
  • Fix error when entering no data in auth & capture forms. (r 472596)
  • Clean up some unused variables (r 473074, 473078)
  • refactor UtilAccounting method to determine root glAccountClass of GlAccount and GlAccoundClass (r 473442)
Base and Framework
  • Small changes to service event handler and multi-event handlers to look at attributes before parameters to allow for overrides; now uses same pattern as elsewhere (r 471134)
  • Fix the path to the calendar lookup images (from content/images/ to images/). (r 471445)
  • Added example print service that renders from a screen, sends it through FOP, and then send it to a printer configured on the server (r 472322)
  • Removed WfMC XPDL definition (DTD, XSD) files, added README files with more information about their location, and changed example files to refer to the public locations instead of one hosted for OFBiz and such; this resolves licensing issue with these text/source files (r 472405)
  • Removed jcl.dtd file for licensing reasons (r 472414)
  • Added parameter asOfDate to convertUom which will select the conversion for that date. Useful for time-varying conversion rates. (r 472587)
  • Changed all build files to add NOTICE and LICENSE files to the META-INF directory in each jar file that is created in OFBiz (r 472422)
  • Enhance ServiceMultiEventHandler to support configurable global transaction (r 472647)
  • Clean up some unused variables (r 473074, 473078)
  • Add a while-compare operation to minilang (r 473333, 473334)
  • Update location of XSD files to apache server
Content
  • Formatting changes (r 471181, 471183, 471187, 471225, 471389, 470271)
  • Removed old unused JPublish files (r 471197, 471226, 471227, 471231, 471387, 472070, 472127, 472295, 472453, 472496)
  • Misc improvements to the layout of the content setup screens. (r 471204)
  • Converted some screens from jpublish to screen widget (r 471222, 471376, 471378, 472420)
  • Removed some bad service definitions (r 471232)
  • email services will now store email 'to' address irrespective if party found of not (r 471364)
  • UI label fix. (r 472021)
  • Minor cleanup (r 472612, 472614)
Manufacturing
  • Clean up some unused variables (r 473074, 473078)
Order
  • Changed email confirmation service to support new anonymous checkout userlogin request attribute that is used after the session has been cleared (r 471133)
  • Fixed bug where placingUserLogin isn't found for anonymous users, so the userLogin from anonymous request variable is now used; this is tested and fixes the confirmation email problem (r 471137)
  • Moved some a few bsh/ftl files that were referenced by the order component from the ecommerce to the order component: the order component is at a lower level than the ecommerce one and so cannot use ecommerce's resources. (r 471152, 471155, 471156)
  • unplanned inventory quantity shown on orderview should take into account marketing package QOH quantities (r 472715)
  • Small change to the orderstatus data prep script to do a findByAnd on OrderRole and without a partyId instead of trying to do a findByPrimaryKey because we may not have a partyId here (r 472801)
  • Filter on Inventory Problems check boxes return in Find Orders & Order List screens with new options in Find Orders & Order List screens to filter POs on . Past ETA ; . Partially Received; . Rejected items (r 472948, 472950)
  • Display ProductCategoryMember.comments when a product from that particular category is viewed, allowing you to have category-specific product information on your online store. (r 473109)
Party
  • Fixed bug where communicationevent could not be deleted when it has an electronictext--electronictext is removed as well now. (r 471322)
  • Menu selection fixes for the party application (r 472024)
Product
  • Fixed issue with the all quantity price calculation stuff; should now only calculate all quantity breaks if and only if the other conditions on the rule are true (r 471118)
  • Fixed bug in PriceServices when ignoring quantity so that it always returns true instead of having that depend on a compare to 0 (r 471127)
  • Added two enhancements for ProductPriceRules: new condition for ProductFeature/Appl, enhancement to group member condition to support a member of a group that is a member of a group in addition to being a direct member of a group (r 472825)
  • Fix bug with deleting contact mech from facilities (r 473006)
  • Clean up some unused variables (r 473074, 473078)
  • Added the ProductCategoryMember.comments to the catalog manager's category products and product categories pages so the user can maintain the comments field (r 473105)
Seed Data
  • Primary categories content locale now default to english (was french) (r 473073)
  • sample data for category-specific product description (r 473113)
Web Tools
  • Add [Reln] link to view relations in the main Entity Data Maintenance page (r 472640)
eCommerce
  • Fix the adjustments that were not properly shown in the final checkout review screen (r 471140)
  • Moved some a few bsh/ftl files that were referenced by the order component from the ecommerce to the order component: the order component is at a lower level than the ecommerce one and so cannot use ecommerce's resources. (r 471152, 471155, 471156)
  • Display ProductCategoryMember.comments when a product from that particular category is viewed, allowing you to have category-specific product information on your online store. (r 473109)
opentaps Financials
  • Completed sales, inventory, profitability analysis report
  • New days outstanding report for Accounts Receivables and Payables
  • Support for invoice writeoffs
  • Foreign exchange gain/loss accounting
  • Improved account reconciliation features

Friday, November 03, 2006

OFBiz Development r470749

51 new commits this week. SVN r 470749 builds and installs successfully. Significant changes this week:
  1. Invoicing service now supports pro-rating of sales tax flag and additional charges on the Shipment entity.
  2. Shark component has been disabled.
  3. Re-factored receive inventory has been fixed to support serialized as well as non-serialized inventory.
Also, the OFBIZ Users Conference took place in Utah this week. You can view the PDF of my remote presentation, Under the Hood with OFBiz/opentaps online, and videos will be available on ofbiz.org soon.

Accounting
  • Removed not needed reference to the workflow component from the accounting build script. (r 468670)
  • New italian translations (r 469808)
  • Invoicing services now support pro-rating of taxes based on product store settings and invoicing of additional shipping charges from the Shipment entity (r 470173)
Base and Framework
  • Reversed BSF jar to the older version because the new one broke JPublish (r 468683, 468667, 468954)
  • Small change to SECA xsd to allow seca files without any rules in them (r 469030)
  • Added option to condition-expr to ignore-case, makes things lots easier when you need something like that. This affects the form, screen, tree widgets and minilang, as well as the Java EntityFinderUtil (r 469046)
  • Implemented a service that calls a CDyne service to get info for a zipcode; also added a service that can be triggered with an SECA (commented out example in the secas_cdyne.xml file) that will call this when a PostalAddress is created or updated and fill in the countyGeoId if a county exists in the database that matches it; also added a couple of Utah counties in the seed data to test this (r 469049)
  • Disabled the shark component by default (r 469084)
  • Better thread information in webtools, which works on Java 5 but will not break on JVM 1.4 (r 469251)
  • Fix bug in sequence value utility where it is actually using Integer instead of Long, so very large sequence values cannot be generated (r 469283)
  • Deletion of common french labels not in CommonUILabels_fr.properties. (r 469343)
  • added a new attribute to the "form" element: override-list-size. It can be used to pass a custom list size (differnt from the actual list size) that can be useful for pagination purposes under some circumstances. The attribute can accept the ${} notation. (r 469408)
  • New italian translations (r 469808)
  • Fix classpath issue in Shark component (r 469914)
  • Converted Shark Jpublish pages to screen widgets (r 469915)
Content
  • Removed applications/content/widget/findprep.bsh which does not seem to be used (r 470685)
  • Commented out reference to a missing bsh script in content management's UserPermissions page. (r 470686)
Entity Model
  • A new prorateTaxes on ProductStore to determine whether the order-level taxes should be charged to invoice in one lumpsum or prorated based on invoice values (r 470168)
Marketing
  • New italian translations (r 469808)
  • Better defaults -- EMAIL and text/html -- for create comm event for contact list screen (r 470620)
Order
  • Minor french translation changes (r 468500, 468528, 469249)
  • New italian translations (r 469808)
  • Fix possible NPE if return item status has no value (r 469867)
  • New OrderAdjustmentBilling entity to record the relationship between OrderAdjustment and InvoiceItem to help determine which tax, shipping, or promo has been invoiced (r 470162)
Party
  • added relation from ContactListPartyAndContactMech view entity back to ContactListParty (r 470628)
  • converted deprecated minilang operations (r 470730)
Point Of Sales
  • POS will now present an additional dialog if multiple products are found with the same bar code SKU (r 468662)
Product
  • Fix bug for product store screen where geo.geoName is null (r 468463)
  • Minor french translation changes (r 468500, 468528, 469249)
  • UI label fix for "ProductLeave empty for single product receiving" (r 468710)
  • removed some debugging code from CategoryContentWrapper which is commented out and not in the right form (r 469210)
  • add subscription attributes to services and screens/forms (r 469337)
  • Fix pagination issue on facility inventory report (r 469537)
  • Refactored the "receivedInventoryProduct" service from "group" service to minilang. In this way the error handling is easier to maintain and implement and the success response messages are finally implemented (when one or more items are received, now the quantity received, the product id and inventory item id are shown). Also the service now handles correctly both serialized and non serialized inventory. (r 469879)
  • Better buttons for schedule shipment route segments page (r 469995)
  • An additionalShippingCharge entity for Shipment entity to track additional shipping charges on top of order shipping charges to be invoiced for the shipment. This can be accessed from the shipment screens, not from the pack order page (r 470165)
  • A new prorateTaxes on ProductStore to determine whether the order-level taxes should be charged to invoice in one lumpsum or prorated based on invoice values (r 470168)
  • Put a max retry of 3 times on the dhl shipment scheduling service, since it is called asynch sometimes and could spawn a lot of retries if it ever failed (r 470619)
  • Small improvements to the product promo code ui usability. (r 470748)
Seed Data
  • Gift Cards Purchase and Gift Cards Reload categories were reversed in demo data (r 468660)
  • Additional unit conversions (inches and millimeters to micron) (r 469615)
  • Default settings for prorateTaxes for demo stores (r 470170)
Web Tools
  • i18n changes and migration from jsp/region to widgets for the 'cache' pages (r 469809, 469812)
  • corrected some menu text (r 470304)
Work Effort
  • Removed not needed reference to the workflow component from the workeffort build script. (r 468674)