Report for purchase orders received not invoiced

Veica · 2009-03-27

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.

Savatage · 2009-03-27

Check your puchase header table for fields
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.

Alex_Chow · 2009-03-27

Check out report 10101 - Reconcile AP to GL.

Veica · 2009-03-30

Thanks for all your replies. I didn't want to modify or create a brand new report and we already new about the Reconcile AP to GL. I just wanted to know if there was another way to go about this.

I'll keep searching to see if we can have another workaroung!

Thanks.

Savatage · 2009-03-30

good luck.

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.

themave · 2009-03-30

Purchase order status report 10156

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

Savatage · 2009-03-30

I can't get that report to work correctly. Everytime I add a filter it generates 0 pages.

themave · 2009-03-30

I use it constantly, have every since we started on Navision back in 1999 version 2.0, now on 4.0

Savatage · 2009-03-30

I just tried it 2 dozen times! no go, no matter if i add filter to Item or Purchase Order Line or either or Both.

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

Alex_Chow · 2009-03-30

Veica wrote:

Thanks for all your replies. I didn't want to modify or create a brand new report and we already new about the Reconcile AP to GL. I just wanted to know if there was another way to go about this.

I'll keep searching to see if we can have another workaroung!

Thanks.

What's wrong with the Reconcile AP to GL report? :-k Isn't that exactly what you need?

DarkSide · 2009-03-31

Reconcile AP to GL sucks. In an environment where you have a lot of inventory transactions you really need something that is date sensitive to support the Reconcile Inventory to GL report. Otherwise you have nice numbers but no backup as to where they came from.

Alex_Chow · 2009-03-31

Yeah, the only draw back for the report is that it's not date sensitive...

Report for purchase orders received not invoiced

Answers

Categories