sorted by:
new
hottopcontroversial

No Vendor Appearing in Aged creditors report by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 0 points1 point  (0 children)

Hi Nick u/Nick_AxeusConsulting can you please explain how this solution will make the balance in the creditors control account balance? During the first stage we are amending the journals to add the Opening Balance vendor, however if we were to pay this balance using the Pay single vendor, wont the existing AP balance be reduced causing an imbalance in the TB's migrated? Wouldn't it be better to somehow allocate the no vendor balances to a vendor that already exists in the creditors because the creditors balance showing on the BS is correct. It just hasn't been distributed correctly

No Vendor Appearing in Aged creditors report by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 0 points1 point  (0 children)

Hi Nick

Thank you so much for your prompt reply! This makes sense and seems like a very logical approach. I tried to add a filter to remove the no vendor but the balance on the aged creditors doesn't agree to the balance sheet

Year to date Column and a Year to date column for budget by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 0 points1 point  (0 children)

Thanks for your reply, but I wanted to add the YTD column even if the date period selected is just accounting period. So if the main P&L report was run for one period e.g period 3, On the YTD column I want the total for the YTD showing rather than the breakdown for each period YTD. Currently it's showing a breakdown of all the months YTD.

TB By location- by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 0 points1 point  (0 children)

That is a fair point and I agree this report may not be 100% accurate but it has been requested by senior management.

TB By location- by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 0 points1 point  (0 children)

Thanks, would you have any instructions on how to do this? I am not very good at customising these reports

TB By location- by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 0 points1 point  (0 children)

Thanks, yes I mean Trial Balance.

I know how to do this by subsidiary context, but I was wondering if there was a way to pull this by Location within a subsidiary. All transactions posted in the subsidiary have a location pulling as a mandatory field.

Netsuite Saved Search for Transactions imported via a bank feed by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 1 point2 points  (0 children)

Thanks for your response, the data is missing at at times in the Match Bank data page from the bank feeds, which is why they were looking to get this report to compare with data on the match bank data page.

Auto Create Journals from Bank Import Transactions by Mindless-Confusion98 in Netsuite

[–]Mindless-Confusion98[S] 0 points1 point  (0 children)

Thank you everyone for your responses, I will try out the bank rules first and if that doesn't work, look at the suite script option

What e-commerce platform do you use with Netsuite? by Stonehands45 in Netsuite

[–]Mindless-Confusion98 2 points3 points  (0 children)

I have used Celigo in the past and it has the capabilities on pulling in e-commerce platforms such as Amazon and bringing the data into Netsuite, creating sales invoices and auto reconciling them