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 gkittelson 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
Dec 5, 2002
115
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
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
933
kgeorge71
kgeorge71
Nisly
  • Locked
  • Question
Deleting purchases from Fixed Assets Purchases in Great Plains
Replies
0
Views
675
Nisly
Nisly
appelq
  • Locked
  • Question
Cash Batch and Bank Fees in Dynamics GP
Replies
0
Views
793
appelq
appelq
Devanand0311
  • Locked
  • Question
Syntax error in date in query expression 'UCase
Replies
0
Views
618
Devanand0311
Devanand0311
moogabe
  • Locked
  • Question
ERROR WHEN ADDING CREDITOR in GP V 9
Replies
1
Views
654
moogabe
moogabe

Part and Inventory Search

Sponsor

Back
Top