Update the Running No. after the import xml data

Rathi

Rathi Member Posts: 51

2016-12-30 edited 2016-12-30 in NAV Three Tier

Hi Guys,

Anyone knows how to update data for Item No after import .xml file.

I need to update the running No.

(Eg: Import from .xml --> FP-NP_SYR)
1. Current data in Item table is FP-NP-SYR-001
2. New import Data update into system --> FP-NP-SYR-002

How to modify the updated data FP-NP-SYR into FP-NP-SYR-002

Thanks in Advance.

0

Answers

Jan_Veenendaal Member Posts: 207

2017-01-26

This is what the INCSTR function is for.

https://msdn.microsoft.com/en-us/library/dd338972(v=nav.90).aspx

Jan Veenendaal
2
zohaibu95@hotmail.com Member Posts: 223

2017-01-26

@Rathi, Use the INCSTR function
For reference: https://msdn.microsoft.com/en-us/library/dd338972(v=nav.90).aspx

Best Regards
Zohaib Ahmed
Dynamics NAV ERP Technical Consultant.

please like / agree / verify my answer, if it was helpful for you. thanks.
1
RockWithNAV Member Posts: 1,200

2017-01-27

Yep go ahed with INCSTR - INCREASE STRING
It will increase the last integer value by 1

Thanks

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
0
SuD Member Posts: 102

2017-01-27

Yup,INCSTR is the solution for your requirement ..eg.INCSTR( 'FP-NP-SYR-001')..

0

Categories