Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

How add lot number and expiration date by api

Posted on by 15

hi 

i used postman for add new purchaseorders

by this url

POST businesscentralPrefix/companies({id})/purchaseOrders

the url get me id 

i used id to add lines in the purchaseorders

by this url

POST businesscentralPrefix/companies({id})/purchaseOrders({id})/purchaseOrderLines

to this moment everything is good

Ashampoo_5F00_Snap_5F00_Friday_2C00_-May-19_2C00_-2023_5F00_23h48m11s_5F00_001_5F00_Purchase-Orders-_2D00_-Dynamics-365-Business-Central-and-9-more-pages-_2D00_-Personal-_2D00_-Microsoft-Edge.png

this is documents

7418.png

but when 

i need posted the purchaseorder

i have this message

5226.png

now 

i need url api to add 

 lot number and expiration date by apiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

i dont need add that manually from Dynamics 365 

i need url 

I read all the api logs and couldn't find any wayyyyyyyyyyyyyyyyyyyyyy
I want it urgently
I have tens of thousands of bills in my old erp

and I want to automatically re-enter them into my new system dynamics365 business central

thank for all

  • abhaq5000 Profile Picture
    abhaq5000 15 on at
    RE: How add lot number and expiration date by api

    hi mr kaspars semjonovs

    i can not find the table 336 or 337 in webservice

    [quote user="KasparsSemjonovs"]

    ‏يجب أن تدرج في الجدول 337 وليس 336. قم بإنشاء مثال وتصدير بيانات الجدول 337 من خلال حزمة التكوين ، لمعرفة كيفية تعبئتها.‏

    [/quote]
  • abhaq5000 Profile Picture
    abhaq5000 15 on at
    RE: How add lot number and expiration date by api

    how can i do this can you give me steps

  • Verified answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    RE: How add lot number and expiration date by api

    You should insert in table 337 not 336. create an example and export the 337 table data through configuration package, to see how it has to be filled in.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: How add lot number and expiration date by api

    Hi,

    You need to write your custom code, so when you are inserting PO Line, so at the time of insertion it should create tha tracking lines, with Lot or Serial no.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: How add lot number and expiration date by api

    Hi, hope the the following can give you some hints.

    How to create Item Tracking Lines automatically during an inbound transaction (Customization)
    https://yzhums.com/7943/

    2133.ms_2D00_dynamics_2D00_nav_2D00_2013_2D00_item_2D00_tracking_2D00_wp_2D00_ap.pdf

    Thanks.

    ZHU

  • abhaq5000 Profile Picture
    abhaq5000 15 on at
    RE: How add lot number and expiration date by api

    I understand that it can be entered normally by the user

    But I need to enter these items programmatically by an external application

    same way that I entered the basic invoice data and items.

    I entered them programmatically through an intermediary program, and I want to enter the rest of the details through an external program.

    I think you understood what I meant

    i need add url in api to add this information(Lot Number,expiration date)

    I don't know if this is a topic that can be accomplished by Microsoft developers or is there a way I don't know

  • Suggested answer
    Earl W Profile Picture
    Earl W 117 on at
    RE: How add lot number and expiration date by api

    the lot and serial no. are entered into  'tracking specification' table (id 336) which corresponds to page item tracking lines where the user would normally enter this information

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans