Why Sales Order Total Amount is zero when status become invoiced!!!

(0) Share

Report

Posted on by Faqruddin

1,883

Dear all - I'm doing SalesTableListPage form customization and I wants to know why Total Amount is changed to zero when status become invoiced. I created display method on SalesTable as below to show TotalAmount in SalesTableListPage form..

display AmountCur totalAmountSales()
    {

        SalesTotals SalesTotals;
        ;
        SalesTotals = SalesTotals::construct(this,SalesUpdate::All);
        SalesTotals.calc();
        return  SalesTotals.totalAmount();
    }

7450.invoice.jpg

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Dogan Adiyaman 698 User Group Leader on at

Like (0)

Report

I'm not suprised becasue you are calling standard totalAmount() method and it works like that.

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Hi Dogan - Could you please tell me which method I should call to get the total value when Status become invoiced in Sales orders...

Thanks

Faqru Shaik

Was this reply helpful? Yes No
krishna.rao@dax 3,006 on at

Like (0)

Report

just use the existing display method in SalesTable.

amountInvoiced()

server display AmountCur amountInvoiced()
{
CustInvoiceJour custInvoiceJour;

select sum(InvoiceAmount) from custInvoiceJour
where custInvoiceJour.RefNum == RefNum::SalesOrder
&& custInvoiceJour.SalesId == this.SalesId;

return custInvoiceJour.InvoiceAmount;
}

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Hi Krishna - No its wrong one. I used this one before and it returns zero values for all sales orders. Please check in your environment..

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Have you checked InvoiceAmount method?

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

There is no such a method in SalesTable. Could you please tell me where its located..

Was this reply helpful? Yes No
krishna.rao@dax 3,006 on at

Like (0)

Report

Either you are doing wrong or not aware of how to use the display method.

In my system the values are displaying.

Make sure have you mentioned datasource in the control.

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Hi Krishna - Have a look my screens and it returns all zeros only...

Was this reply helpful? Yes No
krishna.rao@dax 3,006 on at

Like (0)

Report

Go to the Invoice ActionPane tab & check invoice journals.

let us know is there Invoice amount?

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Yes there is Invoice amount values. So tell me now what should I do exactly!!!

Was this reply helpful? Yes No