Posts

Showing posts from April, 2011

ADempiere can do.

1 ADempiere can do 2 On-line historical information 3 Reporting 3.1 Smart Reporting 3.2 Business Views 3.3 Drill-down and Drill-across 3.4 Report types 3.5 Third Party Reporting Tools 3.6 Customising Reports 4 Data and meta-data 5 Supportability ADempiere can do Sales Processes Raising a quotation or proposal Recording orders Sending the goods or performing the services Invoicing the customer Purchase Processes Raising a purchase requisition from a catalogue Issuing a purchase order Receiving goods and services Receiving supplier invoices. Inventory Processes Tracking inventory Replenishing warehouses Multiple warehouse sites and locators Stock movements Shipping Paying Suppliers & Collecting Debts Accounting Processes Period and year end Financial and management accounting Charts of accounts VAT/TAX/IVA Reporting for other regulatory bodies On-line historical information ADempiere stores all information and tra

ADempiere Callout Implemetation

I have implemented call-out successfully with the help of ADempierians. I want to contribute and share code import java.sql.*; import java.txt.*; import org.compiere.util.*; import org.compiere.model.*; import org.adempiere.model.*; int m_leathername_ID=A_Tab.getValue("m_leathername_ID"); int M_Quality_ID=A_Tab.getValue("M_Quality_ID"); int M_Colour_ID =A_Tab.getValue("M_Colour_ID"); int M_Grade_ID=A_Tab.getValue("M_Grade_ID"); int C_BPartner_ID=A_Tab.getValue("C_BPartner_ID");    String leathername=DB.getSQLValueString(null, "select Name from m_leathername where m_leathername_ID=?",m_leathername_ID); String m_leathercode=DB.getSQLValueString(null, "select m_leathercode from m_leathername where m_leathername_ID=?",m_leathername_ID); String qualityname=DB.getSQLValueString(null, "select Name from M_Quality where M_Quality_ID=?",M_Quality_ID); String m_qualitycode=DB.getSQLValueString(nul
Image
Script Callout From AdempiereWiki Jump to: navigation , search   This contribution was provided by Carlos Ruiz , Quality Systems & Solutions (QSS) http://globalqss.com   This contribution was provided by Víctor Pérez , E-Evolution (Libero) http://www.e-evolution.com Contents 1 Creating the Rule 2 Configure Callout from Table/Column 3 Sample Code provided for copy/paste testing 4 Sample Code for Setting Payment Bank Account 5 Scripting Languages 6 See Also Creating the Rule Within the script you can use: Window context variables start with a W_ prefix Login context variables start with G_ prefix Parameters for callout start with A_ prefix A_WindowNo A_Tab A_Field A_Value A_OldValue A_Ctx Configure Callout from Table/Column This Callout can also be called from the Report & Process Window . Just remember to set in the Rule window from which Event Type are you calling this Rule Script. Sample Code provided for