3943906 Green Ribbon

Posting period will default from the date but can be changeable. For me this is key to having the posting period functionality because it enables you to put a June invoice into the July period if you receive it after you have closed June books for example. If the posting period was always in agreement with the date, then…

Agree with Robert's suggestions. Also this is very bad functionality by NetSuite. I have never come across a system that would change the historic postings in this way before. I am very surprised they get the accreditations they have for accounting with poorly thought out areas like this.

The issue with allowing employees to enter A/P Bills is not really a NetSuite one, but a fraud prevention one. If the same person enters the order, approves it, receipts it and then puts the bill on the potential for fraud increases. Ordinarily you would try (as much as is possible within the constraints of employee…

Nick If you put that name on a journal, does it appear in the customers ledger when you look at the customer record, or only on an A/R A/P report? This could be useful for us. Cheers, Damon

Hi Stephanie You can put a journal on to clear it and the balance will sort of clear down. However, you will always end up with a section on the A/R and A/P for "No Supplier" or whatever. Also the timings will be different so you will have to wait 4 months or whatever for all the balance to clear down on the aging. When I…

Tick that box include term discount for tax and you should be ok.

We run a saved search from the POs which calculates the unbilled values. It never agrees because NetSuite does not automatically journal off the difference between a receipt and an invoice (standard functionality on most financial systems). We reconcile monthly because to leave it would be too big a job for us. However if…

Thanks we are now looking at setting up some memorised transactions that will help. We have considered giving customers access, but the general feeling is the impact / take up will be low. Our customers are retail outlets some pretty small and owner managed. We just dont see them logging in and placing the order as it is…

I think you can fix this by customising the report. Ours shows charge, payment, balance.

We track our collections process by a custom field on the customer account called 'Credit Stage'. We have also created custom reports which come off the schedule each week and tell us which accounts are so many days past due and therefore need action / taking to the next stage. It works ok. I agree with the former post in…

Evan That would be quite useful for me too. Can you explain how / where we would set that bit of script up? Thanks, Damon

Hi Evan I would love to know how you got this working originally. We have tried and never managed it. It would be useful for us. Cheers, Damon

I don't think you can. In our experience use sub-customers only if they are viewed as one from an accounts perspective. Therefore we have some groups of customers that are configured with sub-customers (central remittance from head office) and come groups that are not set up that way (individual remittance from each…

If you use Kits or Groups to combine items and sell as a package then you can set it to print the individual items or not.

You cant operate a shared warehouse in OneWorld that allows access to the inventory across subsidiaries. I assume this is because you need to maintain financial integrity and sell the items from Subsidiary to Subsidiary. It is also difficult to use the same item across subsidiaries even when using differing locations.…

Yes the system adds up the average cost of all the items drawn to make the assembly. I cant see why there wouldnt be an average cost for a member item, unless you dont have any in inventory and are allowing it to go negative. We have written a report using Bluebridge One's pivot report suite extender which gives us the…

I agree with Olivier, it has always done it this way and I know not of a work around. It is a flaw which would surely be easy for NetSuite to fix and they should. I do not know of any other accounts package that works this way.

Not certain how we did it (left it to our IT guys) but we definitely customised the layout and now print cheques. Suggest you push NetSuite to explain how its done.

You dont need to use an inventory item for the labour. I think to do this would be confusing. We set up a Service Item for our different types of labour. We coded these to an expense account in the GL for Labour Recovery and put in the purchase price as the hourly / per min rate. We were then able to add the service item…

We had to use Inventory Item for Labor in order to put labor on the BOM for Assembly Item. This is needed to include labor cost in each specific Assembly Build. It works well for us. This is what we did originally too but found it worked equally well with service items and this meant that we did not have strange labour…

Well, maybe we should take this discussion to another thread. You may be right Olivier, but we made the decision to go with Inventory Items to model labor about 2 years ago. This was after much research, discussion here in the UG, and testing. One of the reasons was to be able to reconcile with actual payroll records on…

Inventory aging report is not a standard report in any system I have seen. I guess it has its uses if you are dealing in perishable goods, but not every sector would use this. I guess you would have to switch on the serial number sequencing and runt it from that some way so that it knows exactly which item is moving in and…

I think accounting periods would help. Could you not just set up one large period for each year. Unless you have this I dont think NetSuite really ever closes the period. That said I am surprised it is AR and Sales that keep changing. I dont see how refunding a credit note would affect it unless you refund at a different…

The wizard of Oz is correct from my knowledge. It is still rubbish though, because your sales analysis and everything will still be out. Why call it a Credit Memo, if Memo it is not?

Hi Esmerelda We experience similar issues. The fact is that standard NetSuite is not properly dual currency compliant. We are not even able to run an Income Statement or Balance Sheet in a currency other than base. When I have enquired about enhancements in this area, the answer I have always been given is that OneWorld is…

We also run into this issue. There are some instances where if you have moved sub custoemrs b/w parents and there was ever transaciton against that sub (when payment via top level is enabled), it makes a mess. Yes second that. Once a customer is a sub-customer, dont ever change it.

Hello All, We currently have a handful of inventory items that have a purchase price listed and a QTY associated with them yet it is not calculating the value of the inventory. This is not happening with all our items (only about 5%) so I do not think is a general setting problem. Also note these items are subitems. In the…

"tie out" means run an ar aging that matches what the gl says. AR Aging says $870k GL says $873. Would like to see these numbers match. In my experience the first think to check is dates / periods. Make sure that you are running consistently for both.

Do you mean by using Assemblies, I will not be able to receive the goods as and when they arrive? like what I am doing now with the kit? You can purchase and receive assemblies as well as the sub-components.

We have never come across NetSuite enforcing this.