Commissions Reporting

• 10-09-2008 9:05 AM

  defg22 Joined on 10-03-2008 Posts 3

  Commissions Reporting Reply Contact I am using Dymanics GP 10.0 and I am trying to get some sales/purchasing reports to calculate our sales/purchasing commissions.  I cannot use the commissions set up they offer because we base our commissions on gross profit, not sales amount.  Anyone have any recommendations as to how to obtain the following information:  Customer Name, Invoice #, Item Number, Item Description, Salesperson ID, Extended Cost, Extended Price, Vendor Name, Buyer ID.  We pay out commissions on both the sale of the item and who purchased the item, so we would need to see both sides of the sale for each line item.  Thanks for your help! Danielle

  Tags: Dynamics GP, Great Plains, Dynamics GP 10, GP

• 10-10-2008 8:19 PM

  In reply to

  ChristinaGeyerPhillips Joined on 04-01-2008 Denver and Kansas City Posts 70

  Re: Commissions Reporting Reply Contact Are you using Sales Commitments?  And do you want to look at posted Sales Order, historical Purchase Orders?  Or unposted Sales Orders, and closed (but not historical) Purchase Orders?  In general, if you are using Sales Commitments these would be the tables you want to take a look at: SOP10100 (Sales work header) SOP10200 (Sales work line items) SOP30200 (Sales history header)  SOP30300 (Sales history line) SOP60100, SOP to POP Link table (to link the sales order line item to the purchase order) POP10100 (Purchase order work header) POP10110 (Purchase order work line) POP30100 (Purchase order history header) POP30110 (Purchase order history line)  Also, if you want to see the fields in these tables, as well as possible ways to relate them, you can use Microsoft Dynamics GP>>Tools>>Resource Descriptions>>Tables to view more information.  Take care, Christina Check out my new blog, http://dynamicsgpland.blogspot.com/