Q1 2007 = Quarter Jan 2007 = Base Period Q2 2007 = Quarter Apr 2007 = Base Period We have transactions dating back to 2001. We have bad transactions dated in January & April and both of the quarter indicate they are quarters and both month indicate they are Base Period.

I have similar problems. I have fixed several and the cause was a deleted transactions, but I have four I have not be able to fix. All four are the same problem - Zero on hand under the Inventory Tab, but the serial number is showing on the Inventory Detail Tab. Below are the transactions for one of these serial numbers.…

I do not understand why Oracle/NetSuite has not put this at the top of their things to fix. This is definitely a GAAP issue - Revenue ALWAYS must be matched with cost. This has been an enhancement request for 14 years. Oracle/NetSuite, get this fixed, please.

Has this issue ever been resolved by NetSuite - User 3943962 has the exact problem experienced by any company when they invoice drop ship item on a sales order prior to having the vendor's bill to enter at the same time. This is definitely an exception to GAAP rule - When you record Revenue you must enter the cost of the…

Mikko - Bad word in my reply - it should have said we are able to perform..... thanks for your comments on my question. It took some time, but we are not able to perform cost adjustments on an inventory adjustment with positive adjustments and the inventory adjustment was created by Web Services. This has saved us a lot of…

Joy - I will do as you have suggested; however, I do not want to be hard to get along with, but if there is an Enhancement [i.e. # 20211] and no one can find it, then it is impossible for users to vote for it. As a suggestion, users should be able to search by enhancement number [20211 - similar to searching for a…

I have following the instructions to the SuiteIdeas page and in the search box I have typed: 1) Enhancement # 20211 2) 20211 3) Inventory Items > Change costing method on existing items 4) Change costing method on existing items 5) Inventory Items And did not have any luck finding Enhancement #20211, can you tell me what I…

Mikko - thanks for your comments on my question. It took some time, but we are not able to perform cost adjustments on an inventory adjustment with positive adjustments and the inventory adjustment was created by Web Services. This has saved us a lot of time.

Your answer provided good information; however, no one in the company has the skill level to create the script. I am now looking for someone locally to create the script for us.

Am I missing something or does your solution to "Clear" No Customer/Project on A/R Aging Report just hides the problem? Your solution to AP records does fix the record and it is "cleared". NetSuite - we need to be able to fix AR records similar to the fix for AP records.

After working with NetSuite over a year or more, NetSuite finally fixed this issue in my database - Yea!! - no more "No Location" showing in my inventory report.

Can you use a workflow to make the Match Bill To Receipt field checked for existing item? If not, can I use a CSV import?

If you still need the search, below is the Criteria tab I am using. It is not fancy, but, give me the information I need. FILTER DESCRIPTION FORMULA Base Currencyis USA Transaction Currencyis British pound Effective Dateis within 1/1/2016 and 12/31/2019 Below is the Results tab: [sort by Effective Date] Base Currency USA=1…

I am trying to do the same thing, except, I want to change the account number on existing items (non-inventory). Is there anyway without changing the transactions in closed period OR if transactions in closed must be changed, can it be done without opening 10 years of history?

Sheila121212 - When you state, your client wants to "mark down seasonal items", is the client wanting to mark down the inventory value or sales price? If sales price, I like Mavel's answer of using a discount.

I have a couple of non-serialized inventory item with a quantity of one (1) and inventory value; but no location,. As above, they happened in long closed accounting periods. System will not display items if the location field is blank (no-location) when using above instructions. Can I remove the quantity and value for…

We have done some additional testing on the above and have come to the conclusion the above Answer ID does not work and it can not be fixed without the involvement of a NS engineer who has access to the actual database records (2) that are causing these "No Location" problems. This is assuming they can add info to a blank…

JM Underwood - Thanks from me also. This is a very old post but it was very useful for us new members.

I am not familiar with the total serial number/lot number processing; however, can you use a lot number for each receipt, with the serial number being captured in a custom field, if the system will not handle both on an item, and ship by lot number with the smallest lot shipping first.

I have a Currency Rate search which provides the info you are requesting [date of each rate change and the rate]: Filters: Base Currency [i.e. USD] - Transaction Currency [i.e.BP] - Effective Date [i.e. 01/01/2017 - 12/31/2018]

I don't have a good solution, but I do the following: I run a register on the Inventory Received Not Billed account from day one to present, export to Excel and create a pivot table to get the total by vendor which does balance to the Bill Purchase Orders screen after adjusting for drop shipments & non-inventory which do…

I attempted the payout; but, the balance was not available to payout. I will look at that option again, I could have overlooked something. I will attempt the write-off journal option; however, again these items do not seem to be available; however, it never hurts to look at your options more than once to make sure you have…

I am attaching some documents and will give more detail. For both, AR & AP, when I run the standard Aging report the detail transactions do not agree with the general ledger control account. I researched the different and discovered the problem dated back to 2004. I will use AR in my explanation; however, I went through…

The period was not closed when the omission was discovered; but, the system will not let us edit the Journal. The system tells us you can not edit journal since payments have been applied. I attempted to delete the journal and un-apply the items that had been applied with no luck. I guess we will have to wait for NetSuite…

How do you correct? To write off a credit memo in NetSuite, here's how to do it: 1.Create a Journal Entry in Transactions>Financials>Make Journal Entries 2.Debit AR for the same amount of the credit memo and put the customer name. Make sure that it is the same AR account used in the Credit Memo to be written off. 3.Credit…

Thanks for the information - Not very well knowledgeable about CSV imports but will give it a try.

Refer SuiteAnswer ID 7702 - Merging accounts of different types is not possible and changing account types after transactions are posted is not allowed. Looks like you are stuck with the long way.

Thanks Olivier - I will see if I can get the desire results with your suggestions. Also, I let you know if Finance Charges triggers scripting now.

I am assuming the refund is for a customer which has an overpayment on their account/statement. You can make a journal entry (debit AR - must entry customer name on the line) and credit the bank account. NOTE - do not forget to put a customer name on the AR line AND I would recommend one AR customer/line per journal since…

I would charge the expense to Consulting Expense when the hours are used. As an example, if you purchased 50 hours and the implementation partner preformed 25 hours of work in month 1, I would expense 50% of the cost in month 1.