MONTMERE.COM

blog.montmere.com

Bill of Materials and Quantities in Dynamics GP 10 | Montmere

http://blog.montmere.com/2011/05/16/bill-of-materials-and-quantities-in-dynamics-gp-10

The goings-on of Montmere Limited. Bill of Materials and Quantities in Dynamics GP 10. Bill of Materials and Quantities in Dynamics GP 10. Here’s a SQL query that will allow you to see what components go into a given finished part number along with the available, on hand, allocated, and back ordered quantities. This is useful if you have a rush job with not enough quantity available in GP and want to see what’s actually in house. DECLARE @needed as INT. DECLARE @item as char(20). SET @needed = 1. Missing...

blog.montmere.com

Zend_Form_Element_Daterange with jQuery UI datepicker | Montmere

http://blog.montmere.com/2011/04/10/zend_form_element_daterange-with-jquery-ui-datepicker

The goings-on of Montmere Limited. Zend Form Element Daterange with jQuery UI datepicker. Zend Form Element Daterange with jQuery UI datepicker. It’s pretty easy to create a wrapper around Zend Form Element Text to make a datepicker, but creating a good, smart daterange picker is a little more tricky. The only two requirements are jQuery UI and that you have some way of injecting JavaScript into your site layout (I use a $this- layout()- headJavascript). Here are the 3x files you’ll need:. Throw new Zend...

blog.montmere.com

Eric Sukalac | Montmere

http://blog.montmere.com/author/ericsukalac

The goings-on of Montmere Limited. Determining Month to Date Sales in Dynamics GP 10 with Project Accounting. This was a tough one. I needed to find month to date sales in GP compiling Sales Orders and entries in Project Accounting. To complicated things a little more, I needed to use the Invoicing amount in Sales Orders if they’ve been fully invoiced and the Invoiced amount from Project Accounting when it is more than the total Fee Schedule. Let me know if you have any questions or comments. DECLARE @it...

blog.montmere.com

Zend Framework | Montmere

http://blog.montmere.com/category/zend-framework

The goings-on of Montmere Limited. Archive for the ‘ Zend Framework. Zend Form Element Daterange with jQuery UI datepicker. It’s pretty easy to create a wrapper around Zend Form Element Text to make a datepicker, but creating a good, smart daterange picker is a little more tricky. The only two requirements are jQuery UI and that you have some way of injecting JavaScript into your site layout (I use a $this- layout()- headJavascript). Other than that, this should be pretty plug-and-play. Throw new Zend Fi...

blog.montmere.com

Dynamics GP | Montmere

http://blog.montmere.com/category/dynamics-gp

The goings-on of Montmere Limited. Archive for the ‘ Dynamics GP. Determining Month to Date Sales in Dynamics GP 10 with Project Accounting. This was a tough one. I needed to find month to date sales in GP compiling Sales Orders and entries in Project Accounting. To complicated things a little more, I needed to use the Invoicing amount in Sales Orders if they’ve been fully invoiced and the Invoiced amount from Project Accounting when it is more than the total Fee Schedule. Month to Date Sales. This is us...

blog.montmere.com

Month to Date Sales | Montmere

http://blog.montmere.com/tag/month-to-date-sales

The goings-on of Montmere Limited. Posts Tagged ‘ Month to Date Sales. Determining Month to Date Sales in Dynamics GP 10 with Project Accounting. This was a tough one. I needed to find month to date sales in GP compiling Sales Orders and entries in Project Accounting. To complicated things a little more, I needed to use the Invoicing amount in Sales Orders if they’ve been fully invoiced and the Invoiced amount from Project Accounting when it is more than the total Fee Schedule. Month to Date Sales. Missi...

blog.montmere.com

GP | Montmere

http://blog.montmere.com/tag/gp

The goings-on of Montmere Limited. Posts Tagged ‘ GP. Determining Month to Date Sales in Dynamics GP 10 with Project Accounting. This was a tough one. I needed to find month to date sales in GP compiling Sales Orders and entries in Project Accounting. To complicated things a little more, I needed to use the Invoicing amount in Sales Orders if they’ve been fully invoiced and the Invoiced amount from Project Accounting when it is more than the total Fee Schedule. Month to Date Sales. Find a Catholic Mass.

blog.montmere.com

PSR-0 Final Proposal | Montmere

http://blog.montmere.com/2011/09/21/psr-0-final-proposal

The goings-on of Montmere Limited. Somehow the PSR-0 Final Proposal disappeared from groups.google.com. I’m putting it here since no one seems to have been responsible enough to post it elsewhere. The following describes the mandatory requirements that must be adhered to for autoloader interoperability. A fully-qualified namespace and class must have the following structure. Each namespace must have a top-level namespace (“Vendor Name”). Each namespace can have as many sub-namespaces as it wishes. The st...

blog.montmere.com

Looking at Manufacturing Orders Associated with Sales Order Lines in Dynamics GP 10 | Montmere

http://blog.montmere.com/2011/05/06/looking-at-manufacturing-orders-associated-with-sales-order-lines-in-dynamics-gp-10

The goings-on of Montmere Limited. Looking at Manufacturing Orders Associated with Sales Order Lines in Dynamics GP 10. Looking at Manufacturing Orders Associated with Sales Order Lines in Dynamics GP 10. Here’s a query that will allow you to see which Open SO Lines have MOs associated with them and which MO exactly it is. This is helpful when you’re looking to find “lost orders” that haven’t yet been processed in Manufacturing. Complete'AND Sales."QTY Remaining" 0 ORDER BY "SOP Number" ASC.