These docs are for v20.3.44. Click to read the latest docs for v20.3.186.

Discussions

Ask a Question
Back to All

update trans.transaction_date and trans.entered_by

I'm so new with Imis and .net
I have this app that reads data from a file then update imis records from the data in that file.
I have a code that update the trans table. Part of the code is below
ComboOrderData comboOrderData = new ComboOrderData
{
Currency = new CurrencyData { CurrencyCode = "USD" },
Order = new OrderData
{
Currency = new CurrencyData("USD"),
LineTotal = new MonetaryAmountData(donation.Amount, new CurrencyData("USD")),
Lines = orderLineDataCollection,
OrderDate = OrderDate = DateTime.Now,
OrderState = OrderStateData.Entered,
OrderTotal = new MonetaryAmountData(donation.Amount, new CurrencyData("USD")),
SoldToCustomerParty = new CustomerPartyData
{
PartyId = donation.DonorId
},
TotalBasePrice = new MonetaryAmountData(donation.Amount, new CurrencyData("USD")),
SourceCode = donation.SourceCode
},
Payments = remittanceDataCollection
};

Currently, the trans.transaction_date is pulling the current date and the trans.entered_by is pulling "Manager". This part is seems like done by Imis automatically. I think.

We would like the trans.transaction_date to be the donation_date from the file and the trans_entered_by will be the file_name that we read the data from or uploaded

What fields do I need to set to update the trans.transaction_date and trans.entered_by?
I thought OrderDate from OrderData will update the trans.transaction_date but it's not. It updates the trans.effective_date instead.

Thank you.