Good Morning Jack! After further review, I found the discrepancy is due to the PO brining in the last purchase price on some of the items versus the purchase price which is in our search. Many of the items do not have a Purchase Price and are pulling in the LPP from previous PO's. I'll need to tweak the formula in the…

Thanks Jack! I had these setup originally, but it looks like I didn't save the filter for internal id originally and I should've double-checked that option. However, the total cost calculated for the item group using the save search is not the same cost that appears on the PO and they should be the same. The total for the…

Thanks Pauline! I've just completed setting it up to test so now I wait until an unsent email is activated and see how it works.?

Thank you Pauline! I will give this a try! I had also tried the Employee Search, but just didn't have the correct Formula Text field in place. Have a great weekend! Michael

Thanks Jack. We needed the Inventory Detail field on the form also and I thought it was only available on the Adv Template. I'll go back and review the Basic Template as well and try to make it work. Thanks for your assistance and testing on this issue. Hopefully, the enhancement will get voted in soon as this has been an…

Thanks Jack. I have also tried adding the item type to the code and it works except it's indenting the kit name and keeping the component unindented. It's also repeating the kit name as a component. </thead> </#if><#if item.itemtype ="Kit"><tr> <td style="width: 189px;"><span…

Thank you @Pauline Joy Cac-Oracle! I will definitely vote for this option.

Thank you @Micah Timbol-Oracle! I unchecked the MATCH BANK DATA field on the account, manually cleared the JE line in the account, and re-checked MATCH BANK DATA field. The JE no longer appears in the Match Data program. We will be performing the reconciliations later today!

Can anyone else assist on this issue? To further clarify, on the account in question we imported all of the transactions as of 9-20-21, but the account was opened on 9-1 with a $250K deposit. When we attempt to match the transactions, we match all of the cleared items through 12-31-20 to the journal entry with ending…

Thanks @Micah Timbol-Oracle ! Currently, we are only using the Match Bank Data and Reconcile Account Statement. We haven't submitted any of the matched data yet, nor have we completed a bank reconciliation. I was referring to the existing SuiteAnswer regarding unchecking as a way suggested by NS to reconcile the beginning…

Thanks John! I'll try to work on this today and see I can make it work. Appreciate the assistance and I'll update you soon! Michael

Thank you everyone! We have arrived at a solution that works, but we're still working on refinements. For now this is how it looks for the alternate MFG listing and the default MFGis populated in the main section on the item record:

Thanks again John. I thought I was following you until the address component fields so maybe I misunderstood the original contact record custom field of LIST/CONTACT. Can you send a screenshot of the field on the contact record? I'm not seeing how to get the fields from the contact address. I had gone a slightly different…

Thanks John! That seems like a great solution! Does your site location appear under the contact tab on the transaction docs or do you use your custom field to select the site from the list and display it in the body of the transaction doc? Michael

Thank you Shamie! I should've clarified further.....the Site Location Address is in addition to the Bill To and Ship To addresses. For example, the SO would have a Bill to for the customer and a Ship To for the installer, but the Site Address would be a 3rd address needed on all of the transactions to track where the items…

Ivy as a follow-up on this same issue....how can I configure the subtab so user could edit/add/remove alternate manufacturers from the item, but allow them to stay on the Master List as well? I guess looking for a setup similar to the Vendor Subtab. Thoughts?

Thank you Ivy! Hopefully, others may have suggestions or solutions that worked. I'm thinking now we allow the default MANUF fields to be our priimary MANUF and we simply store a list of alternate Manuf in a subtab which could be referenced in the event the Primary Manuf is no longer available and we could use the info in…

Thank you Pauline! I had not thought about using Custom Segment. I will try this later today or over the weekend and I will update you.

Thanks Pauline! I don't think the customer item number field will work because I was needing the info on the Inventory Detail Form---attempting to make a workaround for catch-weight tracking. I added my name as Michael, but for some reason it's not showing up. Have a great day! Michael

Thanks for the response; however, the actual way to fix it with Pacejet integration is to change the Shipping Method on subsequent fulfillments to be something different than the origina and save it before fulfilling. When the shipping label is created in Pacejet, you can select the appropriate shipping method you want to…

Update---I fixed the issue by adding the following contexts to the workflow: Suitelet and User Interface. Now the only issue is that if there are subsequent item fulfillments where we want to charge the actual shipping, NetSuite is still computing the shipping as if it was all charged on the first item fulfillment. I…

Thank you for asking for clarification. Pacejet returns two amounts (1) is Freight Cost $ which is the cost of the shipment and (2) the Freight Price $ which is the cost x markup. We want the Freight Price $ field to populate Shipping Cost in Shipping subtab.

It has never worked properly. Once the Item Fulfillment is retrieved, user clicks SHIP and the Pacejet window opens. * User rates the shipment and ships from Pacejet. * Pacejet writes back rates and tracking info back to a Pacejet Subtab on Item Fulfillment, but the rates do not populate in the Shipping Cost field on the…

Thank you Herdi! I just heard from NetSuite and this is a defect on our account and they are assigning an Urgency level to have it fixed.