We require Stock Valuation Report based on Stock Book Summary Cube with classification of the Inventory valuation to be shown based on the Purchase (GRC) Receipt Type i.e. Consignment & Non-Consignment type. Currently Receipt Type field in Stock Book Summary is not available.
Further this report will help filter out the Consignment stock type (Approval basis from Vendor) from the Stock Valuation report and submit to the Bankers which forms a part of Compliance required by the Bankers for working the CC Limits facility.
Now as the CC Limit requires to submit the Inventory Valuation based on Out-right Purchases goods only, we need the filter out / exclude Consignment as type (Receipt Type) in all Stock Book Summary related reports. So this will either require to give a joint of related view with Receipt type field OR maintain the separate Receipt type wise inventory in Stock Book Summary Cube.
As this is critical for all of Ginesys customers enjoying CC / OD / Credit Limit facility from their respective bankers to run their businesses, this will be very critical / useful report for them to extract and submit on the monthly basis with their bankers.
Hope this is implemented at the earliest
Thanks in Advance,
AM