Web Integration Part 2

[Borvik]

Hey all,

Earlier I had started a thread (thread632-1168373) about the possiblity of integrating with an e-commerce website.

jazgeek, gave some helpful ideas - but I ended up trying to write my own integration class myself using PHP.

I have almost completed work on my integration class, however I have a question before I finalize it.

I am wondering the best way to go about adding a line item to an order (using SQL/GP stored procs).

Currently I have the script getting the Qty we have on hand for the item, and if we have enough it will allocate the item to the order (updates the IV00102 table, and the SOP10200 table), otherwise it places the items on backorder (SOP10200 table only at this point).

All orders entered through this system, automatically get placed on a 'Web_hold' for manual confirmation sake.

Should I not be manually allocating the items when the order is created? If not, what qty fields in SOP10200 (besides QUANTITY) should be utilized?

I realize backorder items should probably update the IV00102 table too, or should they not - seeing as the order is being placed on 'Web_hold'?

Thanks for the help - look for the source code coming soon!

 

[NEmacGuy]

I new to Great Plains, but have experience in other systems. We usually bring web orders in as quotes, then you can use the system to convert the quote, and all of the hard get done for you.

Post incase it may help.

 

[Borvik]

Thanks NEmacGuy.

I may end up doing just that, however I hope to make this as simple as possible for our salespeople. The currently don't use the Great Plains quote system, rather they use excel. It would be easier if it were a quote yes.

Second, the website features a history page for the users. It pulls up all their orders (they really don't need to see the quotes - especially as we're hardly using them), by SOPTYPE=2.

By directly inputing the order as an order - it would immediately show up in their history.

 

[jazgeek]

Borvik, I'd run a sql trap on an order entry to find out what stored procedures are run. There's a lot of funny business going on in the background to update various tables throughout GP, there's also credit checks et al that you may be circumventing by going straight into the table.

by running the sql trap you can then view exactly the dex logic that's going on in the background and then encorporate the sql events into your php by calling directly or even by copying them over to your application.

Hope that helps.

You better get a raise for this one



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

Yea - I actually did run a trap - there are a heck of a lot of procedures run.

I didn't see any that update the inventory tables.

I'll go through them again to see what is actually being saved to the SOP document.

Just thought I get the community's perspective on it.

Yea - a raise would be nice! Doubt it will happen though oh well.

 

[jazgeek]

the inventory touch happens when an allocate or fulfill occurs. Depending on your sop settings, you may have it set to have a seperate allocation and fulfill process, whereas we do allocation and fullfillment at order entry to create the deficit in order for our manufacturing bit to see the demand.

I believe it hits the IV00102 table for quantity allocated but a good inventory reconciliation will fix that if you run it over night

-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

Hey jaz,

You mentioned there that the allocation and fulfill process is an SOP setting.

I've been looking for that setting, but can't seem to find it. Could you point me in the right direction?

 

[jazgeek]

in setup>sales>sales order processing> pick sales order setup. Pick your order type and select the "use separate fulfillment process" box.



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

Yup it has a separate fulfillment process.

Any idea when allocation would occur when that is selected (or how to find out)?

 

[jazgeek]

allocation would then occur when a user went into the tools of the sales order and there's an allocate and fulfill button

-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

I found when allocation occurs for us. It does indeed occur when the user enters the order - just like when the "use separate fulfillment process" is unchecked. This happens for us because of some 3rd party addins, that are watching it instead.

I have double-checked my code, and everything appears to be working. We put it live for a few hours to test it out - and if everything pans out within the next few business days, I will pronounce the code complete and release it.

 

[jazgeek]

sell it



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

I could, but there would be no control like a compiled program has - as it's PHP and therefore freely readable code.

That and I'm sure the community here would love to get their hands on it , and I so like releasing stuff to the community.