Skip to Content
avatar image
Former Member

Conversion of Tablet and PACs in Quotation, Sales Order and Delivery

Dear Gurus,

I need solution of my critical scenario related to Pharma Industry: Scenario is:

Background:

==========

We have a product which are in tablet. We keep the base unit of measure of these tablet as PAC, which means 14 tablets equals to 1 PAC. Our stock keeping unit and issuing unit of measure is PAC.

Scenario

=======

.) We receive inquiry of customer for numbers of tablet. e.g. 1000 Tablets

.) We need to present the quotation in Tablets. i.e. 1000 Tablets, equivalent to 71.42 PAC. As we cannot break the PAC we have to give 72 PAC which equals to 1008 Tablets.

Problem

=======

.) 8 tablets are increasing because of the PAC size. These 8 tablets will be DELIVERED but not INVOICED because of the PAC size.

.) We need to charge the COGS of that 8 quantity but revenue will not be recorded.

This situation can happen in different stages like

*) At the time of Quotation 1000 tab: 71.42 PAC: 8 tab difference

*) At the time of Sales Order 800 tab: 57.1428 PAC : short order awarded; 12 extra tablets should be provided

*) At the time of Delivery 400 tab: 28.57 PAC: multiple deliveries; 6 extra tablets should be provided

Need quick and accurate solution from the experts...

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 07, 2012 at 08:42 AM

    Hi Imran Khan ,

    Maintain manual discount condition type at invoice level,for that take unit of measure which is suitable for single tablet.when you

    creating the invoice you will give the discount for the excess tablets Ex:8.This 8 tablets will come under calculation of COGS

    and the cost will not be added to the customer invoice.

    Regards

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 12, 2012 at 10:28 PM

    The condition will not be maintained manually as it will be fixed from Finance. The sales and distribution department will perform the rest except the pricing which will be set before entering the Sales Order by finance department.

    Any other automatic alternative.

    Add comment
    10|10000 characters needed characters exceeded