Hi Yifat/Harry
On the item form, select the setup button, than warehouse
items, it shows a list of possible warehouses for the item you are looking
at.
I believe there should be an entry in here to represent the
item that would actually be in stock for that warehouse.
In our stocktake, it keep locking the items, until I
entered the warehouse number in here.
I don't understand why Axapta does not do this for us, We
are on Axapta 3.0 sp1, maybe they have fixed it....
I do need run a job that will populate this table based on
what is actually in stock in all warehouses for all items.
I believe this will need to be populated before we create
the counting journals.
Rocco
From: truserv_pm [mailto:[EMAIL PROTECTED]
Sent: Saturday, 12 February 2005 2:39 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: locked in counting journal
If I can add a comment here. We are in the middle of an
implemenation and during our testing found that the counting journal
locked the items during the countm which was fine. But after the
count was complete the items remained locked. MBS in Fargo (USA)
provided a fix for us for this. Perhaps you can source this fix
through your MBS contacts.
--- In Axapta-Knowledge-Village@yahoogroups.com, "Yifat Halili"
<[EMAIL PROTECTED]> wrote:
> Hi there,
>
>
>
> I wonder if we are all talking about the same thing?
>
>
>
> I am saying that if I create counting journal and delete it with
out
> posting it, and the parameter "lock items in counting journal" is
on,
> then Axapta does not always unlock all the items in the
> inventitemlocation table... and the client complains. It seems as
though
> I will have to have this bug fixed in Axapta.
>
>
>
> As for Rocco, I think you are talking about creating a counting
journal
> per warehouse, per location... and if you don't set the
> inventitemlocation per item per warehouse then your stock sheet
will not
> be per item per warehouse... is that what you are talking about?
>
>
>
> ______________________________________
>
> Yifat
>
> www.exordia.co.za <http://www.exordia.co.za/>
>
> ________________________________
>
> From: Harry Deshpande [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 10, 2005 9:55 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: RE: [Axapta-Knowledge-Village] locked in counting journal
>
>
>
> Hi Rocco
>
>
>
> Give me a couple of days something urgent has come up (when
something
> goes wrong it goes wrong everywhere and it seems all of our
clients have
> logged priority one calls) *s*
>
>
>
> Regards
>
>
>
> harry
>
>
>
> ________________________________
>
> From: Rocco Giumelli [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 10 February 2005 5:04 p.m.
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: RE: [Axapta-Knowledge-Village] locked in counting journal
>
>
>
> 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
> 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 <http://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
> 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.
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
<http://us.ard.yahoo.com/SIG=129jh2gha/M=298184.6018725.7038619.30011
76/
>
D=groups/S=1705001380:HM/EXP=1108151598/A=2532114/R=2/SIG=12kv5eicd/*
htt
>
p:/clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108065
198
> 669685>
>
>
<http://view.atdmt.com/NFX/view/yhxxxnfx0020000014nfx/direct/01/&time
=11
> 08065198669685>
>
>
> <http://us.adserver.yahoo.com/l?
M=298184.6018725.7038619.3001176/D=group
> s/S=:HM/A=2532114/rand=561789367>
>
>
>
> ________________________________
>
> 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]
> <mailto:[EMAIL PROTECTED]
subject=Uns
> ubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
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.
