I need to know if there is a report in NAV 5.1 for purchase orders that are received but not invoiced. I looked but can't seem to find one that is base. Before I go and modify something I'd like to know if someone knows of a report that would tell us if a purchase order was received but not invoiced.
Thanks.
0
Answers
5752 - Completely Received (Boolean)
or if you have
14000601 -Total Qty To Receive (Base)
if not you can easily create a field
Type Flowfield
CalcFormula:Sum("Purchase Line"."Qty. to Receive (Base)" WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.)))
Now it's easy to create a report on either
Completely Received = YES
or
Total Qty To Receive (Base) = 0
Here's a sample report we use:
http://savatage99.googlepages.com/Repor ... voiced.txt
Note it's only good as the day you run it - their's no "As of some date option" - It's just a quick simple report.
http://www.BiloBeauty.com
http://www.autismspeaks.org
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
I'll keep searching to see if we can have another workaroung!
Thanks.
Why not create another report? PS I already provided a sample report. Are you unable to import txt files from the oject designer? I could make it a fob.
http://www.BiloBeauty.com
http://www.autismspeaks.org
is exactly this
Sorry posted this before I realized the section I was in, this is in 4.0 and 5.0 don't know if it is in 2009
http://www.BiloBeauty.com
http://www.autismspeaks.org
Very strange. & it's unmodified.
Edit..
I see it totals all items on order NOT received. but I don't see it total what was recieved not invoiced.
Am I the only one with 5752 - Completely Received (Boolean)
Isn't it just a simple report of "Direct Unit Cost" * "Quanitity Received" using the Purchase Line.
obviously If it's in the Purchase Invoice Line then it's Invoiced A report like that should not take very long to create.
Even easier just total up field #59 on the Purchase Line "Amt. Rcd. Not Invoiced"
http://savatage99.googlepages.com/Repor ... t_Invd.fob
http://www.BiloBeauty.com
http://www.autismspeaks.org
What's wrong with the Reconcile AP to GL report? :-k Isn't that exactly what you need?
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book