PyanGo is an add on to NetSuite that allows us to map the balance sheet impact of our expense and revenue transactions to specific Designations, Program Areas, Departments, and Awards.  By default, NetSuite only allows one set of coding on the balance sheet side of transactions:

For example, on an Invoice, Accounts Payable could only be linked to the coding found on the header; however, we often have many lines of coding on an invoices, that could be linked to multiple segments. One invoice may be split amongst different Program Areas of a Project, or across several different awards. The standard functionality did not allow us to see the balance sheet impact of these splits.

What PyanGo does, is to reverse the Header level balance sheet impact (entered as all BLANK segments) and create lines for the balance sheet account that copy the amounts/coding from the line level details. One thing to note is that PyanGo cannot code directly to standard GL Accounts, instead it uses three specific accounts created only for this purpose:

• Due to / from Accounts Payable
• Due to / from Accounts Receivable
• Due to / from Cash

PyanGo is a script that runs automatically on the following transaction types:

• Expense:
  • Invoice
  • Invoice Payment
  • Journal Entry
• Revenue:
  • Sales Invoice
  • Customer Payment
  • Enter Revenues
  • Bank Deposit

To view the impact of the PyanGo script, when you are on a transaction type listed above, click “Actions > GL Impact” to see the lines created as a result of the script.