Greetings of the day.
Is it possible to fetch the Open Documents either open or closed or cancelled for all those item from Item Master Data? Need for some analysis of the items for sales and purchase.
Regards.
Dear Sir/Madam,
Greetings of the day.
We work here on FIFO basis for receipt or issue of raw material. Our requirement is to fetch the GRPO no (PD) of the particular raw material issued in the row level of the Production Order. We would create an...
Greetings of the day.
Am trying to create a query for Sales Order, Sum of Row Total of Remaining Open Quantity grouped by BP Code and Open Quantity Total. Want only the Document Number, Card Code and Amount.
SELECT T0.[DocNum], T0.[DocDate], T0.[...
Greetings of the day.
Can anyone just help me with a query with the following conditions. Did try but an unable to get it by group and showing errors. And its not grouping by Date.
Doc Date, Doc Total, grouped by Doc Date.
Regards.
Greetings of the day, experts.
Am having a peculiar situation and hope someone can throw light and guide me.
We have two servers, one installed with SAP B1 9.2 x86 (SQL 2008R2) and another with SAP 10.0 x64 (SQL 2019). On the client side, we need...
Greetings of the day, mam.Absolutely right, the material is issued by FIFO if enabled and this is created by issue from production.As it is, we incorporate the heat code for the manufactured component manually by entering in an UDF we created in prod...
Greetings of the day mam,Thanks for your query.Did modify the query as under and we fetched the results.SELECT T0.[DocNum], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], Sum(T1.[OpenQty])'Remaining Open Qty', Sum(T1.LineTotal)'Remainin...