VAT setup in ofbiz

Is this the latest and accurate guide to setup VAT in ofbiz? Show prices with VAT included in eCommerce (B2C) For that you must : In your store, set the field "Show Prices With Vat Tax"=Y Set the field "Vat Tax Auth Geo Id" with the corresponding VAT Geo (it's a default value, remember

Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)

I like to accomplish the following: 1 - setup spanish accounting plan in Ofbiz 2 - make it in form of xml files available to community Problem: I am not a finance person. Ask: a volunteer I can meet with on e.g. Skype to complete the task Current status: I do have EXCEL version of accounting

Translating UOMs

Is there a possibility to translate UOMs so this it shows in the language as chosen by the user? I could not find it in WebTools > Label Manager. Thanks, Wolfgang

Different VAT product / transportation

I setup the tax authorities such that an VAT of 10% is applied. But transportation should be taxed at 21%. How can I set this up? Thanks, Wolfgang

Error message when creating sales order

I am testing ofbiz 7.12 on a derby database. I entered through ecomseo an order. When checking out a creating the order I get the following error message: The Following Errors Occurred: Problems reading the database, please try again.ERROR: Could not create order (problem invoking the

Re: Tax authority is not availble for provided Tax Authority Party and Tax Authority Geo.

Never mind... just fixed it. Just for hre ones who run into the same problem. I made a mistake when creating up the tax authority in Accounting > Tax Authority. Field Geo refers to the Regional tax authority [ES-B]. I had set [ES] for Spain. Wolfgang On 2019/03/22 09:56:22,

Tax authority is not availble for provided Tax Authority Party and Tax Authority Geo.

I am having trouble to assign tax info to a supplier. I get the error message as in Subject line. That id what I did: (1) I setup tax authority Spain ESP_AT and assigned its role as tax authority (2) I setup a supplier and assigned its role as supplier (3) whn in tab 'TAX INFO' of the supplier,

Updating ofbiz 16.11

I currently run ofbiz 16.11 that I installed as svn co http://svn.apache.org/repos/asf/ofbiz/branches/release16.11 ofbiz.16.11 I tried to update executing 'svn up' from home office /usr/local/ofbiz. The only thing that happened was a 'Restore' of plugins in specialpurpose I had previously

Error message price list

I made a fresh install of latest 16.11 stable. When entering a new price I get hte following error message: java.lang.ClassCastException: Incompatible class: java.sql.Timestamp A price record through is was created. When deleting a reord, I get he dollowing message:

myportal config.

I'd appreciate a hint form the community in what I am doing wrong with the myportal setup. I get a long error message when accessing: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://common. That is what I did: I added a new security group

Web analytics

I do have a few questions around ofbiz and web analytics: * Where can I find document on how to setup it up in orbiz? * Does ifbiz has reporting on board I did not find? * From your experience which other tools than google webanalytics can be used to drive in-depth reports? I'd rather prefer an

ofbiz and SSL & apache

Would you please point me to a procedure how to setup ofbiz to use my letsencrypt certificates? I don't seem to be able to find one. Is it possible to ruj Ofbiz under Apache webser? Thank you, Wolfgang

Food nutrition database

Good day. we want to use ofbiz for a food related business. For tyhat we need to setup a database of ingredients and their nutritional properties. Is this best done hrough the 'Attributes' in the item master or is there a better way? Underneath an example of the data model for an apple.

Delivery schedules for product categories

After testing with ofbiz, I need advice from experts if the following is possible. Background: We need to show in e-Commerce a schedule of parts in weekly buckets for the next six weeks. I use categories for this. Example • Product Category Name: Products week 42: 15/10 – 21/10 •

Credit Card payment service

I found these providers are in the manual. Are they all tested and all working with ofbiz? CyberSource ClearCommerce. PCCharge. RiTA Verisign PayFlo Pro ValueLink (gift cards) Are there others? Wolfgang

Make-to-Order / Drop-ship only

(1) Does ofbiz have a functionality on board that allows to create back-to-back purchase orders from e-Commerce sales orders (single sales orders with multiple lines back to back into a single purchase order with the same lines.), skipping requirements all together. In my case I work with a

Re: Error when receiving purchase order

Sorry for re-sending this email, but I cannot get past this error. Thanks for helping. I set the tax account in GL ACCOUNT DEFAULTS.. Would you please help me to fix this one. Thank you. Wolfgang The Following Errors Occurred: Error trying to begin transaction, could not process method: The

Error when receiving purchase order

I started a fresh ofbiz install (no demo data). I also setup GL chart of Account and reporting periods. I did not setup any accounts on part number level though (tab accounts) I can enter the PO with no problem, but when receiving I get error message.Which points to a problem with GL account

OFbiz on LAMP server

I like to integrate OFbiz on my LAMP server and run it through Apache web server. I googled quite a bit but can;t find anything. Would you please point me to a how too other resources for this purpose. Thanks, Wolfgang

Re: Missing State/Province

On 2018/10/05 15:15:09, Pierre Smits wrote: > Hi Wolfgang, > > Please open a JIRA ticket. > > On Fri, 5 Oct 2018 at 16:46 wp.rauchh...@gmail.com > wrote: > > > The State/Provinces for Spain are missing. > > When entering a new address the system shows "No States/Provinces exist" > > I

Missing State/Province

The State/Provinces for Spain are missing. When entering a new address the system shows "No States/Provinces exist" I like to add a list of the autonomous regions in several languages to standard ofibz. How is this been done? Thanks, Wolfgang

Creating product packs

How to best setup a pack in ofbiz? With pack I mean a product (e.g. a pack for 7 days of food servings) that includes in this example 7 individual servings. Each of these servings could be sold individually too. The price is set for the pack, but the Customer should have the possibility on

How to manage recepies through content functionality

Good day! Background: We are in the process of setting up a food service business. We decided to go with ofbiz as it allows us to contain investment-$ initially. We are trying in phase 1 to use ofbiz standard. (maybe with exception ofeComemrce page) We tested different scenarios and are left

Re: Can't close Job Shop > missing: [IN] [productCostPercentageFormula.baseCost]

On 2018/06/26 17:03:37, wp.rauchh...@gmail.com wrote: > Problem statement. When trying to closr a Job shop I get an error message. > Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: > Service invocation error (Could not commit transaction for service >

Can't close Job Shop > missing: [IN] [productCostPercentageFormula.baseCost]

Problem statement. When trying to closr a Job shop I get an error message. Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [quickChangeProductionRunStatus] call: Roll back error, could not commit

ofbizsetup procedure

Still playing with ofbiz. Now setting it up using the script ofbizsetup: https://10.5.2.1:8443/ofbizsetup/control/main Observations: Tab ‘PRODUCT STORE’; does not allow to set a currency. Ofbiz assumes USD. Tab ‘First CUSTOMER’; missing password field under ‘User name’ on screen causes error

A Product Store has not been defined for this ecommerce site.

I am setting up a data model starting with an empty database. I am getting above message when trying to open the eCommerce page. That is what I setup: * Catalog + 2 categories (Promotion and Browse Root). Both categories have Products defined. * Store, and within the store a Website, facility,

Error messages when uploading xml files

I am trying to upload xml data that I had exported previously form ofbiz. Some of the files fail to load. But it does not give an error message. Got 1 entities from CostComponentCalc.xml Got 1 entities from WorkEffortCostCalc.xml Got 1 entities from FacilityParty.xml Failed

Re: OFBiz MRP & Manufacturing: subcontract-work

On 2018/02/15 16:38:14, Yashwant Dhakad wrote: > Hi Giulio, > > You can also setup multi-level BOM for contract manufacturing product. When > you create job and the dependent production run automatically created for > contract manufacturing product. You can

Getting to know ofbiz

I started testing ofbiz by configuring en empty database to build a data model from scratch. I do have first question (more to come I guess): (1) How can I update exchange rates and unit of measure conversions? (2) How can I create / delete FX rates and units of measures? (3) I created the admin

Contributing to testing / documenation

What is the way / with wehom do I need to talk to become a contributor to the project? Wolfgang

Problems setting up eCommerce

Problem statement: Not able to see sub-categories and their products together on the on the eCommerce page. Configuration: Catalog > Browse Root Catalog > Sub-category 1 > Products > Sub-category 2 > Products I added the Browse Root

Re: Fwd: MODERATE for user@ofbiz.apache.org

I am trying to install ofbiz in a CENTOS 7 server with mariadb. Ofbiz runs fine with derby database, but I am not getting mariadb up and running This is what I did so far created databases in mariadb the following connector is installed: mysql-connector-java-5.1.25-3.el7.noarch I added the