Hi to all.
I have several clients where we use the inventory audit report to validate the purchase account, closing inventories, cost of goods sold and net inventory change. The thing is, we'll also need to have the Distr. Rule and the report that the system produces, doesn't have the possibility of adding this field.
Can someone please help me create a query with the following structure:
Item No. // Description // System Date // Posting Date // Document // Whse // Distr. Rule // Quantity // Cost // Trans. Value // Cumulative Qty // Cumulative Value
It's also important that we can filter by date, since our analysis is conducted every month.
I'm guessing that this query is quite complex to make from scratch, as it requires searching through multiple documents.
Thank you in advance.
Translated with DeepL.com (free version)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.