Skip to Content
0
Apr 28 at 03:38 PM

SAP Business One SQL query for report "​Manufacturing Margin report"

296 Views

Hi all,

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.

Best Regards,

Daniel