aghahari's Profile



  • Rookie Asked on September 16, 2020 in Accounting.

    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:

    1. Navigate to Setup > Accounting > Manage Accounting Periods.
    2. Click on the period in which the payment was recorded (i.e. Jan 2013) in order to edit the base period.
    3. Ensure Allow Non-G/L Changes is checked as true.
    4. Click Save.

    Unlink existing payment record from invoice:

    1. Navigate to the payment record that you would like to void.
    2. Click Edit.
    3. Uncheck any invoices that the payment has been applied to. Note: the status of these invoices may change.
    4. Save the payment record.
    5. Click OK when prompted to save an unapplied payment for the customer.
    6. 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:

    1. Navigate to Transactions > Financial Make Journal Entries.
    2. Enter reversing journal entry (reversing entry to the GL impact of the payment above). For example, debit Accounts Receivable and credit Checking.
    3. Ensure that the correct customer is selected under the Name column.
    4. Enter desired memo for tracking purposes and click Save.

    Applying Payment to Reversing Journal Entry:

    1. Navigate to the payment record once again (Transactions > Customer > Accept Customer Payments List).
    2. Click Edit.
    3. Look for the reversing journal entry in the list of invoices.
    4. Click the Apply checkbox next to the journal entry.
    5. 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.

    • 1 answers
    • 0 votes
    • 1 answers
    • 0 votes
    • 3 answers
    • 0 votes
  • Rookie Asked on February 10, 2020 in Reports.

    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 and y are the same, this will work*

    • 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.

    • 5 answers
    • 1 votes