cancel
Showing results for 
Search instead for 
Did you mean: 

Updating Items in INV1 Table

Former Member
0 Kudos
82

hello All,

  please am updating the price field in the INV1 table for per item.before update the Rate is 2.0 and after update Rate is 0.0.although am only updating the   price field, is there a way to make rate field preserve it value.

Best Regards

Prince

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Are you updating through DI API or UI API?

Can you post your code?

Beni.

Former Member
0 Kudos

hello Beni,

  am using both DI API and UI API and below is the code that does the update.

For Each classItems As DraftClass In itemsData

                   

                    oInvoice.Lines.ItemCode = classItems.itemCode

                    oInvoice.Lines.Price = classItems.Price

                    oInvoice.Lines.SetCurrentLine(count)

                    count += 1

                Next

Former Member
0 Kudos

Hi,

Where do you see that rate is 2.0?

If you put the following line before and after the price update line - is it give different values?

Debug.Print (oInvoice.Lines.Rate)


Beni.