Hi sarah,

you should be able to loop through bill of Materials line using the Line Group – billofmaterials

once you have got the count of Line Item (‘billofmaterials), you can loop through the lines and get the field values.

these are the set of fields we have in our instance.

• billofmaterials“
• “canbedefaultforlocation“
• “canbemaster“
• “currentrevision“
• “defaultforlocation“
• “inactive“
• “masterdefault“
• “memo“

hope this helps.

thanks

Hi Basem,

There is an Employee field on Purchase order that you can set up at the time of PO creation using Workflow / Script and then use the same field to Print the Created by on the Purchase Order PDF.

Alternatively, you can create Custom List field with Employess and then perform above mentioned action.

Thanks

Did you look at achieving this with Workflow, may only take 30 mins or so to test and create it.

Hi Simmons,

I don’t think Statement PDF exposes the line item details on the Advanced PDF, instead you can create an Custom search that will be able to include the Line Level Data.

thanks

Hi @UCN,

From what I see you are looking to achieve, I dont think you will have to create a Saved Search for it

all you will have to do is following

Create custom field ; 

Type: List

List / Record : Item

Under the Sourcing & Filtering tab: Insert the criteria you used in your saved search.

This should achive the desired result.

Thanks you for the same.

I will update my knowledgebase with this.

Answer ID: 51417 has all the answer required for Adjustment import.

@bitpushr : From my experience, I dont think you can’t create Adjustment using CSV import from Scratch, but once you create it in Netsuite with single line only. You can use the csv import to import rest of the lines for the same adjustment.

Hope this helps.

You can use Maximum for the Location Available as well, instead of Sum and this should fix the ambiguity.

Hey,

For any Inventory Adjustment Record Import, you first need to create a Inventory Adjustment record in Netsuite UI and then use the Internal ID of Inventory Adjustment in your CSV import.

Following columns in CSV would do the worder.

1. Adjustment Internal ID
2. Item
3. Location
4. New Qty to Adjust

5. Unit Cost (Options)

After this, you can tick Update in Step 2 of CSV Import and it will perform the import without any issues.

Let me know if any clarification required.

Thanks

Hi,

I think if the Bill gets fully paid by Vendor Credit on Bill Payment Record, then you would not be able to display the Bill under the Apply line, as it would not remain outstanding after the Credit Application.

Surprisingly enough, I am working on the exact same issue.

Also, trying to work out the logic Netsuite uses in Applying Credits to Outstanding bill on Bill Payment Creation.

Thanks