Purchase Header - Field 'Receive' and 'Invoice'

TV_2015
Member Posts: 5
The table 'Purchase Header' has a field named 'Receive' and a field named 'Invoice'. These are both booleans. When an order is received nor invoiced both are obviously 0. When an order is received but not invoiced 'Receive' is set to 1 and 'Invoice' is set to 1. When an order is both received and invoiced both are 1.
I now found a few records in my database where 'Receive' is equal to 0 and 'Invoice' is equal to 1, which should not be possible (I think). When I look at the underlying order lines there is no outstanding quantity or anything else out of the ordinary.
This is only the case for 11 rows out of more than 18.000. I have no idea why this happens. Does anybody have an idea?
I now found a few records in my database where 'Receive' is equal to 0 and 'Invoice' is equal to 1, which should not be possible (I think). When I look at the underlying order lines there is no outstanding quantity or anything else out of the ordinary.
This is only the case for 11 rows out of more than 18.000. I have no idea why this happens. Does anybody have an idea?
0
Answers
-
It's a control field for the posting process, it does not mean anything when you look at the value related to the order. It does not mean what you say it means. They are system fields, nothing more.
When you hit the post process, you can select Receive, Invoice, Receive and Invoice. Depending on your selection it then sets those fields, and those values are used in the posting process.
Debug the posting process, you'll see what happens.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions