Skip to Content
author's profile photo Former Member
Former Member

Inventory Price Calculation

Here is an example of an item.

It is set Sales UOM = SF, Items per Sales Unit =1, Packaging UOM= SF, Quantity Per Packaging UOM=1.777

If I put in a Sales Order for that Item and put 100 in Quantity for ordering 100 SF it will give me in the No of Packaging column 57 which is correct.

I need 57x1.777 = 101.289 which covers my 100 SF area.

The price per SF is 23.11

The SO gives me a total of $2311.00 which is 23.11x100

But to cover the 100 SF I need to order 101.289 and the price should change to $23.41 so the extra tile (1.289) will be not given for free.

Please let me know

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2013 at 07:45 PM

    Hi,

    You have 2 options:

    1. Change the quantity to 101.289 with inventory UoM.

    2. Change unit price to $23.41

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.