340
Dear colleagues,
Can anyone inform me if there is possible to integrate MIAMIPOS32 with NAV?
And if so, can you give some insight or overview?
Thanks a lot
*This post is locked for comments
I have a work management system that needs to send Invoices to NAV. Also, need to import Purchase Orders as approved workpackages for field workers to bill against.
Does anyone have samples of such and integration, or would be willing to assist on scuh a project....
1 250 229 4511
Happy to help :)
Neville,
you help me a lot.
Thanks
It is possible to check during the import however this is done by writing code in the XML port, so if you have more skills on the iBolt side i would suggest you do the checks there (Will make it easier to update going forwards)
the tables you are looking for in NAV are
Sales Header
Sales Line
And the document type should be order
After importing you can go to the actual sales order in the system and post from there, after creating an import (And posting the transaction) it is essential that you properly check the financial entries created as you can introduce some weird problems by not using the UI to import if you dont validate the fields correctly
Neville,
on iBolt, we can set different branch to make condition for check error or.., does XMLPort support too ?
which table is un-posted AP invoice ? can you let me know ?
Thanks
I would recommend getting a NAV developer involved as NAV has specific requirements in terms of what fields in what order need to be validated on the various documents (PO included)
To answer your question though:
Yes, the same process would work in NAV,
You would use a XML port (Which can also do CSV) to import a file containing the invoice
It can be imported as an un-posted PO (No financial implication at this stage) from the file
Then the PO posted manually inside the NAV client (Posting to CoA & inventory) - good as a client confirmation before posting
Alternatively you can have the actual import create the un-posted order then trigger the post so that it is fully automated,
I have done both of these but for the second option you want to be really sure of the quality of your source data as any errors in the posting process will stop the import and roll back the entire file until the error is fixed (There are ways around this though depending on the complexity you want in this solution)
EDIT:
I kept saying PO above i meant SO for Sales Orders (Working on PO's a the moment so have them stuck in my head) :)
Neville,
Your answer are very clear, thanks a lot. original we use iBolt to import CSV file that created by SpendMap into SAP B1 AP invoice draft table then user convert those draft invoice to invoice and SAP B1 will auto to create a JE when user save this invoice. how about Navision ? can I use XMLPorts to import those CSV file into AP invoice and which tables name ?
Hi,
NAV can integrate with almost anything, however a NAV developer would need to create the integration, it would more be a case of finding out what types of integration are supported by MIAMIPOS32
Let them know that NAV can handle the following and they need to pick the one they are able to work with, you will then need to get your NAV partner to build something for you on the nav side to convert these incoming transactions int GL journals, sales docs, or whatever is needed
These are in my preferred order but this will vary based on the requirement and developer:
SQL Tables
Web Services
XML Files
CSV Files
Most other files (Tab separated, fixed length...etc)
NAV can also do other types if required so if they way they use is not on the list it doesn't mean it cant be done
I have done a lot of integration so happy to help if you have any other questions
Sorry,
Kine, Miami32 is a software design for restaurants - touch pad, like win rest. Here is the link:
miami32.miami-kassen.de/miami32english.htm
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (