Web Integration Part 3 1

[Borvik]

Well as promised here is the php for integrating with the SOP order system (using 7.5).

http://borvik.gotdns.com/integrate.phps

Use at your own risk - we have noticed many more unrelated orders having the same master number ever since we started using this.

MS seems to think this is because we haven't updated to the latest service pack (our current login shows 7.50g3), and updating for us seems to be a problem as our server has version 8 installed (you can tell the guy before me knew what he was doing *sigh*).

Sorry for lack of documentation - though if you're trying to use this I would assume you're versed enough in php to figure it out.

Basically to submit the order:
Instantiate the class GPIntegrate

$obj = new GPIntegrate();

Then call the enter order function:

$obj->EnterOrder($connectionClass, $item_array, $customerDataClass);

If you find anything that could be improved let me know, so that I can update ours as well.

Cheers to you all - and hope you find it usefull.

 

[jazgeek]

this deserves a star for sure.



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

jaz

 

[Borvik]

:blush:

thanks jaz - just trying to be helpful.

 

[Borvik]

Updated the AddLineItem routine.

If an item was backordered, it now properly adjusts the IV00102 QTYBKORD column with the correct amount to back order - previously it skipped this, thus not letting it show properly on reports.

 

[Borvik]

Update:

I've confirmed with a 3rd party source, that somehow this is the cause of the duplicate master numbers. All the duplicates I now see are from one order input using this integration feature, and one order input from a salesperson.

I'm flush out of ideas as to why this could be happening, if anybody spots anything - let me know so I can update this.

Thanks.

 

[jazgeek]

maybe you could just scrap the master number creation from GP and use your own method? Keep the two series out of sync with each other to avoid duplicates in the future?

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

jaz

 

[Borvik]

Problem is - the documents get stored in the same place and they all need unique master numbers - including the ones entered by the salespeople. The only way I can think of doing it would be the stored procedure used by GP, as it's supposed to prevent that - but is not apparently.

I've also noticed duplicate SOP Numbers - impossible you say - nope. The duplicates are one that's in history, and the one created by this system. The method for obtaining this is also, by stored proc - and even more necessary if you have special naming conventions. I have some ideas to try out, but will have to see how it goes.