Hey Ivy, Thanks for the quick response. Actually, it appears our netsuite is set to run it's inventory costing on a schedule after 6pm and before 6am. So i merely had to wait until the next day. All items are showing appropriately now!

Hey Micah, i've experimented with a few overhead accounts. i'm waiting to hear back from our netscore/shopify integration to ensure that merging income accounts tied to those sales won't create an issue, then will attempt to utilize this answer for the whole thing. BUT i think it's going to work!

Thank you! I removed the Document Number result as that listed each Item Name multiple times instead of summarizing them. Gave me the PERFECT report so we know what the produce. Can't thank you enough!!!!

Is it possible to group these by item name rather than sales order? It's not a problem, per se, to export to excel, then SUMIF by the item name, but it would be great if the report was done by that. I don't necessarily need to see which SO they belong to, just the total QTY of any items that are on sales orders pending…

Well that was embarrassingly easy. You rock!

That worked! now i see the total amount. Is there a way to see quantity of each per sales order?

Thanks for the quick response. I get "no results" with this search. Screenshots are below of each of the things you requested.

You're awesome. i'm so used to customize being in the top right corner i completely missed it here.

Interestingly, i see the total on the item fulfillment screen. However, when i print it it is blank!

Actually - i just follow the full directions and the "Total" field is still coming up empty for some reason even after marking them as picked. Does the order have to be marked as packed and shipped?

I think the Total Value is the one i'd like to fulfill, but i'm guessing you have to actually "fulfill" the order prior to printing the picking ticket as it has to commit the items as picked first?

Either of those would be sufficient - the goal is to understand the value of the picked items that would be included for shipping so we could declare value!

Well, i actually don't have the advanced PDF packing slips enabled. However, i was able to create custom transaction body fields to populate the data. However, i can't replicate it with either the individual line item rates or the total value of the picking slip (so our warehouse knows how much to declare shipping value…

Thanks @"Pauline Joy Cac-Oracle", I went in and updated my display name so that it would show, but it doesn't appear to be taking on this side of things.

Unfortunately if you try to go in and do them individually, Netsuite also tries to use the current deposits that need to go in and basically "resets" it so you have to do the whole thing manually if you have additional deposits since that time period. I did find a workable solution for our purposes - i just totaled the…

Thanks for the response Shamaine! I'm going to get together a screen recording of how we do the deposits - but we basically have to match them up to the export file we receive from Shopify based on cash sales. The Department is the standard Department field located under "Classification" so that the entire Deposit slip…

How do you setup the financial statement to show those segments? We actually created sub accounts for each of those and that's where i've been reclassifying. I had to go back and reclassify our sales orders and invoices to have the department set as "wholesale", but realized it doesn't update the item fulfillment. I can't…

@"JCirocco" thanks for that insight, i see what you're referring to now. i've got a lot of work to put everything back into the right classifications. It basically shows the lines left and right, instead of below each sub account. I'm not familiar with workflows at all - we are a small business and honestly some of the…

@"JCirocco" this sounds like what i was looking for! How do i connect a specific account with a department? We do currently have our sales orders classified with the department "wholesale"

Hey Shamaine, Not sure why we would want to create a second item. Managing inventory would become a nightmare as the items are the same sku. I don't see that solution as feasible. For question two - we have to do that reconciliation mentioned above at end of the month based on the A/R register. We look at the total of the…

It ended up being a custom item report - the name field was what i needed! Thank you

As usual - you're awesome. Since we have a relatively short history, our interval wasn't allowing the autocalculate feature to work. i shortened it and the reorder points adjusted for me so we are good to go now. items are showing appropriately!

Going forward - i'd like to create new items per your suggestion, as assembly items. What is the process for that? When creating an item, i haven't seen a way to select "assembly item" in any way. Going a step further - the "assembly" isn't generally two components - it's components plus a varying rate charge based on…

I think your second solution is how we will end up having to do this. Will become rather cumbersome when it's all said and done if we have large orders, but should work. Thank you.

I know what this means - but don't really create any scripts myself. We are a smaller startup without a programmer on staff.

We currently aren't using assemblies and SKU's would be specific to an item type/always capitalized. So in this instance we should be fine. Thank you!

Well - it looks like we are already good to go then! That must be why our implementation person setup the Name as SKU. Thank you!

Thanks for the quick response. Actually - we have our own internal naming convention for SKU's. I just want to be able to ensure that we don't enter duplicate names.

Netsuite support actually Zoom'd in and helped me fix it. The journalEntry.selectNewLine('line'); portion was in the wrong area and the original subsidiary was the correct value so we moved it. Below is the final, correct script and it's working like a charm! /** * @NApiVersion 2.x * @NScriptType UserEventScript *…

Netsuite support followed up and said that i needed to set the subsidiary field before you can set the accounts at the line level. I made the following updates but i'm still getting the error. define(['N/record'], function(rec) { function afterSubmit(context) { //Get the cash sale transaction. var cashSale =…