Create Jobs from the Nonconformance Screen with a Button Click
In the Nonconformance screen, we placed buttons in the Operation, PO Receipts, and RMA tabs. When clicked, these buttons would use the fields from each associated tab to auto-generate Jobs. Not only that, after creating the Jobs, the screen would automatically schedule and release them.
Read More »Automate the Approval Process and Revision for Specifications
In the Specification Maintenance screen, we added an Inspection Attributes tab that utilized custom tables to store additional attributes for each specification. Additionally, we automated the approval process entirely, as well as, auto-generated revisions and defaults. This simplified the revision and approval process while allowing them to create more detailed Specifications.
Read More »Dynamic Query Extraction in Epicor® using Recursive Linking
In this Task, I was able to successfully implement Recursive linking into a Query. The Queries objective was to grab all parts that had been sold in the last two years. But also needed to include the Components that went into that part as well as the sequential BOM Levels (0,1,2,3). Then final combine that […]
Read More »Need access to Two datasets in 1 Tablix
In this example, I was uplifting a BAQ Crystal Report to SSRS. I had a need where I needed to use a parameter from the BAQReportParameter Dataset when my main Tablix was using the BAQReportResult Dataset. Why did I need the parameter? There was a complex expression that HAD to be created in a textbox […]
Read More »Extracting a Large Amount of Data Using a Command Prompt and DMT (Requires Epicor® 10.1 or Later): Epicor BAQ Training
Epicor Solutions: Extracting data out can be a cumbersome task and very time consuming. Epicor BAQ Training: Running a DMT extract via the command prompt is much easier and quicker. It utilizes a BAQ that pulls the data and then writes the data to an excel file. All this is done automatically by typing a […]
Read More »