base amount is zero

[Alejandro_Ruiz]

I have documents with subtotal but the database is at zero

any idea why that could be and how to solve it

(if I duplicate the document, the new one if it is correct)

[msundararaja_perumal]

Hello,

Use formula DocTotal-Freight-Vatsum-Discount-Rounding to get the subtotal value.

Thanks.

[Alejandro_Ruiz]

Thank for the Reply

the error is that it also appears in the list of orders

[Johan_H]

Hi Luis,

The field that you marked on the Sales Order form is not the Base amount field in the database.

The base amount field in the database is zero for all our sales orders. Please try this query:

select distinct T0.[BaseAmnt] from ORDR T0

You will see that this field is always zero or null.

Regards,

Johan

[Alejandro_Ruiz]

Thanks for the reply

Duplicate the order and execute the same query and I get information

the error is also evident in the list of orders

[Johan_H]

Hi Luis,

The top two rows in the second screenshot are both zero. How are these two orders similar to each other, and how do they both differ from all the other orders?

Regards,

Johan