Home > Default > Closing Stock Query

Closing Stock Query

October 11Hits:2
Advertisement
Hi Members,
We Want a report for closing stock according to the following parameters,
1-Date from
2-Date to
3-Warehouse
4-Document Series
Query Report should contain with,
Item Code - Item Description - Inventory UOM - Quantity - Item cost(FIFO Value) - Value
(Inventory Audit Report can not use with document Series)
Thank You
Saman

Answers

Hi Rahul,
thank you for reply. You are correct. but in our company we use only 10 document series. under this 10 series all type of
documents are available . so when we select a one series it is containing all of SAP B1 document type.
Example-
Series A- (Delivery , GRN, Return, A/P invoice,A/R Invoice, Payment .....ect) 
Series B- (Delivery , GRN, Return, A/P invoice,A/R Invoice, Payment .....ect)
Series C- (Delivery , GRN, Return, A/P invoice,A/R Invoice, Paymet .....ect)
So Results of this Query  will be a meaning full One.
Can You Suggest a Query for my requirement. I Hope Your Idea.
Saman

Read other 5 answers

Tags:

Related Articles

  • Opening +Receipts-isseue =Closing Stock QueryOctober 11

    Dear Experts, I need a query with condition from to date for stock movement. Following Column I required in Query Item code, Item description, Opening +Receipts-issue =Closing Stock Query Thanks in Advance. Regards MANGESH PAGDAHRE. Edited by: MANGES

  • Closing Stock QueryOctober 11

    Hi Members, We Want a report for closing stock according to the following parameters, 1-Date from 2-Date to 3-Warehouse 4-Document Series Query Report should contain with, Item Code - Item Description - Inventory UOM - Quantity - Item cost(FIFO Value

  • Opening & Closing Stock - Query CorrectionOctober 11

    Dear Experts,                          Please find the below query, where I need IN quantity & values , OUT quantity& values should  pick only from  Standard Production Order , whereas  it should not pick from special Production Order. Rest all in

  • Query for Opening And  Closing StockOctober 11

    Hi Experts... I need a report for Opening and Closing stocks and Goods Receipt and Goods Issue for Raw Materials and Finished Goods and Consumbles ..instead of going for different reports for each we need a combined report which can display for all R

  • How to create a query to see Opening stock and closing stock as on particulOctober 11

    Hi All, How to create a query to see Opening stock and closing stock as on particul. Regards AlbaikHi, In BI 0IC_C03 will provide u the  required information and also having standard queries provided by the SAP. Plz find the list of Queries provided

  • Query  for  Closing Stock goes beyond a particular value.November 30

    Hi, The query for the following requirement: The Closing Stock goes beyond a particular value. The Closing Value of items crosses the pre-defined value.Hi, Yes it is related to the user selected date and stock level. Not answered Closing the thread.

  • MB5B Report table for Open and Closing stock on date wiseOctober 11

    Hi Frds, I am trying get values of Open and Closing stock on date wise form the Table MARD and MBEW -Material Valuation but it does not match with MB5B reports, Could anyone suggest correct table to fetch the values Open and Closing stock on date wis

  • Opening Stock and Closing Stock CalculationOctober 11

    Hi,      My report requirement is to display the material, opening stock for the lower date, closing stock for the higher date and the in between all stock operations..how to fetch the opening stock and closing stock for a particular  material ???..

  • Closing stock report with GRPOOctober 11

    Hai all   Please help me to write this query, For example I have  query to take closing stock report ,but my requirement is ,i want split up for Closing stock and closingvalue like, if i have 40 closing stock means i want details how 40 is arrived fo

  • Inventory opening and closing stock with value reportOctober 11

    Hi All, Is it possible to get details of both opening and closing stock with value of each items of last financial year (2009-10) in inventory report? MizanHi.. you can  try this query Declare @FromDate Datetime Declare @ToDate Datetime set @FromDate

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.584 s.