web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

error importing physical inventory record

(0) ShareShare
ReportReport
Posted on by 350

Using physical inventory record page, i get an error when using the function to import from a text file (which has prior been exported from the same page).

  1. use "Export Recording Lines"
  2. fill in the count where there's <,"",>      -->   <,"3435",> using a text editor
  3. save as .txt
  4. use "Import recording lines"
  5. error message: The Element <Quantity> is expected by Min Occurs value: Once. Element received: <PhysInvtRecordLine>.

Here's an example line:

"LAG-INVT-00001","1","10000","ITEM-ID23,"","TENATN-ID","BIN3","Ethernet/LAN. CAT6 shielded 25cm - Cable ID 20","399","STÜCK",""

tried different charsets UTF-8, ANSI and, CR/LF settings without luck.

what can i do here? how can i use the export-import function from the UI properly?

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Microsoft Employee on at

    I am trying to find that specific page and I am unable to locate this.  Is this for On Prem or Saas?

  • Verified answer
    benovic Profile Picture
    350 on at

    it's SAAS, usind physical inventory order.

    i solved the problem:

    the "export" is not exporting all empty fields in the end of the line, which causes the "import"  to throw error messages.

    Solution: add the fields manually, at the end of the line:

    "LAG-INVT-00001","1","10000","ITEM-ID23,"","TENATN-ID","BIN3","Ethernet/LAN. CAT6 shielded 25cm - Cable ID 20","399","STÜCK","","","","",""

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,091 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,032 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 946 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans