• From: India
  • Registered: 01/12/2015
  • Posts: 26

Topic: Incentive or Penalty while receiving goods

We normally get our finished product through our contractors. As part of our process we pay incentive for prompt delivery or penalise when the criteria is not met.

Created as item (serviceable) but does not allow me to add because either the qty is 0 or the item value is negative. How to overcome this issue. Otherwise any better idea

Regards

Towerfour

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Incentive or Penalty while receiving goods

Journal Voucher / Credit / Debit Notes.

apmuthu's Website

3 Reply by yeshrao (edited by yeshrao 02/14/2015 06:15:33 am)

  • Registered: 01/13/2015
  • Posts: 16

Re: Incentive or Penalty while receiving goods

Thanks apmuthu.

Forget to mention our way of processing this transaction. We include this transaction as part of our GRN and add the transaction into GL (i.e. the way shipping charges included in Direct Sales). What is the best way to do this.

Advance thanks

Towerfour

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Incentive or Penalty while receiving goods

Will Tags suffice?

apmuthu's Website

  • Registered: 01/13/2015
  • Posts: 16

Re: Incentive or Penalty while receiving goods

Thanks apmuthu.

Will it possible to include two input fields under "Suppliers and Purchasing Defaults" while setting up 'General GL'. The same should appear in GRN screen. Will it be possible? If yes, method to do this.

Yeshrao

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Incentive or Penalty while receiving goods

Provide an example of the 2 fields envisaged - are they different for each GRN or only their values are different for each GRN or they have some relationship (calculatable formula) with existing constants / field values?

You might want to experiment with manually entered values into the sys_prefs table and / or use special charge / service items in the GRN.

Checkout the screenshot in the wiki and make a mockup of what you want and link it in here.

apmuthu's Website

  • Registered: 01/13/2015
  • Posts: 16

Re: Incentive or Penalty while receiving goods

No they are not different. We may or may not pay incentive or deduct penalty. Will calculate based on the quantity and pay incentive or deduct the amount w.r.t delayed days.

As you said, need to add a field and include the same in the screen. Need to make changes in 'GL Setup' Screen as well as GRN. Am I right?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Incentive or Penalty while receiving goods

If the incentive is calculatable from the quantity, then a enable/disable flag (0/1) is sufficient for it and an amount variable for delays if it is variable with no dependancy will suffice. Better to have a quick entry for those transactions where these issues arise with no fields necessary in the tables. The fields can be avoided altogether if quick entries are used except that manual computation will be necessary.

apmuthu's Website

  • Registered: 01/13/2015
  • Posts: 16

Re: Incentive or Penalty while receiving goods

We have included two input fields in GRN and the total is getting updated as expected. We are unsuccessful when we change the input value and click update. Though the Ajax gets activated but there is no result. Is there anything we are missing here?

P.S. We have followed the method as in Direct Sales.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Incentive or Penalty while receiving goods

Provide the changed code to test.

apmuthu's Website

  • Registered: 01/13/2015
  • Posts: 16

Re: Incentive or Penalty while receiving goods

Identified work around for our requirement where there is no need to make the changes. While making payments, we exclude or include the penalty or incentive. It gets populated correctly.

The exercise what we carried out, was able to understand the flow of FA

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Incentive or Penalty while receiving goods

It would be nice if you provided the changed files (or actual workflow menu click sequence) so that it may be included in the next version natively.

apmuthu's Website

13 Reply by yeshrao (edited by yeshrao 02/17/2015 12:37:57 pm)

  • Registered: 01/13/2015
  • Posts: 16

Re: Incentive or Penalty while receiving goods

file name and path: /purchasing/includes/ui/po_ui.inc


    start_row();
    label_cell(_("Mahamai"), "colspan=$colspan align=right");
    small_amount_cells(null, 'mahamai', price_format(get_post('mahamai',0)));
    label_cell('', 'colspan=2');
    end_row();

    $display_sub_total = price_format($total + input_num('incen_fine'));
  //  $display_sub_total = $display_sub_total - input_num('mahamai');

  //  label_row(_("Sub-total"), $display_sub_total, "colspan=$colspan align=right","align=right", 2);
  //  $taxes = $order->get_taxes(input_num('freight_cost'));
  //  $tax_total = display_edit_tax_items($taxes, $colspan, $order->tax_included, 2);

   // $display_total = price_format(($total + input_num('freight_cost') + $tax_total));
    $display_total_if = price_format(    $total + input_num('incen_fine')   );
    $display_total =   price_format(     $display_total_if - input_num('mahamai')   );
   start_row();

    label_cells(_("Amount Total"), $display_total, "colspan=$colspan align=right","align=right");
    //submit_cells('update', _("Update"), "colspan=2 align='center'", _("Refresh"), true);
    end_row();

14 Reply by apmuthu (edited by apmuthu 02/17/2015 01:18:36 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Incentive or Penalty while receiving goods

The code appears incomplete since the "incen_fine" form variable is not defined (did you mean to replace the 'mahamai' with a single +Incentive / -Fine variable).

Any reason why you would want to comment out the $taxes and $tax_total assignments and prevent it forming part of the $display_total?

I would expect the last part of the function display_po_items() to be:

    start_row();
    label_cell(_("Incentive / -Fine"), "colspan=$colspan align=right");
    small_amount_cells(null, 'incen_fine', price_format(get_post('incen_fine',0)));
    label_cell('', 'colspan=2');
    end_row();

//    $display_sub_total = price_format($total + input_num('incen_fine'));

//    label_row(_("Sub-total"), $display_sub_total, "colspan=$colspan align=right","align=right", 2);

    $taxes = $order->get_taxes(input_num('freight_cost'));
    
    $tax_total = display_edit_tax_items($taxes, $colspan, $order->tax_included, 2, $order->trans_type==ST_SUPPINVOICE);

    $display_total = price_format($total + input_num('freight_cost') + $tax_total + input_num('incen_fine'));

    start_row();
    label_cells(_("Amount Total"), $display_total, "colspan=$colspan align='right'","align='right'");
    $order->order_no ? submit_cells('update', _("Update"), "colspan=2 align='center'", _("Refresh"), true)
        : label_cell('', "colspan=2");
    end_row();

    end_table(1);
    div_end();
}

But where does the 'incen_fine' get stored and how?

Post's attachments

GRN_Mod.png 22.3 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website