You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Varun Kothari <va...@tcs.com> on 2013/10/01 12:51:13 UTC

Additional shipping charge when prorate shipping is Y

Dear Community Membaers - Please help

This is regarding ofbiz JIRA issue OFBIZ-399
https://issues.apache.org/jira/browse/OFBIZ-399 

As mentioned in the JIRA comments (mentioned below in red text) - NOTES 
section, Shipment.additionalShippingCharge will be ignored when creating 
an invoice from a Shipment if ProductStore.prorateShipping ="Y", I think 
additional shipping charge should still be captured on invoice for that 
particular shipment even on prorate shipping charge 'Y". The original 
shipping charge comes prorated and this new additional charge should be 
captured on that particular shipment for invoice creation. What are your 
views on this, please suggest ???





This is taken care of in SVN r 4699995, 470162, 470165, 470168, 470170, 
470173. Here's a recap:
Added Shipment.additionalShippingCharge field (currency-amount)
Added ProductStore.prorateTaxes field (indicator)
Added demo data for ProductStore.prorateTaxes ("Y") to Ecommerce and POS 
data
Added OrderAdjustment.originalAdjustmentId (id) and relation to 
OrderAdjustment
Added OrderAdjustmentBilling entity
Added additionalShippingCharge field to ShipmentForms.editShipment
Added createOrderAdjustmentBilling service to OrderSimpleMethods
Added calculateInvoicedAdjustmentTotal service to InvoiceServices as a 
helper service to determine amount of a given OrderAdjustment billed to 
existing invoices
Modified InvoiceServices:
createInvoicesFromShipments()
o If shipping charges should not be prorated, examine the order shipments 
for additional shipping charges
o For each additional shipping charge:
+ Create an OrderAdjustment
+ Calculate taxes on the additional charge, if any, and create another 
OrderAdjustment
+ If part of the order was paid via credit card, create an 
OrderPaymentPreference for the additional charges and authorize it
createInvoiceForOrder()
o When creating invoice items from OrderAdjustments (item- or header- 
level), call new service calculateInvoicedAdjustmentTotal to discover how 
much of the adjustment to invoice. Skip the adjustment if it has been 
fully invoiced
o Create OrderAdjustmentBilling records for every OrderAdjustment amount 
added as an InvoiceItem
o Prorate order-level taxes in the same manner as shipping charges, 
controlled by the ProductStore.prorateTaxes field

Notes:
Shipment.additionalShippingCharge will be ignored when creating an invoice 
from a Shipment if ProductStore.prorateShipping == "Y"
Fixed a bug in Opentaps 0.8 PaymentGatewayServices where authorizing an 
OrderPaymentPreference always authorized the remaining amount of the order 
and ignored the requested overrideAmount
The current assumption is that there is no distinction between sales tax 
and shipping tax - IE that the shipping tax rate for a given 
origin/destination combination is identical to the sales tax for that 
combination
When authorizing Shipment.additionalShippingCharge when the Shipment is 
related to an order which has multiple credit card 
OrderPaymentPreferences, the first card found will be used
If the authorization for additionalShippingCharge fails, the shipment will 
still be completed

Varun Kothari
Tata Consultancy Services
Mailto: varun.kothari@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty.   IT Services
                        Business Solutions
                        Consulting
____________________________________________
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you



Re: Set default value for date field in entity

Posted by Jacques Le Roux <ja...@les7arts.com>.
It depends on which part of jQuery (plugins, UI, etc.) . In framework/images/webapp/images/jquery Look for *fr* (I always try to supply a French translation) and see if you can add  a similar *zh* file...

Note: most of the time (99%) the images and attachments don't get through on OFBiz MLs...

Jacques
  ----- Original Message ----- 
  From: xxshutong 
  To: user@ofbiz.apache.org 
  Sent: Monday, October 07, 2013 5:18 PM
  Subject: Re: Set default value for date field in entity


  Hi Jacques,
  Thanks for your reply. I have fixed it in another way.


  Another question, I have changed the language, but the validation message are also english, I researched for a while and found it is the JQuery validation message. Do you know how I can change the JQuery language?





  Thanks,
  Leon.Zhou




  On Oct 7, 2013, at 11:07 PM, Jacques Le Roux <ja...@les7arts.com> wrote:


    If you look into ModelParam.java, you will see that the default-value is only intended to be a simple String, it's not interpreted as an action.
    You could enhance it and provide a patch in a Jira

    Jacques

    xxshutong wrote:

      Dear friends,
      I want to set a date field in entity to current time. I use service as bellow:

      <service name="createInput" default-entity-name="InventoryInput" engine="entity-auto" invoke="create" auth="true">
             <description>Create a new input record</description>
             <!--<permission-service service-name="exampleGenericPermission" main-action="CREATE"/>-->
             <auto-attributes include="pk" mode="OUT" optional="false"/>
             <auto-attributes include="nonpk" mode="IN" optional="true"/>
             <override name="machine_no" optional="false"/>
             <override name="product_id" optional="false"/>
             <override name="batch_no_id" optional="false"/>
             <override name="inputDate" default-value="${bsh: org.ofbiz.base.util.UtilDateTime.nowTimestamp()}"/>
        </service>

      But the bold part can't work correctly, any suggestions?

      Thanks,
      Leon.Zhou



Re: Set default value for date field in entity

Posted by xxshutong <xx...@gmail.com>.
Hi Jacques,
Thanks for your reply. I have fixed it in another way.

Another question, I have changed the language, but the validation message are also english, I researched for a while and found it is the JQuery validation message. Do you know how I can change the JQuery language?



Thanks,
Leon.Zhou


On Oct 7, 2013, at 11:07 PM, Jacques Le Roux <ja...@les7arts.com> wrote:

> If you look into ModelParam.java, you will see that the default-value is only intended to be a simple String, it's not interpreted as an action.
> You could enhance it and provide a patch in a Jira
> 
> Jacques
> 
> xxshutong wrote:
>> Dear friends,
>> I want to set a date field in entity to current time. I use service as bellow:
>> 
>> <service name="createInput" default-entity-name="InventoryInput" engine="entity-auto" invoke="create" auth="true">
>>        <description>Create a new input record</description>
>>        <!--<permission-service service-name="exampleGenericPermission" main-action="CREATE"/>-->
>>        <auto-attributes include="pk" mode="OUT" optional="false"/>
>>        <auto-attributes include="nonpk" mode="IN" optional="true"/>
>>        <override name="machine_no" optional="false"/>
>>        <override name="product_id" optional="false"/>
>>        <override name="batch_no_id" optional="false"/>
>>        <override name="inputDate" default-value="${bsh: org.ofbiz.base.util.UtilDateTime.nowTimestamp()}"/>
>>   </service>
>> 
>> But the bold part can't work correctly, any suggestions?
>> 
>> Thanks,
>> Leon.Zhou


Re: Set default value for date field in entity

Posted by Jacques Le Roux <ja...@les7arts.com>.
If you look into ModelParam.java, you will see that the default-value is only intended to be a simple String, it's not interpreted as an action.
You could enhance it and provide a patch in a Jira

Jacques

xxshutong wrote:
> Dear friends,
> I want to set a date field in entity to current time. I use service as bellow:
> 
> <service name="createInput" default-entity-name="InventoryInput" engine="entity-auto" invoke="create" auth="true">
>         <description>Create a new input record</description>
>         <!--<permission-service service-name="exampleGenericPermission" main-action="CREATE"/>-->
>         <auto-attributes include="pk" mode="OUT" optional="false"/>
>         <auto-attributes include="nonpk" mode="IN" optional="true"/>
>         <override name="machine_no" optional="false"/>
>         <override name="product_id" optional="false"/>
>         <override name="batch_no_id" optional="false"/>
>         <override name="inputDate" default-value="${bsh: org.ofbiz.base.util.UtilDateTime.nowTimestamp()}"/>
>    </service>
> 
> But the bold part can't work correctly, any suggestions?
> 
> Thanks,
> Leon.Zhou

Set default value for date field in entity

Posted by xxshutong <xx...@gmail.com>.
Dear friends,
I want to set a date field in entity to current time. I use service as bellow:

<service name="createInput" default-entity-name="InventoryInput" engine="entity-auto" invoke="create" auth="true">
        <description>Create a new input record</description>
        <!--<permission-service service-name="exampleGenericPermission" main-action="CREATE"/>-->
        <auto-attributes include="pk" mode="OUT" optional="false"/>
        <auto-attributes include="nonpk" mode="IN" optional="true"/>
        <override name="machine_no" optional="false"/>
        <override name="product_id" optional="false"/>
        <override name="batch_no_id" optional="false"/>
        <override name="inputDate" default-value="${bsh: org.ofbiz.base.util.UtilDateTime.nowTimestamp()}"/>
   </service>

But the bold part can't work correctly, any suggestions?

Thanks,
Leon.Zhou

Re: Additional shipping charge when prorate shipping is Y

Posted by Varun Kothari <va...@tcs.com>.
Thanks Jacques.


regards
Varun Kothari
Tata Consultancy Services
Mailto: varun.kothari@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty.   IT Services
                        Business Solutions
                        Consulting
____________________________________________



From:
Jacques Le Roux <ja...@les7arts.com>
To:
user@ofbiz.apache.org
Date:
10/06/2013 01:56 PM
Subject:
Re: Additional shipping charge when prorate shipping is Y



I don't see any business level reason to ignore a shipping charge in an 
invoice if this charge is added on a specifiq shipment after the prorating 
has been done.
It must have been a technical reason. Please create a Jira an provide a 
patch

Jacques

Varun Kothari wrote:
> Dear Community Membaers - Please help
> 
> This is regarding ofbiz JIRA issue OFBIZ-399
> https://issues.apache.org/jira/browse/OFBIZ-399
> 
> As mentioned in the JIRA comments (mentioned below in red text) - NOTES
> section, Shipment.additionalShippingCharge will be ignored when creating
> an invoice from a Shipment if ProductStore.prorateShipping ="Y", I think
> additional shipping charge should still be captured on invoice for that
> particular shipment even on prorate shipping charge 'Y". The original
> shipping charge comes prorated and this new additional charge should be
> captured on that particular shipment for invoice creation. What are your
> views on this, please suggest ???
> 
> 
> 
> 
> 
> This is taken care of in SVN r 4699995, 470162, 470165, 470168, 470170,
> 470173. Here's a recap:
> Added Shipment.additionalShippingCharge field (currency-amount)
> Added ProductStore.prorateTaxes field (indicator)
> Added demo data for ProductStore.prorateTaxes ("Y") to Ecommerce and POS
> data
> Added OrderAdjustment.originalAdjustmentId (id) and relation to
> OrderAdjustment
> Added OrderAdjustmentBilling entity
> Added additionalShippingCharge field to ShipmentForms.editShipment
> Added createOrderAdjustmentBilling service to OrderSimpleMethods
> Added calculateInvoicedAdjustmentTotal service to InvoiceServices as a
> helper service to determine amount of a given OrderAdjustment billed to
> existing invoices
> Modified InvoiceServices:
> createInvoicesFromShipments()
> o If shipping charges should not be prorated, examine the order 
shipments
> for additional shipping charges
> o For each additional shipping charge:
> + Create an OrderAdjustment
> + Calculate taxes on the additional charge, if any, and create another
> OrderAdjustment
> + If part of the order was paid via credit card, create an
> OrderPaymentPreference for the additional charges and authorize it
> createInvoiceForOrder()
> o When creating invoice items from OrderAdjustments (item- or header-
> level), call new service calculateInvoicedAdjustmentTotal to discover 
how
> much of the adjustment to invoice. Skip the adjustment if it has been
> fully invoiced
> o Create OrderAdjustmentBilling records for every OrderAdjustment amount
> added as an InvoiceItem
> o Prorate order-level taxes in the same manner as shipping charges,
> controlled by the ProductStore.prorateTaxes field
> 
> Notes:
> Shipment.additionalShippingCharge will be ignored when creating an 
invoice
> from a Shipment if ProductStore.prorateShipping == "Y"
> Fixed a bug in Opentaps 0.8 PaymentGatewayServices where authorizing an
> OrderPaymentPreference always authorized the remaining amount of the 
order
> and ignored the requested overrideAmount
> The current assumption is that there is no distinction between sales tax
> and shipping tax - IE that the shipping tax rate for a given
> origin/destination combination is identical to the sales tax for that
> combination
> When authorizing Shipment.additionalShippingCharge when the Shipment is
> related to an order which has multiple credit card
> OrderPaymentPreferences, the first card found will be used
> If the authorization for additionalShippingCharge fails, the shipment 
will
> still be completed
> 
> Varun Kothari
> Tata Consultancy Services
> Mailto: varun.kothari@tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.   IT Services
>                        Business Solutions
>                        Consulting
> ____________________________________________
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you



Re: Additional shipping charge when prorate shipping is Y

Posted by Jacques Le Roux <ja...@les7arts.com>.
I don't see any business level reason to ignore a shipping charge in an invoice if this charge is added on a specifiq shipment after the prorating has been done.
It must have been a technical reason. Please create a Jira an provide a patch

Jacques

Varun Kothari wrote:
> Dear Community Membaers - Please help
> 
> This is regarding ofbiz JIRA issue OFBIZ-399
> https://issues.apache.org/jira/browse/OFBIZ-399
> 
> As mentioned in the JIRA comments (mentioned below in red text) - NOTES
> section, Shipment.additionalShippingCharge will be ignored when creating
> an invoice from a Shipment if ProductStore.prorateShipping ="Y", I think
> additional shipping charge should still be captured on invoice for that
> particular shipment even on prorate shipping charge 'Y". The original
> shipping charge comes prorated and this new additional charge should be
> captured on that particular shipment for invoice creation. What are your
> views on this, please suggest ???
> 
> 
> 
> 
> 
> This is taken care of in SVN r 4699995, 470162, 470165, 470168, 470170,
> 470173. Here's a recap:
> Added Shipment.additionalShippingCharge field (currency-amount)
> Added ProductStore.prorateTaxes field (indicator)
> Added demo data for ProductStore.prorateTaxes ("Y") to Ecommerce and POS
> data
> Added OrderAdjustment.originalAdjustmentId (id) and relation to
> OrderAdjustment
> Added OrderAdjustmentBilling entity
> Added additionalShippingCharge field to ShipmentForms.editShipment
> Added createOrderAdjustmentBilling service to OrderSimpleMethods
> Added calculateInvoicedAdjustmentTotal service to InvoiceServices as a
> helper service to determine amount of a given OrderAdjustment billed to
> existing invoices
> Modified InvoiceServices:
> createInvoicesFromShipments()
> o If shipping charges should not be prorated, examine the order shipments
> for additional shipping charges
> o For each additional shipping charge:
> + Create an OrderAdjustment
> + Calculate taxes on the additional charge, if any, and create another
> OrderAdjustment
> + If part of the order was paid via credit card, create an
> OrderPaymentPreference for the additional charges and authorize it
> createInvoiceForOrder()
> o When creating invoice items from OrderAdjustments (item- or header-
> level), call new service calculateInvoicedAdjustmentTotal to discover how
> much of the adjustment to invoice. Skip the adjustment if it has been
> fully invoiced
> o Create OrderAdjustmentBilling records for every OrderAdjustment amount
> added as an InvoiceItem
> o Prorate order-level taxes in the same manner as shipping charges,
> controlled by the ProductStore.prorateTaxes field
> 
> Notes:
> Shipment.additionalShippingCharge will be ignored when creating an invoice
> from a Shipment if ProductStore.prorateShipping == "Y"
> Fixed a bug in Opentaps 0.8 PaymentGatewayServices where authorizing an
> OrderPaymentPreference always authorized the remaining amount of the order
> and ignored the requested overrideAmount
> The current assumption is that there is no distinction between sales tax
> and shipping tax - IE that the shipping tax rate for a given
> origin/destination combination is identical to the sales tax for that
> combination
> When authorizing Shipment.additionalShippingCharge when the Shipment is
> related to an order which has multiple credit card
> OrderPaymentPreferences, the first card found will be used
> If the authorization for additionalShippingCharge fails, the shipment will
> still be completed
> 
> Varun Kothari
> Tata Consultancy Services
> Mailto: varun.kothari@tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.   IT Services
>                        Business Solutions
>                        Consulting
> ____________________________________________
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you