Report Writer U of M on SOP Invoice

(0) Share

Report

Posted on by Community Member

I am trying to add the case price for an item to the SOP Blank Invoice. I deleted the Serial/Lot number table and added the U of M schedule header and detail tables. If every item is sold in the unit of "each", but the case price is required on the invoice and the unit of measures are set up in GP, how would I add the case price to the invoice. For example, 10 units are sold for $2 each on an invoice and there are 5 units to a case, so each case is $10. I need the $10 case price on the invoice.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

There are no discounts given to customers, so that would not be part of the calculation. The case price is only information for the customer. One case price to every customer every time, but a customer can order as many 'eaches' as they want. For each item, the case price and quantity per case is different. I keep getting information for the Each U of M from the U of M detail instead of getting the Case U of M information.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

Let me see if I 'get' this.

You have an item on an invoice and the each unit price is $2. That's fine, and you want the extended price to calculate based on the $2. That item is also available by the case. Case is included as a column in the item's UofM schedule. In your example, you only needed the case price for 1 case. You do not need to know what the price would be if they bought 2 cases instead of 10 eaches.

So, your invoice would be Qty 10, UofM each, Unit price $2, Case Price $10, ext price $20. The order may not be right, but is that the information you're looking for? Even if the customer bought 35 eaches, the Case Price would still display $10.

If that's true, the information you are looking for is a calculation. I do not think the actual number (the price) exists in a table. The system looks at the price list for the method used for the calculation, the quantity, the quantity compared to the base UofM, etc. and then it calculates the price at runtime. You could mimic that calculation, but that would perhaps not be possible using the native Report Writer. That's more than I would want to take on for a forum question.

So, as far as I know, there isn't an easy answer. If your pricing is consistent as far as method, qty discounts and level, you could hard-code the calculation such that you don't have to consider all of the variables that GP does. Again, too much for a forum answer (from me anyway :))

Kind regards,

Leslie

Was this reply helpful? Yes No
hoshang 55 on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

well done...

http://www.soran.edu.iq

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

Hi,

Did your business scenario needs to show all the line item's UofM for an order as case?

then you can use custom RW function to display all the line item as case for the particular order.

using custom RW function you can read the retrieve the case value for the particular item from IV40202 table and calculate the unit price according to that.

using modifier + VBA, also possible.

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

Can you explain the business requirement for why it can't be as "Case" on the invoice? The whole purpose of the U of M schedule is so that you can sell in whatever units you want but that it converts it back to the base unit (each) when removing from inventory.

Maybe if we understand why you can't use the Unit of Measure relevant to the sale (Case) we could help with another suggestion. I am not aware that you could have the Invoice show a different unit than what you have sold in.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

The item needs to be sold as "each", or unit, on the invoice. It cannot be sold as a case on the invoice, and so the case price will not print on the invoice.

Was this reply helpful? Yes No
sueconrod 337 on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

If you use the SOP Blank Invoice and you have listed the unit of Measure as case, then it should come up. You would have to change the U of M on your Invoice Entry line and if you have case setup for that item then it will come up and print correctly.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

This is already set up within GP. I need just the "CASE" price on the SOP Blank Invoice in Report Writer.

Was this reply helpful? Yes No
sueconrod 337 on at

Like (0)

Report

RE: Report Writer U of M on SOP Invoice

Once you have the Unit of Measure schedule setup you need to go to the Item price list (use the go to). Then set your price method and pricing. You have to define the case as being 5 each in the Unit of measure.

Which means you may have more that one Unit of Measure schedule in your setup if you have different cases on items.

On each unit of measure schedule you start out with the least amount you would sell of that object. I've had to set them up for inch, 1/2 foot, foot, yard, then 1/2 cord, cord, etc.

for you: Each, 1/2 case, case, flat (4 cases), pallet, 1/4 container, 1/2 container, Full container when a company was bring in from over seas and had shipping containers. and pallet can be the std 40" pallet or the new 46" pallets.

Was this reply helpful? Yes No