dcmwai_ (~chatzilla@219.95.155.118) joined #gnuenterprise. anyone here? I would like to have some idea about inventory. Action: derek looks around nope no one here Action: derek suspects if we laid down a box of donuts and started talking about sku's for any amount of time we coudl get Vee, jcater and chillywilly to wake up ;) what? ??? I forget what sku stands for stupid kiddie unix something about inventory stock keeping unit which means? inventory... damn inventory... t00t So... will you split out your inventory that in differnet places (HQ, Ware House) Nick change: dcmwai_ -> dcmwai I would expect there to be inventory 'locations' and 'lots' within those locations.. lots? I better talling who am I before asking a lot of question... :) like physical location? I'm the developer of Arias. ( shelf or whatever yea, type some more dcmwai =) the project that split out from Nola and ask you all may know Nola have Lot of Bug we are trying to fix them one by one then will start a rewrite... in our latest inventory design we treat inventory like double entry accounting ;)...that's probably all I should say And this will be the last one.. Inventory... I'm trying to fix the inventory that Nola cause arias as the replacement to nola if so we should talk YEs if you didnt know we actually snarfed the NOLA tree sometime ago and redid their structure chillywilly: Where can I find the flow and fixed a lot of the bus and put in private cvs dcmwai: this isn't gnue stuff derek: Actually yes we did i.e. we were going to port it to the GNU Enterprise Framework chillywilly: Har... that's why I'm not saying anything else i was going to look at arias (as part of gnue-sb implementation) and considered doing the same derek: doing what? the same but it looked at the time like you still had single directory structure format and a crap load of illegal code (font dependencies) forgive me for my languages.. English is not my native languages. and jason spent a lot of time fixing that in Acclite (our fork of NOLA) so i didnt want to tackle it again so moved on to the next thing derek: YEs... Indeep Nola have that and I still dare not to change them so fasr. s/fasr/fast NOLA also was very incomplete and heavily geared towards printing industry derek: Total Agree you are welcome to grab a copy of Acclite and change as you like it has directory structure fixed and all illegal font dependencies removed and is ported to work with postgres acclite? our fork of NOLA from some time back hey that is what I want postgresqk typo i spoke to Noguska (sp) for a few hours on the phone Hours... you must be right :) and was going to work with them on NOLA s/right/rich derek: then... which is why we never made Acclite 'public' sku is how many units you have in stock or something else? we wanted to avoid a fork no fork? but instead submit our changes to their CVS sku is a way to identify a specific part item product whatever but they were incapable of taking them at that the time :( and were abandoning free NOLA derek: well I would like you to help us in arias as well :) the developer of NOLA no longer works at Noguska why hasn't anyone developed schemas for various things? Is everyone really wanting to use appserver? and comes in here on occassion derek: the are going to make it to Nola PRO... chillywilly: again? appserver will never perform like straight relational design ;) chillywilly: I know but it will really take times to build something like that and for most (well is most) SME business they don't need that dcmwai: original plan was we were going to fix NOLA bugs and use the accounting as is dcmwai: well I am just talking in general cuase we really lack packages and bolt on other pieces and convert it all to the GNUe Framework i think our Acclite cvs has forms and such that do that and also I have seen the error of my middleware lovin' ways...got bit by going to more OO crap instead of just a nice db schema ;) we then started GNUe Small Business instead it was going really well until real life hit me :( hmm, I should look at what is there why? real life? dcmwai: wife kids and commitments (along with real job keeping me too busy) haha .... we all will have that problem sooner or later ;) what country are you from dcmwai? you said non native speaker right? Action: derek is curious if we have any GNU Enterprise folks near you Yep, I'm from Malaysia oh cool I don't think so ... :) i dont think we have any active people in Asia hot =) I'm the one :) several that have been interested from there we will have to have you test our i18n on some of the character sets there :) I like to test Chinese :) i suspect if they got all the cyrillic (sp) stuff working other character sets shouldnt be too bad Traditional and Simplify also no problem :) no really... Chinese Problem is more difficult then Japan ra3vat (~ds@ics.elcom.ru) left irc: Read error: 60 (Operation timed out) oh back to the main question... derek did you ever fix the inventory in nola? Action: dcmwai is trying to get the inventory fix within a week time. fixed? what is broken about it? Vee: you know nola? not really Vee: You don't really ... Arias have bad inventory .... Arias is from Nola... ra3vat (~ds@ics.elcom.ru) joined #gnuenterprise. dcmwai: no i didnt play with inventory we structured code and ported to postgres as task #! er #1 then we started to look at the accounting piece (as that was our initial need/interest) derek: do you think we can .... Join force? i think i fixed the account types bug and got it so i could create a chart of accounts accounting type bug? what bug is that? and got interrupted shortly there after dcmwai: as parting to postgres we had some 'issues' I didn't really see that. i.e. the SQL code was REALLY poorly implemented I know... and MySQL lets you do some REALLY bad things that why. I'm thinking to rewrite.. I agree with it. so when you would assign nulls to the primary key it would say 'ok cool i can do that' Damn mysql :0 and postgres would say F*** YOU MOTHER F****ER Action: dcmwai washroom something for sure if postgresql run the SQL I I'm sure that mysql will run it as well... So Action: Vee plays with the nola demo.. we should really write the SQL script base on PosqgreSQL this is interesting nola has a demo? Sex is like air. It's not important unless you aren't getting any. Vee: arias didn't have a demo yet :( i like that quote acclite had a demo somewhere where... Action: derek suspects i should try to revive that but i still want to focus on NOLA private.. :) i hate web applications why? um they suck you hate web application but want to focus on NOLA?? Action: derek announces the proverbial "every one is entitled to their own opinions" no i want to convert nola to the GNU Enterprise framework that was the goal from day one :) but we had immediate accounting software need I see... I've the same idea but just that... from nola to aria :) so figured it was best to clean up NOLA and get it working :-D Bad guy online :) so we could have something quickly then slowly port to the framework How long have you be workig with that? the accounting software deadline hit and we didnt have time so they went with something else and we stopped working on it we worked on it maybe a few weeks i think jcater restructured CVS and removed font dependencies one weekend oh... I work a few months :( and i tested and made chart of account forms the next weekend and patched some bugs micah had started to look at getting it fully functional, but don't know how much time he spent ... tis funny as i was going to contact arias when i did gnue-sb seem to me that everything is going in place.. gnue-sb? to see if you wanted to collaborate, but figured you just started up so likely weren't too interested GNU Enterprise Small Business Edition oh... http://www.gnu.org/software/gnue-sb/ so ... you left us out ... When is that happen? how funny we did this like a year ago the Acclite thing dcmwai: what motivates you with arias? Do you have a company you intend to manage with it? http://www.gnuenterprise.org/~dneighbo/acclite.tar.gz is an old snapshot No.. I've got this.. http://www.gnuenterprise.org/~jcater/snapshots/acclite/ :) http://www.gnuenterprise.org/~jcater/snapshots/acclite/ yip hey you beat me to it Vee: Motive... I don't have any... I just want to make it run... That all Simple. http://www.gnuenterprise.org/~jcater/snapshots/acclite/README.txt will tell you a lot derek: do You mind If I ask something? ask for something :) go ahead worst that can happen is i answer you ;) Action: derek notes you will find the humor in that if you stay around here long enough rather then making the change to Nola. would tou mind to make the change on arias CVS? btw: anyone see that IBM stock is suspended from training pending outcome of an SEC accounting investigation? dcmwai: thats an evily loaded question can we make a deal Something I should have say... Arias still tene to be Very Nola compitable... (in Database and so on) what deal :) I'm open i can't (er refuse) to work in a monolithic directory structure and/or with MySQL we fixed both those things with Acclite IF you could merge/fix ARIAS to have the changes we already made to NOLA say it... i would gladly do all future fixes on ARIAS and would consider working directly with ARIAS on schemas IF you can provided me the changes I'll be verifying it and make it through so that perhaps ARIAS and gnue-sb could be one and the same ARIAS just the 'web front-end' Oh yes :) and Gnue-sb is the back end.. well they would share 'schemas' that is what I called an acocunt software... Not only web base... but is a whole great structure. in this two tier environment business rules would have to be duplicated unfortunately ??? what? ultimately we could have ARIAS use the web UI of the GNU Enterprise Framework it just isnt ready yet It will be if we can make from creating ... easily.. you know smarty? php smarty... um, not enought time not enough time for? webclient will be around eventually not enough time to write a webclient (for the framework) just yet webclient will be around all the time :) there are two or three in the works (one that half works) dcmwai: i think we hitting language barrier i mean GNUe webclient gnue has it's own client(s) GNUe is like SAP R/3 or Peoplesoft it is a framework so you write one "form" haha Josh and I have the same argument some time. and ... and instantly (without code modifications) it will run on curses (text based ui), win32, mac, gtk2, qt, html etc I know. just our 'html' client isnt ready yet is that ture? well curses is 85% there win32 and gtk (via wxwindows) is there qt and gtk2 are like 80% there aria can help that to be your webclient for the time being... and html is like 20% there dcmwai: that is what i was suggesting :) that it could be php client (just having to reimplement logic) derek: I'm also starting to a rewrite after the inventory fix... until the html ui engine for GNU Enterprise is ready i would say look at gnue-sb but its a mess not well documented just yet and some old schema stuff there that could be confusing may be on the rewrite I can have gnue create from on web automatically... but product management is well started and once that is done inventory should be pretty quick to bolt on i just got hit like i said with real life derek: who don't :) derek: I thought I'd have time to maybe tackle finishing that this weekend, but it's not clear that I will now.. I shouldnt say finish Action: derek lays out the box of choco donuts (http://www.gnuenterprise.org/~dneighbo/choco_donuts.jpg) to see if i can get jcater here what I meant was fix the autopopulating thing in the one form there.. =) that's far from putting the final needed form(s) together. derek: about the modificaton where can I get that on acclite? dcmwai: you shoudl check this out http://www.gnuenterprise.org/~dneighbo/table_comparison.pdf and probably read the logs from then I've see that... http://www.gnuenterprise.org/irc-logs/gnue-public.log.25Mar2003 http://www.gnuenterprise.org/irc-logs/gnue-public.log.26Mar2003 dcmwai: warns i can be brutally honest :) dont hold it against me s/opnionated/honest for example arias.sf.net had same plan (though not at that time) Action: derek is going to check out their cvs now Action: derek runs screaming really really really really really really really loudly they kept that horrible nola structure derek be honest. I don't like the structure as well... but we don't have time to clean all that creep/ so we plan to clean up the creep on the rewrite... and For the time being, I will just stick to the old structure and fix all bug. Once a Stable release is being release... A rewrite will begain... us acclite instead :) us or use :) reinhard (~reinhard@M1259P028.adsl.highway.telekom.at) joined #gnuenterprise. way i see it is we 'ripped' account lite after any changes were done to NOLA morning reinhard so you coudl probably take acclite and just apply the patches you made to your original NOLA rip haha and have postgres support and a clean dir structure with minial work but im not pushing that good morning but we have to think that must be a upgrade path for old Nola and arias user... but thats what i meant by : "if you were willing to fix arias to have the features we already put into Acclite" if not... they will be say. dcmwai: why would there be no upgrade path? the schema stayed the same just the files were put in a logical filing instead of all in a single dir and php schemas were added but anyhoo Action: derek suspects the number of folks using NOLA that arent noguska's customers is so small because upgrading on the files structure is easy... but upgrading in database structure will be ... HARD that backwards compatiability would be the most minimal of concerns dcmwai: that was my point we didnt do any DB adjustments to Acclite only file structure derek: oh that will be great... I think you have dB adjustment on that... well we made it support postgres but basically we just converted the schema to postgres derek should I just grep the acclite latest CVS? if the ultimate goal is to stay compatiably to NOLA im not interested if its to use NOLA as a base, im game derek: Nola is the base... im not against providing an 'upgrade' path for NOLA users It will be replace sooner or later... but they will be so minimal i wouldnt make decisions based on taht factor where is jason tonight BTW... you know the usage of estquotecblbindery* on the DB? its a printer thing estimated quote CBL Bindery something for POS right... i imagine CBL Bindery is a type of service but the code wasn't there ... and this is for 'invoices' OH I see... Thank for telling :) i suspect what they were doing is 'estimates' and 'estimates' turn into invoices so someone comes in and i give them a "quote" (i.e. estimate) ohoh and they decide if they want all, some or none of the work done haha .. Damn Noguska :) and based on that i generate a work order/invoice Action: derek is guessing based on limited knowledge of printing business i suspect Vee could elaborate as his setup is similar wrt: pre-quoting work hey actually I'm having problem with printing as well... how am I getting pretty print out on web... it is hardly in control... Even if with page width hmm, I think our schema is better the gnue-sb ;) I dont see how gnue-sb's schema could be used in a comparison, for lack there of.. =) Sure do gnue-sb is a program and arias just a web page (yes... Arias is web Page ) dude i would use gnue-reports if i did this :) Action: derek puts the duck tape back on Vee (shhh dont let out the secrets) derek: Where are you from? here BTW Here is my contact... AIM godinheavenchan ICQ 601356 yahoo dcmwai derek: damn... im in Gilbert, Arizona (United States of America) if you have heard of cowboys and indians Oh then it will be good cause Josh is in USA as well... thats where i'm from I though AP/AR was in gnue-sb you can contact josh for all the issue Action: derek can literally go out front and smell cow manure (yummy) or there was some schema for that When I quote jobs, I use a set formula.. So there is no black magic involved.. I just tell it like it is.. if the customer comes back with an order, the values in their order will again determine the price in the same manner the quote was given so I dont have a need to do anything special.. chillywilly: No... but it was in aria :) What is Vee Doing in Gnue ? yelling at me to finish gnue-sb problem creation derek: was there AP/AR in gnue-sb? um and is the big schema file accurate? does it reflect all of what is there? cause it's much easuer for me to read sql than xml ;) if a tree falls in the forest and no one is there to hear it, does it make a sound? bah if there is ar/ap in the schema and no forms are there to implement it, does it mean we have ar/ap? I was mainly curious about schema as I don't see anything for it...maybe I am blind your momma told you would go blind if you didnt stop doing that lol see what you get for not listening ok not for the time being I'll get my inventory my self... as there isn't any guide line for that :) if and if there is any giude line please do tell me. I still dont know what you want in the way of inventory oop.. I forgot.. in Aria the composit item will never decreast... decrease. so I'm now trying to make it decrease... and btw how is composit item count? you mean an item that is an assembly of other items? I would use a work order process to create the assembly and relieve inventory using the assembly, I'd think. you have 10 A 24 B and 5 C and composite item ABC is a join by 1A 1B and 1C will you automitically have 5 ABC or you have to key in how may to assembly? adding the finished assembly as a unique part s/using the assembly/using the work order/ hum... That is the hard part :( Vee: Can I do something like this? I don't care ow many did I assembly I just know I have so much of A, B and C, and when selling the item, I just put the maximal that can be assembly. After the item is ship I just decrease all of the,,, in A,B and C so in other word ABC dont exsist in quantity... Vee: can you get me :) haha haha ... I wouldnt.. =) why? Action: dcmwai is in a rush to have the inventory problem to solve in 1 week ... someone needs that, I guess? I'm just trying to imagine a case where you might want to do as you describe.. have a look on nola and aria DB and structure and you will know that... we have products tables and such and for each product there's an entry in an inventory account and when you trasfer inventory you debit one account (say "stock") and credit another one (say "sales")