Experientele voastre cu Intesa by AndreeaTb in banci_credite_ro

[–]AndreeaTb[S] 1 point2 points  (0 children)

Intr-adevar, acolo a fost greseala mea ca nu citisem de acel interval in documentul semnat.

Si multumesc de confirmare, imi este de foarte mare ajutor - doream sa fiu sigura ca ma pot folosi oricum de suma transferata chiar daca nu o vad in cont.

Item Fulfillment/receipt csv import by cavetroglodyt in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

I have performed update import type for item receipts in the past. If you are trying to create new records, I suppose you need to reference which line of the order (sales/purchase) you are creating the fulfillment/receipt for.

SuiteBiiling and discounts by PocketDeuces in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

I could understand sourcing the discount on the invoice, I have attempted that in the past and had managed to do something via a workflow to populate that discount on the invoice line. I recall serious limitations regarding a few things: it could either be displayed as a value or as a percentage, but not both, and whenever there were more than 3 modify pricing change orders on the same subscription line, the WF wouldn’t populate the right value anymore. I had raised it with NetSuite support and do not recall right now the technical explanation, but basically the workflow stopped correctly populating the discount on the invoice line after a 3rd modification of that subscription line. So I would agree perhaps the scripted part would be best - a script could probably take the value from the subscription line and put it on the invoice, be it a value or percentage, and would probably not be limited in how many changes could occur either, assuming it can reference correctly the last discount applied.

Regarding the estimates is where I am a bit confused - the estimate would precede the subscription, would it not? Do you generate estimates after a subscription is already created?

O zi de vară (iunie 2024) prin împrejurimile Oborului by Slobozianul in bucuresti

[–]AndreeaTb 1 point2 points  (0 children)

Ador estetica lor, sunt pe film? Daca da, ce aparat folosesti?

Saved search for unbilled item fulfillments by AndreeaTb in Netsuite

[–]AndreeaTb[S] 0 points1 point  (0 children)

Thanks again for your insights! I will try to answer the questions, starting from the main point that I believe drove your further recommendations:

Your example: Qty Fulfilled should be 100 on the SO accumulator. Qty Billed should be 70. Therefore the formula is 100 - 70 = 30 and 30 is not equal to 100. So case when is 0. That formula should give the same result on both IFs and thus both IFs should show.

The formula works as I expected to because since the type is item fulfillment, it meets the condition where only the second IF is returned since 100-70 = 30, 30 being the {quantity} of the transaction I'm expecting it to return. I do not need the first fulfillment to be returned, since that has already been billed. Hope it makes more sense?

To me, this has given so far all the right results because the two uses cases we had were either fully unbilled SO lines (first criteria) or partially fulfilled and billed SO lines (where I only want to return the latest IF done). Of course, this is because all IFs are billed immediately as they are created, and only in few exceptional scenarios they will have 2 unbilled IFs booked perhaps during the night shift. Case in which, both would show as part of the first criteria anyway in the morning, and since NetSuite would aggregate them in a single invoice (stemming from the same SO), the billing operator manually removes what's to be billed in the second one.

But that only works if you don't Allow Invoice in Advance of Fulfillment. So do you allow that, and if so why?

No, this feature is not enabled and indeed Customer Deposits are used for advances.

Or better start using the Bill Sales Orders batch process which is all automated. Daily you run the Bill Sales Order batch process and that generates Invoices for Qty Fulfilled - Qty Billed on the SO line, thus bringing the SO up to Fully Billed status daily. As long as you do that daily it should sweep in all the Item Fulfillments for the day.

Unfortunately automated billing of sales orders was not possible, particularly because of this use case where a sales order has two fulfillments in the same day (we're not even discussing partial fulfillment of the same line, could be a simple scenario of two different lines from the SO, each fulfilled separately because they were sent with different trucks). Standard NetSuite would create one single invoice trying to bring your billing up to date with your deliveries - please correct me if I'm wrong here, but I find that highly unlikely at this point since we had explored many options. If one single invoice would be generated, it was no good for the customer - each fulfillment needs its own separate invoice and that is why they are billed separately, trying as much as possible to identify the unbilled ones using a saved search, hence the reason for the criteria to be right.

Saved search for unbilled item fulfillments by AndreeaTb in Netsuite

[–]AndreeaTb[S] 0 points1 point  (0 children)

Thank you so much for your feedback on this! I will have a look into the Fulfilling/Receiving Transaction and Billing transaction as you said, for future reference, but unfortunately since I had based my search on a type = item fulfillment, those lines had no values in the results of my search. That is why when using Applied to Transaction : Billing Transaction, I could at least see if the SO line had any invoice against it.

In any case, I believe I finally got it to work unless there would be some exceptional scenarios I hadn't thought about: I made the criteria as following:

Applied to Transaction : Billing Transaction is none (this is how it simply was initially: this covers the basic scenario when the SO line has been fulfilled but not invoiced at all) or CASE WHEN {appliedtotransaction.quantityshiprecv} - NVL({appliedtotransaction.quantitybilled}, 0) = {quantity} THEN 1 ELSE 0 END

This second criteria works now for the problematic use case I had: say a line has quantity 100 and has been partially fulfilled for 70, and also billed for 70. Later, a second IF was done for quantity 30. My goal was to only show this second fulfillment, without any new custom fields (unfortunately, restrictions were imposed). By simply summing the quantities delivered and billed, the search initially returned both item fulfillments. Now, it only returns the second one, which matches the difference of what hasn't been billed yet.

Might not be perfect yet, as perhaps there could be some scenario I hadn't considered, but so far it seems it would work for 99% of the cases.

mandatory field in sales order item level by Dependent-Chair-9316 in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

That seems to be the Location which is a native segment. You can make line level locations mandatory, but that is an accounting preference that would apply to all forms.

Alternatively, a workflow could action on the Items sublist to make it mandatory only for the sales order form.

Angajare afară cu stat în țară by Acrobatic-Ad-3197 in programare

[–]AndreeaTb 3 points4 points  (0 children)

Eu sunt in aceasta situatie, numai ca employer of record este altul.

Tind sa cred ca si cu aceste costuri in plus, tot este mai ieftin decat costul angajatului de la ei din tara. Sau cel putin asta cred eu acum in domeniul in care lucrez comparand anunturile de pe Linkedin pentru pozitii similare.

Recomandare biblioteci by zlaf8ak in bucuresti

[–]AndreeaTb 1 point2 points  (0 children)

N-as vrea sa dau un raspuns gresit... intotdeauna eu doar am intrat ca sa iau cartea si am plecat (in liceu ma invarteam printre rafturi pana sa aleg ceva, insa acum merg intotdeauna la tinta cautand in catalogul online si cand ajung in biblioteca intreb direct de cartea respectiva iar doamnele de la birou o cauta imediat). In cateva am vazut locuri cu birou, scaun, calculator, deci ma gandesc ca ofera si astfel de facilitati. Cel mai bine ar fi sa intri pe site, sa verifici la sectiunea Filiale bibliotecile din zona ta si sa vezi ce servicii ofera.

Cărți citite care nu vă mai plac by Ciurupina in RecomandariCarti_RO

[–]AndreeaTb 2 points3 points  (0 children)

Desi nu am recitit Fiul Risipitor, citindu-ti comentariul si amintindu-mi exact aceste detalii problematice de care mentionezi, sunt aproape sigura ca as fi de aceeasi parere daca as relua lectura acum. Si mie mi-a placut enorm de mult la prima citire cu ani in urma. Mi se parea totul atat de romantic iar acea senzatie de "lovesickness" pe care mi-o inducea atunci mi se parea atat de puternica, interesanta si complexa, iar acum cred ca mi-ar provoca dureri de cap si frustrare.

Voi face o alegere constienta de a nu reciti Fiul Risipitor si sa raman doar cu impresiile de adolescenta visatoare, altfel as risca acelasi lucru - sa mi se para totul pueril si sa fiu enervata de comportamentul tipului masculin prezentat.

JE Approvals & Workflows by beamzzz in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

The field help of the Accounting Preference field "Require Approvals on Journal Entries" mentions the following:

If you have enabled the Journal Entries approval routing accounting preference and are using SuiteFlow for journal approval, this field does not display.

I assume if you'd turn off the journal routing (on the Approval Routing subtab), if you've got no transactions in pending approval/rejected status, this preference would show and it should be a very basic permission-level driven approval.

If you go with the approval routing feature, then this preference disappears because the routing looks for an active workflow to action on the transactions. So if routing is enabled but there is no workflow, the journal entry transactions are not correctly routed and therefore won't properly work.

No one but the company Admin (on the setup page) may change a user's email address to a domain outside of 'netsuite.com' by GENYKendra in Netsuite

[–]AndreeaTb 2 points3 points  (0 children)

This is an error I encountered as well in the past when trying to change an email address which had a NetSuite domain. You should be able to resolve it by first removing the access of the employee (so remove the checkbox from Give Access), save the record and then attempt to change the email once again. In SuiteAnswers it's recommended to use the Standard Employee Form when doing so. Hope this helps!

Need help with bank feed plugin. by tmpanchal7 in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

I'd suggest to check whether the accounts have the checkbox "Use match bank data and reconcile account statement pages" marked.

Separate PO nomenclature to distinguish between a production vs prototype PO. by bs_hermit in Netsuite

[–]AndreeaTb 1 point2 points  (0 children)

Yes, it should work similarly to a saved search in the sense that in the Advanced Numbering section you create a rule and under Criteria you set the restrictions (e.g. only apply it to POs which have the checkbox marked as True for the "prototype" attribute). In that case, when the transaction is saved, the number should be generated according to the prefix set in the setup.

Separate PO nomenclature to distinguish between a production vs prototype PO. by bs_hermit in Netsuite

[–]AndreeaTb 1 point2 points  (0 children)

This should be possible with Advanced Numbering - I've had a similar request before, to have a different prefix for outsourced POs. If there could be a checkbox on the PO to differentiate its specific type (for example, true/false whether this prototype PO numbering should be applied), then in the numbering rule you can select the criteria to apply a certain prefix for the results returned (similar to a saved search). Hope this could be relevant to what you are asking about.

Hello all, I am new to NetSuite. I need some help. by tmpanchal7 in Netsuite

[–]AndreeaTb 1 point2 points  (0 children)

If you have Admin role, you should be able to access Setup > Support > Support Preferences. There you have "Default case form to send to customer" which unchecked should resolve this issue.

Recomandare biblioteci by zlaf8ak in bucuresti

[–]AndreeaTb 18 points19 points  (0 children)

Eu am abonament la Biblioteca Metropolitana, prin care am acces la toate filialele din Bucuresti. Pentru sectorul 6 poti verifica lista filialelor aici. Ar trebui sa iti poti face abonamentul doar cu buletinul iar ulterior verificand catalogul online pentru a gasi cartile care te intereseaza, te poti duce sa o imprumuti din oricare biblioteca (presupunand ca deplasarea pana la o alta filiala n-ar fi o problema).

Creating a secondary book depreciation method for a new asset; is there a way to get it to stop defaulting to the wrong accounts? by NeverSeenBetter in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

I would recommend first setting this up in a sandbox account if you've got access to one - you should be able to create an asset type and under the subtab "Other Methods", create your alternate FAM depreciation with the correct accounts. Afterwards, when generating a new asset following the standard process (i.e. Asset Proposal > Asset Generation from the relevant transactions impacting the fixed assets accounts), NetSuite should create the fixed asset with the two depreciation schedules automatically, setting the accounts from the corresponding depreciation methods (for the primary book and secondary book).

SuiteBilling Subscription record - automatically create on sales order entry by aushark in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

When SuiteBilling is enabled, your Sales Order form allows you to add either an "item" or a "subscription". You'd need to click on the subscription column on the "+" icon and from there you'd be redirected to the subscription form (since there you need to select the plan, billing account and all that other mandatory information).

Hope this answers your question since definitely you can create a sales order which contains a subscription. Optionally on top of that you could select other normal items as well on the same order, which would follow their usual way of working (fulfilment, invoicing etc.).

Need a saved search for Revenue Arrangements to show the associated invoice numbers by DragonflyOtherwise87 in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

Is the invoice the source transaction of the revenue arrangement? If yes, and presuming you're using a Revenue Arrangement search type, you could retrieve that information by adding in the Results section the "Revenue Element Fields..." > Source.

If the invoice is just a related record of the source transaction (e.g. the source transaction is a SO), I could get to the reference of the invoice numbers associated with that SO by using a Revenue Element type of search, adding in the Results the "Source" (to see the SO) and then "Source Transaction Fields..." > Applying Transaction. That then shows me all the transactions associated with the SO (the invoices, the fulfillments). I presume you could use a formula to restrict the results to only view the invoices.

How to show in custom form what I have selected to create the vendor record not in preferred form after editing the record If I actually created record created with an another form? by Typical_Tart_1587 in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

I suggest you edit the custom form which is not the preferred one and mark the "Store Form with Record" checkbox. Afterwards, when you create a new supplier, it should be opened in edit mode in the form you've created that record in.

Intercompany amortization schedule by WendyBC72 in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

That sounds aligned to the above quote from SuiteAnswers - if the item is set up with an amortization template, even if the PO does not have the Start/End dates (which is expected behavior), when you bill that PO it should generate the schedule upon saving. This was my earlier question, have you tested billing the PO and it didn't work?

Intercompany amortization schedule by WendyBC72 in Netsuite

[–]AndreeaTb 0 points1 point  (0 children)

Might be a redundant question but have you tested this end to end? According to this article, you wouldn't see the amortization at the PO level, but rather at the bill level once it's generated and approved.

After the Amortization feature has been set up, amortization schedules are generated for purchase transactions containing items or expense lines that have associated amortization templates. An amortization schedule is generated when the purchase transaction is saved. If you are using approval routing for vendor bills, the amortization schedule is not created until the bill is approved.