How to Calculate the Amount Remaining on a Purchase Order in NetSuite

While it is easy to add the Quantity and Quantity Received to a saved search, NetSuite does not provide a standard field to show the amount remaining to be received at the item or header level. This information can be very useful to your warehouse team, your buyers, and your accounting team. Whether you are looking for the missing quantities of a line item or the overall dollar amount to be received, you can use a formula to quickly show what is missing.

To determine the quantity remaining to be received for an item, you can subtract the Quantity Fulfilled/Received from the Quantity on that line. The formula will look like this in your Saved Search results:

Formula (Numeric) | {quantity}-{quantityshiprecv}

To determine the dollar amount waiting to be received, simply multiply by the Item Rate:

Formula (Currency) | ({quantity}-{quantityshiprecv})*{rate}

For example, if you want to see the remaining amounts on multiple POs, you can create a saved search like this:

How to Calculate the Amount Remaining on a NetSuite Purchase Order

Criteria

  • Main Line = F
  • Tax Line = F
  • Status = Purchase Order: Partially Received, Purchase Order: Pending Billing/Partially Received

Results

  • Main Line Name | Group
  • Document Number | Group
  • Amount | Sum
  • Formula (Currency) | Sum | ({quantity}-{quantityshiprecv})*{rate}

To determine quantity remaining to be received per item, simply add the {quantity}-{quantityshiprecv} formula to any line-level search:

How to Calculate the Amount Remaining on a NetSuite Purchase Order

While these formulas are simple, they are flexible enough be used across multiple searches. You can determine the total number of items waiting to be received from a specific vendor, or if you purchase the same item from multiple vendors you can create a Purchase Order search and use a Group summary on Item to see how many you have not yet received.

EXTRA BONUS TIME!

Once you have mastered this formula on Purchase Orders, you can apply it to Sales Orders in the exact same way. Using {quantity}-{quantityshiprecv} will show the number of items that are remaining to be fulfilled from a given line on a Sales Order.

If you would like more information about anything in NetSuite, please contact us at any time! You can also learn about more great tips for NetSuite on our YouTube playlist or our other blog posts.

By |2018-11-30T12:08:05+00:00November 30th, 2018|NetSuite, Technology, Tips & Tricks|0 Comments

About the Author:

Bob Huguelet
Bob is a Consultant on Sikich’s NetSuite team. He has used NetSuite in industry for over three years. His expertise lies in designing optimal processes to meet customers’ business needs. Bob has extensive experience in real-world operations, distribution and integrations, training team leaders and end-users, and working with team-members and third parties to complete a project.
This material has been prepared for general informational purposes only and is not intended to be relied upon as accounting, tax, or other professional advice. Please refer to your advisors for specific advice.

Privacy Information

We use cookies to personalize the website for you and to analyze the use of our website. Click 'Privacy Options' to configure how we can interact with you and your device or computer.

Privacy policy | Close
Settings
private equity services construction accountants Agriculture Services Construction Services Non-Profit Services Government Services