Inventory
MBA Forums
Welcome, Guest. Please login or register.
February 07, 2012, 09:33:17 AM

Login with username, password and session length
Search:     Advanced search
3139 Posts in 977 Topics by 5910 Members
Latest Member: dexterleonar512
* Home Help Search Login Register
+  MBA Forums
|-+  MBA Versions
| |-+  MBA for Avon
| | |-+  Inventory
« previous next »
Pages: [1] Print
Author Topic: Inventory  (Read 2265 times)
kim4avon
Guest
« on: August 06, 2006, 06:52:18 AM »

I'm trying to figure out how to use this feature.

Do I enter "I" under the "T" category when I buy something that is going into inventory or when the customer purchases something from my inventory? 

I have a couple of customers this campaign that are purchasing goods that I want to take out of my inventory.  When I enter that item on their sales order, will it automatically take it out of my stock or do I have to do this manually?

Thanks

Kim

Logged
admin
Administrator
Hero Member
*****
Posts: 1063


View Profile Email
« Reply #1 on: August 06, 2006, 03:51:27 PM »

The "I" is for when you are buy stock for Inventory.  You can MBA take out the items by printing a PO report, see the last check box on report options window "Update Inventory On-Hand amount".  Only use this checkbox once per campaign.

Cheers,
Stan
Logged
Linda B Aussie
Newbie
*
Posts: 44


View Profile Email
« Reply #2 on: August 06, 2006, 08:16:51 PM »


Hi there

I am wondering also on this inventory situation...

If you have something in your inventory (and you have a large inventory, that you cant even try to remember what you have and dont have) how does MBA register that you want to use an inventory item not order another one.?

Thanks

Linda B Aussie
Logged
admin
Administrator
Hero Member
*****
Posts: 1063


View Profile Email
« Reply #3 on: August 06, 2006, 10:05:33 PM »

MBA always assumes if you have Inventory you want to sell it.  Just curious, under what circumstances would a Rep not want to sell out of Inventory?

Cheers,
Stan
Logged
kcenter
Jr. Member
**
Posts: 95



View Profile
« Reply #4 on: August 14, 2006, 10:48:58 AM »

Hi Stan,
You asked why a rep would want to order an item rather than take it out of inventory?
I do that all the time which is why I quit using the inventory feature as it would not order the items I wanted if I had it in inventory.
Many times I am trying to reach a certain sales level and therefore need to order those items, rather than take them out of inventory, or my sales level according to Avon will drop.
Other times I have the items in inventory to use at events or I want to keep my inventory with a certain number of each product so I have them on hand. 
So the inventory feature is not convenient for me at this time.  I hope I explained that well enough.
Logged
Madkison59
Newbie
*
Posts: 45


View Profile Email
« Reply #5 on: October 22, 2006, 05:28:39 PM »

My question on inventory is how to input it so that I can print out my sales summary and see the cost of my inventory listed.   I realize I need to manually input this number into My Accounting worksheet but I want to balance my sales summary to my Avon invoice each campaign.

Since recording inventory under Data - Inventory Shelf will not update to the sales summary, I don't see the use in it except that it gives you the option of recording the cost of the item.    I see that you suggest using Sales Invoices to record inventory items but that doesn't give you the option of recording the cost so I'm assuming we have to override the retail price and put in the cost.   When we eventually sell that item, will it only adjust the quanty of items and not any financial information?   

Sorry for all the questions.   I'm an accountant and trying to see how I can use this to print campaign reports.   I want to be able to print a campaign P&L and have everything reflected.

Thanks for your help.

Mary
 
Logged
admin
Administrator
Hero Member
*****
Posts: 1063


View Profile Email
« Reply #6 on: October 22, 2006, 08:29:32 PM »

Yes, you can override the Price/Cost amounts in My Inventory. 

From an Accounting Point of View the problem with Inventory is that it is an Asset (similar to Cash, this is a Balance Sheet account) and not an Expense (which is an Income Statement Account).  So when a Rep buys Inventory it should not be added into My Accounting as an Expense until its sold (then it should be part of Cost of Goods).

However some Reps want to just put all purchases for a Campaign down as Cost of Goods and don't want to carry the cost in Inventory.  That is they Expense the whole cost during one campaign (when they buy it) and in the next when they sell the item it is pure profit as they have already expensed the Cost of Goods portion in previous campaign.  Another problem that has come up is Reps sometimes get Free items at Sales Meetings (maybe as a prize) and want to add it to Inventory to sell but it was free so there is no Cost (no Cost of Goods the item is 100% profit).

MBA lets you do it either way but you have to enter the Inventory cost/expense portion by hand.

Cheers,
Stan
Logged
Madkison59
Newbie
*
Posts: 45


View Profile Email
« Reply #7 on: October 29, 2006, 12:11:33 PM »

Okay..last question on inventory and I'll leave you alone.  My preference is just to enter inventory just once and not to have to go back and adjust the cost.   I see that if I enter inventory under Sales Order with an I type, it reflects under Sales SUmmary as inventory at the retail price because of the downloaded brochure.   It makes more sense to me to override the brochure price and enter my cost so that the inventory amount is reflected correctly on the sales summary.   Do you see a downside to this in MBA?  I don't see a specifc purpose to seeing both the cost and the retail price listed on the inventory report since the retail price may change as brochure prices change. 



Logged
admin
Administrator
Hero Member
*****
Posts: 1063


View Profile Email
« Reply #8 on: October 29, 2006, 03:45:37 PM »

I will have to think about this for a bit.

An issue with a Avon business is that on the surface it is Brochure driven not Inventory driven.  This can be a problem because an Inventory item may no longer be available (not in Current or last one or two brochures) so from a Brochure perspective does not exist and therfore does not have a Current Retail price.  This is the reason I have a Retail Price in Inventory (item may several or many months old, may even be discontinued).

When I first created MBA for Avon the first Reps I talked to were not concerned with Inventory (in fact they were not even concerned with tracking Customer balances).  They ran their business in a very simple manner, Customer ordered product, they ordered it from Avon, when they deliverd it they collected in full.  No Inventory, no Customer balances, very simple accounting.  Then one wanted to sell items she had won as prizes at Sales meetings. Then another wanted to not bother with some Returns, she would just keep them and resell them later.  This is where/when Inventory was added on to MBA and has continued to grow from there. 

Cheers,
Stan
Logged
Madkison59
Newbie
*
Posts: 45


View Profile Email
« Reply #9 on: November 03, 2006, 10:31:33 PM »

Yes...we are a demanding lot, aren't we?    Wink    I may be trying to make this harder than it needs to be.    I imagine those original Avon reps you made this for were still using the carbon copy order form to do exactly what you said...Take the order, order from Avon, deliver the product, collect the money and move on to the next campaign.   I'll rethink my needs also.   But I appreciate all your help.
Logged
Pages: [1] Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1 RC3 | SMF © 2001-2006, Lewis Media Valid XHTML 1.0! Valid CSS!