Hi, I am new to SAP b1 and wanted to see if there is a way to join table OINM with OACT? I am looking to calculate the cogs and revenue of items by channel and looking to add the following fields from OACT - [ActId], [Segment_0], [Groups], [Fathe...

Hi, I am very new to SAP B1 and looking to calculate the profit, cogs and revenue at an item/SKU level on a monthly basis. Can I create a query to do this? Any help would be greatly appreciated! Thanks,

Hi, I am new to SAP B1 and looking to send SQL query alerts as an excel attachment. Currently, I have SQL queries set up in Alert Management to go out every morning. In this process, the SQL query result is pasted into the email body which is not v...

I created a new table through SSMS called sales_data. I plan to create the following query in SAP query manager so that business users can enter the dates and get the revenue and quantity for customers for the specified dates. select groupcode, car...

Hi All, I am very new to SAP B1. I would like only a few people to change group names for business partners. No one except these users can change the groups for business partners. What would be the best to do this? Any help would be greatly appre...