Mis-Calculation in A/R Invoice

[Former Member]

Hello,

Please find attached the screenshot. For the last item, I have put quantity as One and rate, but the Total Amount is different.

Please Help

Regards,

Mitesh

[kothandaraman_nagarajan]

Hi,

Your subject is related to AR invoice. But you attachment is related to sales order.

Please post AR invoice and item master  screenshot for better understanding.

Thanks & Regards,

Nagarajan

[former_member505219]

These factors are saved with the SO/PO. Even if you modify the item master data, SO will bring these factors from saved SO data. Plz check SO row details thoroughly.

[Former Member]

Dear All,

Even I noticed that its making the calculation as Rate multiply by No. of Packages, but in Item Master Data, Item per Sales Unit is 10 and not 50. So from where is it taking 50?

And secondly, in the Second Item, quantity is 40, No. of packages is 20, then too the calculation of Total Amount is Unit PRice multiply by Quantity only and not with Number of Packages.

Regards,

Mitesh

[Former Member]

yes, it is a fact....

pls check after making the Quantity per Package=10 ?

[Former Member]

My Sales Order and Delivery is already punched. I want to know the reason for it.

[Former Member]

Hello,

You will have to check all the parameters like , items per sales unit, qty per packaging, uom of the item.  Also are their any factors defined for this item...

Thanks,

Priya

[Former Member]

I have checked all the details. But the Qty per package is 10 and not 50. And also there is one more item in the same SO, where qty is 40 and No. of package is 20, then too the calculation is made considering the qty as 20 only.

Regards,

Mitesh

[Former Member]

Dear Mitesh,

The last item's unit price is multiplying with No. of Packs instead of Quantity which is generated wrong figure. You need to verify the Quantity per Package-sales tab on this Item Master data and make the change accordingly.

[Former Member]

Hello,

It is coming right i think i.e. 50 (no of packs) x 847 (unit price) = 42350

What is the UOM of this item in purchase, sales and inventory in master form? 

check that. 

accordingly the amount is getting calculated.

Thanks,

Priya