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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / physical inventory record
Small and medium business | Business Central, N...
Suggested Answer

physical inventory record

(0) ShareShare
ReportReport
Posted on by OluKoralage 5

When i trying to import the Physical inventory record i am receiving the below error message 

Any one know the correct file format for this

pastedimage1641815720366v1.png

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at

    How are you doing this import?

    Using a configuration package  or an XML port that is customized?

    If the last one is the case you need to check the format that your xml port expects to get.

  • OluKoralage Profile Picture
    OluKoralage 5 on at

    Hi Bruvik,

    I was trying to use txt format and the sample data upload is as follows

    "PHIO-000005","1","10000","10","WIN","","ABi Black-10","","UNIT","1"

    "PHIO-000005","1","20000","11","WIN","","ABi Black-11","","UNIT","0"

    "PHIO-000005","1","30000","13","WIN","","ABi Black-13","","UNIT","0"

    "PHIO-000005","1","40000","6","WIN","","ABi Black-6","","UNIT","0"

    This is a exact format I downloaded under "Recording" from Import a list of counted inventory items from a file "

  • yohi2020 Profile Picture
    yohi2020 245 on at

    Hi,

    The CSV needs 4 more fields to import in Phys. Inventory Recording page.
    I added 4 fields manually like below, and I could import the csv file.

    pastedimage1641821087014v1.png

    Ex)
    "PHIO00001","3","20000","1900-S","","EAST","","PARIS Guest Chair, black","","PCS",""
      ↓ Added 4 fields
    "PHIO00001","3","20000","1900-S","","EAST","","PARIS Guest Chair, black","","PCS","","2","","2021/4/30",""

    I am not sure why Microsoft docs does not explain this import functionality.

    error importing physical inventory record - Dynamics 365 Business Central Forum Community Forum 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,226

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,047 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans