Is there some kind of a standard Sales Invoice import?

rookie
Member Posts: 3
I do not know Navision at all as I am SAP consultant but one of my customer uses both SAP and Navision and their Navision consultant does not seem to be the brightest one around ... :-(
Anyway, my question is - is there some kind of a standard to import data into sales and process it as regular sales invoices. What we are trying to do is to import sales data from POS and then let Navision calculate cost of goods sold.
As much as I have understood from this forum we could use dataport to import the data but what I am looking for is the way to call Navision "function" that "creates sales invoice" based on the imported data.
Regards.
Anyway, my question is - is there some kind of a standard to import data into sales and process it as regular sales invoices. What we are trying to do is to import sales data from POS and then let Navision calculate cost of goods sold.
As much as I have understood from this forum we could use dataport to import the data but what I am looking for is the way to call Navision "function" that "creates sales invoice" based on the imported data.
Regards.
0
Comments
-
the create function you are looking for would be your dataport. this means that data can be imported directly into sales header and sales lines tables. During import you must take care of validating fields (cheking of validity, table relations, inital values for fields are set, some fields are aditionaly filled acording to inputed data, etc.) no big deal for navision programmer/developer. and the consultant should also know which fields are necessary to successfully enter and correctly post sales invoice...
btw. at the end you can call the posting routine if you are sure your data is ok...®obi
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯0 -
Thanks for the info.
I was just wondering if the posting also starts the "subroutines" if I can call then like that, of posting the cost of goods sold too - so that I would end up with sales posting that is based on imported data and cost posting that is based on that sales invoice?
Regards.
Peeter0 -
yes your dataport should "mimic" invoice entry as normal user would enter it manually.
then posting routines should be called (as user would press posting button) - ok to be honest your call is a bit deeper in posting routine to skip questions like "do you want to post invoice"...
BTW. Codeunit 80 is the one you should call for posting. Let us know if you need more details.®obi
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯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