Good Day, I've Created a UDF and placed it in my Item Master data. Also Created a UDT that is linked using the UDF in Master data. Since it is linked it returns all the data that is in the UDT, I want to add a filter that it only provides the specifi...
Good day,
I'd like to create a query somewhat similar to the Inventory posting provided by the system.
example warehouse WH1 has Bin locations B1, B2, etc.. The query will ask for a date and it will display each bin with its corresponding amount...
Good day, by chance is there any way I can store outgoing payments for a customer.
Currently they have the Vendor payments but I would need to use one that stores for customers.
Need to query a list of items that are in the Bin Location for over a day. The standard report " Bin Location Content List" works but I am looking to get the results for items that are there for 1 day o more. The results will be used for another quer...
Good day,
Would like some assistance in building up a report using the query generator.
I want to generate a report for Purchases with the dates for each order from start to finish with number of days it took.
- purchase order,
- down & bala...
That's correct by chance do you know if the values returned can be filtered using another field. Example in Item Master, if it belongs to an Item group I just want to see specific rows based on this.
Hey ankit.chauhan1,Thanks for the quick response. Good answer, seems I just had to specify the DocType as your example shows. Seems default value is for vendors. Works great.Regards,Freddy
I have a query that I need, basically it needs to get the stock value for all bin in a warehouse.It does not match up with the data retrieved using inventory posting from the system. SELECT T4."BinCode", SUM(T0."InQty"-T0."OutQty") AS "In Stock Qty",...
