2. PHPRunner General questions
  3. extension on order entry
This topic is locked

extension on order entry

 		2/6/2017 1:33:45 AM
PHPRunner General questions
P
 peterp author

Hi All,

I have a situation where I have an order header that has the total of the individual lines but I need the individual lines to calculate their extensions and show this total as they are being entered and updating the order total in the header. The item price is entered from a item price table which works.

I don't want to edit the extension I just want it calculated and displayed during editing and adding line items to the order, the calculation of the order header total is being achieved via the order totals totals calculated on the fly tutorial that was posted recently, unfortunately I can't get the right process to have this occur can somebody please help me or point me in the right direction to achieve this.

Also as a side issue when the order line item is entered the price is automatically fund and added to the line however if you tab over the unit price you lose the price I would like to be able to retain the looked up price.

I will appreciate any help with theses issues as they are holding me up from completing this project.

Thankyou

Best regards,

Peterp
Sergey Kornilov admin 2/6/2017

This will require quite a serious amount of coding. While calculating extensions, whatever that means, for each line is straightforward, calculating totals of calculated fields is all custom coding.
To calculate something for each line use approach described in this article:

https://xlinesoft.com/articles/how_to_use_calculated_fields.htm (option #3)

You will have to add your code to Javascript OnLoad event of Add and Edit pages of details table.
P
 		peterp author 2/6/2017



This will require quite a serious amount of coding. While calculating extensions, whatever that means, for each line is straightforward, calculating totals of calculated fields is all custom coding.
To calculate something for each line use approach described in this article:

https://xlinesoft.com/articles/how_to_use_calculated_fields.htm (option #3)

You will have to add your code to Javascript OnLoad event of Add and Edit pages of details table.


Thanks for the reply,

Extensions is where the QTY of an item that is ordered is multiplied by the unit cost of that item which results in the extend price(extension). I would have thought that in a sophisticated package such as PHPrunner this would have been fundamental functionality and not something that would require extensive programming to achieve