Difference between revisions of "Plugin: Alt OrderLine"

From iDempiere en
Line 28: Line 28:
 
**Cable A1 - Qty=100 meters
 
**Cable A1 - Qty=100 meters
 
*Will result in:
 
*Will result in:
**2 X Drum A - Qty=100 meters
+
**2 X Cable A1 - Qty=100 meters
  
 
[[File:AltCONSOLIDATE.png|270px|right]]
 
[[File:AltCONSOLIDATE.png|270px|right]]

Revision as of 18:34, 7 December 2015


Continuation

  • This project is a separate plugin and continuation of Plugin:_Alternative_Output.
  • Use that plugin if you just want a simple display and control of alternative output.
  • This plugin here has additional CONSOLIDATE and CONSOLIDATE_SAME_LINE output
  • Again, what is vital is that this is a pure separate non impact to core plugin with no meta-model or design entanglement. Everything follows the Java and OSGi concept of Object-Oriented componentisation with loose coupling.

Tab Model

  • The extra tab model is same as C_OrderLine with each line for each display output row.
  • Same as previous plugin, it has simplified fields.
  • C_ALTOrderLine parent key is C_Order_ID, it can have many to one C_Order parent.

Hash Formatting

SOrderLineAlt.png
  • Similar to previous plugin, it uses hash # character in BOM parent description box
  • HEADER#CONSOLIDATE will take any similar product lines into one with its qty value summed up
  • HEADER#CONSOLIDATE_SAME_LINE will group only those that have same qtys.
    • For example:
    • Cable A1 - Qty=100 meters
    • Cable A1 - Qty=100 meters
  • Will result in:
    • 2 X Cable A1 - Qty=100 meters
AltCONSOLIDATE.png
AltConsolidated.png

Screenshots of Examples

  • See screen above of normal OrderLine tab showing source that has two lines of similar products and similar qtys (2 sets of screws at qty=8)
  • They will be used to quickly test the plugin as shown on screens below.
  • First the setting is to #CONSOLIDATE#, then Prepare the Sales Order.
  • Note the output has both lines merged with the qty = 16
  • Next we change to #CONSOLIDATE_SAME_LINE, and Prepare the same Sales Order again.
  • Note that now the alternative orderline has maintained the qty = 8 but description is '2 X <product>'

Easy Source

  • I have made the source code as pushed to bitbucket well described so that any coder can change it easily.
  • Note that the ALT tab did not apply discount for LineNetAmt, but that is easy to solve in code - just copy the original C_OrderLine column values. What is important is the ability to group arbitrarily any set of products quickly and to change description for PrintFormat to be more readable.
AltCONSOLIDATESAMELINE.png
AltConsolidatedSameLine.png

TODO

  • Next will be to prepare a PrintFormat option for Sales Order Window

Feedback

Please rate this plugin:

{{#w4grb_rate:Plugin:_Alt_OrderLine}}

<w4grb_ratinglist pagevotes idpage="Plugin:_Alt_OrderLine"/>

If you want to provide additional comments, please use the Discussion page.

Cookies help us deliver our services. By using our services, you agree to our use of cookies.