Andri2 Red Ribbon

Hi Micah, ideally yep, e-mail alert. Maybe not a list but, just to be alerted via e-mail when anyone will unapply the two journals. Thank you! A.

Hi Clarisa, sure, case #5475594 and defect #638044: Multi-Book > GAAP Book AP/AR Aging Report Does Not Match with the Primary Book AP/ AR Aging Report. Regards, A.

oki, I will file the case, thank you!

Hi Clarisa, those are unrealized FX's you may see on the screenshots that the amounts are reversed first day next month. I do not want to remove the currency revaluations, I just want to have the results same for Primary Book and Statutory Book with the final reval in appropriate currency. The Bill is in USD our Primary…

Hi Patrick, yep, you are right, I did not realized the Remaining Amount. I guess it's not possible to add Remaining Amount to Balance Sheet, right? :D Thank you A.

Hi guys, is this still a system limitation? Our customers are requesting to include QR codes on Invoices for payment. Do you think the suggested solution in SA 106924 is not an option to achieve something like this? Thank you Regards, A.

Hi Patrick, probably yes, but just thinking how can I extract these Base Currency Adjustments from NetSuite... But it's still interesting that the system is able to calculate this on backend and revaluate the account correctly. Wondering which formulas are behind the fields in Currency Revaluation.. Thank you A.

Hi Patrick, yep, I was thinking the same, however the type does not really matter as the Base Currency Adjustment is booked in EUR (because our Primary Book is in EUR) and we are excluding all EUR transactions in this currency reval. report. So even though I excluded the Currency Revaluations, the balance did not change. A.

Hi Clarisa and Patrick, it seems to be running now and not erroring out :) However I'm not sure about the data in the Pivot table. E.g. on Petty Cash Account On the Last Currency Revaluation Aug (2023) (see the balances on screenshot) The Foreign Currency Balance is ok, however I see mismatch in the Base Currency Balance…

Hi Patrick, I did check it but it's timeouting for me too..and in the pivot table I get error.. A.

Hi Patrick, yep, I've tried to scheduled the report as well, but it failed. I don't mind not having the ending exchange rates in the Dataset, we can add those in excel... If you could share your thoughts on some workaround for these two reports, that would be great! :) Thank you A.

Hi Patrick, we can't use these reports as we have too many transactions and the page won't load.. ('The results of this report are too large. Please, narrow your results') That's why I'm looking for some workaround report for this.. A.

Hi Patrick, yep, we are using this BS report as well, for reconciliation of accounts. We would like to also have kind of 'summary' per account and per currency as we have so many transactions that we can't load it in Balance Sheet Report in UI. It is possible that there are more currencies per account. In general we are…

Hi guys, nevermind this, is it seems like there can't be existing transactions in Draft Status. If there are, it's causing this issue not accepting the inactivation of the rule. A.

Hi Patrick, I think this would not help us. :( Because as the historical transactions were not processed we would be still missing the 'Opening Balances' . And there are existing transactions in Primary Book which does not have the Statutory Book added, as it was activated without running the Historical Transactions.. A.

Hi Patrick, there is no way to 'match/close' book specific journals, right? Especially for IC AP/AR Accounts..as it's not allowed to populate Name field on lines. And yep, you are right I wasn't thinking about all those periods closed before. If we have the statutory book setup for all entities in one, I have no idea what…

Hi Patrick, we are able to locate the transactions in Statutory Book representing the Opening Balances. However we don't want to open the books three years back. We are unable to edit those opening balances however we are able to reverse them. Does this help somehow? A.

Hi Patrick, thank you. Regards, A.

Hi Clarisa, thank you! :)

Hi gurus, I would like to follow up on this one. We have set up an Adjustment Period and I would like to understand what is the best practice within Period Close Checklist? Should we run all the closing tasks on the Adjustment period again after closing Feb 2023? I would like to mainly understand how will the system handle…

Hi Kaci, thank you for your reply! :) The issue for us is that we are trying to match 2 journals in the customer payment one journal Debit AR and other Credit AR, so we can't really use the Apply Credit Memo part.. :( Not sure if there is any alternate solution for us.. What do you think? Regards, Andrea

Hi Kaci, thank you for the follow up. Hmm, so is there any advise how to solve this if we have thousands of transactions like this, which need to be matched? Are the enhancements grabbed by the engineer or it's untouched since the creation? Thank you :) A.

Hi guys, wondering if there is any solution/workaround for this enhancement 216783, since 2019? We have thousands of such transactions, we can't match these manually in UI... Thank you! A.

Hi Joahnna, thanks for that! I'm always weirdly confused where I can use these joins and where not.. Thank you very much! A.

Hi Micah, thank you, unfortunately this was not the pain point here. The pain point here is why is it possible to save Vendor Bill with particular subsidiary and A/P account which is restricted for completely different subsidiary. Why is the system ignoring the restrictions set on the A/P Account. However I've submitted…

Hi Micah, nope, I would still appreciate if you could please confirm that this is expected behaviour. Thank you A.

Hi Kaci, thank you, I thought it will be an enhancement, too bad it has just like 4 votes :D so I'm not sure if this will be ever introduced.. But thank you for checking this for me. Regards and take care, Andrea

Hi Kaci, sure, I will wait for your findings. Thank you very much! :) Regards, Andrea

Hi Micah, any update on this one please? Thank you! A.

Hi Micah, sure, no worries. Thank you! :) A.