Best Of

HI - thanks for the reply, at least I know the bug (enhancement!) is being tracked.

Attendee isn't a field in that table, and response seems to be the only field that is has differences between duplicates.

I'll use select distinct over all columns except response for now - I need all fields and I need to remove duplicates.

Hi @Jervin Nicholas Teopengco-Oracle ,

It works.

Thank you so much!

Jet

Angela, appreciate your time and expertise. I will propose to our accounting team.

Thank you for sharing your insights on this Tigran!

Hi @Jet Zhang,

Good day!

It seems like the BFO report generator does not support the transform property. While it uses HTML- and CSS-like syntax, there are important differences. For details on supported features, please refer to the official documentation.

Given this limitation, here’s a quick code snippet that might help:

<p rotate="-45" font-size="48pt">______________</p>

Here's what it looks like on preview:

I hope this helps!

Hi @User_S6FVQ ,

I wasn't clear - My apologies. Let's say that you calculate and give coop credits monthly.

Create the Co op item to be used on the credit memo's issuing the coop amount. (use the account that has been identified by your accounting team for coop accumulation values.

Create a saved search that covers the period you're providing the credit for. Lets say for the month. so it would be a saved transaction search. Criteria = main line is true, date = last month, type = invoices, credit memo's (or cash sales & refunds if you use those). On the results, Date, document number, name Summary type = group), and amount(summary type = sum).

Now you have the search showing a name and amount per line for the coop calculations. export your search, and add a column to calculate the %

Next, you'll create the credit memo's. For each total, multiply it by your % total amount * .02 - this is the amount of the Coop credit. Set the customer name into the credit, and use the 'Coop' item as the line. set the amount and save. Once you create the credit memo's, they can be applied to any transactions

I hope this helps!

I was able to debug this thanks to Red's information by adding ?html to the end of the tracking links that were being generated by the PDF. This revealed:

<a href="http://www.dpdlocal.co.uk/service/tracking?consignment=6705614431" <a 

href="http://www.dpdlocal.co.uk/service/tracking?consignment=6705798623" 

target="_bb1_mss_trackshipment">6705798623</a>

Which shows that the tracking links from oneship when there are multiple deliveries was being poorly generated.

I was then able to fix instances of multiple links by first assigning the links manually to my own <a> elements and then rendering them properly.

<#assign raw = record.custbody_bb1_mss_trackinglink>

<#assign links = raw?matches("http://www\.dpdlocal\.co\.uk/service/tracking\?consignment=\d+")>

<#if links?size gt 0>

<table width="100%">

  <tr background-color="#00415F">

    <td colspan="10" align="center">

      <b color="white">PoD Order Tracking Link(s):</b>

      <#list links as url>

        &nbsp;

        <a href="${url}" color="white">

          <font color="white">${url?keep_after("consignment=")}</font>

        </a>

      </#list>

    </td>

  </tr>

</table>

</#if>

Resulting in the fix for when OneShip has multiple tracking links.

@Shorin Rio Daa-Oracle @Angela Bayliss Thank you for your responses. This would be for Ship Central. I don't see any good documentation on how to set this up so we can choose a fed ex one rate package in ship central. And different sized one rate boxes. From envelope to larger one rates.

And it is your Patrick Olson, Angela!

Hello @Adinath_Bodakhe m

you can use the Asset Transaction of asset Revaluation and revalue the asset to a zero cost with zero useful life left in NetSuite

The GL Impact can be for December, you don't have to do this in a different month. The depreciation and the adjustment can both take place in December.

Does this answer your question?

Thank you so much @PaulFleetwood to share your knowledge and insights to help them out. Your input is highly valued and appreciated!