PO pricing not using saved level 2 pricing when we receive it, but rather the last price input from previous PO. Also EOY inventory pricing issue.

SOLVED

so hopefully this comes out clear. BACKGROUND: I am the regional warehouse supplying products to 13 salons.  ISSUE #1: Wrong pricing on purchase orders. --We set the pricing of products (level 1- and 2) in the system under maintain inventory items and save it.. We create a purchase order when buying products from a vendor. The vendor has a sale. When we receive the products we physically change the price on the purchase order (not in the system/level 2 pricing).  Next time we order under normal pricing the PO reflects the sale price when receiving, not the saved level 2 pricing.  Sometimes we get random discounts so we have the issue often because we don't know we are getting a discount until we receive the invoice.  So we then change the price physically on the PO, but it saves it despite the level 2 pricing staying the same throughout. What would be the proper way to handle this issue?

 ISSUE#2 (or question). We are doing end-of-year inventory soon. Does the software average all costs for each product or just use the last cost that we were charged? If it doesn't automatically average the costs, is there a feature to do this?

In a jam so any assistance is greatly appreciated..thanks--Captain Deyette (AIRBORNE!)

  • 0
    verified answer

    It sounds like your inventory is FIFO (First In, First Out)  If that is the case, and not Average, believe it or not, Sage 50 knows how many pieces you purchased at each price and will use that information when calculating the value of your inventory.  

    Your price level 2 is apparently based on LAST COST.  It last cost goes down, the selling price goes down.  Change the type of calculation and this will not happen.  

    FYI the "Inventory management" tab is your friend.  You can use this to look up prices paid in the past.  You may need to use this to reset your price level 2 price when you change the way it is being calculated.

  • 0 in reply to Best Business Strategies

    I'm terribly sorry for the late reply. I though I had sent it, but I guess it didn't go through. I read your reply as soon as you posted and used the information. I still just have one more question (not trying to have you teach me accounting ...been teaching myself as I muddle along).

    How do I  change last cost calculation? I see from the system the accounting method is average or that is what it says in the box. I don't know if I even need to change PL2 LAST COST  now that I know this information. However, if I did want to change the calculation, how I would I go about doing that? I see where you can hit the calculation button, but then you need to input something and I don't know what the standard calculations are?

    Last thing, is this information available in a  manual? I have some sort of printed out manual here, but it doesn't have the information I was seeking.  Of course I may not have the new one or a complete one.

    Thanks again-

    Respectfully-Captain D