Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
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
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.
RIS Plus, LLC
MVP - Business Apps