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]> To: Axapta-Knowledge-Village@yahoogroups.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]
