[mmelanson99]

I am trying to import some AP data and there are a couple required fields for custom fields blocking my data entry.

I think they are from a previous consultant for some script…. I have tried disabling the script, searching the customization and the forms, but it is still asking me for these fields….

I know there are 5 different ways to do the same thing in NetSuite… can some you throw out ideas where I should look to disable these mandatory fields so I can import a National Grid bill.

thanks
This is a cached copy. Click here to see the original post.

[smyre@sog.unc.edu]

Michael,

If the fields are not custom, you should have found the mandatory setting on the form. Open a sample bill (do you mean an invoice?) & click edit. That should show you what form you use for invoices; you may use different forms, so make sure you figure out which one or make the changes for all invoice forms. Go to Setup > Customization > Transaction Forms & edit the form. If you were using a standard form, you'll only be able to "Customize" it. Do that & create a new custom form for your company (and make sure to use it for this transaction). You can only make changes to custom forms. Go to the "Screen Fields" tab & look through the subtabs until you find your field. Uncheck the mandatory box. If you cannot uncheck it, NS requires it.

If this is a custom field, there is another place to look. Setup > Customization > Transaction Body/Column/Item Fields. Find the field, and click on it to edit. Go to the "Validation & Defaulting" tab & uncheck "Mandatory" there.

I hope this helps.

Bonnie

[mmelanson99]

Bonnie,

Thanks for your reply… very helpful. I know that others who follow will find it very useful.

After taking a night off I found my problem. I thought it was script on the PO form. As it turns out it we have Landed cost enabled. I am trying upload Vendor Bills but is requiring me to add Cost Allocation Method and an item…. I guess as part of the Landed cost.

I am trying to import Vendors Bills related to AP… like National Grid…. they don't have landed cost. I guess because Landed Cost is enabled, it is required in the upload?

Anyone chime in on this one please… thanks…

[mmelanson99]

Mystery solved…

There is a way around this. You have to upload in multiple files

https://usergroup.netsuite.com/users…ad.php?t=22103

I will summarize someone else's pain here.

When creating the upload files, don't use the heading AMOUNT, if you do it pulls in the item from for the item amount and the import fails. Use the word TOTAL instead.

You need to create two files, one for bills and one for expense line and import them.

Just tested one and it worked.

1) Bills

External ID (match to line)

Date

Memo

Reference No.

Vendor Internal ID

Posting Period

Terms

Due Date

2) Expense Line

External ID (match to body)

Reference No.

Account

Total (not named "Amount" )

Memo

[Author]

Posts