RE: [Axapta-Knowledge-Village] locked in counting journal

[Rocco Giumelli]

Hi Harry   I may have crossed-paths on problems, Was You problem the same as this one?   Anything to add?       This was My Experience   My first experience with Annual Stocktaking was quite miserable. Firstly I had created my counting journals too early and the Stock on hand was taken as at the date of printing the journals, Do not print your journals too early for processing, Duplicate your system and than print them out so you can get everyone ready. Creating the Counting jounral on the day of the stock take. In my circumstances , we operate about 15 Warehouses national, and each Item Number must have a cross reference in the item form, under setup called warehouse items. Each Item number needs to have the associated warehouse loaded into here so. otherwise axapta locks the item number against the first warehouse that is processed. I thought this cross-reference would have been created by the actual transactions for that item in the warehouse where it has been used. (Otherwise when Stocktake is processed it keep saying that the item was locked, and it stops the flow)   Now I am on Axapta 3.00 sp1 , so I not sure whether this affects you, but I hope they have solved this problem in the next release. I am Sure there is other things that I Missed completly, GOOD Luck!   Rocco   A Response that I received Late Last Year   I don’t know why the inventitemlocation table is not populated automatically; all I know is that I had to populate the table in several of my implementations. I did get clever and used a csv import into Axapta. This made the process much quicker. It is easy to populate the spread sheet once you have all the items, the warehouses and the locations.   Also once the inventitemlocation is set up correctly, creating a stock counting journal is not a problem. If you create the journal per warehouse then the system locks the items in each respective warehouse (and location)…   I hope this answers your questions. Basically the inventitemlocation is very important for stock counting in different warehouses.   Regards, ______________________________________ Yifat Halili Financial Systems Consultant Exordia - a division of PricewaterhouseCoopers SA Website: www.exordia.co.za From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 February 2005 3:54 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi   Confused. Why do u want to mass populate inventItemLocation from on hand inventory? Which fields to u want to mass populate?   Regards   harry   From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 3:56 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] locked in counting journal   Hi Harry   Is it Per Item and Per warehouse?   Do you have a way to Mass Populate the inventitemlocation table with the Current on hand inventory of Axapta?   I would have thought this table would have been updated when items go into the Warehouse   Thanking You   Rocco   From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 4:09 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi   This is a bug with standard axapta. The flag is on table inventitemlocation. You will have to set this flag per item once a counting journal is posted.   Regards   harry         Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 289 9031 Fax +64 9 358 1018   CGNZ Limited and its predecessor organisations (Cap Gemini Ernst & Young, and Ernst & Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects.  CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world’s leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices.  Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies.  The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions.  Find out more about what we do at http://www.cgnz.com/middlemarketsolutions   CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. The opinions expressed are not necessarily those of CGNZ.  CGNZ accepts no liability for any loss, damage or consequence, whether caused by our own negligence or not, resulting directly or indirectly from the use of this email and attachments.   From: yifath1 [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 2:40 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] locked in counting journal   Hi all, can anyone help me, axapta 3, sp 3, items are locked during counting is activated on the inventory parameters. However if a journal is created and then deleted, then some items still remain locked in journal... even though the journal no longer excists... what modification is required...? Many thanks in Advance. Yifat Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.