Payment Initiate Date issue

[senthil]

Hi Mike,

I have one clarification in the Payment section.Please find attached the screen shot (Payment_Initiate Date.jpg)
in the screen shot ,the payment section we have passed only payment date ( 10/02/2016)
but in the top there is a column called "Initiated Date" which is showing 09/02/2016 .may i know where it is coming from .actually the payment date should be a "Initiated Date"
kindly advice how we can match the "Initiated Date" as "payment date"

Thanks & Regards
Senthilnathan

[Mike.Sheen]

in the screen shot ,the payment section we have passed only payment date ( 10/02/2016)
but in the top there is a column called "Initiated Date" which is showing 09/02/2016 .may i know where it is coming from .actually the payment date should be a "Initiated Date"
kindly advice how we can match the "Initiated Date" as "payment date"

Thanks & Regards
Senthilnathan

The Initiated Date is the date of the sales order - SO_Main.InvoiceInitDate in the table - this is automatically set to the operating date when a sales order is created. Payments when added will set their Payment Date to also use the operating date - but you can change that after adding the payment to the order.

If you want the payment date to be the same as the Initiated date, just add the payment and set the payment.PaymentDate to be equal to the salesOrder.InitiatedDate.

[senthil]

Dear Mike,

Thanks for the reply.and I have small mistake in the previous post.the actual issue is in the payment date section . not Initiated date.
Please find attachment screen shot.in the screen the "Date" in the payment section is not correct .it should be Initiated date.
in the payment section I have update the " payment date" as Initiated date.but in the screen is not reflected.
kindly advice how to make payment Date as Initiated date.

This is the payment Section code

Dim objPayment As New JiwaFinancials.Jiwa.JiwaSales.SalesOrder.Payment
Dim obType As New JiwaFinancials.Jiwa.JiwaSales.SalesOrder.PaymentType

obType.PayType = SalesOrder.SalesOrderPayTypes.e_SalesOrderPayTypeCash
Dim _PaymentTypes As New JiwaFinancials.Jiwa.JiwaSales.SalesOrder.PaymentTypeCollection()
_PaymentTypes.Add(obType)
_PaymentTypes.Read()

For i = 1 To _PaymentTypes.Count
If (_PaymentTypes(i).RecID = PaymentTypeId) Then
obType = _PaymentTypes(i)
Exit For
End If
Next
With objPayment

.AmountPaid = Convert.ToDecimal(PaymentAmount)
TotalPaid = TotalPaid + PaymentAmount
.PaymentDate = InterfaceDT
.PaymentRef = PaymentRef
.BankName = "ROS"
.PaymentType = obType
.ProcessPayment = True

End With
jwJiwaSalesOrder.SalesOrderPayments.Add(objPayment)

Thanks & Regards
Senthilnathan

[Mike.Sheen]

Hi Senthil,

Without actually trying this myself, if the payment date is not being set right then it is possible we're setting the payment date at the time of adding and overriding what you already set it to prior to adding to the collection (If so, that's a bug) - but to attempt to work around this, can you try performing the following:

Code: Select all

objPayment.PaymentDate = InterfaceDT

AFTER your call to add to the collection:

Code: Select all

jwJiwaSalesOrder.SalesOrderPayments.Add(objPayment)

Mike