....but those invoices show the $18 amount. if it was just issue number 1 we could make 1 big credit memo to apply towards their account to make up the consolidated price difference. but now idk

Someone’s in trouble lol

idk how the negotiations went down originally. i walked into this mess haha ¯\_(ツ)_/¯

my accountant is PISSED. and she also told me not to edit anything for now

Yeah you don’t really want to touch historical sales

hi all - anyone integrated with Magento, how do you handle variances in taxes calculated in Magento from what NetSuite calculates upon import of the SO?

@pinny frieder You can add to your SOP to print the check image browser tab to a pdf file and save that file somewhere secure. Integrity of file matching netSuite transaction records is subject to there being no check printing issues (e.g. printer skips a page, etc.) of course.

For pipeline reports - which currency exchange rate is used?

Anyone here create a margin report that can be use per product or multiple products?

Or an accurate margin report within NetSuite?

Use the item profitability report. That's the out of the box report. Under Reports > Items/Inventory. However, there are a few limitations, for kits you cannot pull up the margin

Is it possible to change the account of a kit item moving forward? I'm getting this message "The G/L impact of a transaction in a closed period cannot be changed" but I don't wish to change the account of the transactions in a closed period.

@Grant in the past you needed to contact NetSuite support and they could do it for you

@Grant @al3xicon, way back when I was working in NetSuite, I was assigned to manage those requests from clients. Here's what they would ask:

a. The person requesting should be an authorized contact in NS, preferrably Admin role.

b. They will ask you the specific items you need to change the GL account preferably include the internal ids of these items.

c. The old and new GL account that you need the change. preferably include the internal ids of this account as well.

Anyone know if its possible to add a Net Profit % calculation to the totals in P&L reporting?

like an EBITDA right? there's an article on it in suiteanswers

if not that, then it should at least get you close @mark_maccentre

@mark_maccentre if you are customizing the standard P&L,

Customize the report and under Edit Columns section, click the Amount column and below it look for the Add % of Income Column. Enable that checkbox field

@Jacob uploaded a file:

has anyone used the budgeting function in netsuite? Looking for opinions on it vs other budgeting tools

set the channel topic: Hi Guys, I am currently looking to speak with NetSuite Consultants (Preferably with an accounting background) to work on a remote basis for a Chicago based NetSuite Partner I am closely working. Please feel free to reach out if interested! Thank you!

cleared channel topic

Free lance people sometimes hang out in #jobs if you're looking for someone. If you're looking for consultancy companies, you can ask in #general for advice on who to contact

An invoice has 100% discount thus total amount is 0. The gl impact doesn't show the accounts receivable entry. Is this correct?

Is it possible to export a single journal entry as excel or csv?