ArtsMagna Business Management Software

Not trying to scare you but I need to do a stock take of just one of
our jewelry lines

I think I know what to do but I wanted some confirmation

Will I open the stocktake module
With the barcode scanner scan all products into the module THEN the
scary part
I am not sure how to update just one product line. I have been
through the tutorial on the DVD I got as far as The request widow
(print stocktake for which category)
You are saying type in CL@ I guess I would use our 3 letter supplier
code + @ not CL to isolate 1 product category group ....Is this where
I go?
OR in the past you told me to do a stock take from a printed report
and adjust difference through a purchase order making qtys negative or
positive where we need to add or remove

Please tell me the best and easiest way to do this
We are hoping to do this tomorrow night

Thank you so much


Warmest Regards,

Rae
OOMA - Objects of My Affection Ltd.

Hi Rae,

Unfortunately there are only 2 ways to do the StockTake

1)The all Stock

2)Only selected Product Categories


It sounds like you want to do it by Supplier or Brand but this is not currently possible. If you can do it by Categories, say Rings, Bracelets, etc. than what you described is correct.

Catch you soon,
Adri

UPDATE - From July 2008 ArtsMagna also allows to StockTake by Line/Brand!

Hi Adri

I didn't have too much trouble with the stocktake

I'm telling you exactly what I did just incase I did it wrong I seemed
to get the right result for the first column Qty Available.
I need some reassurance that things I attempt for the first time are
correct, somehow I still have a problem.

I followed your instructions from the email .... When I got to #4Open
excel file I put all qty to 1, (I am dealing with 569 line items)
I imported the file as Credit note (Possibly I misinterpreted steps 7
& 8 on the email)

When I opened inventory Pandora everything was at negative so I
deleted the negative from the excel file
I inserted that file into a purchase order as code + qty this gave me
qty 0 on all Pandora (which is what I wanted because Pandora was so
wrong)

Kathleen and I then counted all Pandora into the excel file I save the
file to text tab delimited
I then inserted this excel file into AM using code + qty giving me
correct qty for all Pandora (Qty Available)


BUT (and there always is a but)
I now have issues in the other columns....Qty owned.. ...Qty appro out
You had told me in the past that the first 2 columns should be the
same and nothing should appear in the last 2 columns
(We have quantities in these 2 columns on other brands possibly due to
laybys)

I am going to attach a file with the problems only, just incase I
haven't explained myself very well. ( I have saved it as excel)

What I would like from you please is:-
1 How do I fix this problem and stop it happening in the future
(because clearly we are not understanding a particular procedure and
are doing something wrong)
2 Please explain to me in detail what the last 2 columns are for.



Warmest Regards,

Rae
OOMA - Objects of My Affection Ltd.

Hi Rae,

Hopefully the following Audio/Video Tutorial will help explain how AM Stock works. Check them out in this order:

1)Audio Only ftp://ftp.artsmagna.com/amlite/tutorials/Others/How the Stock Works in AM - Part 1 (Audio Only).mp3

2)Audio + Video ftp://ftp.artsmagna.com/amlite/tutorials/Others/How the Stock Works in AM - Part 2.avi

If the above links do not work, simply try copying and pasting them.

Enjoy,
Adriano

Hi Adriano,

I am doing the supplier of Sunstate at the moment and I have the sheets the girls have written up from the shop (showing me the actual stock I have in the shop) I have looked in Brands and found that sunstate has been entered under 3 different headings SNST, SST, SUNSTATE therefore I have looked under all 3 for the stock some of which I can't find, I have also looked by supplier code. How do I rectify this? I'm thinking I just go into purchase orders and make up a dummy invoice is this the correct procedure to follow, please let me know.

Thank You
Regards NIta

Yes that is correct Nita.
Basically I would

1)first of all, modify the products cards by Unifying all records under the same Brand and/or Supplier

2)secondly recheck once everything is unified into the one group

3)thirdly double check that any of the missing records are definitely not in the system under a totally different Brand and/or Supplier and fix individually the ones you might find

4)lastly add all the ones totally not found in a New PO (FAKE INVOICE) which you should flag as an Adjustment (under Doc. Type)

Catch you soon,
Adri