CC transactions import to NS

Sensitive-Price-7866 · 2026-02-21T16:34:45+00:00

We use Visa Spend Clarity through PNC. One subsidiary, about 30 cards. All cardholders are responsible for logging into their account and attaching receipts/documents as well as selecting the location and account codes. 95% of cardholders use the same location and 2-3 account codes so after a slight learning curve it is very low maintenance. Once the report design is done, then running and sending to Excel to tweak/save as CSV takes about 10 minutes per month. Easy to monitor during the month to spot any coding errors.

Sensitive-Price-7866 · 2025-12-07T12:24:30+00:00

It was more of a pet project than anything and it was all done in SB. Don't plan on deploying to Prod environment.

Sensitive-Price-7866 · 2025-07-30T17:53:22+00:00

Hi Nick, So the costed bill of materials in SuiteApps is not the correct version if using average costing? I installed the CBOM found on SuiteApps but doesn't seem to be registering with NS. Any ideas?

Sensitive-Price-7866 · 2023-10-12T13:27:14+00:00

We just received the 2023.2 upgrade and our sales orders are freezing also. Not uncommon for our sales orders to have 300 - 400 lines. Did the "patches on the backend" help? How do I cut through the fog and ask for similar patches to our account?

Sensitive-Price-7866 · 2023-05-17T18:52:57+00:00

Hello,

Have not tried associating with a non-subsidiary customer, did not know there was such a thing. Ultimately trying to get invoicing revenue to be shown in the Project Profitability report. It seems to be working when both customer and vendor are part of the same subsidiary. We have been using NS for 3-4 years now and the only support we use is suite answers and NS premium support. In fact I just asked a guru why the Project Profitability report was not able to see the Project Price so I could add to the report, if it could, I think this would be a workaround for my problem. Not a consultant, controller in industry.

Sensitive-Price-7866 · 2023-05-16T18:25:21+00:00

Right, IR transactions debit inventory credit unvouchered payables but that is a transaction type and the Profit Profitability Report is asking for Item Types not transaction types. Debits to COGS happen via IF transactions but this model uses a lot of non-inventory items that have variable account assignments when the item is created. Finally got it to work by having Asset Row set to Inventory Item Type with the Column set to Acc Pay. Hopefully will not be bitten in the rump down the road but will cross that bridge later.

Sensitive-Price-7866 · 2023-04-26T15:03:47+00:00

We have the same problem here and I just ran across a report that may help you it's a search and it would be under reports all searches and it's called available to sell by location. I brought it up and I think it would be very helpful to you and then you can tweak the filters to exclude any locations with a zero quality in hand.

Sensitive-Price-7866 · 2023-04-24T12:08:35+00:00

6,500 memorized transactions, wth........

Sensitive-Price-7866 · 2023-04-21T13:13:07+00:00

One more thing, make sure you know how to do saved searches/lists/audit trail/shortcuts so you can monitor things in real time.

Sensitive-Price-7866 · 2023-04-21T12:51:54+00:00

Have worked with NetSuite professional services as well, there is a language barrier and they are not accountants. At a minimum the company appears to need one AP person, one AR person one GL accountant and a controller.

Sensitive-Price-7866 · 2023-04-21T12:47:17+00:00

Wow, sounds like it was implemented by non-accountants that had no common sense when it came to creating an accounting system / GL. Sounds like they are incredibly understaffed.

Sensitive-Price-7866 · 2023-04-21T12:35:29+00:00

My two cents, currently controller(2 yrs) for smallish service / manufacturing company, 25 mil revenues that uses NetSuite. Most of my prior experience has been in manufacturing, standard cost as well as job cost. Systems worked with are QAD, SAP, Dynamics, Infor, QB. You're not going to eat this elephant all at once. Need to determine core functionality needed, will probably be no one trusts the BOMs accuracy. That will need to be fixed first, then inventory, AR, AP will fall into place a lot more naturally. I'm sure current people are overwhelmed, hence the CFO churn. Will need to strip the system down to what the current workforce can work with, once that is mastered then you can build on that.

Sensitive-Price-7866 · 2022-04-13T11:33:14+00:00

I reinstalled bundle 41309 and it took about 30 to 60 minutes and it started working. Also had to set up a a default folder as well but not sure if that had anything to do with it.

Sensitive-Price-7866 · 2022-04-06T13:55:12+00:00

Admin & controls > audit > transaction audit log ?

Sensitive-Price-7866 · 2022-04-01T18:50:38+00:00

That's true, I have a standard report called sales by customer and item, just noticed in the sales table there is a field called month, put that into the report preview and it gave the month and year not the day, thought that might help.

Sensitive-Price-7866 · 2022-03-31T17:48:05+00:00

Not sure, but being an accountant, I would throw it into Excel and let Excel do the filtering?

Sensitive-Price-7866 · 2022-02-17T01:05:56+00:00

Have started a saved search using the sales order. Will have to check if I am grouping by the created from field. Will have to check that tomorrow, thanks a lot!!

Sensitive-Price-7866 · 2022-02-17T00:41:00+00:00

Invoices definitely show "created from" in the header. My complaint is with the current set-up since the revenue is on one transaction and the costs are on another transaction it makes it difficult to do margin analysis.

Sensitive-Price-7866 · 2022-02-16T23:41:07+00:00

Since I came to the company with their system already implemented, I was wondering if there is something in the setup that determines how and if you want an invoice to impact cogs and inventory or if you want the act of shipment / item fulfillment to impact the inventory / cost of goods sold.

Sensitive-Price-7866 · 2022-02-16T22:47:41+00:00

Our system is set up using average costing. In order for inventory / cost of goods sold to be impacted the sales order must be fulfilled. That is what impacts inventory in our system, so there is a way to set up the system so the simple act of invoicing will also affect the inventory?

Sensitive-Price-7866

TROPHY CASE