Yogesh,
You can enter the Inventory opening balance from Inventory/Stock Count Journal
or from Item/Stock Movement Journal. But when you are dealing with item
dimensions. You have to follow the following steps to track the Dimension ID
for each item because the Dimension ID is available in Invent Dim table with
the item dimension (InvenSize, InventColor, ConfigID)
1. Extract all master records of Items Dim from InventDim Table in Excel.
2. Extract all master record of Item Dimension Combination from
InventDimCombination Table.(Item Number will be available with all
dimensions(InvenSize, InventColor, ConfigID) without Dimension ID).
Fields of Sheet1 (InvenDim Table) will be like:
A B C
D
INVENTDIMID
CONFIGID
INVENTSIZEID
INVENTCOLORID
Fields of Sheet2 (InventDimCombination) will be like following and manually add
Dim ID as highlighted in this sheet2
A B C
D E
F
ITEMID
CONFIGID
INVENTSIZEID
INVENTCOLORID
NAME
Dim ID
Now write the Excel Macro to compare the fields(InvenSize, InventColor,
ConfigID) of InventDim Sheet1 with InventDimCombination Sheet2.
Sub main ()
Dim a as integer
Dim b as integer
For a=2 to 200
For b=2 to 200
If sheet1.range(“B” & a).value=Sheet2.range(“B” & b).value and _
sheet1.range(“C” & a).value=Sheet2.range(“C” & b).value and _
sheet1.range(“C” & a).value=Sheet2.range(“C” & b).value then
Sheet2.range(“F” & b).value=Sheet1.range(“A” & a).value
End if
Next
Next
End sub
Now Dim id will be available for each item in this “F” column of Dim Id, you
can give with the items in Item Journal Transaction Sheet.
Warm Regards,
Imran Bin Naeem
Cell: +966569522071
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of yogesh n
Sent: Monday, June 16, 2008 12:35 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Inventory opening balances
Dear All
I m trying to import inventory opening balances.
how do i relate inventdimid in inventjournal trans???
Kindly suggest soon.
Thanx in advance
Regards
Yogesh
_____
Best Jokes, Best Friends, Best Food. Get all this and more on Best
<http://in..rd.yahoo.com/tagline_groups_11/*http:/in.promos.yahoo.com/groups/bestofyahoo/>
of Yahoo! Groups.
<<image001.gif>>
<<image002.gif>>
