Hi, a question for the community.I'd like to generate a report that creates a simple picking list from a production order, and not using the Generate pick List wizard!The scenario is: currently the user is viewing the production order and looking at ...
Hi,Within the OQUT fields for reporting, where/what field would report on the linked Sales Order? If the quote has been converted to a Sales Order, it show in the relationship map; but how to I get the relevant linked Sales Order to show in my report...
Hi, I have written the below simple SQL for reporting on Sales Orders, where the warehouse location is specific.
My question is, how do I make the report exclude all cancelled documents from the list? I have put a CASE statement in the SQL that sho...
Hi,
We have setup an approval process for all new Purchase Orders added by any user, this works fine and as expected.
However, once the PO has been approved and is live we would like users to be able to make updates/amends to delivery dates, quan...
Hi, I have written a SQL for a function button on the BOM; but I'm not sure how to get the report to show me the stock I have in separate warehouse locations as well as overall stock!
Example screen grab below of what I'm trying to achieve from the...
Just to close this off, the SQL is working now as:SELECTT0."Father", T0."Code", T0."ItemName", T0."Currency", T0."Price", (SELECT T2."OnHand" FROM OITW T2 WHERE T2."ItemCode" = T1."ItemCode" AND T2."WhsCode" = 'W') AS "W Stock", (SELECT T2."OnHand" F...
Thanks, yes it is a bit unusual. The initial approval is required to ensure of no mistakes in business partner, items, costs etc.The changes after approval are for delivery date mostly, as the goods are sea-freight, so the due date changes often.We d...
Thanks Nagarajan,Yes, I have checked the BP Tab on general settings and we do have all the selections ticked. But if we try to change something on the PO and 'Update' it sends the document on another round of approvals; we want to remove the approval...
Thanks Johan, I will have a play and see if I can get it to work. I have tried a simple copy and paste of the SQL supplied but I get errors, I can see what it is trying to achieve though so I'll attempt to rewrite it to work for us.Thanks for your he...