Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Optimized POP integration

Status
Not open for further replies.
Luvsql

Luvsql

Technical User
Apr 3, 2003
1,179
CA
I have an integration setup that will import POs from another system. However, I receive errors that the Item is not associated with the item. When you manually enter a PO, it prompts to create the association. Will IM not do this? This means for every item and vendor combination, I will have to manually create an association before running the integration (I have to run it daily).

Does this seem a little nuts?
 
Sort by date Sort by votes
As well, when integrating PO's, the tax schedule does not get added and not tax is calculated. When we have to invoice, we have to add the tax schedule to each line item because simply adding it to the bottom of the receivings window doesn't do anything.

When I manually add the same information in Great Plains, the tax schedule gets added. Using the integration does not.
 
Upvote 0 Downvote
I've found a few things missing from those SQL Optimized integrations. Just the other day I ran across a couple of fields I couldn't map on a Receivings Transaction integration.

What's strange is the the SOP integration has additional options to update inventory records but the PO one doesn't seem to have those.

I guess you can run a SQL script before the integration to update the records. :( I think I'd ask the Tools team what they suggest. They are usually good with coming up with solutions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bjrogersnc
  • Locked
  • Question
Integration Manager Payables Script
Replies
0
Views
265
bjrogersnc
bjrogersnc
winthropdc
  • Locked
  • News
Visual Studio Integration Toolkit replaces Menus for Visual Studio Tools
Replies
0
Views
90
winthropdc
winthropdc
svrcrown
  • Locked
  • Question
Payroll & FI integration query PEO/ASO model
Replies
0
Views
88
svrcrown
svrcrown
smatthews
  • Locked
  • Question
GP 10 on SQL 2008 R2 SP3
Replies
0
Views
81
smatthews
smatthews
MBresnan
  • Locked
  • Question
Applying receivables credit memos during integration
Replies
0
Views
39
MBresnan
MBresnan

Part and Inventory Search

Sponsor

Back
Top