Thanks @Tris Mendoza-Oracle !!

Hi @Patrick Fresnosa-Oracle It's not the payable account but the sales account the invoice will go to for that particular customer. Regular customers go to 40000 sales intercompany customers go to 400001 intercompany sales (these customers are setup as intercompany and have their own subsidiary) We want to send the regular…

Hello @Patrick Fresnosa-Oracle We have intercompany customers that represent subsidiaries under our umbrella. However, this is another intercompany customer that does not represent a subsidiary inside of NetSuite, so they do not have that box checked. I would want their sales revenue to go to the intercompany sales account…

Thank you so much!

Thank you Tris!

Hi Nicole, Yes that will work. I'll test it out on my end thank you!

Thank you!

Fantastic! It worked! I was doing something similar but it wasn't populating. Are the parenthesis important when creating the formulas? My original formula was just {total}/{quantity}

Hello @MTL_MIA I tried the formula you provided and I couldn't get it to work, it's empty.

Hello, Yes, I was able to check it and it is unfortunate that there is no fix. Thank you for your help!

BUMP

Thank you Tris! Helpful as always.

Can anyone assist with this workflow?

Amazing! You're absolutely right! Thank you so much, no idea how I missed this!

Hello All, This does not work for locked transaction forms. Does anyone know how to make LOCKED transaction forms from bundles Inactive?

@Tris Mendoza-Oracle Hi Tris, thank you for your response. The make inventory available feature is turned on at that location. The second setting you are referring to would not apply since this is a work order, not a sales order. I have opened a ticket and will see what they say. Thank you all for your help.

I've tried doing that several times and it doesn't commit the item. That's what I had mentioned in my original post, not sure if its bugged.

Yes it does show the quantity on hand.

Hello, we don't use bins in this Location so it can't be a BIN issue and the status is set to good. I've also tried manually reallocating inventory and it still won't work.

We do use supply allocation, Inventory status is default good status, with ano BIN locations. The other item on the order was committed without any issue.

@Tristan Joy Mendoza-Oracle Thank you for your reply, I've checked on my end and there are no units committed. I'm stumped on this issue, any other insight on what it could be?

@CDuf So I was able to get it to work but I'm not sure that I understand what I did haha Here is the formula that worked My original objective was to: Filter sales orders in which items fulfilled were less than then quantity ordered but also include orders in which 0 were fulfilled.

Thank you again we will move forward with receiving it immediately after it's shipped. I appreciate all the help!

Hello @Patrick Fresnosa-Oracle So it looks like we are on the same page, what you showed is exactly what we thought. The financial transfer only happens on item receipt, therefore the purchasing entity should receive these items immediately if they wish to display it on their books?

Hello @Patrick Fresnosa-Oracle Thank you for the reply. What you showed is exactly what I'm referring to. When you do the item fulfillment for Subsidiary A it puts in Transit for Subsidiary A. This is incorrect since it no longer belongs to subsidiary A. It belongs to subsidiary B which is the purchasing entity and should…

Thank you Clarisa! Looking forward to hearing from people.

Bump! Can anyone share some knowledge on this?

Thanks again Joy, I will be checking with developers to see if there is any script issue causing this. Below is what our Unit chart looks like, let me know your thoughts. Can you see if you can do it with MG? on your end? Thank you

Hi Joy, could it be because you did not choose a unit? Can you try choosing a unit on your end? or maybe its a rounding error with MG?

Following up on this, anyone have insight on this matter?