Calcuating Account Period Cost from Gross Profit Report (Financial)

Legacy Contributor

I have been tasked to create a custom report that includes the customer order line item costs for the given accounting period from the Gross Profit Report (Financial). I was wondering if anyone has done this and if so, could you share the code with me.

I have attached screen shot of what I am looking for and have highlighted the specific field that I am looking for.

I appreciate your help.

Derek

Legacy Contributor

First, VISUAL has not been able to show me how to get the Gross Profit any other way than by running the report.

Second, always make sure you run the Gross Profit in the accounting Window, not the one in Manufacturing; the Manufacturing one does not tie to the accounts the same.

What we do is run the Gross Profit report, "Print" as a file, then I match the data from sales to that to make the report complete. Here's my process to add additional data to the Financial Gross Profit report. It adds Quantity, Industry, Territory, SalesRep, Carrier ID (from Customer Order), Estimated Cost (From Part Site), and Shipped Date (From Shipper)


[Updated on 10/1/2015 10:42 AM]