Friday, June 24, 2005

OFBiz Development SVN r5205

34 new commits this week. SVN r 5205 builds successfully but entity engine tests could not run due to a Shark container problem.

Significant changes:
  1. Many improvements to the Request -> Quote -> Order process
  2. Significant internationalization of error messages and labels in the order and party managers
  3. Change in security setting: default now calls for all paswords to be encrypted. Non-ecrypted passwords will no longer work.
Thanks to Our Contributors
This week's contributors include Matt Kasubaski, Jean Luc Malet, Jacopo, David, Andy, and myself.

Entities and Seed Data
  • New INVENTORY_ACCOUNT glAccountTypeId created to set a default inventory account for an organization. (r5172)
  • PartyClassification no longer points to PartyClassificationType. Instead, PartyClassification ties Party and PartyClassificationGroup together, and PartyClassificationGroup has a partyClassificationTypeId. So, essentially, partyClassificationTypeId has been moved up from PartyClassification to PartyClassificationGroup. (r5173)
  • PartyContactMechPurpose now has relations going out to PostalAddress and TelecomNumber entities (so you don't have to go from PartyContactMechPurpose to ContactMech to PostalAddress any more...) (r5176)
  • OTHER_NO_POST paymentTypeId removed (r5191)
Base and Framework
  • By default, passwords now MUST be encrypted with SHA. (This was a change in the framework/security/config/ file, where password.accept.encrypted.and.plain is set to false by default.) All demo user files have been changed. (r5178, r5187) Shark container admin password fixed. (r 5188)
  • Service validation with UserLogin changed (r 5190)
  • Truition integration (r 5183)
  • New UtilMisc.addToDoubleInMap adds a Double to a key in a Map or creates a new one with the Double value if not already there (r 5195)
  • CSS layout fixes for cross-browser compatibility (r 5198)
  • New tests for creating large number of values in entity engine (r 5205)
  • New ui labels (r 5193)
Accounting/GL Implementation
  • Finished balance sheet
  • Created services to export GL transactions to an outside accounting/GL system. The first example is generating QBXML for Quickbooks. (Here is an example of an OFBiz transaction imported into Quickbooks.)
  • new service findLastClosedDate to find the last closed date and CustomTimePeriod, for doing balance sheets (r 5194)
  • convertUom service now works for dated uom conversions (ie, currencies) (r 5189)
  • ui labels improvements (r 5199)

  • Fixed problems when paryId does not change when the cart is already initialized (r 5175)
  • quoteName field added to the Quote entity (r 5179, r 5180)
  • Improvements to finalizeOrder, including customer info entry in anonymous checkout (r 5182)
  • Refunds for credit changed to CUSTOMER_REFUND paymentTypeId, with the from and to parties on the payment fixed (they were reversed) (r 5191)
  • Request -> Quote -> Order improvements, including: currency uom for maximum amount in CustRequest entity; currency and descriptions passed in as default values from request to quote; added Agent role for RequestRole; using standard price rules if quote has no price, when quote items are added to cart (r 5200)
  • Error message internationalization (r 5202)
  • Clean ups to the party lookup screens (r5174)
  • New routine to validate customer information in createCustomer and new service for updateCustomer (r5177)
  • Fixed missing go back link (r 5186)
  • Party relationship pages moved from JSP to screens, forms, and FTL (r 5192)
  • View profile migrated to screen widgets from JPublish, with new links for seeing payments of a party (r 5196)
  • Internationalization changes for French (r 5201)
  • Better error message handling in catalog manager when fields are missing (r 5181)
  • Fixed pagination errors and increased view size to 50 (from 20) rows for applying features from category (r 5203)
  • Fixed pagination in EditFeatureCategoryFeatures (r 5204)
  • Bad ui labels name fixed (r 5197)

Friday, June 17, 2005

OFBiz Development SVN r5171

50 new commits thiw week. r5171 builds and installs successfully.

Significant Changes
  1. New screen in WebTools which lists all services available and, in detail, shows the parameters and class/method or script/method of each service.
  2. New order email template for ecommerce, replacing old ones.
  3. New screens for managing order role and quote role.
Thanks to our Contributors
This week's contributors include Jacques Le Roux, Joe Eckard, Matt Kasubaski, Ashish Hareet, David, Jacopo, Hans, and myself.

Entity and Seed Data
  • Re-classified GL Account Classes, which are "ASSET", "LIABILITY", "EQUITY, etc. as either DEBIT or CREDIT accounts by creating DEBIT and CREDIT GlAccountClass values and making them parent GlAccountClasses for everything else. (r5158)
  • More detailed abbrevations in for Uom entity for fluid ounce and pints (distinguishes UK vs US.) (r5163)
Base and Framework
  • Login errors no longer returned with html li tags any more (r5141)
  • alias-view-column is now turned on for MySQL in entityengine.xml (r5147)
  • Fixed bugs in FindCustomTimePeriods service. (r5150, r5157)
  • Internationalization (r5151, r5159)
  • new UtilDate.toTimestamp method to convert java.util.Date to java.sql.Timestamp (r5164)
  • Internationalization (r5132)
  • Updates to PayflowPro to do capture, void, refund and verisign to use newer fields, populate more info (r5160)
  • New view-entities AcctgTransAndEntries (r5162) and GlAccountAndHistory (r 5169) for doing income statements and balance sheets, respectively.
  • UI labels for financial statements (r5168)
Accounting/GL Implementation
  • Completed implementation of screen-based order notification emails. ecommerce/templates/email/OrderNoticeEmail.ftl replaces the old email templates. (r5122, 5123)
  • Internationalization (r5125)
  • Fixed ui label for the word "From" for rental items (r5137)
  • Fixes to communication event (r5142, r5143)
  • Fixed display of "Gift Card Number" (r5146)
  • css change for size of small images: height instead of width restrained (r5148)
  • Fixed layout and popus for calendar pages (r5152)
  • table to css formatting changes (r5153)
  • order detail now shows additional product information, including quantity, pieces, weight, height, width, depth. (r5161)
  • Fixed bad file name for ui labels. Now it works again. (r5134, r5136, r5138)
  • Internationalization (r5126)
  • Fixed inconsistent previous link (r5127)
  • Fixed orderItem comparison for rental order items (r5129)
  • finalizeMode of "payoption" is brought back during checkout payment options. There seems to be problems with "payment already received" payment methods. (r5130)
  • Services and screens for managing quote role (r5139)
  • For quotes, request roles are copied to quote roles (r5144)
  • Product descriptions shown in lists for quotes (r5144)
  • If no store shipping methods are found, ShippingEvents will now report "No applicable shipment method found" instead of "System error" (r5145)
  • Fixed bad link for adding quote items to cart (r5154)
  • HTML clean ups in product detail page (r5156)
  • product detail page shows additional information, see change in eCommerce above (r5161)
  • css changes for boxoutside, boxtop, and boxbottom tables (r5166)
  • Fixed ui label bug for "create new quote coefficient" and "create return" (r5171)
  • Fixed bugs for finding party relationship service (r5150)
  • More internationalization (r5124)
  • Re-factored cache management of ProductConfigWrapper for configurable products (r5131)
  • Catalog Manager's inventory page for products will now show products at all facilities, such as stores, etc., not just warehouses (r5140)
  • Fixed bug for creating new facilities (r5149)
  • Added missing header items for "Edit Product Features" (r5155)
  • Fixed bug for product reservations (r5165)
  • New screen to list all available services (r5167)
  • Calendar pages migrated to widgets (r5128)
  • UI changes (r5135)

Friday, June 10, 2005

OFBiz Development SVN r5121

44 new commits this week. r5121 builds and installs successfully.

Significant Changes
  1. Full implementation of gift certificates.
  2. Complete migration of facility to screen widget from JPublish.
  3. New payment types--please use the appropriate payment type in the future, rather than just DISBURSEMENT and RECEIPT, in your apps.
Thanks to our Contributors
This week's contributors include Jacques Le Roux, Jean-Luc Malet, as well as the usual suspects David, Andy, Hans, Jacopo, and myself.

Entity and Seed Data
  • New payment method type (Company Check) (r5097)
  • Payment types have been separated from just RECEIPT and DISBURSEMENT to various customer and vendor payment and refund types (r5097). Also a new non-GL posting payment type (r5101) (we'll see if this stays around...)
  • PaymentMethod now has a GL account field, associating checking accounts, etc. with specific GL accounts (r5098)
  • New PaymentGlAccountTypeMap entity to map GL accounts associated with PaymentTypes (r5099). You can now set up as many different payment types as you need and associate them with GL accounts.
  • New ProductAverageCost entity (r5103, 5109)
  • New AcctgTransEntryProdSums view-entity for aggregating accounting transaction entries (this is an example of how to do SELECT SUM(..) GROUP BY ...; queries with the entity engine) (r5107)
  • New GiftCardFulfillment entity. ValuleLinkFulfillment is still around but is now OldValueLinkFulfillment. (r5118)
  • New ownerPartyId in Facility which identifies the owner of the inventory in a facility (r5119)
Base and Framework
  • http parameters with multiple ~..= are now treated as normal in UtilHttp.getParameterMap (r5078)
  • appbar labels internationalized (r5081)
  • populating screen context now done in ScreenRenderer (code moved out of ScreenWidgetViewHandler) (r5088)
  • common ui labels now in French as well (r5112)
  • common header now supports additional stylesheets (r5113)
  • new UtilValidate.isGiftCard method to validate gift card numbers (r5116)
  • Fixed wrong label for payment method type in payment screen (r5096)
  • PaymentGatewayServices now use CUSTOMER_PAYMENT and _REFUND payment types (r5114)
  • Full implementation of gift certificates usinf FinAccounts. Services to create, add funds, check balances make purchases with, and redeem gift certificates. Uses ValueLink. (r5118)
Accounting/GL Implementation
  • Product average cost tracking
  • Posting of Cost of Goods Sold (COGS) entries on sales invoices, currently using average cost method.
  • new service sendMailFromScreen takes an URI and sends the screen from that URI as an email (r5089)
  • Fixed use of stripViewParamsFromQueryString (r5080)
  • order review pages and template for order notification email cleaned up. Will use sendMailFromScreen to do order notice emails (r5095)
  • main.ftl simplified thanks to screen-widget (r5105)
  • bug fix in gift card reload email template (r5117)
  • New helper methods for linked production runs (r5100)
  • removed files no longer needed by screen widget, like envsetup jsp and bsh (r5076) and includes/ sub-directory in WEB-INF/actions/ (r5077)
  • i18n of order entry pages (r5093)
  • new screen to look up purchase order header (r5094)
  • changed payment type RECEIPT to CUSTOMER_PAYMENT. For now, returning items for store credit now is a non-posting payment (r5102)
  • search for requests page improved (r5104)
  • categorydetail.bsh simplified (r5106)
  • new feature to generate PDF of orders. See an example of a sales order and a purchase order PDF. (r5115)
  • French UI labels (r5121)


  • a product can only be a variant of one product. Existing STANDARD_FEATUREs and PRODUCT_VARIANT associations are removed (r5079)
  • French UI labels (r5082), (r5087)
  • migrated to screen-widget: edit facility pages (r5084), inventory and return pages (r5085, r5086), facility group (r5090), shipment pages (r5091), completing migration of facility manager to screen-widget (r5092)
  • receive inventory has lookup PO header button (r5094)
  • screens in facility manager for owner party id of a Facility (5119)
  • now possible to operate multiple stores and hotels on same OFBiz system (r5120)

Friday, June 03, 2005

OFBiz Development SVN r5075

29 new commits this week. SVN r5075 builds and installs successfully. Significant changes this week:
  1. New feature to manage tax status in different geographic locations, including storing different tax ids and tax exemption status.
  2. New feature to specify multiple partyIds with different roles on orders, such as ship to customer, bill to customer, placing customer, end user customer, and vendor roles as well.
  3. A lot of French localization work was done.

Entity and Seed Data
  • commonCanadian provinces are now PROVINCEs rather than STATEs. Get state worker has been modified to get both STATEs and PROVINCEs, so the functionality doesn't change. (r5049)
  • there is now a new PartyTaxInfo entity which records, for each party, the geographic location (geoId), tax id for this location, and whether the party is exempt. Useful for doing multiple sales tax jurisdictions with separate tax ids and exemption rules. (r5051)
  • the relationship between WfActivity and WfProcess (for workflows in the framework/shark component) is now either "WfProcess" or "SubFlowWfProcess" (r5057)
  • new seed data to test tax exemption: there is now a customer (partyId: DemoCustCompany) which is tax exempt in UT and CA (in ecommerce seed data) (r5060)
Base and Framework
  • MapStack is now implemented with Javolution (r5050)
  • form-widget entity-option now supports temporary MapStack in the context as well as fields from the entity (r5050)
  • added support for alias-view-columns setting in entity engine's datasource when doing ORDER BY (r5056)
  • added code for getBytes to support byte[], ByteWrapper (r5058)
  • formatting changes (r5066)
  • updated to Derby (r5075)
  • Some variable changes (r5048)
  • fixed some French translations (r5062)
  • after creating payment, payment application form shows up (r5065)
  • Only showing tax if it is non-zero (r5063)
  • URLs show only userLoginId, not entire user login info, for security reasons (r5063)
  • sales tax details displayed in order detail page (r5071)
  • InitLowLevelCode screens removed (r5046)
  • initLowLevelCode service no longer has an output and is now designed to be run as a batch job (r5047)
  • quote-to-order internationalization (in French) (r5061)
  • internationalization of catalog and facility facility managers to French (r5069)
  • cache management for ProductConfigWrapper (r5072, r5074)
  • new reports for manufacturing (r5073)
  • New facilities for specifying order roles--lots of new fields for placing, shipping, billing, end user customers and vendors in the storeOrder service (r5053)
  • storeOrder will now check PartyTaxInfo to see where the party is exempt in this geographic location and store the tax id and the exemption amount (r5053)
  • recalcTax code now gets a billToPartyId (r5054)
  • fixed problem with finding wrong party for billing accounts in order entery (r5055)
  • fixed problem in checkout with wrong party in header (r5055)
  • general clean up of HTML and removing of JPublish documents (r5055)
  • error message improvements (r5067)
  • when creating new shopping lists, partyId is gotten from orderPartyId of the cart rather than from UserLogin (r5068)
  • new screens for administering party tax info (r5051)
  • more updates to backend system (r5070)