gokuakuatsushishoukai Bronze Medal

@Patrick Fresnosa-Oracle I also found that EJs created by amortization schedules have schedulnum which should be the schedule information. Is it really impossible to pick up it on a saved search with an id? {schedulnum} didn't work on a saved search.

I'd tried {journal.customfieldidname} but it didn't work.

@Patricia Ann Divino-Oracle I appreciate your answer. Can we get a Journal's custom body field value on an amortization schedule saved search by writing {} format id?

@Dominica Sevilla-Oracle I apreciate your help. However, the all column fields were blank even though there are some links between estimations and sales orders. Please confirm if your suggestion was correct.

@Katerina Winklerova-Oracle I appreciate your help. If we set the Residual Value directly on the FAM Asset Record, Residual Value % is ignored correctly? I would like to make sure of the specification. Best Regards,

@Tiru Chembeti I appreciate your help, but, Could I get more details about the flow with captures? Especially, I would like to know where can I set about... into which book the depreciation is written.

@Joy Noreen Magoling-Oracle How your investigation has been going? Hopefully, we'll get solid information soon. Best Regards,

@Katerina Winklerova-Oracle I appreciate your help. But we want to process only transactions created by memorized schedules with a custom script. That's why we searched the element that transactions have to distinct it.

@Katerina Winklerova-Oracle Thank you for the last time. However, it was nowhere to set multiple depreciate methods on one asset so I raised the case again.

@Patrick Fresnosa-Oracle I appreciate your reply. What is prospective merge? I couldn't follow you there.

@Patrick Fresnosa-Oracle I couldn't find Rev. Rec. Start Date, Rev. Rec. End Date column. In our environment, can't use Rev Rec Features and it is inactive. Is it related to this issue?

@Kristoffer Viray-Oracle Both seem not to be the cause? Any other points that can cause this issue?

@Katerina Winklerova-Oracle I appreciate your help. I'll check the documents that you gave me.

here is the current behavior

@Katerina Winklerova-Oracle I appreciate your support. it's super helpful. >>>work at the line or the subtotal level I couldn't imagine this difference, could I beg your explanation about this in detail? FYI, In our environment, Apply to Subtotal is inactive now. Best Regards,

@Tiru Chembeti To explain why this behavior is critical, we are using rev-recognition process on Sales Order, which means the revenue amount and its invoice amount get different in the case I raised. That's why the function is a kind of deathblow.

@Kristoffer Viray-Oracle No, I would like to edit an existing Payment File Format, not to create. I think that saving it with another Name won't go along with what we need.

@Tiru Chembeti Unfortunately, we found a critical failure and discrepancy in this case. Here is a test Sales Order and its invoice schedules. SUBTOTAL 11,988 / TAX TOTAL 1,199 / TOTAL 13,187 (JPY) Then I created all invoices for the Sales Order and I found the TOTAL's discrepancy. 1 ) First of all, the amounts of…

@Tiru Chembeti I appreciate your help. Then, in conclusion, #1's discrepancy never happens and, in the end, the total amount and total tax are the same all the time between sales orders and invoices(#2 is the NS specification), right? #1 not correct one #2 correct one

@Tiru Chembeti I appreciate your reply. Is the result the same in no decimal point case? I would like you to reproduce the 12 invoices also in your account with the no decimal point configuration. And please provide me with the screenshot again. I'm sorry to bother you but it would be greatly helpful for us.

@Kristoffer Viray-Oracle I appreciate your reply. This is so crucial point for our implementation project, so your support is gonna be so important and helpful. We'll wait for the investigation result. Best Regards,

@Kristoffer Viray-Oracle I appreciate your reply. Please keep investigating. Best Regards,

I solved the script schedule list access lacked. Closed.

@Katerina Winklerova-Oracle I'm sorry for rushing you so much, but I would like to make sure the specification clearly. >>>I can see detailed results only for the FAM transactions: we are using the Multi-Book Accounting feature Now we cannot add the column of "Accounting Book" on the transaction details report, there is no…

@Katerina Winklerova-Oracle >>> I might involve the other gurus specialized on the Scripting. Yes, please. I would like to know how to write scripts to create memorized transaction schedule.

@Patrick Fresnosa-Oracle I appreciate your reply. What we wanted is to add "Accounting Book" column on the report, not the filter, but, is it impossible by the specification? I want to make sure it clearly. Best Regards,

@Katerina Winklerova-Oracle I appreciate your reply. I would like to hear about the following your suggestion more. Do you mean it is possible to CREATE memorized transaction schedule by a suitescript? Memorizing transaction is basically done by adding field value 'memorize': true before saving transaction. It could be…

Exactly we are using the Multi-Book Accounting feature now. That means this time, the result is "impossible", right? @Katerina Winklerova-Oracle

@Kristoffer Viray-Oracle I appreciate your super-swift reply. Was greatly helpful.

@Tiru Chembeti The customer is active even now. As the specification, from where does NS picks up the customer name on JE created RRS? I'll check it. Or if there are other points that I should check, please tell me. Best Regards,