FIFO Calculation on Total field of Goods Issue

[Former Member]

Hi Everyone,

Good day!

I tried to create a Goods Issue and upon posting it I noticed the total amount(Total field). I didn't understand how it gets the amount. Can you enlighten me where does it gets the amount and how does it calculates?

I tried to simulate or create transactions using the following:

GOODS RECEIPT PO:

Doc 1 :   Qty - 20   Price - $10

Doc 2 :   Qty - 10    Price - $10

Doc 3 :   Qty - 15    Price - $10 

GOODS ISSUE:

Qty - 30   Item Cost - $10.33     Total - $360.00  = ? (how this amount is calculated)

Please help me to further understand the calculation of the Total.

Your response will be highly appreciated.

Thanks and Warm regards,

Anthony M.

[kothandaraman_nagarajan]

Hi,

How did you get item cost as $10.33? Please post screen shot of good issue window with info price, item cost and total here to check.

Tested in 8.81 version, getting total of 300 in journal entry. There is no price at total unless there is info price at good issue.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagarajan K,

I stated below how I get the Item Cost:

Valuation Method: FIFO

Since the quantity in the Goods Issue document is 30 pieces, the system gets the first two prices of Magic Item which are 10$ and11$.

20 pieces x 10$ = 200$ and 10 pieces x 11$ = 110$

The Total Quantity is 30 pieces and the Total Amount is 310$

Item Cost: 220$ / 30 pieces = 10.33$

Yes there is a price in the Info Price field. I attached the screen shot of Goods Issue document.

You mean the Total amount came from the Info Price multiplied by its quantity? Actually upon using Info Price as my cost, I get the Total $360.00.

Total =  Info Price * Quantity

           = $12 * 30

           =  $360

Is it how SAP Business One calculates the Total amount in the Goods Issue document?

Thanks and Warm regards,

Anthony M.

[kothandaraman_nagarajan]

Hi,

Total amount in good issue calculated by info price  * quantity.

Is it possible to post your GRPO for 25,15 and 10 quantities?

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagarajan K,

Noted. Thanks. Is it standard in SAP Business One? What if I don't have Info Price amount, will the Total amount is just 0, isn't it?

My created Goods Receipt POs are below:

Doc 1 :   Qty - 20   Price - $10

Doc 2 :   Qty - 10    Price - $11

Doc 3 :   Qty - 15    Price - $12

Apologies if the stated email earlier has only same costs which is $10.

Thanks and Warm regards,

Anthony M.

[kothandaraman_nagarajan]

Hi,

Yes correct.

Thanks & Regards,

Nagarajan

[Former Member]

Thank you.

May I know where the Info Price gets its value?

Thanks and Warm regards,

Anthony M.

[kothandaraman_nagarajan]

Hi,

Based on price list selected in Good Issue window.

Note: Please do not ask question after closing thread.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

I'll take note of it.  Thank you very much.

Thanks and Warm regards,

Anthony M.