logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Need to see open PO's - Need open PO Data
Options
Go to last post Go to first unread
Previous Topic Next Topic
MikeM  
#1 Posted : Tuesday, August 16, 2022 7:53:01 PM(UTC)
MikeM

Rank: Newbie

Groups: Registered
Joined: 8/16/2022(UTC)
Posts: 2
United States
Location: KS
We are looking for a SQL view or a way to export open purchase order data to an SQL table. Item# and Qty Open. We are needing this data to be available to another SQL server DB on the same server. A view would be perfect, but we have not been able to find the required data to produce the results. Any suggestions appreciated.
Back to top

Wanna join the discussion?! Login to your Red Wing Software Developer Forum forum account, or Register a new forum account.
Back to top  
aarony  
#2 Posted : Wednesday, August 17, 2022 1:56:31 PM(UTC)
aarony

Rank: Administration

Groups: Administrators, Moderator, Registered
Joined: 2/28/2018(UTC)
Posts: 53
Location: Red Wing, MN

Was thanked: 4 time(s) in 4 post(s)
We recommend using the provided tools to extract data from CenterPoint.
All of our reports support the ability to export to Excel or CSV files.
We also provide a Data Browser tool which can be installed by performing a custom installation.
Back to top
MikeM  
#3 Posted : Wednesday, August 17, 2022 2:09:06 PM(UTC)
MikeM

Rank: Newbie

Groups: Registered
Joined: 8/16/2022(UTC)
Posts: 2
United States
Location: KS
Hello,

I'm not aware of how your tools would provide a direct read of Centerpoint SQL data by another SQL database. We are currently pulling other data from Centerpoint this way, but we are not able to piece together tables / logic to accomplish the open PO quantities. Please recommend an integration partner that could provide us either the SQL View or Stored procedure logic. We would be interested in visiting with them about paying for the solution.

Mike
Back to top
aarony  
#4 Posted : Wednesday, August 17, 2022 2:17:45 PM(UTC)
aarony

Rank: Administration

Groups: Administrators, Moderator, Registered
Joined: 2/28/2018(UTC)
Posts: 53
Location: Red Wing, MN

Was thanked: 4 time(s) in 4 post(s)
Our tools would not allow another SQL Database to directly read data from the CenterPoint SQL Database.
I'm afraid directly interfacing with the SQL Data for CenterPoint is not something we recommend or support at this time.
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.5.1 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.079 seconds.