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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What mssql tables does the report "Purchase Orders Received not Invoiced" use to pull Land

Status
Not open for further replies.
jaustill

jaustill

IS-IT--Management
Dec 15, 2003
84
0
0
US
Macola Progression 7.7.300 running on a mssql 2000 server [no Flex] [no custom]

What mssql tables does the Macola report "Purchase Orders Received not Invoiced" use to show Landed Cost Received not Invoiced?

I am specifically looking for the table that stores the Landed Cost received not invoiced amount that shows up when the report is run.

The amount it pulls is not the one in POLNDCST_SQL or POPURCST_SQL or IMDISFIL_SQL
 
Sort by date Sort by votes
I think I found the table I needed, it is IMRECHST_SQL
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mjbasecamp
  • Locked
  • Question
What is the highest version of SQL Server 2017 CU that Macola Progression 7.9.300 is compatible with
Replies
3
Views
102
dgillz
dgillz
nsiegmundt
  • Locked
  • Question
How to edit the "search_desc" field for an item inside of macola (table imitmidx_sql)
Replies
1
Views
56
dgillz
dgillz
JBHILLS
  • Locked
  • Question
User "Settings" header Icon Grayed out
Replies
1
Views
46
JBHILLS
JBHILLS
prog_0927
  • Locked
  • Question
Move Bulk of Orders to Closed Status
Replies
4
Views
95
crystalreporting
crystalreporting
prog_0927
  • Locked
  • Question
AR Aging Report Not Matching
Replies
3
Views
60
prog_0927
prog_0927

Part and Inventory Search

Sponsor

Back
Top