Is there a standard report in NAV which can be used as an sales invoice but also show the Backordered Items in a seperate section
My approach was to modify the exisiting sales invoice report,add another sales invoices line section and find the corresponding sales line to get the Quantity and Outstanding Qty
Can anyone point me int he right direction
thanks
Regards,
GD
0
Comments
we don't backorder so not to create too many headaches. We figure if they really want it the will order it again.
Anyways this would be so easy in Crystal reports (for example) we'd create a variable called "Backorder Grouping"
with a simple formula (if Qutstanding Qty = 0 then 0 else 1) then add it to a group which would either make an item a zero or 1 and since 0 comes first it would group all the completed items together then they incomplete together too , after it.
I bring this up because this is kind of what you need to have happen unfortunately Nav and grouping isn't always the easiest thing (keys needed an all that stuff). But perhaps someone has an idea using an integer dataitem or something.
Sorry i couldn't have been more help but I do feel your grouping pain
http://www.BiloBeauty.com
http://www.autismspeaks.org
Would you not do the modification on the despatch docket?
The issue I see with this approach, is that the Invoice is a legal document which you will need to re-produce. What happens when the back-order is shipped and you re-print the invoice?
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
http://www.BiloBeauty.com
http://www.autismspeaks.org
You're bang on (as usual) - I forget than I shouldn't use local terms - I suppose I should call it a posted shipment document but it'll always be a despatch docket to me
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
Thanks for all the help it works beautifully
GD