Archive for October, 2011

Button to Print Pick Ticket from Order Entry – Epicor 9

Monday, October 24th, 2011

I like posting answers to common questions I see on forums. A lot of users want to be able to print reports directly from the entry screes like Order Entry. Below is some sample code on how to print the sales order pick ticket. This will submit the print request and open the report in preview mode.

Here are the steps:

  1.  Add a button to the summary tab. I’m assuming you know how to place a button on the screen and create a button click event. You can look at the article on Automatic Pack Slitp Number Generation.
  2.  Add the following assembiles to your customization:
    • Epicor.Mfg.Core.BLConnectionPool
    • Epicor.Mfg.Rpt.ISOPickListReport
    • Epicor.Mfg.Rpt.SOPickListReport
  3. Add the following code to the button click event:
private static void btnPickList_Click(object sender, System.EventArgs args)
{
 Epicor.Mfg.Core.Session epiSession = default(Epicor.Mfg.Core.Session);
 epiSession = (Epicor.Mfg.Core.Session)SalesOrderForm.Session;
 Epicor.Mfg.Rpt.SOPickListReport rptSOPickList = new Epicor.Mfg.Rpt.SOPickListReport(epiSession.ConnectionPool);
 Epicor.Mfg.Rpt.SOPickListReportDataSet rptDSSOPickList = rptSOPickList.GetNewParameters();
 
 EpiDataView edvOrderHed = (EpiDataView)oTrans.EpiDataViews["OrderHed"];
 
 DateTime dtShipBy = default(DateTime);
 
 dtShipBy = Convert.ToDateTime(edvOrderHed.dataView[edvOrderHed.Row]["RequestDate"]);
 
 // You may need a wider date range to include releases out side the ship date on order header
 if (DateTime.Compare(DateTime.Today, dtShipBy) > 0) {
  rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["FromDate"] = dtShipBy.AddDays(-1);
 } else {
  rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["ToDate"] = dtShipBy.AddDays(1);
 }
 
 rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["OrderList"] = edvOrderHed.dataView[edvOrderHed.Row]["OrderNum"];
 rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["AutoAction"] = "Preview";
 //Set this to your task agent id.
 rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["AgentID"] = "TaskAgnt";
 
 //The report style you want to print.
 rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["ReportStyleNum"] = 1002;
 rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["WorkstationID"] = Environment.MachineName + " 1";
 rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["DateFormat"] = "mm/dd/yyyy";
 rptDSSOPickList.Tables["SOPickListReportParam"].Rows[0]["NumericFormat"] = ",.";
 
 // TaskAgnt is the ID of your task agent.
 rptSOPickList.SubmitToAgent(rptDSSOPickList, "TaskAgnt", 0, 0, "Epicor.Mfg.UIRpt.SOPickListReport");
 
 MessageBox.Show("Pick List Print Job Submitted.");
}

Posted in Epicor, Epicor Customizations | Comments Off

Epicor ERP is the Best Kept Secret in Global ERP

Thursday, October 20th, 2011

You don’t hear much about Epicor in comparison to the “big name” players of the ERP software market. But as an Epicor Partner, we’re not complaining. We know Epicor is the best kept secret in global ERP and know those who use it realize it to be true. Don’t just take our word for it; check out the functionality possible with Epicor ERP for yourself:

Single Point of Data: Internal operations need to be integrated in order to achieve global visibility.

And Epicor ERP is a comprehensive solution that helps make that visibility possible. Epicor ERP can do it all, including accounting, order processing, manufacturing, human resources and data from other functions as well as including advanced financial management reporting and analysis. With real-time and accurate information at your fingertips, you can make better business decisions that help the success of your company. Instead of gathering information from a number of different systems and then never really knowing if the data is accurate, pull from one ERP solution that encompasses all parts of your business.

Adaptable Business Architecture: Epicor ERP scales to your business needs to support long-term growth. There are multiple deployment options that help ensure you stay within your means when making an ERP software purchase, such as hosting, online functionality, and on-premises implementations. Whatever works for you, Epicor can make it happen. In addition to the beginning stages of deployment, Epicor ERP can grow with you on a global scale. Some ERP systems limit your potential, but Epicor ERP adapts the way you need it to. Epicor also provides solutions in over 30 languages so you’re not hindered in where you can do business.

Beyond offering a product designed for global business, Epicor has a global infrastructure that incorporates support centers located in every major operating region—the Americas, EMEA (Europe, Middle East and Africa), and Asia Pacific. Through these regional centers, Epicor provides support in more than 20 languages. For more information on Epicor ERP, please contact us at Datix.

Posted in Epicor | Comments Off

Restore Progress AppServer Configuration

Wednesday, October 5th, 2011

I recently had a strange issue. We had a server file system filled up because of a runaway log file. The log files were removed to free up some disk space but during this process the Progress Admin Server lost its configuration information.

I did a lot of digging and found the configuration file in c:\oe102a\properties\ubroker.properties where c:\oe102a\ is the install directory of Open Edge. There is also a backup file in c:\oe102a\properties\ubroker.properties.old. I was able to copy the contents of this file into ubroker.properties restart the Admin Server and everything came up.

Posted in Epicor | Comments Off