tag:blogger.com,1999:blog-78336458893416147362024-03-27T16:53:22.514-07:00NetSuite Development NotesNetsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.comBlogger8014125tag:blogger.com,1999:blog-7833645889341614736.post-66983283807037314162021-09-06T03:31:00.000-07:002021-09-06T03:31:10.774-07:00How to write SuiteScript script elegantly with VS CODE<iframe width="480" height="270" src="https://youtube.com/embed/0K-pqYu-0uI" frameborder="0"></iframe>Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-88462867156572513882021-02-18T20:00:00.001-08:002021-02-18T20:00:10.149-08:00Permission to Setup Tax Codes and/or Tax Groups<span style="LINE-HEIGHT: 115%; FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-PH; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">To allow non-administrator users to setup or edit tax codes and tax groups, the Administrator must add the <b style="mso-bidi-font-weight: normal">Tax Items</b> permission by following the steps below.<br><br>1. Navigate to <b style="mso-bidi-font-weight: normal">Setup > Users/Roles > Manage Roles.</b><br>2. <b>Edit</b> the role.<br>3. <b style="mso-bidi-font-weight: normal">Permissions > Lists ></b> add <b style="mso-bidi-font-weight: normal">Tax Items</b> with at least <i style="mso-bidi-font-style: normal">Edit</i> access level.<br>4. Click on <b style="mso-bidi-font-weight: normal">Save.</b></span> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-38854360402737946582020-12-22T17:00:00.001-08:002020-12-22T17:00:17.760-08:00Override Avatax in NetSuite<p>Once an Avatax tax code is used in a transaction, it can no longer be changed in the transaction because it is locked to the tax code since there is a document on the admin console reflecting the transaction. To further explain:</p><p>1. When a transaction is first created using Avatax Tax Item, Avatax computes the tax, sets the special field provided by NetSuite to avoid tax field being overidden by NetSuite. NetSuite's logic ignores NetSuite's computed tax and uses Avatax's computed tax if <br>this special field is set.<br><br>2. Now if the user changes the Tax Item from Avatax Tax Item to 'Non Avatax Item', in this case 'Non Taxable' or 'Exempt', Avalara does not calculate the tax and also does not blank out the special hidden field so that NetSuites Tax Engine can take over.<br>If this special hidden field is not blanked out by Avatax, NetSuite ends up using the value in this field and to the end user it appears that tax did not change.<br><br>The two options would be:</p><p>1. To cancel/close/offset the transaction and create a new one using a non-Avatax tax code. <br>2. Turn Avatax off, edit the transaction to change the tax code and turn Avatax back on. </p><p><i><b>Note</b></i>: If there are many instances like this - where you need to change a tax code from Avatax to non-Avatax, the workaround you may want to consider is to create a User Event script that on Edit will set the taxamountoverride field to null if tax item is not Avatax. If you want this, you can review with your developers to create that script. </p><p><br> </p> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-82173070339823831942020-03-09T11:00:00.000-07:002020-03-09T11:01:56.513-07:00CSV Import: Sales Order > Error: Invalid item reference key xx.<p class="MsoNormal" style="background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;"><b><span style="font-size: 9pt; font-family: Verdana, sans-serif;">Recommendations:</span></b><span style="font-size: 8.5pt; font-family: Tahoma, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;"><span style="font-size: 9pt; font-family: Verdana, sans-serif;">1. The CSV Import file shouldcontain the same Item Name format as shown in <b>Transactions</b> > <b>Sales</b> > <b>Enter Sales Orders</b> > <b>Items</b> tab > <b>Items </b>subtab> <b>Item </b>drop down field. </span><span style="font-size: 8.5pt; font-family: Tahoma, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;"><span style="font-size: 9pt; font-family: Verdana, sans-serif;">2. Internal ID can also beused instead of Item Name. Just make sure that on the field mapping page, clickon the pencil icon beside the <b>Item</b> field and <b>ChooseReference Type</b> = <b>Internal ID</b>.</span><span style="font-size: 8.5pt; font-family: Tahoma, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal"><span style="font-size: 9pt; font-family: Verdana, sans-serif; background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;">3. Verify if theItem is Inactive. If the Item record is inactive, set it to active statusbefore importing.<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size: 9pt; font-family: Verdana, sans-serif; background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;">-Navigate to <b>Lists</b> > <b>Accounting </b>> <b>Items.</b><o:p></o:p></span></p><p class="MsoNormal"><span style="font-size: 9pt; font-family: Verdana, sans-serif; background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;">-Check the <b>ShowInactives</b> box.<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size: 9pt; font-family: Verdana, sans-serif; background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;">-Uncheck the <b>Inactive</b> boxbeside the Item Name.<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size: 9pt; font-family: Verdana, sans-serif; background-color: rgb(242, 244, 246); background-position: initial initial; background-repeat: initial initial;">-Click on <b>Submit</b>.<o:p></o:p></span></p> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com2tag:blogger.com,1999:blog-7833645889341614736.post-41865184573287198902020-03-07T10:00:00.001-08:002020-03-07T10:00:09.845-08:00Sales Order Saved Search that Shows Billing Schedule and Revenue Recognition<P>1. Navigate to<B> Lists > Search > Saved Searches > New> Transaction</B>.</P><P>2. On the <B>Criteria</B> tab ><B> Standard</B> subtab add the following filters:</P><UL><LI>Type = is Sales Order <LI>Billing Schedule = specify billing schedules.</LI></UL><P>3. On the<B> Results</B> tab > <B>Columns</B> subtab add the following fields:</P><UL><LI>Number > Summary type = Group <LI>Name > Summary type = Group <LI>Account > Summary type = Group <LI>Reseller (Custom) > Summary type = Group <LI>Billing Schedule > Summary type = Group <LI>Next Bill Date > Summary type = Group <LI>Rev. Rec. Start Date > Summary type = Group <LI>Rev. Rec. End Date > Summary type = Group</LI></UL><P>4. Rename the search and click<B> Save & Run</B>.</P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com1tag:blogger.com,1999:blog-7833645889341614736.post-70273871404972968822020-02-26T07:00:00.001-08:002020-02-26T07:00:10.559-08:00Avoid "Attempting to access memorized transaction as a non-memorized transaction" when doing a search via Web Services.<P>User receives "Attempting to access memorized transaction as a non-memorized transaction" when performing Web Services search operation. One possible way to avoid this is to set Memorized = false on search filter, see sample SOAP request below:</P><P><soap:Body><BR> <platformMsgs:search><BR> <platformMsgs:searchRecord xsi:type="tranSales:TransactionSearch"><BR> <tranSales:basic><BR> <platformCommon:mainLine><BR> <platformCore:searchValue>true</platformCore:searchValue><BR> </platformCommon:mainLine><BR> <B> <platformCommon:memorized><BR> <platformCore:searchValue>false</platformCore:searchValue><BR> </platformCommon:memorized></B><BR> <platformCommon:status operator="anyOf"><BR> <platformCore:searchValue>_invoiceOpen</platformCore:searchValue><BR> </platformCommon:status><BR> <platformCommon:type operator="anyOf"><BR> <platformCore:searchValue>_invoice</platformCore:searchValue><BR> </platformCommon:type><BR> </tranSales:basic><BR> </platformMsgs:searchRecord><BR> </platformMsgs:search><BR> </soap:Body></P><P> </P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-22110227646539129272020-02-21T05:00:00.001-08:002020-02-21T05:00:09.748-08:00Reference Checkout: Switch from Three-Step Checkout to One-Page Checkout<p align="center"><span style="FONT-SIZE: 9pt; FONT-FAMILY: 'Verdana','sans-serif'; mso-bidi-font-family: Tahoma"><a style="TEXT-DECORATION: underline" href="http://netsuite.adobeconnect.com/p6oqrucod17/" target="_new"><img alt="Image" src="https://netsuite.custhelp.com/euf/assets/images/portal-click-to-play.png" /></a></span><br><b>Duration: 5 minutes</b></p><FONT size=2 face=verdana>For <B>Reference Checkout version 2.0 (Bundle ID:41420) and version 2.02 (Bundle ID: 49333)</B>, users can switch from the default <B>three-step Checkout</B> process to the <B>One-Page Checkout</B> process by following these steps:</FONT><BR><P><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">1. Navigate to <B>Documents</B> > <B>Files</B> > <B>File Cabinet</B>, then open this folder:<B> Web Site Hosting Files</B> > <B>Live Hosting Files</B> > <B>SSP Applications</B> > <B>NetSuite Inc. - Checkout 2.02.0 </B>> <B>Reference Checkout</B>.</SPAN></P><P><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I>Note: For <B>Reference Checkout 2.0</B>, the <B>SSP Application folder</B> to navigate to is <B>Netsuite Inc. - Checkout</B>.</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">2. Copy the files listed below from the Reference Checkout application folder to their corresponding folders in the Custom Checkout application folder: </SPAN><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><B>/js/src/app/Configuration.js</B></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">3. Navigate to <B>Documents</B> > <B>Files</B> > <B>File Cabinet</B>, then open this folder:<B> Web Site Hosting Files</B> > <B>Live Hosting Files</B> > <B>SSP Applications</B> > <B>NetSuite Inc. - Checkout 2.02.0 </B>> <B>Custom Checkout</B> > <B>js</B> > <B>src</B> > <B>app</B>. Click <B>Edit</B> next to the <B>Configuration.js</B> file, and click the <B>Edit</B> link in the file record.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">4. Search for this comment in the code: <I><B>/* the normal three step checkout */</B></I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I><B></B></I></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">5. Below this comment is the code which displays Reference Checkout as a three-step Checkout process.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">6. Enclose the entire code in an HTML comment tag (<B>/* {code} */</B>) to comment out the entire code.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><B>Sample:</B></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><B>/*</B> <I>, checkoutSteps: [<BR> {<BR> name: _('Shipping').translate()</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I></I></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I>.</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I>.</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I>.</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I></I></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I> this.wizard.application.trackTransaction(this.wizard.model);<BR> }<BR> }<BR> ]<BR> }<BR> ]</I> <B>*/</B><BR></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">7. Next, search for this comment in the code: <I><B>/* The One Page Checkout Scenario */</B></I></P></SPAN><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">8. Below this comment is the code which displays Reference Checkout as a One-Page Checkout process.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">9. Remove the HTML comment tags which encloses this entire code.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><B>Sample:</B></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I> , checkoutSteps: [<BR> {<BR> name: _('Place Order').translate()<BR> , steps: [</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I>.</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I>.</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I>.</I></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><I> this.wizard.application.trackTransaction(this.wizard.model);<BR> }<BR> }<BR> ]<BR> }<BR> ]</I></SPAN></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">10. Click <B>Save</B> to save the changes to the file.</SPAN></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><FONT face=Tahoma></FONT></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"><B>Notes:</B></SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">- In order for the customization to take effect, make sure that the <B>Custom Checkout 2.02.0</B> SSP application has precedence over the <B>Reference Checkout 2.02.0</B> SSP application. If <B>Reference Checkout 2.0</B> is used, make sure that the <B>Custom Checkout</B> SSP application has precedence over the <B>Reference Checkout</B> SSP application.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">- Kindly refer to the article, <B>Changing SSP Application Precedence (Answer ID: 27494) </B>for the steps.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">- Depending on the Reference Checkout version used, make sure the <B>Custom Checkout Touch Points</B> are deployed in the web store.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">- Kindly refer to the article, <B>Deploying an SSP Application to Your Site (Answer ID: 27503)</B> for steps on how to deploy the Touch Points to the web store.</SPAN></P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P><P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></SPAN> </P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-33877620006546179292020-02-19T19:00:00.001-08:002020-02-19T19:00:10.287-08:00Search to Get the Percentage of Fulfilled Quantity Out of Ordered Quantity<div style="FONT-FAMILY: Tahoma, Geneva, sans-serif; FONT-SIZE: 8pt"><div style="FONT-FAMILY: Tahoma, Geneva, sans-serif; FONT-SIZE: 8pt"><div style="FONT-FAMILY: Tahoma, Geneva, sans-serif; FONT-SIZE: 8pt"><div style="FONT-FAMILY: Tahoma, Geneva, sans-serif; FONT-SIZE: 8pt"><font face="Tahoma, Geneva, sans-serif"><span style="FONT-SIZE: 11px"><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: #f2f4f6; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">1. Navigate <b style="mso-bidi-font-weight: normal">to Lists > Search > Saved Searches > New</b> > Select <b style="mso-bidi-font-weight: normal">Transaction.</b></span></p><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: #f2f4f6; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"><b></b></span><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"><!--?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /--><o:p><br></o:p></span></p><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: #f2f4f6; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">2. Under <b style="mso-bidi-font-weight: normal">Criteria</b> tab, set the following:</span><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"><br><b style="mso-bidi-font-weight: normal"><span style="BACKGROUND: #f2f4f6">Type</span></b><span style="BACKGROUND: #f2f4f6"> is Sales Order</span><br><b style="mso-bidi-font-weight: normal"><span style="BACKGROUND: #f2f4f6">Date </span></b><span style="BACKGROUND: #f2f4f6">is (specify a specific period)</span><br><b style="mso-bidi-font-weight: normal"><span style="BACKGROUND: #f2f4f6">Main Line</span></b><span style="BACKGROUND: #f2f4f6"> is false</span><br><b style="mso-bidi-font-weight: normal"><span style="BACKGROUND: #f2f4f6">Tax Line</span></b><span style="BACKGROUND: #f2f4f6"> is false</span><br><b style="mso-bidi-font-weight: normal"><span style="BACKGROUND: #f2f4f6">COGS Line</span></b><span style="BACKGROUND: #f2f4f6"> is false</span><br><b style="mso-bidi-font-weight: normal"><span style="BACKGROUND: #f2f4f6">Shipping Line</span></b><span style="BACKGROUND: #f2f4f6"> is false</span> <o:p></o:p></span></p><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"><br><span style="BACKGROUND: #f2f4f6">*Set other criteria needed.</span><o:p></o:p></span></p><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"><o:p> </o:p></span></p><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: #f2f4f6; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">3. Under <b style="mso-bidi-font-weight: normal">Results </b>tab, set the following:</span><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"> </span><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"><o:p> </o:p></span></p><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: #f2f4f6; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">Number<br>Name<br>Quantity<br>Quantity Fulfilled/Received<br>Formula (Percent) > Formula = </span><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">nvl({quantityshiprecv},0)/nullif(nvl({quantity},0),0)<br><br>4. Enter a <b style="mso-bidi-font-weight: normal">Search Title.</b></span></p><p class="MsoNormal" style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH"><b></b><br>5. Hit <b style="mso-bidi-font-weight: normal">Save & Run</b>.<o:p></o:p></span></p></span></font></div></div></div></div> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com1tag:blogger.com,1999:blog-7833645889341614736.post-75890195866149284972020-02-16T09:00:00.001-08:002020-02-16T09:00:11.592-08:00Customer Records for PayPal Integration Without Express Checkout<p><br></p><p>When<b> PayPal Express Checkout</b> is enabled in NetSuite account, a new customer record is created each time the shopper uses express checkout.</p><p>When PayPal is integrated <b>without Express Checkout,</b> the same customer record is used upon log-in regardless of what PayPal email login was used after clicking on the <b>Pay with PayPal </b>button.<br><br></p> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-60206055012911816342020-02-06T07:00:00.001-08:002020-02-06T07:00:09.585-08:00Reprocess R03 Script to Add Additional Contract Items in Contract Record<p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'">View Contract with contract item<b>> </b>Go to<b> Transaction</b> tab> Click on Sales order> Add new item> Run the R03> Contract item not processing for additional item on to the Sales Order<b></b></span></p><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 8pt; mso-fareast-font-family: 'Times New Roman'"><p style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'"></span> </p><p style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'">1. Edit the sales Order</span></p><p style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'">2. Under the <b>Option & Log> Set the Check Log Status to Pending</b></span></p><p style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'">3. Run again the R03 script in <b>Setup> Customization> Scripts.</b></span></p><p style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"></p></span> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-72913071442732815712020-02-04T12:00:00.001-08:002020-02-04T12:00:12.395-08:00Effect on Sales Tax Liability Report and Pay Sales tax page if Credit memo for Sales Tax Refund is Issued<P style="MARGIN: 0in 0in 8pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">Given: Credit Memo for Sales Tax Refund was issued and this is to be reflected on Sales Tax Reports<BR style="mso-special-character: line-break"><BR style="mso-special-character: line-break"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P><P style="MARGIN: 0in 0in 8pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">The credit memo will just have the effect of offsetting the invoice for the customer for whom sales tax was refunded to. The effects will wash out in the report, since the tax due amount is cumulative. <o:p></o:p></SPAN></P><P style="MARGIN: 0in 0in 8pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">The Pay sales tax page will have an amount once the amount of the credit memo has already been offset by a new sales tax invoice i.e. the page will only have an amount once the tax due column is positive again.<BR style="mso-special-character: line-break"><BR style="mso-special-character: line-break"><o:p></o:p></SPAN></P><P style="MARGIN: 0in 0in 8pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">See below for sample computation:<o:p></o:p></SPAN></P><P style="MARGIN: 0in 0in 8pt" class=MsoNormal><I style="mso-bidi-font-style: normal"><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">In the example below, sales tax charged for the whole invoice = 9<o:p></o:p></SPAN></I></P><P style="MARGIN: 0in 0in 8pt" class=MsoNormal><I style="mso-bidi-font-style: normal"><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></I></P><P><TABLE style="WIDTH: 308pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=411><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><I><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">(Periodic)<o:p></o:p></SPAN></I></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><I><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">(Cumulative)<o:p></o:p></SPAN></I></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Tax Collected<o:p></o:p></SPAN></B></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Tax<o:p></o:p></SPAN></B></P><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Due<o:p></o:p></SPAN></B></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Month 1<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Invoice in Month 1 (to be refunded)<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Total Before payment, Month 1<o:p></o:p></SPAN></B></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Payment in Month 1<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">-9<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Total After payment, Month 1<o:p></o:p></SPAN></B></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 7"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Month 2<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 8"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Other invoice 1 in Month 2<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 9"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Other invoice 2 in Month 2<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 10"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">CM in Month 2<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">-9<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">-9<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 11"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Total Before payment, Month 2<o:p></o:p></SPAN></B></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 12"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Payment in Month 2<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 13"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Total After payment, Month 2<o:p></o:p></SPAN></B></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 14"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 15"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 16"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">SUMMARY<o:p></o:p></SPAN></B></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Tax Collected<o:p></o:p></SPAN></B></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Tax<o:p></o:p></SPAN></B></P><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Due<o:p></o:p></SPAN></B></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 17"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Invoice<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">18<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">18<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 18"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Credit memo<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">-9<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">-9<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 19"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">Payment<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">-9<o:p></o:p></SPAN></P></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 20; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 174pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=232 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 68pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=91 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">9<o:p></o:p></SPAN></P></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 66pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=88 noWrap><P style="TEXT-ALIGN: center; LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'">0<o:p></o:p></SPAN></P></TD></TR></TBODY></TABLE></P><P style="MARGIN: 0in 0in 8pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"><o:p> </o:p></SPAN><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P><P style="MARGIN: 0in 0in 8pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 107%; FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">Related article: Issue Credit Memo for Sales Tax Refund and Have It Reflected on Sales Tax Report</SPAN></P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com1tag:blogger.com,1999:blog-7833645889341614736.post-69697677418375958002020-02-04T11:00:00.001-08:002020-02-04T11:00:13.309-08:00Difference between Resource Allocation Feature and Project Task Manager Bundle<P>The Resource Allocation feature helps resource managers allocate the right resources to projects based on availability, skill sets, and other criteria. </P><P>The Project task manager will allow you to manage and edit project task assignments using a graphic interface that displays project resources and assigned tasks.</P><P>In summary, the Resource Allocation feature helps you to allocate project resources to different projects based on certain criteria whereas, the Project Task Manager bundle enables you to allocate project resources to different tasks using a graphic interface.</P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-87950977759136602222020-02-02T23:00:00.001-08:002020-02-02T23:00:09.940-08:00Reference My Account: Add space between State and Zip code in Order Details page<p><br></p><p>Reference My Account's Order Details page displays a Ship To section. Currently, the address is displayed where State and Zip Code are not separated. <br><br>To resolve this, users will need to modify the <b>Address.Model.js</b> file.<br><br><img src="https://system.na1.netsuite.com/core/media/media.nl?id=16412&c=TSTDRV555267&h=1abc8f2397335f412ad1"></p><p><b>Requisites:</b><br>1. Custom My Account folder is already populated with files copied from the Reference My Account folder. <br>2. <b>Setup > Site Builder > Set Up Web Site > Touch Points</b> tab:<br>Name: View Customer Center<br>SSP Application: Custom My Account </p><p>Steps:<br>1. Navigate to <b>Setup > Site Builder > Web Site Hosting Files</b>. <br>2. Navigate to <b>SSP Applications > NetSuite Inc. - My Account > Custom My Account > js > src > app > modules > Address</b> folder.<br>3. Edit <b>Address.Model.js</b>.<br>4. On Line 29, add "<b>+ ' ' +</b>" between <b>this.get('state'))</b> and <b>this.get('zip')</b> to add a space like below:</p><p><b> this.get('city') + ' ' + (this.get('state') === null ? '' : this.get('state')) +' '+ this.get('zip') + ' ' + this.get('country');</b><br><br>5. Save.<br></p><p>After making the changes above, state and zip codes will now be separated by a space. <br></p><img src="https://system.na1.netsuite.com/core/media/media.nl?id=16411&c=TSTDRV555267&h=545ea47bd683e6798ca4"><BR><br><i>Note: State and Zip Code in Order Details is already separated by a space in Reference My Account 1.06.0</i> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-72989148683711276902020-01-20T09:00:00.001-08:002020-01-20T09:00:09.741-08:00An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors<p class="x_MsoNormal"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font></p><p class="x_MsoNormal"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag <a name="x_OLE_LINK4"></a><a name="x_OLE_LINK3"></a><a href="https://webmail.netsuite.com/owa/redir.aspx?C=nKBe9P42r0-WUEKx9l6J3t09ZGImDNEI0H2zGM4BuBIkgx7D_8hFrkJ_X4gJxuo1ZbneVF7_0xI.&URL=https%3a%2f%2fsystem.netsuite.com%2f" target="_blank">https://system.netsuite.com/</a> to all relative anchors such as <a href="#top">Back to top</a>. </span></font></p><p class="x_MsoNormal"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">i.e. The email message includes a "Back to Top of Page" link and clicking it should return the user to the top of the page. This looks like: </span></font></p><p class="x_MsoNormal"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><a name=top></a> </span></font></p><p class="x_MsoNormal"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font><a name="x_OLE_LINK1"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><a href="#top">Back to top</a></span></font></a><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font></p><p class="x_MsoNormal"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The "Back to top" link now has a URL of <a href="https://webmail.netsuite.com/owa/redir.aspx?C=nKBe9P42r0-WUEKx9l6J3t09ZGImDNEI0H2zGM4BuBIkgx7D_8hFrkJ_X4gJxuo1ZbneVF7_0xI.&URL=https%3a%2f%2fsystem.netsuite.com%2f%23top" target="_blank">https://system.netsuite.com/#top</a>. The link opens a new page when clicked from within Outlook. </span></font></p><p class="x_MsoNormal"><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">To make sure <a href="https://webmail.netsuite.com/owa/redir.aspx?C=nKBe9P42r0-WUEKx9l6J3t09ZGImDNEI0H2zGM4BuBIkgx7D_8hFrkJ_X4gJxuo1ZbneVF7_0xI.&URL=https%3a%2f%2fsystem.netsuite.com%2f" target="_blank">https://system.netsuite.com/</a> isn't appended to any of the anchor tags, open the template file in Mircrosoft FrontPage and configure the anchor tag urls and copy/paste the html into the template record in NetSuite. This method ensures no additional html is added to the template and anchor links work as expected.</span></font><font size="2" face="Arial"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font></p> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com1tag:blogger.com,1999:blog-7833645889341614736.post-65313219267271890322019-07-17T00:00:00.001-07:002019-07-17T00:00:13.011-07:00Save / approve transaction (Bill, Cash Sales, Sales Order, Expense Report) > Error: The currency on the transaction, xxxx is different from yyyy, the currency of the entity, zzzz on this transaction<font face="Times New Roman"></font><p class="MsoNormal" style="margin: 0in 0in 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Scenario:</span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">•<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Save / approve <span style="mso-bidi-font-weight: bold;">transaction (i.e. Vendor Bill, Invoice, SalesOrder, Credit Memo, Cash Sale, Expense Report)</span><b style="mso-bidi-font-weight: normal;"></b></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">•<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Error: <b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;">The currency on the transaction,xxxx is different from yyyy, the currency of the entity, zzzz on thistransaction</i></b></span></p><font face="Times New Roman"></font><p class="MsoNormal" style="margin: 0in 0in 0pt; text-indent: 0.5in;"><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Example: </span></i></b><span style="font-family: "Verdana","sans-serif"; font-size: 9pt;">The currency on the transaction, GBP isdifferent from USD, the currency of the entity, {<b>Employee Name</b>} on thistransaction."</span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"></span></b></p><font face="Times New Roman"></font><p class="MsoNormalCxSpLast" style="margin: 1em 0px;"><span style="font-family: "Verdana","sans-serif"; font-size: 9pt;"><br><b style="mso-bidi-font-weight: normal;">Findings:</b></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">•<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">The error is derived from amismatch between the <b style="mso-bidi-font-weight: normal;">transactioncurrency</b> and the <b style="mso-bidi-font-weight: normal;">entity's </b>availablecurrencies in the entity record's <b>Financial </b>tab > <b>Currencies </b>subtab or</span><span style="font-family: "Verdana","sans-serif"; font-size: 9pt;"></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">•<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">The employee record'scurrency and its transaction(s) are different from the base currency of itssubsidiary</span><span style="font-family: "Verdana","sans-serif"; font-size: 9pt;"></span></p><font face="Times New Roman"></font><p class="MsoNormalCxSpFirst" style="margin: 1em 0px;"><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"> </span></p><font face="Times New Roman"></font><p class="MsoNormalCxSpLast" style="margin: 1em 0px;"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Solution:</span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">•<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Verify that the <b>EntityRecord</b> (<b>customer, project, vendor</b>) has the <b>same currency</b> asthe<b> Sales/Purchase transaction</b> (Invoice, Sales Order, Vendor Bill,Purchase Order)</span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">•<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">If there is a mismatchbetween the two (entity and transaction), user has the option of either:</span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level2 lfo1;"><!--[if !supportLists]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">1.<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Adding the<b> Currency</b>in the entity record's <b>Financial </b>tab > <b>Currencies </b>sub tab or</span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level2 lfo1;"><!--[if !supportLists]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">2.<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Choosing <b>another entity</b>for that transaction with the same currency as the transaction</span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; mso-add-space: auto;"><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"> </span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">•<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Verify that the <b style="mso-bidi-font-weight: normal;">Employee</b> record's currency and its transaction(s)are the same as its subsidiary</span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level2 lfo1;"><!--[if !supportLists]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">1.<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Delete the transaction(i.e. Expense Report)</span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level2 lfo1;"><!--[if !supportLists]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;"><span style="mso-list: Ignore;">2.<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Edit the Employee record tomatch the employee's currency to the base currency of its subsidiary </span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 1in; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level2 lfo1;"><!--[if !supportLists]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana;"><span style="mso-list: Ignore;">3.<span style="font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;"> </span></span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-PH;">Re-create the transactionfor that employee with the correct currency</span><span style="font-family: "Verdana","sans-serif"; font-size: 9pt;"></span></p><font face="Times New Roman"></font> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-52508130257568331672019-07-16T23:00:00.001-07:002019-07-16T23:00:10.189-07:00Tax Rate is incorrect in Check/Credit Card transaction created from Reconciliation's New Charges/New Deposit<font face="Times New Roman"></font><p class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal; mso-add-space: auto;"><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'>Scenario:<o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>User has default <b style="mso-bidi-font-weight: normal;">Tax Code</b>with rate other than <b style="mso-bidi-font-weight: normal;">zero</b> under <b style="mso-bidi-font-weight: normal;">Setup > Accounting> Set Up Taxes</b></span><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>User navigated to <b style="mso-bidi-font-weight: normal;">Transactions> Bank > Reconcile Bank Statement </b>/ <b style="mso-bidi-font-weight: normal;">Credit Card Statement</b></span><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>User entered an <b style="mso-bidi-font-weight: normal;">Other Charge</b>in the <b style="mso-bidi-font-weight: normal;">New Charges </b>tab</span><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>User opened the <b style="mso-bidi-font-weight: normal;">Check/Credit Card</b>via <b style="mso-bidi-font-weight: normal;">Transactions > Bank > WriteCheck/Use Credit Card > List</b></span><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>Tax Rate</span></b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'> for the <b style="mso-bidi-font-weight: normal;">Tax Code</b> is <b style="mso-bidi-font-weight: normal;">zero</b></span><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal;"><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p> </o:p></span></b></p><font face="Times New Roman"></font><p class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal;"><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'>Findings:<o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l1 level1 lfo2;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>Bank Reconciliation</span></b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'> is only concern with the <b style="mso-bidi-font-weight: normal;">bank account </b>part of a transaction andnot the tax computation of a transaction</span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l1 level1 lfo2;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>Adding <b style="mso-bidi-font-weight: normal;">Tax Code</b> in <b style="mso-bidi-font-weight: normal;">Bank Reconciliation</b> is still an <b style="mso-bidi-font-weight: normal;">enhancement</b> (<b style="mso-bidi-font-weight: normal;">133497</b>)</span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; mso-add-space: auto;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p> </o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l1 level1 lfo2;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>NetSuite is not designed to split the amount entered in the <b style="mso-bidi-font-weight: normal;">Account</b> line in the <b style="mso-bidi-font-weight: normal;">New Charges</b> tab between the <b style="mso-bidi-font-weight: normal;">account</b> and the <b style="mso-bidi-font-weight: normal;">Tax Code </b>account (using the <b style="mso-bidi-font-weight: normal;">TaxCode's Tax Rate</b>)</span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in;"><span lang="EN-US" style='line-height: 115%; font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'><o:p> </o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l1 level1 lfo2;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>NetSuite will enter in the full amount to the <b style="mso-bidi-font-weight: normal;">account </b>specified in the <b style="mso-bidi-font-weight: normal;">NewCharge </b>tab and a <b style="mso-bidi-font-weight: normal;">zero Tax Rate</b>in the transaction</span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in;"><span lang="EN-US" style='line-height: 115%; font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'><o:p> </o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l1 level1 lfo2;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>NetSuite will use a <b style="mso-bidi-font-weight: normal;">zero Tax Rate</b>because it will be misleading to end users who will view the transaction ifthere is a <b style="mso-bidi-font-weight: normal;">non-zero</b> <b style="mso-bidi-font-weight: normal;">Tax Rate</b> but <b style="mso-bidi-font-weight: normal;">zero Tax Amount</b> in the transaction.</span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in;"><span lang="EN-US" style='line-height: 115%; font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'><o:p> </o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.5in; line-height: normal; text-indent: -0.25in; mso-add-space: auto; mso-list: l1 level1 lfo2;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: EN-PH;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH; mso-ansi-language: EN-US;'>The same is true with the amount and Tax Code from <b style="mso-bidi-font-weight: normal;">Deposit/ CCard Refund</b> created via <b style="mso-bidi-font-weight: normal;">Bank/Credit Card</b> <b style="mso-bidi-font-weight: normal;">Reconciliation'sNew Deposits/New Credits </b></span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'><o:p></o:p></span></p><font face="Times New Roman"></font> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com3tag:blogger.com,1999:blog-7833645889341614736.post-44504107500074440502019-07-16T22:00:00.001-07:002019-07-16T22:00:10.762-07:00Custom Role tagged to a subsidiary > Open Tax / Financial Report > An unexpected error has occurred or This Period is not defined for this fiscal calendar<font face="Times New Roman"></font><p class="MsoNormalCxSpFirst" style="margin: 1em 0px 0pt; line-height: normal; mso-add-space: auto;"><b style="mso-bidi-font-weight: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-fareast-language: EN-PH;'>Scenario:<o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoNormalCxSpLast" style="margin: 1em 0px 0pt; line-height: normal; mso-add-space: auto;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'>Certain subsidiary is getting unexpected error whenpulling up financial reports:<o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l3 level1 lfo4; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User enabled <b style="mso-bidi-font-weight: normal;">Multiple Calendars</b> under <b style="mso-bidi-font-weight: normal;">Setup </b>> <b style="mso-bidi-font-weight: normal;">Company </b>> <b style="mso-bidi-font-weight: normal;">Enable Features</b>> <b style="mso-bidi-font-weight: normal;">Accounting </b>tab</span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l3 level1 lfo4; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User created a new <b style="mso-bidi-font-weight: normal;">Fiscal Calendar</b> under <b style="mso-bidi-font-weight: normal;">Setup</b> > <b style="mso-bidi-font-weight: normal;">Accounting</b> > <b style="mso-bidi-font-weight: normal;">FiscalCalendars</b></span><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt;'></span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l3 level1 lfo4; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User assigned the <b style="mso-bidi-font-weight: normal;">Fiscal Calendar</b> to a <b>subsidiary</b></span><b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt;'> </span></b><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l3 level1 lfo4; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User restricted arole that has access to financial reports/tax reports to just that <b>subsidiary</b></span><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt;'> </span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l3 level1 lfo4; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User logged inusing that role</span><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt;'></span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l3 level1 lfo4; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User navigated to <b style="mso-bidi-font-weight: normal;">Reports </b>><b style="mso-bidi-font-weight: normal;"> Financial </b>and opened any <b>Financial Report</b></span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'> or <b>Reports >VAT/GST ></b> open any <b>Tax Report</b> <o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l3 level1 lfo4; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User got theunexpected error: </span><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></p><font face="Times New Roman"></font><p class="MsoNormalCxSpFirst" style="margin: 0in 0in 0pt 0.75in; line-height: normal; mso-add-space: auto;"><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>This Period > is not defined for this fiscalcalendar. Go to 'Setup > Accounting > Manage Tax Periods'and set up orassign the period you need<o:p></o:p></span></i></b></p><font face="Times New Roman"></font><p class="MsoNormalCxSpMiddle" style="margin: 0in 0in 0pt 0.75in; line-height: normal; mso-add-space: auto;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p> </o:p></span></p><font face="Times New Roman"></font><p class="MsoNormalCxSpLast" style="margin: 1em 0px 0pt; line-height: normal; mso-add-space: auto;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>Findings<o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l1 level1 lfo1; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>The error is causedby:</span><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></i></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 1in; text-indent: -0.25in; mso-list: l0 level2 lfo3; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>Home </span></b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>><b style="mso-bidi-font-weight: normal;"> Set Preferences </b>><b style="mso-bidi-font-weight: normal;"> Analytics </b>><b style="mso-bidi-font-weight: normal;"> Report by Period = Financials Only or AllReports</b></span><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></i></b></p><font face="Times New Roman"></font><p class="MsoNormalCxSpFirst" style="margin: 0in 0in 0pt 94.5pt; line-height: normal; mso-add-space: auto;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>Financial Periods</span></b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'> are <b style="mso-bidi-font-weight: normal;">Period</b> based</span><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></i></b></p><font face="Times New Roman"></font><p class="MsoNormalCxSpLast" style="margin: 0in 0in 0pt 94.5pt; line-height: normal; mso-add-space: auto;"><b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>Tax Reports </span></b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>are <b>Period </b>based </span><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></i></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l2 level1 lfo2; mso-add-space: auto;"><!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>Periods</span></b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'> in <b>ManageAccounting Period/ Manage Tax Period </b>> <b style="mso-bidi-font-weight: normal;">Fiscal Calendar</b> are <b style="mso-bidi-font-weight: normal;">unassigned</b></span><b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style='font-family: "Verdana","sans-serif"; font-size: 9pt;'><o:p></o:p></span></i></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l2 level1 lfo2; mso-add-space: auto;"><!--[if !supportLists]--><span lang="EN-US" style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-ansi-language: EN-US;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User missed out on <b>assigningthe periods </b>to their respective <b style="mso-bidi-font-weight: normal;">FiscalYear</b> and <b>Fiscal Quarter</b><b style="mso-bidi-font-weight: normal;"><o:p></o:p></b></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l2 level1 lfo2; mso-add-space: auto;"><!--[if !supportLists]--><span lang="EN-US" style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-ansi-language: EN-US;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>Fiscal Period</span></b><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'> <b>setup/hierarchy</b> is necessary to <b>Tax/Financial Reports</b>specially in determining the <b>Retained Earnings (Balance Sheet Report</b>) or<b>International Tax Reports</b><b style="mso-bidi-font-weight: normal;"><o:p></o:p></b></span></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.5in; mso-add-space: auto;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'><o:p> </o:p></span></b></p><font face="Times New Roman"></font><p class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal; mso-add-space: auto;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>Solution:<o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l4 level1 lfo5; mso-add-space: auto;"><!--[if !supportLists]--><span lang="EN-US" style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-ansi-language: EN-US; mso-fareast-language: EN-US;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User will loginusing <b style="mso-bidi-font-weight: normal;">Administrator</b> role to checkthe name of the <b style="mso-bidi-font-weight: normal;">Fiscal Calendar</b>assigned to their role's subsidiary (<b style="mso-bidi-font-weight: normal;">Setup</b>><b style="mso-bidi-font-weight: normal;"> Company </b>><b style="mso-bidi-font-weight: normal;"> Subsidiaries > </b>view subsidiary >(<b>Tax</b>) <b style="mso-bidi-font-weight: normal;">Fiscal Calendar</b>)</span><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Calibri; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-bidi-theme-font: minor-bidi;'><o:p></o:p></span></b></p><font face="Times New Roman"></font><p class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; mso-list: l4 level1 lfo5; mso-add-space: auto;"><!--[if !supportLists]--><span lang="EN-US" style="font-family: Symbol; font-size: 9pt; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-ansi-language: EN-US; mso-fareast-language: EN-US;"><span style="mso-list: Ignore;">·<span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span><!--[endif]--><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-ansi-language: EN-US;'>User will navigateto <b style="mso-bidi-font-weight: normal;">Setup </b>><b style="mso-bidi-font-weight: normal;"> Accounting </b>><b style="mso-bidi-font-weight: normal;"> Manage(Tax) Accounting Periods > </b>choose <b style="mso-bidi-font-weight: normal;">FiscalCalendar</b> and either click <b style="mso-bidi-font-weight: normal;">Set UpFull Year</b> or enter in the <b style="mso-bidi-font-weight: normal;">New YearOnly </b>and <b style="mso-bidi-font-weight: normal;">New Quarter Only</b> one byone</span><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style='font-family: "Verdana","sans-serif"; font-size: 9pt; mso-fareast-font-family: Calibri; mso-bidi-font-family: "Times New Roman"; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-bidi-theme-font: minor-bidi;'><o:p></o:p></span></b></p><font face="Times New Roman"></font> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-4271111492509419562019-07-16T21:00:00.001-07:002019-07-16T21:00:12.803-07:00Add Item on a Sales Transaction: Sales Description and Item Price Do Not Populate<font face="Tahoma, Geneva, sans-serif" size="1">Cannot add an item on a Sales Transaction like Sales Order, Cash Sale or Invoice. </font><font face="Tahoma, Geneva, sans-serif" size="1">The item shows up on the list of items that can be added but when the user clicks on it, the sales description and price do not populate.</font><div style="font-family: Tahoma, Geneva, sans-serif; font-size: 8pt;"></div><font face="Tahoma, Geneva, sans-serif" size="1">When the user clicks the Add button, the item is not added on the line.</font><br><font face="Tahoma, Geneva, sans-serif" size="1"><br></font><br><font face="Tahoma, Geneva, sans-serif" size="1"><b>Solution:</b></font><br><font face="Tahoma, Geneva, sans-serif" size="1">1. On the Item record, navigate to the<b> Sales/Pricing tab > Sales description </b></font><font face="Tahoma, Geneva, sans-serif" size="1"><b>field</b> : there is a backslash or reverse slash <b>"/"</b> character at the end of the sales description.</font><br><font face="Tahoma, Geneva, sans-serif" size="1">2. Remove the </font><span style="font-size: x-small;"> backslash or reverse slash </span><b style="font-size: x-small;">"/"</b><span style="font-size: x-small;"> character</span><BR><font face="Tahoma, Geneva, sans-serif" size="1">3. Click <b>Save</b> </font><br><font face="Tahoma, Geneva, sans-serif" size="1"><br></font><font face="Tahoma, Geneva, sans-serif" size="1">After removing the </font><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;"> </span><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;">backslash or reverse slash <b>"/"</b></span><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;"> from the sales description, the user is now able to add the item on a sales transaction. The Sales description and Price automatically populate on the line item.</span><br><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;"><br></span><br><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;"><br></span><br><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;"><br></span><br><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;"><br></span><br><span style="font-family: Tahoma, Geneva, sans-serif; font-size: x-small;"><br></span> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-78833795965163764242019-07-16T20:00:00.001-07:002019-07-16T20:00:13.620-07:00Void Journal Entry Permission for Custom RoleTo be able to void <b>Journal Entries</b>, the user must have at least <b>Create</b> level of access for <b>Make Journal Entry</b> permission.<br><p> </p><p>Here are the steps to resolve this :<br><br></p><ol><li>Navigate to <b>Setup > Users/Roles > Manage Roles</b>.<b> </b></li><li><b>Edit </b>the role of the User.</li><li>Under the <b>Permissions </b>tab > <b>Transactions </b>subtab > <b>Make Journal Entry </b>= <b>Create</b>.</li><li>Click <b>Save</b>.<br></li></ol><p><br></p> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-18442563730129134232019-07-16T19:00:00.001-07:002019-07-16T19:00:13.924-07:00Expose Currency Revaluation Search Amount for Exhange Rate Variance Account Same as the Net Variance of the Currency Revaluation Record<P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">The values in the Amount column, are calculated based on the <B>Consolidated Exchange Rate</B> set in the <B>Results </B>tab of the Transaction Saved Search. If users would like the amount to be the same as the net variance shown on the Currency Revaluation Record, they can perform the following:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 10pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class=MsoNormal><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">1) <B>Edit </B>Search<o:p></o:p></SPAN></P><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 10pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class=MsoNormal><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">2) Under <B>Results </B>tab > <B>Consolidated Exchange Rate</B> = None<o:p></o:p></SPAN></P><P style="LINE-HEIGHT: normal; MARGIN: 0in 0in 10pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class=MsoNormal><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Tahoma; mso-fareast-language: EN-PH">3) Click S<B>ave & Run</B><o:p></o:p></SPAN></P><P> </P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-90199087064607133032019-07-16T18:00:00.001-07:002019-07-16T18:00:08.215-07:00Reason Why UPS Shipping Items Appearing in FedEx/More ListIf UPS Shipping Items appear in the Shipping Method dropdown after FedEx/More is selected as the Shipping Carrier check to see if the Shipping Item is integrated with UPS. <BR><BR>1. Any Shipping Items not integrated with UPS/FedEx will appear in the More section. These shipping items will all appear in the FedEx/More Carrier dropdown. <BR><BR>2. All Flat rate Shipping Items will also be in the More section and will appear in the FedEx/More Carrier Dropdown. <BR><P>3. Only UPS Shipping Items using UPS Real-Time Rates will appear in the UPS Carrier dropdown. <BR>-Check this by navigating to <B>Lists</B>> <B>Accounting</B>> <B>Shipping Items</B>> View the Shipping Item> In the <B>Shipping Rate</B> tab> check if <B>UPS Real-Time Rate</B> is selected. </P><P>4. To use the Shipping Items not using UPS Real-Time Rate the <B>Shipping Carrier</B> field needs to be set to <B>FedEx/More</B>. </P><P> </P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-71260488584499339682019-07-16T17:00:00.001-07:002019-07-16T17:00:10.467-07:00Find the Date when Vendor Bill is Fully Paid<P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-fareast-font-family: "Times New Roman"'>There is no field on the Vendor bill record that gives the information on when a vendor bill is fully paid directly on the UI.</SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-fareast-font-family: "Times New Roman"'>1) On a Vendor bill record, if you click on the <B style="mso-bidi-font-weight: normal">Related Records</B> tab, under the <B style="mso-bidi-font-weight: normal">payments sub tab</B> you will see the link to the bill payments that have been applied to set the status of the Bill to Paid in Full. The date when the bill is paid in Full is the link that has the latest date. The Related Records tab is available on Standard Vendor Bill form. If you use a custom form, please ensure to have this sub tab enabled on the form.<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-fareast-font-family: "Times New Roman"'>2) This date when a vendor bill is paid in full can be retrieved by using dateclosed field on the saved search where transaction type is vendor bill. In order to use dateclosed field:</SPAN></P><SPAN style='FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-fareast-font-family: "Times New Roman"'><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: 150%; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Tahoma'>- Navigate to <B>Reports > Saved Searches > All Saved Searches > New</B></SPAN><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"'><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: 150%; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"'><BR></SPAN></B><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"'>- Select <B>Transaction</B> link<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: 150%; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"'>- Set the following under <B>Criteria Tab > Standard Subtab:</B><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt 30pt; LINE-HEIGHT: 150%; TEXT-INDENT: -0.25in; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; tab-stops: list .5in"><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol'></SPAN><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: Symbol; mso-bidi-font-family: "Times New Roman"'> </SPAN><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 150%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Tahoma'>Type =Vendor Bill</SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"> </P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 115%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Tahoma; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA'>Under<B> Results Tab > Columns Subtab</B>, add following fields(choose other based on your preference) </SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; LINE-HEIGHT: 115%; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Tahoma; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA'> - dateclosed.</SPAN></SPAN></P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN style='FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-fareast-font-family: "Times New Roman"'></SPAN> </P><P class=MsoNormal style="MARGIN: 0in 0in 10pt; LINE-HEIGHT: normal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B><SPAN style='FONT-SIZE: 9pt; FONT-FAMILY: "Verdana","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Tahoma'><o:p> </o:p></SPAN></B></P> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-49014302596718918782019-07-16T16:00:00.001-07:002019-07-16T16:00:08.891-07:00Translation for Item Option Label not Displaying on the Web Store<p><span style="font-size: 9pt; font-family: Verdana, sans-serif;"><br>The value set in<span class="apple-converted-space"> </span><b>Customization</b><span class="apple-converted-space"> </span>><span class="apple-converted-space"> </span><b>Lists,Records, & Fields</b><span class="apple-converted-space"> </span>><span class="apple-converted-space"> </span><b>Transaction Item Options</b><span class="apple-converted-space"> </span>><span class="apple-converted-space"> </span><b>ItemOption</b><span class="apple-converted-space"> </span>> <b>Display</b><span class="apple-converted-space"> </span>tab > <b>LABEL FOR INPUT</b><span class="apple-converted-space"> </span>will override all languagetranslations set on the<span class="apple-converted-space"> </span><b>Translation</b><span class="apple-converted-space"> </span>sub tab.<o:p></o:p></span></p><p></p><p><span style="font-size: 9pt; font-family: Verdana, sans-serif;">To ensure that translations for itemoptions are used, leave the<span class="apple-converted-space"> </span><b>Labelfor Input</b><span class="apple-converted-space"> </span>field blank andjust enter the preferred translations under<span class="apple-converted-space"> </span><b>Translation</b><span class="apple-converted-space"> </span>><span class="apple-converted-space"><b> </b></span><b>Language</b><span class="apple-converted-space"> </span>><span class="apple-converted-space"> </span><b>Label</b><span class="apple-converted-space"> </span>(<b>Customization</b> > <b>Lists,Records, & Fields</b> > <b>Transaction Item Options</b> > <b>ItemOption).</b></span></p><p><span style="font-size: 9pt; font-family: Verdana, sans-serif;">Note as well that when LABEL FOR INPUT field (under Display tab) is blank, name of the custom field displayed in the Web Store will follow the LABEL field (Main area) value.</span></p> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-16033736166179012552019-07-16T15:00:00.001-07:002019-07-16T15:00:10.172-07:00Change Payment Terms on Invoice Sourced from Sales Order Instead of Billing Schedule via CSVWhen the Billing Schedule attached to a Sales Order has Payment Terms assigned, the Invoice created will follow the terms set on the Billing Schedule instead of the Sales Order, which populates from the Customer Record. <br><br>If you want to change Invoices already created to use the terms from the Sales Order instead a search can be created to find the affected Order and you can use the search to do a CSV Import to update the terms on the Invoices. <br><br>1. Create a search to find affected Invoices and the terms set on the Sales Order:<br> a) Navigate to <b>Reports> Saved Searches> All Saved Searches> New</b>: Select <b>Transaction<br> b) Rename the search<br></b> c) In the <b>Criteria </b>tab:<br> <b>Type = Invoice</b><br> <b>Applied to Transaction fields</b>... then select <b>Billing Schedule</b> <br> d) In the <b>Results </b>tab:<br> <b>Number<br> Applied to Transactions fields...</b> then select<b> Terms</b><br> e) <b>Save and Run</b><br> f) <b>Export as CSV</b><br> g) Save CSV file<br><br>2. CSV Import to Update Invoices with the Terms from the Sales Order:<br> a) Navigate to <span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"><b>Setup ><span class="Apple-converted-space"> </span><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Import/Export ><span class="Apple-converted-space"> </span><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Import<span class="Apple-converted-space"> </span><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">CSV<span class="Apple-converted-space"> </span>Records</I></I></I></b><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><span class="Apple-converted-space"> </span>and set the following:</I></I></I></span><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><br><p class="MsoListParagraphCxSpMiddle" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt 1in; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -0.25in; -webkit-text-stroke-width: 0px"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"><span style="FONT-SIZE: 9pt !important; FONT-FAMILY: Verdana !important">1.<span style="FONT: 7pt 'Times New Roman'"> <span class="Apple-converted-space"> </span></span></span></span><i><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Import</I></span></i><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><span class="Apple-converted-space"> </span>Type<span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">: Transactions</span></I></p><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><p class="MsoListParagraphCxSpMiddle" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt 1in; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -0.25in; -webkit-text-stroke-width: 0px"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"><span style="FONT-SIZE: 9pt !important; FONT-FAMILY: Verdana !important">2. <span style="FONT: 7pt 'Times New Roman'"> <span class="Apple-converted-space"> </span></span></span></span><i><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">Record Type</span></i><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">:<span class="Apple-converted-space"> </span><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Invoice</I></span></p><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><p class="MsoListParagraphCxSpMiddle" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt 1in; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -0.25in; -webkit-text-stroke-width: 0px"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">3. </span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">Browse the file from the computer and click Next.</span></p><p class="MsoNormal" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; -webkit-text-stroke-width: 0px"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"> b) </span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">In the<span class="Apple-converted-space"> </span><b>Data Handling</b>, choose<span class="Apple-converted-space"> </span><b><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Update</I></b><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">.</I></span></p><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><p class="MsoNormal" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: 0px; -webkit-text-stroke-width: 0px"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"> c)</span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"><span style="FONT-SIZE: 9pt !important; FONT-FAMILY: Verdana !important"><span style="FONT: 7pt 'Times New Roman'"> </span></span></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">Map the following in the<span class="Apple-converted-space"> </span><b>Field Mapping</b><span class="Apple-converted-space"> </span>page:</span></p><p class="MsoListParagraphCxSpMiddle" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt 1in; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -0.25in; -webkit-text-stroke-width: 0px"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"><span style="FONT-SIZE: 9pt !important; FONT-FAMILY: Verdana !important">1.<span style="FONT: 7pt 'Times New Roman'"> <span class="Apple-converted-space"> </span></span></span></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">Number – Number (<em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Invoice<span class="Apple-converted-space"> </span>folder)<br></I></span></p><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><p class="MsoListParagraphCxSpMiddle" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt 1in; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -0.25in; -webkit-text-stroke-width: 0px"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif">2. Terms - Terms (<em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Invoice<span class="Apple-converted-space"> </span>folder)</I></span></p><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><p><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"> d) Click <b>Next</b>. <br> e) <span style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; FLOAT: none; COLOR: rgb(0,0,0); TEXT-ALIGN: left; FONT: 11px Verdana; DISPLAY: inline !important; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -24px; -webkit-text-stroke-width: 0px">Enter an<span class="Apple-converted-space"> </span></span><b style="FONT-SIZE: 11px; FONT-FAMILY: Verdana; FONT-VARIANT: normal; WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT-STYLE: normal; TEXT-ALIGN: left; LETTER-SPACING: normal; LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -24px; -webkit-text-stroke-width: 0px"><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: ">Import<span class="Apple-converted-space"> </span>Map Name</I></b><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><span style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; FLOAT: none; COLOR: rgb(0,0,0); TEXT-ALIGN: left; FONT: 11px Verdana; DISPLAY: inline !important; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -24px; -webkit-text-stroke-width: 0px"><span class="Apple-converted-space"> </span>and click<span class="Apple-converted-space"> </span></span><b style="FONT-SIZE: 11px; FONT-FAMILY: Verdana; FONT-VARIANT: normal; WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT-STYLE: normal; TEXT-ALIGN: left; LETTER-SPACING: normal; LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -24px; -webkit-text-stroke-width: 0px">Save & Run</b><span style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; FLOAT: none; COLOR: rgb(0,0,0); TEXT-ALIGN: left; FONT: 11px Verdana; DISPLAY: inline !important; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -24px; -webkit-text-stroke-width: 0px">.</span></I></span></p><em class="rn_Highlight" style="FONT-WEIGHT: bold; FONT-STYLE: normal; TEXT-DECORATION: "><p><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana, sans-serif"><span style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; FLOAT: none; COLOR: rgb(0,0,0); TEXT-ALIGN: left; FONT: 11px Verdana; DISPLAY: inline !important; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -24px; -webkit-text-stroke-width: 0px"></span> </span></p><p class="MsoListParagraphCxSpMiddle" style="WHITE-SPACE: normal; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); PADDING-BOTTOM: 0px; TEXT-ALIGN: left; PADDING-TOP: 0px; FONT: 11px Verdana; PADDING-LEFT: 0px; MARGIN: 0in 0in 0pt 1in; LETTER-SPACING: normal; PADDING-RIGHT: 0px; BACKGROUND-COLOR: rgb(255,255,255); TEXT-INDENT: -0.25in; -webkit-text-stroke-width: 0px"><br></p></I></I></I></I></I></I></I></I></I> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0tag:blogger.com,1999:blog-7833645889341614736.post-50012208952269228572019-07-16T14:00:00.001-07:002019-07-16T14:00:08.716-07:00Search Saved to Show Profitability Per Transaction<p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">To create this search please follow the steps below:</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'"></span> </p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">1) Navigate to <b>Reports</b> ><b> New Search</b> > <b>Transaction</b></span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">2) Under <b>Criteria </b>tab:</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">--<b> </b>Add <b>Type</b> is <b>Sales Order</b></span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">-- Add<b> Main Line</b> is False</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">3) Under <b>Results </b>tab:</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">-- Add<b> Sales Rep</b> -- Summary Type is Group</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">-- Add<b> Number</b> (this is the SO number) -- Summary Type is Group<br>-- Add <b>Amount</b> -- Summary Type is Sum<br>-- Add <b>Item</b> <br>-- Add <b>Quantity </b><br>-- Add<b> Item Fields</b>...<b>Purchase Price</b> (this is the cost of the item)-- Summary Type is Sum -- Label is Cost<br>-- Add <b>Formula (Numeric)</b> = {quantity}*{item.cost} -- Summary Type is Sum -- Label is Total Cost</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">-- Add<b> Formula (Numeric)</b> = {amount}-({quantity}*{item.cost}) -- Summary Type is Sum -- Label is Profit</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">4) <b>Create Saved Search</b></span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">5) Rename Search</span></p><p class="MsoNoSpacing" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Tahoma','sans-serif'">6) Click <b>Save & Run</b></span></p> Netsuite Developerhttp://www.blogger.com/profile/17025259763347877658noreply@blogger.com0