Menu
▾
▴
sql-ledger-users
|
From: Roy W P. <arc...@mt...> - 2008-02-05 18:57:12
|
Afternoon everyone ! Long time no talk/email ! I finally got around to upgrading (from 2.6.27 to 2.8.12) I copied the setup.pl script into the /usr/local/sql-ledger and ran it. then i followed the docs for the 2.6. to 2.8 upgrade... copied the templates... removed the filename prefix.... i logged in and..... Upgrading to Version 2.8.12 ... Error! drop trigger del_recurring ON oe ERROR: trigger "del_recurring" for table "oe" does not exist I would assume that the upgrade script assumed i was using 2.7 or newer and it complained about a table that doesn't exist in 2.6.27 ? The 2.8 manual makes no mention of special way of upgrading from 2.6 I assume other have run into this ? What do i do now ? -- Roy Pennington Arch Distributors of Canada Phone: 204.257.8161 |
|
From: Michael H. <mh...@it...> - 2008-02-05 19:05:53
|
As I recall that error is "normal" and you can just re-login and it will be fine. Thanks, Michael On Feb 5, 2008, at 10:57 AM, Roy W Pennington wrote: > Afternoon everyone ! > Long time no talk/email ! > > I finally got around to upgrading (from 2.6.27 to 2.8.12) > > I copied the setup.pl script into the /usr/local/sql-ledger and ran > it. > then i followed the docs for the 2.6. to 2.8 upgrade... copied the > templates... removed the filename prefix.... > > i logged in and..... > > Upgrading to Version 2.8.12 ... > Error! > > drop trigger del_recurring ON oe > ERROR: trigger "del_recurring" for table "oe" does not exist > > I would assume that the upgrade script assumed i was using 2.7 or > newer and it complained about a table that doesn't exist in 2.6.27 ? > The 2.8 manual makes no mention of special way of upgrading from 2.6 > > I assume other have run into this ? > What do i do now ? > > -- > Roy Pennington > Arch Distributors of Canada > Phone: 204.257.8161 > > ---------------------------------------------------------------------- > --- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Adam V. <amv...@gm...> - 2008-02-05 19:11:27
|
Roy W Pennington wrote: > Afternoon everyone ! > Long time no talk/email ! > > I finally got around to upgrading (from 2.6.27 to 2.8.12) > > I copied the setup.pl script into the /usr/local/sql-ledger and ran it. > then i followed the docs for the 2.6. to 2.8 upgrade... copied the templates... removed the filename prefix.... > > i logged in and..... > > Upgrading to Version 2.8.12 ... > Error! > > drop trigger del_recurring ON oe > ERROR: trigger "del_recurring" for table "oe" does not exist > > I would assume that the upgrade script assumed i was using 2.7 or newer and it complained about a table that doesn't exist in 2.6.27 ? > The 2.8 manual makes no mention of special way of upgrading from 2.6 > > I assume other have run into this ? > What do i do now ? > > http://sourceforge.net/mailarchive/message.php?msg_id=20070511152330.M943%40gumby.simtax.ca -- Adam Vandemore Systems Administrator IMED Mobility |
|
From: Roy W P. <arc...@mt...> - 2008-02-05 20:16:43
|
Thanks Michael & Adam ! the section mentioned in the archive post that Adam linked to: ----------------- 3. If you receive the following error while upgrading ERROR: trigger "del_recurring" for table "oe" does not exist load admin.pl and "Unlock" the system. 4. log in --------------------- isn't in the doc for UPGRADE-2.6.27-2.8.0 but it is in the docs UPGRADE-2.8.0-2.8.2, UPGRADE-2.8.2-2.8.4 etc There is no doc named "UPGRADE-2.6.27-2.8.12".... is that an oversight ? or is it recommended to upgrade to 2.8. then incrementally to 2.8.12 ? -- Roy Pennington Arch Distributors of Canada Phone: 204.257.8161 |
|
From: Armaghan S. <sa...@le...> - 2008-02-06 02:38:28
|
Roy W Pennington wrote: > isn't in the doc for UPGRADE-2.6.27-2.8.0 > but it is in the docs UPGRADE-2.8.0-2.8.2, UPGRADE-2.8.2-2.8.4 etc > > There is no doc named "UPGRADE-2.6.27-2.8.12".... is that an oversight ? > or is it recommended to upgrade to 2.8. then incrementally to 2.8.12 ? Yes, the incremental upgrade is the recommended (and the only) way and seems logical because every upgrade script is written whenever a new (incremental) release comes out. Armaghan -- Purpose-built SQL-Ledger Hosting http://www.ledger123.com/ Free trial available. -- |
|
From: Dieter S. <dsi...@sq...> - 2008-02-06 16:31:47
|
On Wed, 6 Feb 2008, Armaghan Saqib wrote: > On 2/6/08, Dieter Simader <dsi...@sq...> wrote: >> come on, Armaghan, what a crock. > > What I did mean was upgrade through ****sql scripts **** is And this is different, how? SQL-Ledger runs the scripts for you, there is no need to run these scripts manually. > incremental. I did not say that you need to install each incremental > SL version to upgrade. Yes you did! > > I do this almost on daily basis for my hosting customers and just run > the sql-scripts. Have also documented it on my sql-ledger WIKI at Business must be really good for you if you are upgrading on a daily basis. > wiki.ledger123.com. See: > > http://wiki.ledger123.com/index.php?n=Local.Upgrades and > http://wiki.ledger123.com/index.php?n=Development.PostgreSQL You are not doing anyone a favour by distributing false information. |
|
From: Dieter S. <dsi...@sq...> - 2008-02-06 03:18:34
|
come on, Armaghan, what a crock. The upgrade can be done for any version from 1.2.7 onward without an incremental upgrade. This bit of information is even posted on the website at http://sql-ledger.com/cgi-bin/nav.pl?page=source/index.html&title=Download <quote> Upgrading from any version > 1.2.7 to the latest version Upgrading is easy. Load setup.pl from the sql-ledger root directory and select Upgrade. The script will lock everyone out and install the new code over top. The only thing left to do is to log in to upgrade a dataset. To upgrade manually load admin.pl and Lock the system. Download the new code and untar over top and fix the permissions according to the UPGRADE file in the doc directory. Most of the time there is nothing else to be done. Load admin.pl and Unlock the system. When a user logs in the Dataset is upgraded automatically, you do not have to do anything. If other steps are required, i.e template modifications, they will be listed in the UPGRADE file. You DO NOT have to install intermediate versions to upgrade to the latest version! Intermediate upgrades are done for you. </unquote> On Wed, 6 Feb 2008, Armaghan Saqib wrote: > Roy W Pennington wrote: >> isn't in the doc for UPGRADE-2.6.27-2.8.0 >> but it is in the docs UPGRADE-2.8.0-2.8.2, UPGRADE-2.8.2-2.8.4 etc >> >> There is no doc named "UPGRADE-2.6.27-2.8.12".... is that an oversight ? >> or is it recommended to upgrade to 2.8. then incrementally to 2.8.12 ? > Yes, the incremental upgrade is the recommended (and the only) way and > seems logical because every upgrade script is written whenever a new > (incremental) release comes out. > > Armaghan > > |
|
From: Armaghan S. <sa...@le...> - 2008-02-06 09:03:57
|
On 2/6/08, Dieter Simader <dsi...@sq...> wrote: > come on, Armaghan, what a crock. What I did mean was upgrade through ****sql scripts **** is incremental. I did not say that you need to install each incremental SL version to upgrade. I do this almost on daily basis for my hosting customers and just run the sql-scripts. Have also documented it on my sql-ledger WIKI at wiki.ledger123.com. See: http://wiki.ledger123.com/index.php?n=Local.Upgrades and http://wiki.ledger123.com/index.php?n=Development.PostgreSQL Sorry for causing any confusion to list members. Regards -- Purpose-built SQL-Ledger Hosting http://www.ledger123.com/ Free trial available. -- |
|
From: Dirk E. S. <ds...@ca...> - 2008-02-07 03:26:34
|
> come on, Armaghan, what a crock. > > The upgrade can be done for any version from 1.2.7 onward without an > incremental upgrade. This is theory, practice is different. I just upgraded an install that has 25 companies from 2.6-something to 2.8.11. Besides of the lock-unlock workaround desribe in the upgrade docs I had lots of trouble. - Half of the companies worked just fien after loggong in, locking, unlocking and loggin in agian. The rest just were impossiblle to upgrade. Problems start with: Error! alter table semaphore add expires varchar(10) ERROR: ya existe la columna «expires» en la relación «semaphore» and Actulaizando a versión 2.8.11 ... Error! create table curr (rn int, curr char(3) primary key, precision int2) ..you never make it until the end. - The funny part is: Other companies (databases) upgrade like a charm, same install, same versions. The diffenrece you fin in the user configuration: Some of my users didn't have configured their defualt currency, not even the company name; - obviously bad, but this shouldn't brake the upgrades. It took me the whole night for an upgrade that should take not more than one our. 1) Login to each company. If they were fine they complained once, you just had to go to admin, lock, unlock, login again. 2) For companies that complained about semaphore I had to edit and run manually the Pg-upgrade-2.8.6-2.8.7.sql by hand, do the upgrade after. Logging into 25 companies for 4-5 times, checking etc. is a pain. Definitely something is wrong with the upgrade scripts. - Finally I made it, all companies are up and working fine. Thats the only good news on upgrading to 2.8.11, jumping some versions. If you do continous upgrading your life is easier! Best wishes Enrique -- Dirk Enrique Seiffert - Lintec S.A. Ed. Torre del Reloj - Of. 401 Plaza de los Coches, Centro Cartagena - Colombia http://www.lintecsa.com |
|
From: J.M. \Jersey\ M. <je...@ib...> - 2008-02-08 12:53:03
|
Hi All, Following scenario: The Customer is invoiced lump sum for the project. This involves time, goods, accommodation and so on. How can I allocate expenses to the project without issuing invoices? Best regards "Jersey" |
|
From: Paul T. <pt...@wa...> - 2008-02-08 13:14:02
|
Make a project code, use that for both revenue lump sum and for costs invoices and hours, do a project report and be prepare to be amazed? 2008/2/8, J.M. Jersey Miszczyk <je...@ib...>: > > Hi All, > > Following scenario: > The Customer is invoiced lump sum for the project. This involves time, > goods, accommodation and so on. > > How can I allocate expenses to the project without issuing invoices? > > Best regards > "Jersey" > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > |
|
From: Jersey <je...@ib...> - 2008-02-08 19:46:12
|
Thnx :), Sounds easy, but... I am using SQL_Ledger 2.8.12... and I am not really an accountant. How do I "invoice" the project. Or how do I "assign" a lump sum to the project? Some items will be invoiced to the client. How can I allocate the invoices to the project? Some "consumables", time etc will not be invoiced but they still should be allocated to the cost of the project. I am checking the manual... maybe I'll get a vision :) ----- Original Message ----- From: "Paul Tammes" <pt...@wa...> To: <sql...@li...> Sent: Friday, February 08, 2008 3:13 PM Subject: Re: [SL] Projects and goods allocation > Make a project code, use that for both revenue lump sum and for costs > invoices and hours, do a project report and be prepare to be amazed? > > 2008/2/8, J.M. Jersey Miszczyk <je...@ib...>: >> >> Hi All, >> >> Following scenario: >> The Customer is invoiced lump sum for the project. This involves time, >> goods, accommodation and so on. >> >> How can I allocate expenses to the project without issuing invoices? >> >> Best regards >> "Jersey" >> >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2008. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.19.20/1261 - Release Date: 2/5/2008 > 8:57 PM > > |
|
From: J.M. \Jersey\ M. <je...@ib...> - 2008-02-13 05:26:51
|
Hi all, How would one go about creating Bill of Materials from a sales order. When you want to invoice out assemblies and get detailed list of components with suppliers names. Best regards "Jersey" |
|
From: Paul T. <pt...@wa...> - 2008-02-13 06:24:22
|
[Off Topic] Why would you want to do that? So the customer can order parts and assemble himself next time? Use supplier name, so the customer can cut you out as middleman? Seems not the brightest of plans.. [On Topic} Use make parts, use all name, article number and supplier info you like in part name. Then use make assembly and make a sales order for the assembly. Alternatively, it., if we are talking consultancy, make one article assembly with 5000 lines of text info related to it. 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>: > > Hi all, > > How would one go about creating Bill of Materials from a sales order. When > you want to invoice out assemblies and get detailed list of components > with > suppliers names. > > Best regards > "Jersey" > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > |
|
From: Michael H. <mh...@it...> - 2008-02-13 07:09:13
|
Re [Off Topic] I don't know about NL and ZA but in the US most distributors won't sell to "end users". Also, (continuing to play Devil's advocate :), in the US some classified military contracts require the complete supply chain to be detailed. Not to mention I could see where a detailed BOM might be handy just for training purposes... Thanks, Michael On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote: > [Off Topic] > > Why would you want to do that? So the customer can order parts and > assemble > himself next time? > Use supplier name, so the customer can cut you out as middleman? > Seems not > the brightest of plans.. > > [On Topic} > > Use make parts, use all name, article number and supplier info you > like in > part name. > Then use make assembly and make a sales order for the assembly. > > Alternatively, it., if we are talking consultancy, make one article > assembly > with 5000 lines of text info related to it. > > > 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>: >> >> Hi all, >> >> How would one go about creating Bill of Materials from a sales >> order. When >> you want to invoice out assemblies and get detailed list of >> components >> with >> suppliers names. >> >> Best regards >> "Jersey" >> >> >> --------------------------------------------------------------------- >> ---- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2008. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> > ---------------------------------------------------------------------- > --- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: J.M. \Jersey\ M. <je...@ib...> - 2008-02-13 14:03:37
|
Sorry guys... misunderstanding. Imagine: I get the order, multiple instances of the various assemblies. Now I want to make (for myself only) a list of all the parts including quantities, last prices and suppliers. Is it possible? -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Michael Hasse Sent: 13 February 2008 09:09 AM To: sql...@li... Subject: Re: [SL] BOM Re [Off Topic] I don't know about NL and ZA but in the US most distributors won't sell to "end users". Also, (continuing to play Devil's advocate :), in the US some classified military contracts require the complete supply chain to be detailed. Not to mention I could see where a detailed BOM might be handy just for training purposes... Thanks, Michael On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote: > [Off Topic] > > Why would you want to do that? So the customer can order parts and > assemble > himself next time? > Use supplier name, so the customer can cut you out as middleman? > Seems not > the brightest of plans.. > > [On Topic} > > Use make parts, use all name, article number and supplier info you > like in > part name. > Then use make assembly and make a sales order for the assembly. > > Alternatively, it., if we are talking consultancy, make one article > assembly > with 5000 lines of text info related to it. > > > 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>: >> >> Hi all, >> >> How would one go about creating Bill of Materials from a sales >> order. When >> you want to invoice out assemblies and get detailed list of >> components >> with >> suppliers names. >> >> Best regards >> "Jersey" >> >> >> --------------------------------------------------------------------- >> ---- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2008. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> > ---------------------------------------------------------------------- > --- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date: 2/12/2008 3:20 PM |
|
From: Michael H. <mh...@it...> - 2008-02-13 18:28:59
|
I believe Paul's reply below (the [Ontopic] section) contains the
answer. Haven't tried it myself but it sounds good!
Set up your parts to have all those details then use Assemblies
to group the parts as you please and a Sales Order with the Assembly
to get the actual output.
Thanks,
Michael
On Feb 13, 2008, at 6:04 AM, J.M. Jersey Miszczyk wrote:
> Sorry guys... misunderstanding. Imagine:
> I get the order, multiple instances of the various assemblies. Now
> I want to
> make (for myself only) a list of all the parts including
> quantities, last
> prices and suppliers. Is it possible?
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf
> Of Michael
> Hasse
> Sent: 13 February 2008 09:09 AM
> To: sql...@li...
> Subject: Re: [SL] BOM
>
> Re [Off Topic] I don't know about NL and ZA but in the US most
> distributors won't sell to "end users". Also, (continuing to play
> Devil's advocate :), in the US some classified military contracts
> require the complete supply chain to be detailed. Not to mention I
> could see where a detailed BOM might be handy just for training
> purposes...
>
>
> Thanks,
>
> Michael
>
>
> On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote:
>
>> [Off Topic]
>>
>> Why would you want to do that? So the customer can order parts and
>> assemble
>> himself next time?
>> Use supplier name, so the customer can cut you out as middleman?
>> Seems not
>> the brightest of plans..
>>
>> [On Topic}
>>
>> Use make parts, use all name, article number and supplier info you
>> like in
>> part name.
>> Then use make assembly and make a sales order for the assembly.
>>
>> Alternatively, it., if we are talking consultancy, make one article
>> assembly
>> with 5000 lines of text info related to it.
>>
>>
>> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>:
>>>
>>> Hi all,
>>>
>>> How would one go about creating Bill of Materials from a sales
>>> order. When
>>> you want to invoice out assemblies and get detailed list of
>>> components
>>> with
>>> suppliers names.
>>>
>>> Best regards
>>> "Jersey"
>>>
>>>
>>> --------------------------------------------------------------------
>>> -
>>> ----
>>> This SF.net email is sponsored by: Microsoft
>>> Defy all challenges. Microsoft(R) Visual Studio 2008.
>>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>> ---------------------------------------------------------------------
>> -
>> ---
>> This SF.net email is sponsored by: Microsoft
>> Defy all challenges. Microsoft(R) Visual Studio 2008.
>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ----------------------------------------------------------------------
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date:
> 2/12/2008
> 3:20 PM
>
>
>
> ----------------------------------------------------------------------
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
|
|
From: Paul T. <pt...@wa...> - 2008-02-14 07:49:06
|
Sure, then later use articles - stock treport to see how much is in stock. You may even disassemble assemblies back to spare parts if you should want to ;-) 2008/2/13, Michael Hasse <mh...@it...>: > > I believe Paul's reply below (the [Ontopic] section) contains the > answer. Haven't tried it myself but it sounds good! > Set up your parts to have all those details then use Assemblies > to group the parts as you please and a Sales Order with the Assembly > to get the actual output. > > > Thanks, > > > Michael > > > > On Feb 13, 2008, at 6:04 AM, J.M. Jersey Miszczyk wrote: > > > Sorry guys... misunderstanding. Imagine: > > I get the order, multiple instances of the various assemblies. Now > > I want to > > make (for myself only) a list of all the parts including > > quantities, last > > prices and suppliers. Is it possible? > > > > -----Original Message----- > > From: sql...@li... > > [mailto:sql...@li...] On Behalf > > Of Michael > > Hasse > > Sent: 13 February 2008 09:09 AM > > To: sql...@li... > > Subject: Re: [SL] BOM > > > > Re [Off Topic] I don't know about NL and ZA but in the US most > > distributors won't sell to "end users". Also, (continuing to play > > Devil's advocate :), in the US some classified military contracts > > require the complete supply chain to be detailed. Not to mention I > > could see where a detailed BOM might be handy just for training > > purposes... > > > > > > Thanks, > > > > Michael > > > > > > On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote: > > > >> [Off Topic] > >> > >> Why would you want to do that? So the customer can order parts and > >> assemble > >> himself next time? > >> Use supplier name, so the customer can cut you out as middleman? > >> Seems not > >> the brightest of plans.. > >> > >> [On Topic} > >> > >> Use make parts, use all name, article number and supplier info you > >> like in > >> part name. > >> Then use make assembly and make a sales order for the assembly. > >> > >> Alternatively, it., if we are talking consultancy, make one article > >> assembly > >> with 5000 lines of text info related to it. > >> > >> > >> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>: > >>> > >>> Hi all, > >>> > >>> How would one go about creating Bill of Materials from a sales > >>> order. When > >>> you want to invoice out assemblies and get detailed list of > >>> components > >>> with > >>> suppliers names. > >>> > >>> Best regards > >>> "Jersey" > >>> > >>> > >>> -------------------------------------------------------------------- > >>> - > >>> ---- > >>> This SF.net email is sponsored by: Microsoft > >>> Defy all challenges. Microsoft(R) Visual Studio 2008. > >>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >>> _______________________________________________ > >>> sql-ledger-users mailing list > >>> sql...@li... > >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >>> > >>> > >> --------------------------------------------------------------------- > >> - > >> --- > >> This SF.net email is sponsored by: Microsoft > >> Defy all challenges. Microsoft(R) Visual Studio 2008. > >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > ---------------------------------------------------------------------- > > --- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2008. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > -- > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date: > > 2/12/2008 > > 3:20 PM > > > > > > > > ---------------------------------------------------------------------- > > --- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2008. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > |
|
From: J.M. \Jersey\ M. <je...@ib...> - 2008-02-15 07:57:13
|
Thnx guys :) -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Paul Tammes Sent: 14 February 2008 09:49 AM To: sql...@li... Subject: Re: [SL] BOM Sure, then later use articles - stock treport to see how much is in stock. You may even disassemble assemblies back to spare parts if you should want to ;-) 2008/2/13, Michael Hasse <mh...@it...>: > > I believe Paul's reply below (the [Ontopic] section) contains the > answer. Haven't tried it myself but it sounds good! > Set up your parts to have all those details then use Assemblies > to group the parts as you please and a Sales Order with the Assembly > to get the actual output. > > > Thanks, > > > Michael > > > > On Feb 13, 2008, at 6:04 AM, J.M. Jersey Miszczyk wrote: > > > Sorry guys... misunderstanding. Imagine: > > I get the order, multiple instances of the various assemblies. Now > > I want to > > make (for myself only) a list of all the parts including > > quantities, last > > prices and suppliers. Is it possible? > > > > -----Original Message----- > > From: sql...@li... > > [mailto:sql...@li...] On Behalf > > Of Michael > > Hasse > > Sent: 13 February 2008 09:09 AM > > To: sql...@li... > > Subject: Re: [SL] BOM > > > > Re [Off Topic] I don't know about NL and ZA but in the US most > > distributors won't sell to "end users". Also, (continuing to play > > Devil's advocate :), in the US some classified military contracts > > require the complete supply chain to be detailed. Not to mention I > > could see where a detailed BOM might be handy just for training > > purposes... > > > > > > Thanks, > > > > Michael > > > > > > On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote: > > > >> [Off Topic] > >> > >> Why would you want to do that? So the customer can order parts and > >> assemble > >> himself next time? > >> Use supplier name, so the customer can cut you out as middleman? > >> Seems not > >> the brightest of plans.. > >> > >> [On Topic} > >> > >> Use make parts, use all name, article number and supplier info you > >> like in > >> part name. > >> Then use make assembly and make a sales order for the assembly. > >> > >> Alternatively, it., if we are talking consultancy, make one article > >> assembly > >> with 5000 lines of text info related to it. > >> > >> > >> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>: > >>> > >>> Hi all, > >>> > >>> How would one go about creating Bill of Materials from a sales > >>> order. When > >>> you want to invoice out assemblies and get detailed list of > >>> components > >>> with > >>> suppliers names. > >>> > >>> Best regards > >>> "Jersey" > >>> > >>> > >>> -------------------------------------------------------------------- > >>> - > >>> ---- > >>> This SF.net email is sponsored by: Microsoft > >>> Defy all challenges. Microsoft(R) Visual Studio 2008. > >>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >>> _______________________________________________ > >>> sql-ledger-users mailing list > >>> sql...@li... > >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >>> > >>> > >> --------------------------------------------------------------------- > >> - > >> --- > >> This SF.net email is sponsored by: Microsoft > >> Defy all challenges. Microsoft(R) Visual Studio 2008. > >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > ---------------------------------------------------------------------- > > --- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2008. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > -- > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date: > > 2/12/2008 > > 3:20 PM > > > > > > > > ---------------------------------------------------------------------- > > --- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2008. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.4/1277 - Release Date: 2/13/2008 8:00 PM |
|
From: Armaghan S. <sa...@le...> - 2008-02-14 04:22:55
|
J.M. "Jersey" Miszczyk wrote: > Sorry guys... misunderstanding. Imagine: > I get the order, multiple instances of the various assemblies. Now I want to > make (for myself only) a list of all the parts including quantities, last > prices and suppliers. Is it possible? > > "Goods & Services--Reports--Requirements" is something close to your requirements though it does not give you supplier name and last cost. Armaghan -- Purpose-built SQL-Ledger Hosting http://www.ledger123.com/ Free trial available. -- |
|
From: Dieter S. <dsi...@sq...> - 2008-02-06 03:41:07
|
duh, Roy, if this error does not happen in the upgrade from 2.6.27-2.8.0 but it happens in the upgrade 2.8.0-2.8.2 why should it be in the UPGRADE docs for 2.6.27-2.8.0 ? BTW, this error was done delibertly so people wouldn't have to mess around with the upgrade scripts. I could have left the oneliner which is in Pg-upgrade-2.8.0-2.8.2.sql in the next upgrade script and have you edit the upgrade scripts instead. Which is easier, load admin.pl, unlock the system and log in again or have you edit the upgrade script? On Tue, 5 Feb 2008, Roy W Pennington wrote: > Thanks Michael & Adam ! > > the section mentioned in the archive post that Adam linked to: > > ----------------- > 3. If you receive the following error while upgrading > > ERROR: trigger "del_recurring" for table "oe" does not exist > > load admin.pl and "Unlock" the system. > > 4. log in > --------------------- > > isn't in the doc for UPGRADE-2.6.27-2.8.0 > but it is in the docs UPGRADE-2.8.0-2.8.2, UPGRADE-2.8.2-2.8.4 etc > > There is no doc named "UPGRADE-2.6.27-2.8.12".... is that an oversight ? > or is it recommended to upgrade to 2.8. then incrementally to 2.8.12 ? > > |
|
From: Roy W P. <arc...@mt...> - 2008-02-06 16:23:07
|
On February 5, 2008, Dieter Simader wrote: > duh, Roy, if this error does not happen in the upgrade from 2.6.27-2.8.0 > but it happens in the upgrade 2.8.0-2.8.2 why should it be in the UPGRADE > docs for 2.6.27-2.8.0 ? > But it DOES happen when upgrading from 2.6.27 to 2.8.12 I never meant to suggest it should be in the 2.6.27-2.8.0 doc > BTW, this error was done delibertly so people wouldn't have to mess around > with the upgrade scripts. I could have left the oneliner which is in > Pg-upgrade-2.8.0-2.8.2.sql in the next upgrade script and have you edit > the upgrade scripts instead. > > Which is easier, load admin.pl, unlock the system and log in again or have > you edit the upgrade script? obvious answer FWIW As you know, I own a copy of the manual and have used SL for a while. I'm familiar with the traditional upgrade process and yet... I read the 2.6.27-2.8.0 upgrade docs and the readme that the setup script always gives the option to display, and didn't see a mention of the possible error. I guess i could have read the 2.6.12-2.8.0 upgrade docs AND then 2.8.0-2.8.x upgrade docs, but it's not intuitive to read docs for a 2.8.0-2.8.12 upgrade when you aren't upgrading from 2.8.0... That said, it would be a pain to keep having to create upgrade docs for every possible upgrade combination. I'm someone who reads docs and yet I didn't read anything about the error being expected. Maybe stick a comment in the readme or FAQ ? who knows.... It's not a criticism so don't take it that way. it's a suggestion in the interest of making things easier for everyone. IMO, any way to prevent people from littering the list with questions to documented answers is a good thing. Cheers, Roy |
|
From: Dieter S. <dsi...@sq...> - 2008-02-06 17:18:50
|
On Wed, 6 Feb 2008, Roy W Pennington wrote: > On February 5, 2008, Dieter Simader wrote: >> duh, Roy, if this error does not happen in the upgrade from 2.6.27-2.8.0 >> but it happens in the upgrade 2.8.0-2.8.2 why should it be in the UPGRADE >> docs for 2.6.27-2.8.0 ? >> > But it DOES happen when upgrading from 2.6.27 to 2.8.12 Roy, I told you the error happens when you upgrade from 2.8.0-2.8.2 The fact that you are upgrading from 2.6.27 has nothing to do with the error when it happens. If you were to upgrade to 2.8.0 there is no such error but because you are continuing with the upgrade to 2.8.12 the error crops up. Do you understand it now? > I never meant to suggest it should be in the 2.6.27-2.8.0 doc Yes, this is what you suggested and are still suggesting, see above. |
|
From: Roy W P. <arc...@mt...> - 2008-02-06 18:11:58
|
On February 6, 2008, Dieter Simader wrote: > On Wed, 6 Feb 2008, Roy W Pennington wrote: > > > On February 5, 2008, Dieter Simader wrote: > >> duh, Roy, if this error does not happen in the upgrade from 2.6.27-2.8.0 > >> but it happens in the upgrade 2.8.0-2.8.2 why should it be in the UPGRADE > >> docs for 2.6.27-2.8.0 ? > >> > > But it DOES happen when upgrading from 2.6.27 to 2.8.12 > > Roy, I told you the error happens when you upgrade from 2.8.0-2.8.2 Yes i realized that weh i read the 1st replys to this thread... as you so eloquently say....DUH. but.. from a user stand point you are upgrading in 1 functional step, regardless of what the scripts are doing behind the scene. > The fact that you are upgrading from 2.6.27 has nothing to do with the > error when it happens. If you were to upgrade to 2.8.0 there is no such > error but because you are continuing with the upgrade to 2.8.12 the error > crops up. Do you understand it now? Yes i understand it. My point was it is not intuitive. From a user stand point you are upgrading in 1 functional step, regardless of what the scripts are doing behind the scene. The fantastic upgrade method simplifies the process to 1 simple step, but the docs are set up to assume that the user realizes that the script does it in multiple steps. It is not intuitive to read multiple upgrade documents (2.6.27-2.8.0 then 2.8.0-2.8.x etc etc) when from a user standpoint you are seemingly upgrading in 1 step. > > I never meant to suggest it should be in the 2.6.27-2.8.0 doc > > Yes, this is what you suggested and are still suggesting, see above. NO. If you read my last post.... you may see that i am suggesting that there MAY be ANOTHER way to document the process. It could be simply creating another doc called '2.6.27-2.8.12 upgrade' or adding it to the faq or in the readme file or whatever... My point is the docs are not totally inuitive, and that can lead to otherwise needless questions. Do with that input as you wish. Roy FWIW, as a successful, former business owner who will be retiring early to go travel the world on his sailboat.... I learned long ago, that replying to customers in a seemingly condescending way does little to help improve revenue. During the current transition to the new owners, I have suggested that they use SQL-ledger and pay for ongoing support. It's mailing list threads like this that make me start to question my advice to them. |
|
From: Michael H. <mh...@it...> - 2008-02-06 18:40:29
|
> It's mailing list threads like this that make me start to question...
----------------------------------
At first blush I would agree, but this isn't really normal for
Dieter. He may be a bit brief at times but Dieter usually comes
across as a regular guy running a small business and treating his
paying customers right. These few posts sound more like the
stereotypical programmer-curmudgeon growling at the rest of humanity.
However, this is the flip side of the great advantage of only
having to deal with one person, you only have one person to deal
with! If they are stressed out in some other part of their life one
gets the spillover without any context.
So let's give Dieter the benefit of the doubt and wish him the best.
Thanks,
Michael
On Feb 6, 2008, at 10:11 AM, Roy W Pennington wrote:
> On February 6, 2008, Dieter Simader wrote:
>> On Wed, 6 Feb 2008, Roy W Pennington wrote:
>>
>>> On February 5, 2008, Dieter Simader wrote:
>>>> duh, Roy, if this error does not happen in the upgrade from
>>>> 2.6.27-2.8.0
>>>> but it happens in the upgrade 2.8.0-2.8.2 why should it be in
>>>> the UPGRADE
>>>> docs for 2.6.27-2.8.0 ?
>>>>
>>> But it DOES happen when upgrading from 2.6.27 to 2.8.12
>>
>> Roy, I told you the error happens when you upgrade from 2.8.0-2.8.2
>
> Yes i realized that weh i read the 1st replys to this thread... as
> you so eloquently say....DUH.
> but.. from a user stand point you are upgrading in 1 functional
> step, regardless of what the scripts are doing behind the scene.
>
>> The fact that you are upgrading from 2.6.27 has nothing to do with
>> the
>> error when it happens. If you were to upgrade to 2.8.0 there is no
>> such
>> error but because you are continuing with the upgrade to 2.8.12
>> the error
>> crops up. Do you understand it now?
>
> Yes i understand it.
> My point was it is not intuitive.
>> From a user stand point you are upgrading in 1 functional step,
>> regardless of what the scripts are doing behind the scene.
> The fantastic upgrade method simplifies the process to 1 simple
> step, but the docs are set up to assume that the user realizes that
> the script does it in multiple steps.
> It is not intuitive to read multiple upgrade documents
> (2.6.27-2.8.0 then 2.8.0-2.8.x etc etc) when from a user standpoint
> you are seemingly upgrading in 1 step.
>
>>> I never meant to suggest it should be in the 2.6.27-2.8.0 doc
>>
>> Yes, this is what you suggested and are still suggesting, see above.
>
> NO. If you read my last post.... you may see that i am suggesting
> that there MAY be ANOTHER way to document the process.
> It could be simply creating another doc called '2.6.27-2.8.12
> upgrade' or adding it to the faq or in the readme file or whatever...
> My point is the docs are not totally inuitive, and that can lead to
> otherwise needless questions.
>
>
> Do with that input as you wish.
>
> Roy
>
> FWIW, as a successful, former business owner who will be retiring
> early to go travel the world on his sailboat....
> I learned long ago, that replying to customers in a seemingly
> condescending way does little to help improve revenue.
> During the current transition to the new owners, I have suggested
> that they use SQL-ledger and pay for ongoing support. It's mailing
> list threads like this that make me start to question my advice to
> them.
>
> ----------------------------------------------------------------------
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X