Netsuite Invoice Balance

  • 259Views
  • Last Post 25 October 2022
  • Topic Is Solved
0
votes
Finance Department posted this 20 October 2022

Hi there,

We are using two daily automated exports to take data from our Netsuite account into a private Onedrive, to update an excel spreadsheet report.

This report shows us debtors and invoice details. However, for some reason Skyvia wont pull over Amount Paid, or Amount Remaining. No other value fields apart from "Amount" work. Whilst this is ok, if a client partially pays a large invoice, the report will still show the full amount (example: 10k invoice, client pays 5k meaning 5k left, however Skyvia amount will still be 10k as AmountDue or AmountRemaining wont show).

Is this a bug or limitation of Skyvia?

netsuite excel bug value amount
Order By: Standard | Newest | Votes
0
votes
Support Skyvia posted this 22 October 2022

Hi,  

Thank you for contacting Skyvia Support.  

 

Please be informed that we are processing your request and will get back to you soon.  

 

Sorry for the inconvenience. 

 

Best regards,

Serhii

Technical Support Engineer 

0
votes
Support Skyvia posted this 24 October 2022

Hi Ian,

Thank you for contacting Skyvia Support.  

After a closer look at your package, we see that Amount Paid and Amount Remaining columns are not selected. Those columns are supported and must show the correct data.

Please, send us more details where you don't see AmountDue or AmountRemaining and only see the full Amount.  We also recommend clearing your metadata cache in your NetSuite connection.

Looking forward to hearing back from you.  

 

Best regards,

Serhii

Technical Support Engineer

 

0
votes
Finance Department posted this 24 October 2022

Hi Serhii,

I've tried clearing metadata and re-adding the amountPaid and amountRemaining options back in but i still get the following:

As you can see in the first row, the invoice amount is 363, however the amount remaining and amount paid columns still show blank. This is the same for all invoices.

1
votes
Support Skyvia posted this 25 October 2022

Hi,

Thank you for your response.

 

Some NetSuite form fields are not returned in API responses without adjusting settings manually in the NetSuite user interface.

For instance, the amountRemaining and amountPaid fields are listed in NetSuite's definition of their invoice object, but are not returned unless enabled in the UI. Here are the steps to enable the amountRemaining and amountPaid fields for invoices:

1. Navigate to an existing invoice.

2. Hover over Customize in the top-right corner, and then click Customize Form.

3. Click the Screen Fields tab.

4. For both the Amount Paid and Amount Remaining table entries, click the checkbox in the Show column.

5. Click "Save"

6. Export your data again

Let us know the result.

 

Best regards,

Serhii

Technical Support Engineer

  • Supported by
  • Finance Department
New Ticket
Categories
Popular Tags
Close