PaulRipley Red Ribbon

ok thanks for the comment Tigran.

i couldnt actually see that tab. We have a View Customer 360 in the top right which maybe gives the info but the reply was helpful

Sure but I'm not hopeful to be honest

Hi Richard Thanks for replying. Thats the strange thing, there is no update on the system notes. We noticed things like the ordering of the scripts had changes, parameters were missing , access removed but nothing on the system notes

Many thanks for your reply

thanks thats great, i have passed onto the accountants Paul

Thanks Mark. That makes sense. The only issue the accountant told me is that this would be an interco transaction so they would want to recognise the payable also in subsidiary 2. It sounds like there is no way to do this on the Vendor Bill screen - theyd have to do an interco journal to recognise the due to/froms But your…

Hi Yes and unfortunately it didnt help but thanks anyway

Many thanks for your help

Thanks Angela. So you have this custom field . You have a Parent Vendor and multiple Vendors based on currency. Is the benefit for reporting ie so that you can report at the Parent Vendor level plus the payment benefits. Also do you need to make all Vendors without a child a Parent so that you can report at the Parent…

Thats so odd but and a bit rubbish but if thats what you have to do…

Thanks, i understand that you have to enter the entity bank but literally on every invoice you have to specify the entity bank? It seems like a very manual process

ok thanks for checking

HI Clarisa The case number is below Many thanks Paul 6132451 At what point in the day are the HSBC rates taken and where can we find them on HSBC website

Thanks that did work

Thanks Clarisa. The HSBC rates are difficult to agree. HSBC in the UK did not recognise the rates in NetSuite eg there are too many decimal places. So I logged a ticket with support which confirmed the 6am load, but they also said they are loaded by an API. I've asked support to ask Product Management where the API sources…

Hi Amanda Does this mean you put multiple subsidiaries into one batch and then create one payment file to send to bank, and therefore only one approval needed in netSuite?

Hi Amanda Yes we are Paul

actually not sure this works

Thanks. Just FYI i found this in the suite ideas repy "I've figured out the solution to this problem! If you go to Setup->Company->Enable Features, click 'Items and Inventory' tab, tick the checkbox labelled 'CENTRALIZED PURCHASING AND BILLING', and then click SAVE. Once this feature has been enabled a new field will…

Thanks all, yes we are working with NetSuite consultant but it seem NetSuite doesnt work with loading a trial balance in multi transaction currency as you have to load one journals per currency and fx rate

thanks we are in the UK - will look at zone sftp

I think they are currently trying to get that resolved

NetSuite/Saltedge isnt licensed for RBSi even though it says it is on the website.

Hi - just an update, although NetSuite/Saltedge claim that RBSi works with the bank suite feeds app - it currently doesnt

Thanks for all your replies, the answer i found elsewhere which is "I think you can't filter the netsuite fields directly but you can set customisable fields which then auto fill the standard fields, and the customisable fields can be filtered for whatever journal options you want." Thanks again Paul

Thanks for replying. I'm actually OK at powerbi. Just not sure how complex the tables are in Netsuite

Thanks Angela - it was more that when you post a journal to the general ledger, how you help the accountant to know whether they need to post to department and class or department, class and location ie which segments to post to.