Item Opening Balance dataport problem

Business Central/NAV Developers Forum
1

Dear All, I would like to check if some body has done a Dataport for Item opening balance with Batch no (Item tracking) Please advice which are the tables to update for opening balance? I tried to update updating table 32,6501 is there any other table to update as (339,6503,6505)and I faced the following problems. 1. the Amount in the table 32 cannot be updated. I don’t know why? 2. after updating the above tables when I do a sales transaction the system doen’t allow me to post the trn.It give me a error code “there is no value entry with in the filer filer:item ledger enrty no 233” I guess it is becos I don’t have a value in Amount filed in table 32. How do we rectify this problem. Please advice Urgent thanks

2

Try importing into tables 83 (Item Journal Line) and 6500 (Item Tracking Line) and then using the standard posting functions to post the journal.

3

Hi, when doing data migration of balances (opened invoices, G/L balance, inventory) NEVER import the data into the movement tables. Always import into the respective journals and post the respective data to have all the posting dependencies established correctly. As you realized there are a lot of dependecies among the tables which get created during the posting process… Saludos Nils

4

I have tried with Table No 83 But It gives me an error as " Option Should not be blank " " option is mission or invalid in the expression. What is the problem ? I have taken most of the field which has to be updated You can have a look on the codes Have I left any impt field OBJECT Dataport 50000 <Item OB TRansfer Table 83> { OBJECT-PROPERTIES { Date=14/02/02; Time=[ 2:54:06 AM]; Modified=Yes; Version List=; } PROPERTIES { FileFormat=Fixed; } DATAITEMS { { PROPERTIES { DataItemTable=Table83; } FIELDS { { 5 ;12 ;“Item No.” } { 17 ;10 ;“Posting Date” } { 27 ;13 ;“Entry Type” } { 40 ;10 ;“Document No.” } { 50 ;5 ;“Location Code” } { 55 ;7 ;Quantity } { 62 ;7 ;“Invoiced Quantity” } { 69 ;7 ;“Quantity (Base)” } { 89 ;10 ;“Document Date” } { 99 ;9 ;“Line No.” } { 108 ;2 ;“Qty. per Unit of Measure” } { 110 ;3 ;“Unit of Measure Code” } { 113 ;9 ;“Journal Batch Name” } { 122 ;5 ;“Journal Template Name” } { 127 ;8 ;“Unit Amount” } { 135 ;8 ;Amount } { 143 ;4 ;“Item Tracking No.” } { 175 ;11 ;“Responsibility Center” } { 194 ;5 ;“Unit Cost” } { 199 ;7 ;“Invoiced Qty. (Base)” } { 206 ;9 ;“Inventory Posting Group” } { 215 ;8 ;“Source Code” } { 223 ;6 ;“Gen. Prod. Posting Group” } { 229 ;10 ;“Value Entry Type” } { 247 ;12 ;Description } } } } REQUESTFORM { PROPERTIES { Width=9020; Height=3410; } CONTROLS { } } CODE { BEGIN END. } }

5

Now I am able to transfer the OB in Table 83 But when I post the sales against the OB there is an error. " there is no value entry within the Filter " Filter : Item Ledger Entry No :124 Is there some where I missed top update.