|
From: emdeex <em...@gm...> - 2006-10-25 01:19:35
|
Thanks for the tips Richard, I refined it down a bit and made some changes: http://www.weberp.org/wikidocs/HOWTO?v=1dva On 10/20/06, Richard Flores-Moore <ri...@bt...> wrote: > > HI emdeex, > > ...erm, I am not sure of the level of sophistication you need but if you > just need a list of customer numbers the following SQL will work. > > select debtorno, sum(ovamount) from debtortrans where year(trandate)=2006 > group by debtorno > having sum(ovamount)>500 > > ...stitching it back to the debtorsmaster would require some thought but > probably if you wanted that too you could SQL the debtormaster and use the > above as a subselect. > > Hope this helps. > Best regards > RichFM > > ________________________________ > > From: web...@li... on behalf of > web...@li... > Sent: Wed 18/10/2006 20:24 > To: web...@li... > Subject: Web-erp-developers Digest, Vol 5, Issue 21 > > > > Send Web-erp-developers mailing list submissions to > web...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > or, via email, send a message with subject or body 'help' to > web...@li... > > You can reach the person managing the list at > web...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Web-erp-developers digest..." > > > Today's Topics: > > 1. WebERP and Christmas/NY (emdeex) > 2. Re: WebERP and Christmas/NY (st...@se...) > 3. Re: [webERP-users] Shipment Problems (st...@se...) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 18 Oct 2006 13:44:44 +1000 > From: emdeex <em...@gm...> > Subject: [WebERP-developers] WebERP and Christmas/NY > To: "webERP Developers" <web...@li...> > Message-ID: > <22c...@ma...> > Content-Type: text/plain; charset="iso-8859-1" > > Does anyone have some SQL to produce a Christmas/NY mailing list from > WebERP. > > Something like; all customers with a spend in 2006 that is above X? > > Maybe for Suppliers, all suppliers that we spent more than X with in 2006? > > Thanks for any help! > emdeex > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://sourceforge.net/mailarchive/forum.php?forum=web-erp-developers/attachments/20061018/4b40e7f8/attachment.html > > ------------------------------ > > Message: 2 > Date: Wed, 18 Oct 2006 04:52:49 -0700 (PDT) > From: st...@se... > Subject: Re: [WebERP-developers] WebERP and Christmas/NY > To: web...@li... > Message-ID: <199...@ww...> > Content-Type: text/plain;charset=iso-8859-1 > > Will be working on it in the next few months actually but not for this > Christmas. > > Steve > > -----Original Message----- > From: emdeex [mailto:em...@gm...] > Sent: Tuesday, October 17, 2006 11:45 PM > To: webERP Developers > Subject: [WebERP-developers] WebERP and Christmas/NY > > > Does anyone have some SQL to produce a Christmas/NY mailing list from > WebERP. > > Something like; all customers with a spend in 2006 that is above X? > > Maybe for Suppliers, all suppliers that we spent more than X with in 2006? > > Thanks for any help! > emdeex > > > > > ------------------------------ > > Message: 3 > Date: Wed, 18 Oct 2006 11:36:15 -0700 (PDT) > From: st...@se... > Subject: Re: [WebERP-developers] [webERP-users] Shipment Problems > To: web...@li... > Message-ID: <327...@ww...> > Content-Type: text/plain;charset=iso-8859-1 > > Ouch, Gareth, just realized I called you Graham and the gang in a > different list message. Sorry about that! > > Steve > > -----Original Message----- > From: Gareth Spanglett [mailto:ga...@ag...] > Sent: Wednesday, October 18, 2006 12:44 PM > To: For the general discussion of webERP project > Subject: Re: [webERP-users] Shipment Problems > > > Hi James and Jason, > > You have to finish the PO process in order to produce final figures. > Additional steps: > > - receive goods into warehouse (have you done this?) > - process invoice (sets final quantities and prices) > - register a payment and allocate to invoice > > Then, go to the Shipments. The zeros should then be updated with > finalized amounts. The weighted costing doesn't kick in until the > shipment is actually closed, at which point it calculates the additional > costs, distributes them based on the value of the goods, weights the > costing of each items and updates the standard cost. > > > > James Palof wrote: > > I am having the same issue with this. Does Any body know how to do > > this. Or is it a bug? > > > > James > > > > > > */Jason Grant <jg...@wa...>/* wrote: > > > > I have never managed to get the shipment costing working correctly. > > > > I have just tested in the Demo 3.05 RC1 and am still having the > > same problems. > > > > Here is my process. > > > > Generate a Purchase Order 1 For supplier 99. > > Create a Shipment for supplier 99 and add PO 1 to the shipment. > > Receive PO 1. > > > > Enter a Supplier Freight invoice against shipment. > > Enter a Supplier Invoice against Goods Received. > > > > View the shipment costing. > > > > The Extra Shipment Charges appear OK against the shipment costs > > however, none of the data seems to be updated for the stock lines. > > > > IE it shows an invoiced qty of 0, local costs of 0 etc and > > therefore no variances are reported. - See attached. > > > > Any help on what I am doing wrong would be greatly appreciated. > > > > Kind Regards > > > > J > > > > > > > > > > ------------------------------------------------------------------------ > > All-new Yahoo! Mail > > < > http://us.rd.yahoo.com/evt=43256/*http://advision.webevents.yahoo.com/mailbeta > >- > > Fire up a more powerful email and get things done faster. > > ------------------------------------------------------------------------ > > > > > ------------------------------------------------------------------------- > > Using Tomcat but need to do more? Need to support web services, > security? > > Get stuff done quickly with pre-integrated technology to make your job > easier > > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > web-ERP-users mailing list > > web...@li... > > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > > ------------------------------ > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > ------------------------------ > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > End of Web-erp-developers Digest, Vol 5, Issue 21 > ************************************************* > > > |