NSPK Blue Ribbon

@Judith Culanding-Oracle I understand the purpose and for this we have a custom GL plugin script created so here we credit back to the sales account and then debit to the refunds. Would that be the workaround for this? Thanks.

Nevermind, it's babased On specific time. Thanks.

@Michelle Janine-Oracle , @Vernita , I'm looking for something similar. We have a custom email that gets sent out whenever there is a specific item on the PO.

Explaining further - We have our top level assembly of supply type BUILD with BOM components. BOM components have sub-assemblies with supply type as purchase and the default cost and the purchase price has been set up for those. These Purchase type assemblies do not BOM components. Whenever I roll up, it is not calculating…

@Tris Mendoza-Oracle , thanks for directing towards the SA 88668. In the screenshot below (I've masked some fields), the item that is checked is a top level assembly with several sub-assemblies (of BUILD type) and assemblies (of PURCHASE type). During the data migration, we brought in the items with the standard cost and…

@netsuite community, let me know if anyone else has gone through this before with standard costing. @Jervin Nicholas Teopengco-Oracle

@Herdi Rana-Oracle , I saw some of your advices on cost roll up. Any help is appreciated. NSPK

As an update, for now we were able to set asset account in the Expense Account field and the system allowed us to do so. Is this the best practice? NSPK

I still am not sure, overall I think NetSuite is not sure of how the roll up works. My question is do I need to run the sub-assembly for cost roll up or do I run at the parent level? Our costs in NetSuite is incorrect. NSPK

@Richard James Uri-Oracle , do we have any experts on standard costing that could shed some light on this.

Any updates on this? Do I need to do the cost roll up of sub-assemblies first? That's what I have done and want to confirm that this is the way to go. NSPK

@Niks Blando-Oracle , I'll update this with screenshots and steps. NSPK

Hi, not really. So what I need to know is if this is limited to just one account posting for shipping charges or can I make that based on the class on the item? NSPK

Hi @Niks Blando-Oracle , no not the registration, we got that taken care of in our sandbox. This is on the Shipping Item/Method. Here's one example for FedEx - Ground, Shipping Rate- Likewise for Handling - NSPK

I also want to know if this is where custom segment will be required and is there a webinar on how to create a custom segment and how the GL impact changes with SuiteGL implementation. NSPK

Yes, I did have that on, thanks for that. Besides that, I have an Assembly with supply type of Purchase. It has no BOM components. I keyed in the standard cost for the assembly, $500. Updated the Planned cost to $550. I cannot run the cost roll up as it has no components and running that replaces the planned standard cost…

Did not see Item Locations in the mapping - NSPK

@Angelica Mae Segador-Oracle , we are using the integrated shipping label and that's the reason we did not create one with Advanced PDF. NSPK

@Able Wilson , it didn't show, so now I'm using (-({total}-{amountremaining})), this formula to get the calculation and this worked on the invoice, I just created another one just for sales order. Thanks, NSPK

Another way that I found could work is to pay through the parent for the child using Accept customer payment page. I can see all the transactions of the child / sub-customer and also apply the parent's credit memo or even customer deposit. NSPK

UPDATE: I updated Reference Number 1 to show order number and that worked. Is there a way to rename the Ref to Order Number? NSPK

Hi @Angela Bayliss , thanks for the quick response. This is not a custom field on the sales order, I need to calculate the discount amount and populate on the default Discount Rate field on the order. Here's the screenshot on the order: Screenshot of the saved search: Screenshot of the results: Screenshot of workflow field…

Any updates on this?

Hi, yes, I do see the results and as mentioned I've grouped these - This is the SS results - Here, I've added the SO that has 2 customer deposits - This is what I have in the Results tab - This is from the related records of the SO - This is from the custom field where it should display the total amount - I've added the…

I did uncheck the store value and it still does not populate. NSPK

@Patrick Fresnosa-Oracle no, we will need to create the elimination accounts manually and we will not use the Eliminate Intercompany checkbox on accounts. Not sure how this will turn out, but keeping fingers crossed. Thanks, NSPK

@Patrick Fresnosa-Oracle , we are now thinking of not using intercompany feature, instead create elimination accounts manually and run that manual. Looks like this is our best choice given the circumstances. Now we will need to figure out how to manually eliminate the transactions. NSPK.

@Patrick Fresnosa-Oracle is there a way to update GL impact from a non intercompany account to an intercompany account on posting transactions? NSPK

Hi Patrick, no intercompany transfer orders will not work and I admit that our process is not clean, but this happens in international shipment. There are a number of factors that happen which is not supported by NetSuite. We need to be able to print invoices, update quantities to the last point, add new line items, update…

Yes, that is correct, we will have to. So would then be the best option to write a JE moving inventory and associated financial impact to intercompany accounts?