how to invoice in pieces as well as in packets

[Former Member]

Hi Experts,

see what i want to do.

In item Master, i define UOM in Piece and item per purchase unit is '1' .And Packaging UOM in Container and Quantity per Packaging UOM is '10' means, in one container 10 pieces of computer are there.

Now when i punch an invoice,

i fill quantity 10 , it increase the inventory by 10 piece of computers.

now i want to purchase 2 packets and inventory should be increase by 20 pieces of computers.

same for sales time.

how i can do it.

Thanks & Regards

Manoj S

[Former Member]

If you already understand the concept, then you should know your answer. It is impossible to invoice in pieces as well as in packets within one invoice. You can only use one type of UoM in one invoice.

[Former Member]

Hi,

when i punch the invoice then it take as in piece by default not in pkts.

from where i can choose for pkts.

let suppose i define

Purchasing UOM in pkts,

Items per Purchasing Unit is 10,

and

Packaging UoM (Purchasing) in Cases,

Quantity per Packaging UoM is 5.

plz tell me how i can use this in invoice to purchase in pkts as well as in Cases for different-2 invoice not in one.

where are the option to select for pkts and cases in invoice.

thanks & regards.

Manoj S

[Former Member]

Item Master Data

Purchasing Tab:

Purchasing UOM 10pk

Items per Purchasing Unit 10

Quantity per Packaging UOM 1

Sales Data Tab:

Sales UOM EA

Items per Sales Unit 1

Quantity per Packaging UOM 1

Be careful as once you create a transaction with the changes you cannot modify some of fields.

Do a test in a test Data Base first.

[Former Member]

Hi M. Jenkins,

i created item master as like you suggest

when i punch purchase invoice i fill quantity field with 1 then it take effect on inventory with 10.

this is ok

but i want to also puchase only 2 or 3 piece then how i can...

Thanks

Manoj S

[Former Member]

That's an existing problem, I haven't found a way around that yet except using a FMS in the purchase order to get the Min Purchase amount and then update the Qty field and not using the SAP B1 Purchase Qty.

Edited by: M. Jenkins on May 20, 2009 6:51 PM

[Former Member]

Hi,

thanks for reply

if i will not use SAP B1 Qty then how my inventory will increased.

is it not possible in SAP B1?

thanks

Manoj S

[Former Member]

Hi All,

Please solve my problem..

Thanks

Manoj S

[Former Member]

If you want to purchase only 2 or 3 piece, have you tried to enter 0.2 or 0.3?

Thanks,

Gordon

[Former Member]

I assigned this query in the Qty Field in the PO it will fetch the Min Purchase and multiples, if you dont want to order the min you can override it.

DECLARE @OriQty AS numeric, @OrdrMulti AS numeric, @MinOrdrQty AS numeric

SET @OriQty = $[$38.11.0]

SELECT @OrdrMulti = ISNULL(T0.OrdrMulti/ISNULL(T0.NumInBuy,1),0) FROM OITM T0 WHERE T0.ItemCode = $[$38.1.0]

SELECT @MinOrdrQty = ISNULL(T0.MinOrdrQty/ISNULL(T0.NumInBuy,1),0) FROM OITM T0 WHERE T0.ItemCode = $[$38.1.0]

IF @OriQty < @MinOrdrQty

SET @OriQty = @MinOrdrQty

ELSE

IF @OrdrMulti > 0

BEGIN

IF CEILING(@OriQty / @OrdrMulti) * @OrdrMulti > @OriQty

SET @OriQty = CEILING(@OriQty / @OrdrMulti) * @OrdrMulti

END

SELECT @OriQty

[Former Member]

Hi Gordon Du ,

its working but this is not proper way to give quantity.

here i define items per Purchasing Unit 10

ok

let suppose items per Purchasing Unit is 13 then what i do.

thanks

Manoj S

Edited by: Manoj Sourot on May 21, 2009 10:28 PM

[Former Member]

Hi M. Jenkins,

This is not working.

and how will this effect the inventory

plz expain me

Thanks

Manoj S

[Former Member]

Purchasing unit is there for you to take advantage of it. If you purchase randomly without any rules, just use inventory UoM. For the previous case, I believe majority of your purchase would be in the whole packets of 10. It makes sense that you have occasionally purchase 2 or 3. I don't think 13 would be a regular number for purchase unless your business is so special that does not follow common sense.

[Former Member]

Hi Manoj,

As your case, to receive 2 or 3 items, go to Form Setting >>> tick Base Units field and updated

- if you want to receive by container, the status of base units is no, then value 1 in quantity field means 10 items

- if you want to receive by item, change base units into yes, than value 1 in quantity field means 1 item

You can use both of them in one document by multi-rows to match your requirement.

Hope this solve your issues,

Son

[Former Member]

HI Son Tran Van ,

thanks for solution

tell me one thing also,

what is use of Packaging UoM (Purchasing), Quantity per Packaging UoM

[former_member583013]

Packing UoM is the identifier for UoM for that item example: Box, Carton, etc.

Quantity per Packaging UoM is how much in each Box / Carton

[Former Member]

Hi Suda Sampath ,

how to use Packaging UoM (Purchasing), Quantity per Packaging UoM.

and what is difference between this and Purchasing UOM,

Items per Purchasing.

give an example to punch an invoice in both case.

Thanks & regards

Manoj S

[former_member583013]

Packing UoM and Quantity per Packaging UoM does not change the inventory quantity when receiving stock.

Items Per Packing Unit number will multiply by your quantity field on the PO and this gets posted to Inventory

Item Per Pack Unit: 10

You create PO for 100:

Inventory received would be 1000 units

[Former Member]

Thanks for reply,

then what is use of Packing UoM and Quantity per Packaging UoM .where this is used?

why we defined this?

[Former Member]

B1 online help has an easy understand example for the difference between these two unit:

For Purchasing UoM

You buy a case of soft drinks. There are six bottles (items per purchase unit) in one case. The item that you buy is a bottle but you purchase it only as a case of six bottles. Therefore, the unit of measurement is a case and there are six items per purchase unit. If you buy five cases, you actually buy 30 bottles of the soft drink.
In all transactions, "case" is the purchasing unit. And the number of items per purchasing unit is six.
You then enter the quantity in purchasing units in the purchase order.

For Packing UoM

You buy containers of soft drink cases, and the container is the purchasing packaging unit. Each container consists of 10 cases, which means that "10" is the quantity per packaging unit.

[Former Member]

Hi Gordon Du,

i have all ready read that.i understood that but i m asking where & how this is use in SAP B1.

plz explain 4 me with example in B1.

thanks

Manoj S