For the same problem, if I want to automate this process with web services, can anyone put me in the right direction? Like to be able to run a program to extract the set of GL balances from the operational account/instance and import it into the reporting account/instance on a per period basis, but without overwriting GL…

Sorry, I don't really understand some of your replies but I am really glad of the support you guys have shown. Let me try again. Like to have 2 sets of books. One set for daily operations; and another set is for reporting. So at end of each period, like to copy all the GL balances from the daily sets of books (instance) to…

Thank you Evan. A new discovery of the transaction search. Its sometime I must explore further...

The fixes for both Expense and Purchase Limit have been applied and it works. I think the problem is Netsuite has not thoroughly tested the application. This sort of problem should not appears. Nonetheless, thanks Netsuite for fixing them so quickly.

Yes, this problem extends to the Purchase Limit as well. If an amount is specified in the field, no PR from the employee can be submitted until the field is cleared.

In fact, the solution is to customise an accounting role such as A/P Clerk or Accountant, or some similar role to include Expense Report - Full access level at Permissions > Transactions. This was not documented in the Help database. At least I cannot find it. Maybe to include this info in the next update?

I just found out that this is a known bug, which will be fixed with a patch to release on Aug 28, 2007. Will see if the fix works...