is there a way to consolidate multiple sales orders into one invoice?

@k1ko Not natively, but NetSuite do sell a SuiteSolutions bundle which will do this called Consolidated Invoicing SuiteSolution (https://netsuite.custhelp.com/app/answers/detail/a_id/49491/kw/consolidated%20invoice) Simple consolidated invoices with increased accuracy for accounts receivable and accounts payable Reduce time, costs and paperwork for your invoice consolidation process Control and traceability of invoice consolidation process

thanks mark - just need to contact account manager to get that installed then?

Yup, but it’s a chargeable bundle - from memory it’s a one-off payment.

Hi all, some of our transactions in a closed period got updated recently which resulted in some GL impact and it's messing up the financial reports. Is there any way we can reverse these impacts quickly?

journal entries possibly

I'm no accounting wizard but i believe thats what i've seen done in the past.. don't take my word as gospel

#safeharbor

@neerajrtiwari need to do corrective reversal journal entries

Thanks @creece and @Sam-I-Am - I figured out an easier way. The Item Fulfillment records that were updated recently from Picked to Shipped converted the "Posting" from N to Y for these records - thereby changing the GL impact in the reports. I just had to revert the IF record back to Picked so that it becomes non-posting - for the affected records. Luckily, there were not a lot!

Has anyone run into this issue in 17.1 when closing periods?

A file, which can't be shown because your team is past the free storage limit, was commented on.

For some reason the close says it's done but it's stalled out

so we cna't turn on G/L changes

er, non-G/L impact changes

On the Comparative Income Statement, we'd like to compare two equal periods. Right now, the left shows the period that we select, but the right shows data from a full year.

We found how to change that period in the Customize options under Columns, clicking on the Comparative Amount column, then changing the Alternate Period Range, but we'd like to have that option as a filter on the main report.

Hi all, I am trying to understand the balance sheet detail for Retained Earnings. I am not sure how the Amount column (the second last column just before Balance column) is changing for the current posting period - May 2017. Does anyone know which type of transaction records cause this column to change for Retained Earnings row?

Just to give a context - the Amount column for Retained Earnings has always been zero but for May, we suddenly have numbers changing for it on almost daily basis - which it shouldn't be doing.

@neerajrtiwari I thought last year earnings becomes this year retained..

do you have multi-currency? are you looking at consolidated?

@jays I figured that there were couple of Inventory Adjustment records that increased the Amount for our Retained Earnings

We are trying to figure out a way to limit the type of accounts visible to different people in the Adjustment Account

was it you that mentioned that you were able to approve inventory adjustment and it hit a closed period? that seems to be a bug in the system.. if that is the case we have a bigger issue.. as once the period is closed we should not be able to impact it...

it should go to the next open period or the current period based on the settings

Actually, the issue is happening for current open period (May 2017)

The other issue I found was we are not closing the periods all the way. Like the periods are just locked..but the prerequisites are remaining for the close checklist for some of the accounting periods. I am working with support to find out the clean way to close the accounting periods.

Since the accounting periods are just locked, admins can actually can edit the transactions in the old locked, posting periods. If the accounting period is properly closed by following NetSuite's checklist then even admins can't edit the transaction records directly. They have to first reopen the transaction and then edit. I think only admins can reopen transaction records but I need to verify this.

HI Everyone, I dont have an accounting background and need some fellow accounting minded folks to help out. Our Income Accounts are set to use "General Rate Type" to "Current". Our Expense accounts are set to use "Average" and our Equity accounts are set to use "Historical". Few questions... is this the proper way? How do others have it set up?

Equity is usually set to 'Historical',.Then generally Balance sheet accounts are set to current rate and Income Statement would be average. I believe this is how NetSuite defaults the rates when you set up a new account. I would confirm with your Finance team though (in theory they should know!)