Thanks Hemant and Khue. Now its working perfectly . Actually I didn’t know that it picks dimension number from number sequence setup. I was not giving it proper dimension id because of which it was generating various errors .
Ya Hemant, I know that we shall be careful while entering inventory OBs as we also import GL OBs because of which it can double the inventory balance. This was also a reason of using Movement journal , where we can give an “Inventory Clearing offset account” . Regards, faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hemant Kumthekar Sent: Tuesday, February 27, 2007 12:09 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: Re: [Axapta-Knowledge-Village] Inventory OBs Hi, If you are importing the Opening Balance using P/L journal, then you just need to load the proper InventDimId. Make sure that you have the InventDimId created / loaded in AX. Do you have Config/Size/Color and Storage Dim combinations like Warehouse/Location/Batch/Serial .... you need to give that information to help you out or guide you properly. I have been using P/L journals to load Opening Balance for last 5 years, and I had done with all dimension combinations of Config/Size/Color/Warehouse/Location. But also you need to understand that you should not have a double dip when you are importing your GL balances and your Inventory Balance will be one of your GL entries to be imported also. So take care that you don't have Inventory G/L account affected becuase of P/L journal load and then you also have G/L import which may have a Inventory G/L balance as a part of import. Hemant K ----- Original Message ---- From: 江华 <[EMAIL PROTECTED] <mailto:jhuaweier%40163.com> > To: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> Sent: Monday, February 26, 2007 12:54:13 AM Subject: Re:Re: [Axapta-Knowledge-Village] Inventory OBs Agree with "Khue Trinh"'s comments. John ÔÚ2007-02-23£¬kbi kbi <[EMAIL PROTECTED] <mailto:hsvkbi%40yahoo.com> > дµÀ£º Hi Faiqa, I always use P&L for import the opening balance.... not sure that you use Movement journal to have integration with GL on your OB import. INVENTDIMID problem: I think can you import data into InventJournalTable, InventJournalTrans... Then you can write a small job to read through the inventJournalTrans. For each transactions, you can check if there is a "linked" record in InventDim table by using the method: InventDim::findOrCreate(...) The reason I don't put full sample code here because I don't know how many inventory/item dimension you have (size, color, configuration, warehouse, location...) for your inventory transaction. This will help you to create record in InventDim table. then you can postyour inventory journal to get opening balance. Hope this help Thanks Khue Trinh ----- Original Message ---- From: Faiqa Khushi <[EMAIL PROTECTED] <mailto:faiqa.khushi%40m-consultants.com> > To:Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> Sent: Wednesday, February 21, 2007 8:00:26 PM Subject: RE: [Axapta-Knowledge-Village] Inventory OBs Thanks David, but in Trade and logistics manual (Chapter 6) its written that in movement journal we can select offset ledger account and this journal is used to change prices and to bring opening inventory balances during system setup. So I think Movement Journal is the proper way to enter Inventory OBs. Secondly even if I move from P&L journal , I think I will still face this issue because InventDim table also get involve in that journal. PLEASE GUYS , IF ANYONE CAN SUGGEST SOMETHING TO RESOLVE THIS PROBLEM. Regards, Faiqa From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Bonk, David Sent: Wednesday, February 21, 2007 5:38 PM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: RE: [Axapta-Knowledge- Village] Inventory OBs Faiqa; This does not answer your specific question but when we imported inventory OBs we brought it in through the Profit and loss journal and had none of the problems that you mention. You obviously will have other issues to consider such as the P&L journal creates GL entries however from the inventory perspective; it worked well. David ____________ _________ _________ __ From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com <mailto:Axapta- Knowledge- Village%40yahoog roups.com> [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com <mailto:Axapta- Knowledge- Village%40yahoog roups.com> ] On Behalf Of Faiqa Khushi Sent: Tuesday, February 20, 2007 6:31 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com <mailto:Axapta- Knowledge- Village%40yahoog roups.com> Subject: [Axapta-Knowledge- Village] Inventory OBs Importance: High Hi everyone, I am facing an issue while importing inventory OBs in Movement Journal. I am importing records in InventJournalTable, InventJournalTrans and InvenDim. It imports the records successfully in inventjournaltable and inventjournaltrans , but in invendim it generate errors against many records that "the record already exist". When I check that record in invendim table using query analyzer , there wasn't that record against which it generate that error . Can anyone explain that how it generate InvenDimID for each record and can we make our own invendimid or there is some logic behind generating this id ? It would be great if someone can write the steps of importing inventory OBs into the system. Regards, Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] __________________________________________________________ Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. http://farechase.yahoo.com/promo-generic-14795097 [Non-text portions of this message have been removed] <!-- #ygrp-mlmsg {font-size:13px; font-family: arial,helvetica,clean,sans-serif;*font-size:small;*font:x-small;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;*font-size:100%;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family: Georgia; } #ygrp-text p{ margin: 0 0 1em 0; } #ygrp-tpmsgs{ font-family: Arial; clear: both; } #ygrp-vitnav{ padding-top: 10px; font-family: Verdana; font-size: 77%; margin: 0; } #ygrp-vitnav a{ padding: 0 1px; } #ygrp-actbar{ clear: both; margin: 25px 0; white-space:nowrap; color: #666; text-align: right; } #ygrp-actbar .left{ float: left; white-space:nowrap; } .bld{font-weight:bold;} #ygrp-grft{ font-family: Verdana; font-size: 77%; padding: 15px 0; } #ygrp-ft{ font-family: verdana; font-size: 77%; border-top: 1px solid #666; padding: 5px 0; } #ygrp-mlmsg #logo{ padding-bottom: 10px; } #ygrp-vital{ background-color: #e0ecee; margin-bottom: 20px; padding: 2px 0 8px 8px; } #ygrp-vital #vithd{ font-size: 77%; font-family: Verdana; font-weight: bold; color: #333; text-transform: uppercase; } #ygrp-vital ul{ padding: 0; margin: 2px 0; } #ygrp-vital ul li{ list-style-type: none; clear: both; border: 1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight: bold; color: #ff7900; float: right; width: 2em; text-align:right; padding-right: .5em; } #ygrp-vital ul li .cat{ font-weight: bold; } #ygrp-vital a { text-decoration: none; } #ygrp-vital a:hover{ text-decoration: underline; } #ygrp-sponsor #hd{ color: #999; font-size: 77%; } #ygrp-sponsor #ov{ padding: 6px 13px; background-color: #e0ecee; margin-bottom: 20px; } #ygrp-sponsor #ov ul{ padding: 0 0 0 8px; margin: 0; } #ygrp-sponsor #ov li{ list-style-type: square; padding: 6px 0; font-size: 77%; } #ygrp-sponsor #ov li a{ text-decoration: none; font-size: 130%; } #ygrp-sponsor #nc { background-color: #eee; margin-bottom: 20px; padding: 0 8px; } #ygrp-sponsor .ad{ padding: 8px 0; } #ygrp-sponsor .ad #hd1{ font-family: Arial; font-weight: bold; color: #628c2a; font-size: 100%; line-height: 122%; } #ygrp-sponsor .ad a{ text-decoration: none; } #ygrp-sponsor .ad a:hover{ text-decoration: underline; } #ygrp-sponsor .ad p{ margin: 0; } o {font-size: 0; } .MsoNormal { margin: 0 0 0 0; } #ygrp-text tt{ font-size: 120%; } blockquote{margin: 0 0 0 4px;} .replbq {margin:4} --> [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links __________________________________________________________ Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]