I got the request below to build a report using sql tables from SAP Business One, the problem i don't know where to start, very new at this, can someone build a query that satisfies the requirements? I would be deeply appreciated.
Manufacturing Margin report
This report show the margin being made on a manufactured item. the user enters a bill of materials item and the price list they want to base the margin on. The report then shows that price (if it's a foreign currency price list then show that value and use the current exchange rate to work it back to the base currency. The list the raw materials and the moving average cost price of each item. At the bottom work out the margin by subtracting the cost prices from the sales price. show a percentage also.