Dear Users,
In Navision 5.0 is there any way i can identify whether a purchase order is completely invoiced using any field in the header (Similar to 'Completely received' boolean field in the header) ?
Regards,
Venkatesh
Thanks and Regards,
Venkatesh
0
Comments
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
There is not a field in purchase header that shows you the order is completely invoiced.
You could create a new field
Best regards
http://www.novalysis.it
As an addition if you part process a completely invoiced order may remain and there is a batch job to clear these out.
As Adam pointed out navigate the Menu to:
Administration > IT Administration > Data Deletion > Purchase Documents > Delete Invoiced Purchase Orders.
This will run Report - 499 - Delete Invoiced Purch. Orders
If you do not want to Delete the Orders but just Report or Mark them, then look at this report and how it works.
David
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com
David
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com
Definitely its possible to make that flowfield, but unfortunately the logic is wrong on two points.
Firstly its possible to have a negative quantity on an order, so the first condition should be : "Quantity=FILTER(<>0)".
Second, (I think what David was pointing out) is that Qty. To Invoice is a user entered field (with a default), so it is not possible to guarantee the meaning of this field. In fact a large percentage of clients have code to set this to Zero after each posting. You can't create the logic "Quantity Invoiced" = "Quantity" in a flow field.
So you are correct that the flow field will work, but unfortunately it won't be reliable. So you would need to add "Outstanding Quantity" = 0 and "Quantity Shipped Not Invoiced" = 0, though I am doing this off the top of my head, and would need to open Navision to check if I am 100% correct or not.
This works but not correctly, as the "Qty. to Invoice" may be set to Zero by the user, this could be the case in preparing the Purchase Orders to only receive, the user could set the "Qty. to Invoice" to zero which would negate the correct use of this flowfield.
If you were to use Outstanding Quantity and Qty. Received Not Invoiced, which are system set, then it could work. However we do not know why the OP wants to identify the Orders, if it is just to delete them then there is already a process which requires no new fields or code, it is always better for support and upgrade reasons when possible to offer a first solution that requires no system changes.
David :?
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com
It could be for cost analysis, lead time estimation, etc...
ERP Consultant (not just Navision) & Navision challenger