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

Sales by Vendors report in Great Plains

Status
Not open for further replies.
BHAT100

BHAT100

Programmer
Joined
Dec 5, 2002
Messages
115
Location
CA
I want to make sales report by vendors in cystal. is there any table or field can be linked to sop tables to pop tables to pull sales data by vendors

-bhat
 
Sort by date Sort by votes
The SOP60100 is the SOP to POP Link table. From this you can link to the POP10100 to get the Vendor ID.
 
Upvote 0 Downvote
sop and link table works if the company linking each and every sales document with PO

-Bhat
 
Upvote 0 Downvote
Use SOP60100 if the Sales Order is linked to a PO, if not, link SOP30300 to IV00103.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kgeorge71
  • Locked
  • Question Question
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
2K
kgeorge71
kgeorge71
Nisly
  • Locked
  • Question Question
Deleting purchases from Fixed Assets Purchases in Great Plains
Replies
0
Views
1K
Nisly
Nisly
appelq
  • Locked
  • Question Question
Cash Batch and Bank Fees in Dynamics GP
Replies
0
Views
1K
appelq
appelq
Devanand0311
  • Locked
  • Question Question
Syntax error in date in query expression 'UCase
Replies
0
Views
1K
Devanand0311
Devanand0311
moogabe
  • Locked
  • Question Question
ERROR WHEN ADDING CREDITOR in GP V 9
Replies
1
Views
1K
moogabe
moogabe

Part and Inventory Search

Sponsor

Back
Top