HI @Cherry Eunice B Licyayo-Oracle , Thanks for clarifying but I'm not much clear on the approach you're talking about. Can you please elaborate this further through a demo. Thanks

Hi @Clarisa De Torres-Oracle , Yes, I'm trying to reverse the impact of the removed transactions related to the intercompany PO and SO, which are Item fulfillment and Invoice. The line items are as below: Please note the above are not being posted in the Primary accounting books but do in the secondary accounting books.

Hi @Clarisa De Torres-Oracle , Thanks for your response. I deleted everything except the PO and SO, in which case the PO was closed and the SO was set to cancelled. The above appeared while posting a book specific journal in the primary accounting books. This is specially when I select one of the account in the journal…

Hi @Jam Amper-Oracle , Thanks for your guidance. I have reviewed the articles and it says the inventory costing runs on its own. Is there any way we can check its schedule or run the costing schedule manually?

Hi @Patrick Fresnosa-Oracle , Thanks for your guidance, I've understood the impacts however I believe deleting them isn't an option in the system as they're intercompany paired

Hi @Patrick Fresnosa-Oracle , Thanks for your reponse. You mean to say that if the intercompany POs and SOs are left in the system as it is they won't impact anything? Yes, I've deleted the IF and IC invoice too and cancelled the POs and SOs

Hi @Patrick Fresnosa-Oracle , Thanks for guiding on this. I've tried deleting but it was not a closed period and hence not possible due to the intercompany pairing as suggested in the second video. The video reflects the same scenario of pairing option greyed out, however now I've managed to set the PO as closed and the SO…

@Patrick Fresnosa-Oracle Thanks for confirming. Really appreciate your support Thanks

Hi @Patrick Fresnosa-Oracle , I tried deleting the Item fulfillment from the Sales order and then the invoice in the SO. The PO remained the same of higher amount. The PO was also a paired intercompany one.

Hi @Patrick Fresnosa-Oracle , Thanks for clarifying on this. I've tried deleting it but it still remained. Now I've deleted the invoice as well after which it disappeared from the list of intercompany reconciliation but still the PO and SO exist in the system.

Hi @Patrick Fresnosa-Oracle , Thanks for your response. This option of Update Intercompany Order Quantities Automatically Prior to Shipment is already selected, but still facing the same. So you suggested instead of editing the Item fulfillment, I should go for deleting the item fulfillment and item receipts first on both…

Hi @Patrick Fresnosa-Oracle , Thanks for your reply. Yes, when I processed the green box appeared on top saying number of transactions processed = zero (null)

Hi @Clarisa De Torres-Oracle , Thanks for your feedback. Yes this helps abit but what we want is the breakdown of item fulfillments. What I noticed that the list contains multiple line items for one item fulfillment as it contains multiple items. Is there a possibility like we get one item fulfillment list from this and…

Hi @Clarisa De Torres-Oracle , Thanks for your response. The P&L report needs further expansion. Like below: In the above can we further expand the Item fulfillment to display its sub contents?

Hi @Jeremy Guimaras-Oracle , Thanks for you response. Yes, you're right there are 2 line items in the bill which is appearing twice, but the 2 line items are with different item codes so can't be merged to one. Is there a solution to this? Thanks

Hi @Jeremy Guimaras-Oracle , Apologies for the late response. Below is the criteria and results screenshot: The last 2 ones show the results in which the PO is appearing thrice in which one of the bill number is shown twice Thanks

Hi @Jeremy Guimaras-Oracle ! Thanks for getting back on this. Yes, its a dropship and the following details are shown thrice: The bills are in 2 but one of this is shown twice. Have tried adding the additional criteria but still the bills are appearing thrice. By grouping the saved search by summary type, what options have…

Hi @Jeremy Guimaras-Oracle , Thank you so much for your guidance, this formula does work but unfortunately in our scenario the results are appearing differently as below: I don't know why but the list shows everything in the related records but the 2 bills are being shown thrice. And this was infact a Puchase order with…

Hi @Slobodan Sobic , Thanks for your response. We tried this but the results were blank, basically we want to extract the following data for the POs in case of multiple bills against a PO: Could you please guide on this that how can we extract the multiple bills against a PO through a saved search? Thanks

@niks blando-oracle Is this feature to show related records in saved search possible now in NetSuite?

Hi @Clarisa De Torres-Oracle , Thanks for your support. In our case as it was intercompany journal so it worked through the pay single vendor section. Thanks

Hi @Micah Timbol-Oracle , Thanks for your support, but this solution didn't work in our case. We did the advanced intercompany journals to apply them across subsidiaries and then deleted the ones appearing in the No Vendor lists. This cleared the list as well as kept their accounting impact across subsidiaries as it is.…

Hi @Patrick Fresnosa-Oracle , Thanks for your response. Yes, I've tried this approach but unfortunately didn't help out. The bank and the vendor isn't linked to that subsidiary. Is there any way to allow this by changing vendor or bank records? Thanks

Hi @Dominica Sevilla-Oracle , Thanks for your response. I want to clear the list of No Vendors as mentioned in the later scenario above, but I don't want it by report customization just to hide them but to clear them once for all by clearing those transactions and streamlining everything. I've been trying to allocate the…

Hi @Katerina Winklerova-Oracle , Thanks for your response. Yes, this is helpful but the difference is between the account balance and last reconciled balance as below: Is the difference between both the balances constantly running or is it supposed to be equal?

Hi @Katerina Winklerova-Oracle , Thanks for your guidance. I've gone through this to history and have noticed that the last statement balance and reconciled this statement shows last matching at Feb-22. From onwards there are differences as below: Now the question is, when I go on to the details of the first account it…

Hi @Katerina Winklerova-Oracle , Thanks for your response. Yes, we're using the deprecated page till yet as one of the subsidiary is moved on Reconcile Account Statement till yet. After reconciling all last year these would also be shifted to the new Reconcile Account statement method. Thanks

hi @Tigran Shahnazaryan , Thanks for your response. So we should select either the Accounts Receivables or Payables accounts then in this option?

Hi @Katerina Winklerova-Oracle , Where can I get details for my Account manager from? Thanks

Hi @Katerina Winklerova-Oracle , Thanks for your response. We're from Pakistan and we have some other alliance partners in Pakistan previously in the market too.