Forum Discussion

GopalaAP's avatar
GopalaAP
Contributing User
4 years ago
Solved

Returning Damaged stock to Supplier

When we buy a product, we buy by carton and number of units will be 10, but when some of the units are damaged I need to issue credit request, then when I raise a new Purchase Invoice, enter the quantity as a negative, system tend to take whole carton, how can I do the returns only for the damaged units?  For example came 10 cartons, (10x10 = 100Units), one carton damaged, opened and check, only 4 pks are damaged and need to request for credit for 4 packs and remove it from inventory. But when I put -4, the stock it picks as -40. How to do this please. Thanks

  • The_Doc's avatar
    The_Doc
    4 years ago

    Hi GopalaAP 

     

    My methodology will only work if your description is correct on how you enter your stock.

     

    If I read correctly 

     

    1 carton = 10 units 

    1 carton = $80 i.e. 1 unit = $8

     

    Take it from another angle - you order 1 carton and you get by mistake 1 unit how would you enter that.

     

    According to my understanding of your setup you would enter this order as 

     

    0.1 cartons received = $8

     

    So if you received 4 units (i.e. 4/10ths) of a carton - you received 0.4 cartons.

     

    You then note ALL of these are damaged and you return them.

     

    The credit would be -0.4 x 1 carton = - $32

     

    If this isn't happening then your inventory isn't how you are describing I suspect.

     

    Just being The Devil's Advocate - sorry.

     

    The Doc

     

     

4 Replies

Replies have been turned off for this discussion
  • The_Doc's avatar
    The_Doc
    Ultimate Cover User
    4 years ago

    Hi GopalaAP 

     

    My methodology will only work if your description is correct on how you enter your stock.

     

    If I read correctly 

     

    1 carton = 10 units 

    1 carton = $80 i.e. 1 unit = $8

     

    Take it from another angle - you order 1 carton and you get by mistake 1 unit how would you enter that.

     

    According to my understanding of your setup you would enter this order as 

     

    0.1 cartons received = $8

     

    So if you received 4 units (i.e. 4/10ths) of a carton - you received 0.4 cartons.

     

    You then note ALL of these are damaged and you return them.

     

    The credit would be -0.4 x 1 carton = - $32

     

    If this isn't happening then your inventory isn't how you are describing I suspect.

     

    Just being The Devil's Advocate - sorry.

     

    The Doc

     

     

  • GopalaAP's avatar
    GopalaAP
    Contributing User
    4 years ago

    Hi Doc,

    It worked perfectly, Thank you so much. I made mistake by using -0.04, instead of -0.4. Thanks

  • The_Doc's avatar
    The_Doc
    Ultimate Cover User
    4 years ago

    Hi GopalaAP 

     

    Without getting complicated - here is a quick and easy - if possible.

     

    So 10 packs = 10 x 10 = units (1 pack = 10 units)

     

    You open a single pack and 4 units in a pack are damaged = 4/10 of this pack are damaged 

     

    In the whole order 4 of the 100 are damaged = 0.04 

     

    or 0.4 of an order of 10 

     

    The Doc

  • GopalaAP's avatar
    GopalaAP
    Contributing User
    4 years ago

    Hi, Thanks for solution. However, when I create the return/credit for -0.04 Qty, then the total amount is not correct. Example if the unit price is $8/Pk, then it should be -$32 + GST supplier credit, but when we use -0.04, total amount credit comes to -$0.35. Any suggestion. Thanks

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.