Import Qty to Phys. Inventory journal on Nav 5.0

Business Central/NAV Developers Forum
1

Hi,

Im with basic knowledge of nav development.

I need import physical stock from text file (csv) to phys inventory journal. I have created dp with below fields

“Item No.”
“Qty. (Phys. Inventory)”

  1. Ill generate phys stock over journal lines and using dp to export as csv.
  2. Do necessary changes on csv need to import back to journals.
  3. Post journal

Then I realized that some fields like Quantity, “Invoiced Quantity”,“Quantity (Base)”,“Invoiced Qty. (Base)”,“Entry Type” needs to be changed according to the changes of csv. I tried to trigger those fields with VALIDATE but didn’t work. Afterwords I have included those fields to dp.

When I’m trying to import data Im getting "Item No. ‘’ does not exist. " Seems something to do with line nos and tried few ways but ended up with no luck. Anyone can assist me ?

2

hi,

i tried following with success using the first row of table 281.

the export dataport:

OBJECT Dataport 50001 Phys. Invent. Export
{
  OBJECT-PROPERTIES
  {
    Date=16.11.14;
    Time=19:46:29;
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
    Import=No;
    FileName=c:\temp\phys-invent.csv;
    FileFormat=Variable;
    FieldSeparator=[;];
  }
  DATAITEMS
  {
    { PROPERTIES
      {
        DataItemTable=Table281;
        ReqFilterFields=Item No.;
      }
      FIELDS
      {
        { 1    ;     ;"Entry No."          }
        { 2    ;     ;"Item No."           }
        { 3    ;     ;"Posting Date"       }
        { 4    ;     ;"Entry Type"         }
        { 5    ;     ;"Document No."       }
        { 6    ;     ;Description          }
        { 7    ;     ;Quantity             }
        { 8    ;     ;"Qty. (Phys. Inventory)" }
      }
       }
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=9020;
      Height=3410;
    }
    CONTROLS
    {
    }
  }
  CODE
  {
    BEGIN
    END.
  }
}

for import part change the Import property to Yes.

i exported the first row, changed the values for Quantity and “Qty. (Phys. Inventory)” and imported that row again without errors.