import data to sales 1

[KO99]

Hello! I'm relatively a newbie to GP (less than a year; used SQL much longer). I have to import data from our order software into GP (by way of Access): TRX > SALES TRX > SALES TRX ENTRY > ORDER (before anything is transferred to an invoice and posted). I have done database traces and have come up with an overwhelming # of tables where I'd enter data directly into GP SQL tables. I think I only need the SOP10103, SOP10100, SOP10200, SOP10104 tables but am afraid of missing tables (such as where the Distribution > Distribution Reference accounts info is). The trace also picked up IV, GL, and ME tables which I'm not sure why I'd need to enter in order info there. Is the SOP list above correct; do I need any IV, GL, and ME tables? Also, should I enter in the order so I get the automatic Document number and then do the data dump? *Thanks* in advance for help!!!!

 

[jazgeek]

buy integration manager. There are entirely way too many tables hit at time of sales order entry for you to effectively import directly to the table.



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

jaz

 

[KO99]

Jaz, Thx for the suggestion but I don't think my co. will pay for it so I *have* to do this the long way around. Or if anyone has integration manager & is willing to list the tables for me, it would be *extremely* appreciated. I think that if the order is set up before I do the data dump, there would be fewer tables to dump data into, correct? Thank you!

 

[jazgeek]

believe me, it will cost you more on trying to develop your own integration than buying integration manager.

you will end up messing some table or relationship up in GP and not know about it until it's too late.

SOP entry hits so many different area's in the system, not just the main sop tables. Inventory is hit, receivables is hit, quantity master is hit, etc etc and that's just the ones I can think of off the top of my head.

sop entry hits stored procedures to update info in other area's of the system.

Take my word for it, I've been working with this software since v 3.15 and I wouldn't even consider trying to do an integration into SOP without Integration Manager.



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

jaz

 

[KO99]

I hear you... maybe this the IM that everyone's telling me about? If yes, then we have Dexterity which is good news! (Duh!?) Correct me if I'm wrong & am getting my hopes up....

Microsoft® Dexterity™ INTEGRATION GUIDE Dynamics and eEnterprise Release 7

I'm starting to read the books now.....

Thanks all!

 

[jazgeek]

nope,

as with anything in GP... you have to buy it

IM is Integration Manager... it costs.



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

jaz

 

[KO99]

Jaz - thx v. much for all your help! I must agree with your little quote!

 

[KO99]

Merry Xmas to me! Apparently the co. has the software but no one else knew about it except the boss... yaaay! Thx. for your help!

 

[jazgeek]

lol... that makes it easier.

you can see what modules you are registered for on customersource or in your help>about>registered modules screen


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

jaz

 

[AbuArja]

Dear K099, if you need further help in creating the sales transactions using the SQL Server Stored procedures, I can come up with a document that gives you tips about the tables that you should take care of.

Sorry for the late response, but I was in vacation and I didn't visit this site long time ago.

regards
Mohammad

 

[KO99]

Mohammad: Thx for your offer. Unfortunately I haven't been able to test IM yet b/c I'm waiting for it to be installed on our server... however, if it's not too much trouble, I would love to see a tips document. I would very much appreciate it if you've got the time. Hope you had a nice vacation!
Best regards,
K.O.