pclark's blog


Syndicate content
pclark's picture

Adding Flexibility to Sales Account Assignments - A step towards multi-company in a single xTuple database :D

Click for full-size, really big graphic...

Hey! How have you all been?! I've stepped back into my cubicle and will attempt to grace the xTuple Blog-o-sphere once again with something I think EVERYONE may find interesting.

Sales Account Assignments - In the Beginning...

Setting up Sales Account Assignments within the bounds of Site, Product Category and Customer Type is more than sufficient to meet the needs of most organizations.  However, in some circumstances a company may sell the same products in many different ways. Depending on how much detail a particular Controller wants to see in the General Ledger, they may have a need to book sales to differing accounts by the Type of Sale or the Region/Area the product was shipped into.

In xTuple, a Customer can only have one Customer Type. Sales Account Assignments can use this Customer Type to drive sales to particular GL Account Assignments based on the Site, the Product Category and the Customer Type. This does run into its limitations... quickly. One work-around in the past was to duplicate your customer. This can make things messy. Very Messy if you have many different ways to Sell a product and you want that detail in your GL. This leads to an Unwieldly Matrix of Sales Account Assignments and Duplicate Customers, Nightmares, Headaches and Nausea. Read more »

pclark's picture

Batten down the Hatches!!! Encrypting your PostgreSQL Traffic with OpenSSL.

It's 3AM... do you know what your server is doing?

You probably don't know. If you do know, you need to do something other than worry about your server.

In most cases, it's probably not doing anything more than when you left it at the end of the day.  But, during the day, you have some external users connecting, querying your PostBooks or xTuple databases - All seemingly innocent... or ARE THEY?! It could be some MITM parsing your datastream. Read more »

pclark's picture

Installing PostBooks®... the long way.

While we do publish PostBooks® Installers that will quickly and easily install PostBooks®, some people like to make the installation a fun little project by installing the individual components.  And really, it's not a bad way for you to practice installing, or to get hands on experience with some of the pieces that we try to hide from you in the packaged installers.  This will be like taking a long walk, but in the end, it's the journey that counts.  Now, if you've been following my writings/ramblings for a while, or if you have met me in person, you know that I'm fiercly aligned with the Penguin Nation, that is, I use, recommend, endorse, and otherwise try to sell everyone on using some flavor of Linux.  Well, In this blog, you'll notice I don't say "Now, go to 'terminal' and..." .  Yep - ALL GUI.  How's THAT for a surprise?  The other surprise is that I wrote this using screen shots from Windows 2000.

          Two roads diverged in a wood, and I--
          I took the one less traveled by,
          And that has made all the difference.
- Excerpt from The Road Not Taken by Robert Frost (1915)
  Read more »

pclark's picture

"Free Milk" - Report Writing Tips

Everyone loves report writing and no one here at xTuple loves report writing more than Chris. As a matter of fact, he loves report writing so much, he has set it free and now report writing - by and large the customer requested report mods - reside under my 'Umbrella of Responsibility'.

So, I thought I'd share the wealth, and be the giver of "Free Milk" - if you will - by sharing some of my report writing tips.

This tutorial will take you through how to use some of the fancy schmancy little known tricks we've put into openRPT and maybe I'll tell you about some of the undocumented stuff too. Read more »

pclark's picture

Don't put all your eggs in one basket.

We all expect our favorite gadget vendors to cram more and more functionality into devices.  Clipped on just about everyone's hip thesedays are Phones that can send email, play music, socialize, take pictures and record movies.  Oh, and they make the occasional phone call. 

Sure, it's debatable if they actually do any of these really well. 

Are they convienent?  Yes.  Read more »

pclark's picture

Have you checked your QIC backup's lately... and a Haiku.

Nearly 3 years ago, I was hired by xTuple.  It was an exciting time and I couldn't pack up the family truckster and get to VA soon enough.  As part of my parting ways with the old company, I had to write up some instructions.  I've included a portion of them here as a sad precautionary tale.  Keep in mind, this was 3 years ago - 2007.  Besides, it's too early for an April Fools.  Why I have these notes still? IDK.  Maybe it's my 'I told you so' insurance.

These are my instructions, dated 2/28/2007. Read more »

pclark's picture

PostgreSQL Kung-Fu: Migrating between major versions.

Has this happened to you?  You're called in to sandbox the newest version of xTuple for a customer.  "Piece of cake" you think to yourself, "I'll buzz in and buzz out, 30 minutes tops".

"ERROR: syntax error at or near "(" at character 578"

Arrrrgh!  We'll you try again, maybe even open up the update package and poke around looking for a syntax erorr.  "I know this worked on my laptop when I tried it at home..."  Deep breath, keep your cool... We all know that the 10 minute jobs are the ones that end up taking days and years off of our lives.  Read more »

pclark's picture

Simple Postgres Server Monitoring Script for Linux and OSX

Nagios, Splunk, SNMP are various monitoring tools that can alert you to the status of connectivity to your SQL server.  While I would like to employ these tools to monitor our network, I find that I really just want a tool to tell me 'Hey!  Go check the server!  It ain't working because of x,y,z...'.  Checkpg.sh is such a tool. Read more »

pclark's picture

Remote Connection Fun with Tunneling!

Oftentimes, we find ourselves not able to be On-Site or otherwise physically On-Console of the server we need to work on.  If time is of the essence the administrator with command line savvy can conquer just about any remote administration or troubleshooting need. How does one acheive this level of connectivity?  Where can I get some of that? Well, look no further than 'terminal' and 'ssh'. Read more »

pclark's picture

Running the xTuple Installer on x86_64 Fedora 11

So, you have a fancy new Fedora 11 x86_64 workstation like me?  Well, there's some special consideration you need to give your setup to get our Installer working correctly.

Check out http://www.xtuple.org/xTuple-3.3.0-Fedora-11-x86_64-How-To