Hello,

I'm trying out this module mainly for the Purchase Order and Receive Goods options, but may use other portions in the future.

Do I have to create ERP Items for any item I want to add to a purchase order? I order from 20 or so different vendor catalogs, and do not have them in a database. Maybe I'm not understanding the purpose of the PO option. IS there any documentation for this module?

Thanks.

Comments

Steel Rat’s picture

IT also looks like ERP is trying to force clean URLS. I'm using a test system without a primary domain, and do not have clean URls enabled.

singularo’s picture

Status: Active » Closed (won't fix)

You can setup automatic download/import of pricelists via xxxx.com/node/add/erp-price-list-update

Which can then be scheduled using the recurring feature to run every night. We utilise this to update pricelists from 3 emailed and 2 downloaded pricelists every night.

Clean urls - Ahhh. yes, we probably do have multiple spots where clean urls are assumed. This probably will never be fixed in the d6 version. Will try to address with d7 port.

Steel Rat’s picture

I guess my point is I just want to create a simple PO, items I'm purchasing from a vendor, not something being purchased from my company, without any external dependencies. Is this possible without including all the other ERP stuff? The reason I'm trying ERP and not just a CCK content type is because I can't get atomic PO numbers during the initial creation form presentation. I have to wait until the content is created before I can get a unique PO number. I'm hoping ERP can solve this problem for me.

Thanks!

singularo’s picture

No, ERP does not create/allocate PO numbers until save is clicked either

This is a limitation of web based and multi-user databases in general, its tricky to allocate a number and know that is could not be used by another user between when you load the page, and when you click save.

There are ways to build around the issue, but i'd think about your processes. Why do you need the number first?

HTH

Steel Rat’s picture

In my experience placing orders with vendors, they often want your PO number up front, and you're often doing this over the phone. It's similar to creating trouble tickets. You usually are presented with a ticket number as soon as you start the ticket creation process, not when the ticket is saved.

I think the way I've seen/heard of this being don't before is to perform a node save programatically without the user's knowledge, so then a number is available to give them.

singularo’s picture

Yep, typical workflow for us is:

* Customer rings up, wants to buy a notebook
* Create an ERP quote with the one you have from stock
* Email them the quote
* Get confirmation back via phone/email if required
* Click "Create PO" while viewing the quote.
* Click Save
* Login to wholesalers website
* Submit order, using PO from the above

Of course, if ordering stock, there may be no customer involvement.

It sounds like maybe you're logging into the wholesalers website, adding all items to the cart, then when checking out, you don't have the PO number?

If we do that, we just fill out the PO in erp in another window/tab with cut/paste at the same time, and click save, then switch tabs and past the PO number into the wholesalers form.

If you are ordering something unusual that you don't have in your item list, create a "MISCPARTS" or something like that and put the real part number in the text field as you go.

HTH

RKopacz’s picture

have a related question, just came across this module. I have a client who would like to create a website for his customers, where they could create their own space to aggregate information from various suppliers, then create displays where they could check off which products they would like from which vendor in the desired quantities, and add it to a sort of shopping cart. The shopping cart display, when clicked would then be used to generate printable POs, one for each vendor, which would then be faxed to the vendor (this is by current trade habits; I suppose they could also email the PO as a pdf, but my client informs me that is not the current custom in the industry.

I guess the key distinguishing ingredient here is that instead of using the module for its own ERP, it is creating a space where visitors can create a user account, where they aggregate and manage their own data and generate POs for their own account.

Is this possible with erp?

Thanks in advance for your answer

ShannonK’s picture

I'm on the same page as Steel Rat - we often order products from a vendor, who requests a PO#, so we have to have a way of generating a unique number (that cannot be repeated) that correlates to the order and keep track of the input in some kind of database. Currently, I use the Webform module to do this, since it creates a SID (submission identification), which is unique, and we use this as a PO#. I haven't figured out how to modify how it appears, however, as I would like to add three letters before the SID among other things, but for now, it's working well enough.

I found this thread in hopes of finding something that would work better. Steel Rat - if you read this - can you post back if you found a solution or work-around?

Steel Rat’s picture

Hi Shannon.

I ended up creating a custom content type called PO. I added the fields I needed to track the PO number, status, ordered date, received date, etc. I use the Matrix CCK module for the line items (this is a less than ideal solution since there is little control on how it's presented, but it works).

To generate a unique PO number I use the Serial module, Computed Field, and Rules. There are some limitations to the Serial and Computed field modules which require the use of Rules to properly generate a number which is displayed when the form is first saved. I haven't been able to have a number generated automatically when the create form is presented. So the user has to perform the following:

1) Click Create PO
2) Select whether the PO is one of two types
3) Enter the Vendor name
4) Save the form

After the first save they are given a PO number, so it doesn't take too long when on the phone. I use the Computed Field CCK module to append two letters on the front of the number generated by the Serial module (the two letters are dictated by the PO type chosen in step 2 above).

The Rules module is necessary because the first save of the form doesn't generate the po number properly. So I have a Rule which does a second save automatically upon node creation.

Hope this helps. If you need some of the code I used for CF and such, you can email me at alberts dot jeff at gmail dot com