Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Import

(0) ShareShare
ReportReport
Posted on by 4,818

Hi expert, is there any way to import the serial number before create the purchase order and then assign the serial number to the items? I check only  337 Reservation Entry stores the serial number before post. Can I import the data to this table?  Thank you!

*This post is locked for comments

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Import

    Hi snoppy,

    I agree with Ashwini,

    try using TempTable where you can pull the records and later pick one which you want to use...

    --------------------

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: Import

    You can create temp table to upload your stuff, directly to these tables not suggested. Do small customization where you want to select and apply, then using Navision default program get it created as happens in std.

    Also maintaining all details directly in this table will be tricky job and prone to errors which may lead to new issues.

    Still if you can eleborate your requirement in detail , it will be easy to suggest best answer for your requirement.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: Import

    Functionality that you are looking for is not available in the default version of Dynamics NAV. Plus I really do not see a solid logic of your requirement as anyhow you need to enter the serial numbers to the system.

    If you can provide more details on the process you are following may be we can give you a better answer.

    As amol mentioned, if you are planing to do any modifications related to item tracking please be very careful as it is a very complex area in the Dynamics NAV. 

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Import

    Hi

    It is not possible in standard Navision as whenever the serial no is assigned system looks for Itemno and during the purchase order you have to generate the serial no.

    You might need to customize it but be careful as Item tracking in Navision is very complex

  • snoppy Profile Picture
    snoppy 4,818 on at
    RE: Import

    When I create a purchase order, I need to apply the serial number to the items. Is there any way to import the serial number to the table and then select the serial number from the list to apply the serial number to each item in the purchase order? Thank you!

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Import

    I'm not sure about your requirement, can you elaborate your process more exactly, why do you need such import? Perhaps, Item Tracking Code (T6502) and Serial No. Information (T6504) are interesting for you?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans