Project

General

Profile

Tasks #6000

Invoice amount wrong RG received yesterday

Added by Rijas P almost 3 years ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
Mohamed Suhail
Start date:
03/23/2022
Due date:
% Done:

100%

Estimated time:
Spent time:
1.00 h

Description

We have completed one RG yesterday, the total amount we checked before completing and now in RG report and Bpartner settlement the invoice amount showing wrong.

The item EU21010 actually received 59CTNs+59Pcs. But now in invoice details its showing 2 lines with total amount of 59CTNs+59CTNs.

We have checked the Shipment document number and the stock qty showing is correct. Only the mistake happened in RG invoice. Please correct the invoice value and check the landed cost calculation is proper or not.

Please see how the item mentioned in CSV sheet.

Name Quantity Order No UOM
EU21010 59 GF190506 Carton
EU21010 59 GF190506 Each

PS: Please clear it immediately. We have to do the payment allocation.

Files

RG report EU21010.JPG (134 KB) RG report EU21010.JPG Rijas P, 03/23/2022 11:59 AM
Vendor shipment EU21010.JPG (138 KB) Vendor shipment EU21010.JPG Rijas P, 03/23/2022 11:59 AM

History

#1

Updated by Shemil Ali almost 3 years ago

  • Assignee changed from Mohamed Suhail to Rufsal N K
#2

Updated by Rufsal N K almost 3 years ago

created bugzilla Bug 8349

#3

Updated by Rijas P almost 3 years ago

Dear Noufal/Suhail,

Could you please correct the invoice amount & Check cost details. We are still waiting to allocate the payment for this invoice.

#4

Updated by Rijas P almost 3 years ago

Reminder..!! Please clear it immediately. We have to allocate the payments.

#5

Updated by Noufal K almost 3 years ago

  • Assignee changed from Rufsal N K to Mohamed Suhail
#6

Updated by Mohamed Suhail almost 3 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Rijas P wrote:

Reminder..!! Please clear it immediately. We have to allocate the payments.

Corrected Invoice amount. Please check

euro=# update c_invoiceline set pricelist=0.68,priceactual=0.68,linenetamt=40.12,linetotalamt=40.12,price_uom_id=100 where c_invoiceline_id=2187587;
UPDATE 1

euro=# update c_invoicelinetax set taxbaseamt=40.12 where c_invoiceline_id=2187587;
UPDATE 1

euro=# update c_invoicetax set taxbaseamt =86218.4600,taxcalculatedamt=86218.4600 where c_invoice_id =1055088;
UPDATE 1

euro=# update c_invoice set totallines=86218.4600,grandtotal=86218.4600 where c_invoice_id =1055088;
UPDATE 1

#7

Updated by Rijas P almost 3 years ago

  • Status changed from Resolved to Closed

Found updated.

#8

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF