Dear Q & A TeamThe below query lists our total inventory at any date in the past.I would like to add the OIBT table to it in order to link the locations to so that we can see holding by warehouses etc problem is we use custom bins, the table is @Bin....
Dear all
we have a query to manage our budgets etc code below, we use SAP 9.3 64 bit
i need assistance to add the previous months actual sales into it but do not know how to go about it.
please see query below which i need to add the previous m...
Hi
i created the below query, but it does not populate all items, i think it has to do with the warehouse statement for OINM or OITW join
see query below
SELECT T1.[ItemCode], T1.[ItemName], t1.frgnname, T2.[ItmsGrpNam], max(t1.onhand) as SOH, ...
We have and use reports and queries to show open Sales Orders.
What i need now is to see what batches is allocated to those open sales orders, so looking for a query that shows the Sales order and then also populates the batches and quantities link...
Hi expertsThe query below was done by previous employee. This query is used as a database in Excel and has a lot of information from various tables.The PO+4 column does not populate the information (even though there is and should be information), th...
is there anyone that can assist with this query? it either omits the last activity date or omits some items and or duplicate items on the query.i have tried this query as well..SELECT distinct T0.[ItemCode], T0.[ItemName], t0.frgnname, T1.[ItmsGrpNam...
