Results 1 to 4 of 4

Thread: Pastel Partner - How to change inventory item from service to physical item

  1. #1
    Silver Member
    Join Date
    Apr 2011
    Location
    Jhb
    Posts
    276
    Thanks
    105
    Thanked 14 Times in 10 Posts

    Question Pastel Partner - How to change inventory item from service to physical item

    Hi,

    I have imported an inventory masterfile from a .csv file. I wanted to do a test on whether an item will sell for less than cost (I entered a minimum GP% in the setup) I selected the first item on the stock listing and used it in my example. I noticed that I could do a quote for less than cost (!).

    I went into the individual item's file and saw that it was marked as a service item and that area was greyed out, so I could not change it to physical item. On all the other items they were also marked as service items, but with them I have the option to change it (not greyed out).

    I have 3 questions:

    - I selected Group 002 (Inventory Goods) in the setup screen for inventory. Should all my items then not be marked as physical items (and not service items)? Could it be that it is shown as service items, because I imported the masterfile with zero quantities?

    - Why can I not change this one item's classification from service item to physical item?

    - Why did it allow me to do a quotation for less than cost if I entered a minimum GP%? Could it be because of the zero quantities?

    Please help!

    Thanks.

  2. #2
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts
    Just check the following:

    Go to Setup...........Inventory...........Other ........and check that the inventory group that your stock item falls in, is not marked as "service item" in the "Type" option.
    Also you can quote any price even below cost and the system will allow this. I do know though that when doing an invoice you will be alerted that the price is below cost.
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  3. #3
    Silver Member
    Join Date
    Apr 2011
    Location
    Jhb
    Posts
    276
    Thanks
    105
    Thanked 14 Times in 10 Posts
    Hi Martinco,

    I have checked and the type is marked as Inventory / Physical item. Serial item is unticked...

    I am baffled...

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Quote Originally Posted by J7J View Post
    I selected Group 002 (Inventory Goods) in the setup screen for inventory. Should all my items then not be marked as physical items (and not service items)? Could it be that it is shown as service items, because I imported the masterfile with zero quantities?
    The group that you select under Setup...Inventory does not determine whether or not an item is a physical item or a service item.

    You need to select either "Physical" or "Service" on the individual stock item masterfile record.

    Quote Originally Posted by J7J View Post
    Why can I not change this one item's classification from service item to physical item?
    This is because there is transaction history on this stock item, whereas the other items have no transaction history yet. Pastel's audit trail integrity standards prevent you from amending the physical/service status of a stock item once there is transaction history on an item. However, with specialised software at my disposal, I can change the status for you - give me a shout if you want me to do it remotely for you.

    Quote Originally Posted by J7J View Post
    Why did it allow me to do a quotation for less than cost if I entered a minimum GP%? Could it be because of the zero quantities?
    I have not yet tested this situation on my test data, so I stand to be corrected in saying that it could be due to the fact that the item was a service item.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

Similar Threads

  1. [Question] Pastel Partner - Indication of GP% when doing quote
    By J7J in forum Accounting Forum
    Replies: 2
    Last Post: 24-Jun-11, 10:00 AM
  2. Replies: 2
    Last Post: 14-Apr-11, 11:22 AM
  3. Replies: 0
    Last Post: 21-Feb-11, 10:27 AM
  4. [Question] Pastel Partner
    By Goop in forum General Business Forum
    Replies: 5
    Last Post: 15-Aug-10, 06:58 PM
  5. [Question] Help with Pastel Payroll Partner
    By celly007 in forum Tax Forum
    Replies: 3
    Last Post: 17-Sep-09, 10:25 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •