39
Points
Questions
0
Answers
5
-
Neither of those 2 (Override Accounting Permission and Allow Non-GL posting) will let you accomplish what you need to.
Voiding a check has direct G/L impact and as long as the period is closed, you cannot accomplish this.
Below are instructions from Curious Rubik (echoed by NetSuite Developer Notes)
A payment recorded in a closed period cannot be directly voided without reopening the period.
However, a reversing journal entry can be created to apply against the payment transaction to essentially cancel the payment. This can be done by taking the steps listed below:
Allow Non-GL changes:
- Navigate to Setup > Accounting > Manage Accounting Periods.
- Click on the period in which the payment was recorded (i.e. Jan 2013) in order to edit the base period.
- Ensure Allow Non-G/L Changes is checked as true.
- Click Save.
Unlink existing payment record from invoice:
- Navigate to the payment record that you would like to void.
- Click Edit.
- Uncheck any invoices that the payment has been applied to. Note: the status of these invoices may change.
- Save the payment record.
- Click OK when prompted to save an unapplied payment for the customer.
- Hover over Actions and click GL Impact. Please take note of the GL Impact as the reversing journal entry will reverse the accounts affected here.
Create Reversing Journal Entry:
- Navigate to Transactions > Financial > Make Journal Entries.
- Enter reversing journal entry (reversing entry to the GL impact of the payment above). For example, debit Accounts Receivable and credit Checking.
- Ensure that the correct customer is selected under the Name column.
- Enter desired memo for tracking purposes and click Save.
Applying Payment to Reversing Journal Entry:
- Navigate to the payment record once again (Transactions > Customer > Accept Customer Payments > List).
- Click Edit.
- Look for the reversing journal entry in the list of invoices.
- Click the Apply checkbox next to the journal entry.
- Enter desired memo and click Save.
The payment should now be applied to the reversing journal entry. Navigate back to Setup > Accounting > Manage Accounting Periods and uncheck Allow Non-G/L Changes in the corresponding accounting period. After taking the above-mentioned steps, users may now continue to create a chargeback for the customer.
- 1451 views
- 1 answers
- 0 votes
-
You can accomplish this on the user role.
- 870 views
- 1 answers
- 0 votes
-
Check out Enhancement 417499. Might be related.
- 865 views
- 3 answers
- 0 votes
-
This is possible using a formula field:
1. Customize Report
2. Navigate to Edit Columns tab
3. Click Add Formula Field
4. Give a name under Column Label
5. Check Add Grand Total box
6. Select Ratio x/y from Formula Type
7. Select Qty from x
8. Select Qty from y
9. Uncheck Apply Formula to Grand Total box
*Logic: You are trying to make your calculation equal 1 per line so that the sum equals the count of lines in the report. If your selection for x and y are the same, this will work*
- 3637 views
- 2 answers
- 0 votes
-
I know that this has been answered, but there is another way to view this information that is more legible in my opinion.
Using “&xml=T” gives you everything in terms of tags and can be a little difficult to read for some.
There is a chrome extension called: Netsuite Field Explorer. This does the exact same thing as “&xml=T” but is more legible.
Simply click the extension and a page will open listing all field internal ids and the current value of each field.
- 3763 views
- 5 answers
- 1 votes