3946007 Green Ribbon

That would be helpful. Is there anyone who can confirm the old code is still working or has heard anything new about it? (Susanne)

Try something similar to this to get you started, it will show you last sale date, last receipt date and difference between the two; Create an Item Search CRITERIA Inactive=False RESULTS Item = Group BY Available = Maximum Formula(Date) = Maximum DECODE({transaction.type}, 'Sales Order', {transaction.trandate}, '') (Custom…

We've got something similar, basics below should get you started; Item Saved Search CRITERIA Inactive=False RESULTS Item = Group Available = Maximum Formula (date) = Maximum DECODE({transaction.type}, 'Sales Order', {transaction.trandate}, '') Should get you started.

Hi Jim, We run these searches all the time, although I'm not that experienced with results for Kit/Assemblies. Going back to the very basic use case, from my experience you should be getting some results when using criteria Available = less than equal to zero, but as you are seeing, one thing is that when Available or On…

Not sure about your particular use cases, but essentially a barcode scanner is just a keyboard...So basically any field that you can type into you can use a barcode scanner to input data...

Thankyou Olivier! Appreciated. I still seem to be having a problem though. Items that have no history at all - i.e. no PO, no Item Receipt, no SO etc etc appear in the report - this is as expected. But Items that have a PO, Item Receipt and Bill but that have no Sales History / Invoices do not appear.... not as expected...…

Anyone? I have been trying for a couple of days now... How do we do a saved search against items where a transaction has not happened within a time period? Please... Peter

I ran into something similar and loosely solved it by replacing the ELSE 0 with "0.0000001" in the denominator (divide by) portion of the forumla. It's not mathematically perfect but should be accurate when rounded to hundredths.

Thanks for the reply Wizard of Oz, but do you have idea on how i can put the value of <%=getCurrentAttribute('item','custitemid')%> on the browsers web title tab. Thanks.:)

Thanks Eric_TrueCloud we could do this as an alternative, but using javascript will not take effect on SEO side.

Thanks for the reply Olivier... Just to further explain the use case. When my warehouse staff are receiving a purchase order I would like for them to be able to update an items weight using a column on the Item Receipt transaction form... Would this require scripting? Cheers, Pete

In essence, categories are just like another facet in SCA. The SiteBuilder categories cannot be displayed. You use Content Delivery to then customise the text/images etc that you want displayed at a category level. In short, the traditional category structure from SiteBuilder is not supported.

Let's hope that NS decide to implement a flexible pricing policy on the Ignite module. P

PureModern, The best way to achieve the Page Title would be to do a saved search with the item name (or whatever field that you wish to incorporate into the page title), export this to MS Excel, then do a concatenate function to join the Item Name + the static text you wish to incorporate. How you handle this in the future…

Thanks Madhur & jpacifics for your responses. I've had a try doing this with workflow - and still don't seem to have any luck. I have included screenshots of my current setup. https://system.netsuite.com/core/media/media.nl?id=321891amp;c=732990&h=ba3b301e2851adec49bd…

Thanks very much Tim. Cheers, Pete

Thanks for the replies - have investigated Assembly Unbuilds, which theoretically works, but is obviously quite cumbersome. Will examine further.

I'm not sure why you say it's not possible? Any specific reason why not? The data is there, you just need to run a couple of saved searches, then some quick analysis in Excel. At the risk of repeating what I said above, here is a starting point for the criteria you need. This is a fairly rudimentary method of calculating…

Run a transaction saved search (similar criteria to your previous question the other day) but with mainline=yes. Output Amount as an Average. This will give you your average sale value. For number of repeat transactions, once again, very similar to previous criteria but Group by customer, and count of number will give you…

Transaction Saved Search Criteria Type=Sales Order (or cash sale depending on when your recognise the sale) Main Line = No Account = COGS Date = Your date Range Results Internal ID (Group By) Quantity (Sum) That should get you started anyway...

THanks Fred. I am not sure where the credit to their account would come from. If I close the Sales Order witht the BackOrdered item it has no effect on their financial balance? Thanks, P

Thanks for your assistance :) Pete

Great! Thanks Wiz :)

Wow - thanks Vijay - that is scary that I didn't know that :)... Are there any other transactions apart from Item Receipt, Item Fulfillment, Inventory Adjustment, Cash Refund that affect inventory counts? Thanks! Pete

Doesn't solve the issue, but I have a saved search set up that alerts to changes made to pricing on a SO.

RF-Smart is what we use. We don't use Lot's so can't comment on the suitability there.

Company: BestBrandsDirect.com.au Licenses: 10 Business: Online Retail Location: Perth Primary use of NS: Online Store, Inventory, Order Mgmt, Accounting Major Frustrations: No shipping integration, very inflexible ecommerce functionality which will become outdated very quickly

Thanks for the input. The issue is that we create 100 of these each week, each with a different discount amount, so very cumbersome to create a matching Campaign to every promotion code. Perhaps the one work around might be to create 100 promo code with 100 matching campaigns, then rotate the usage of these promo codes…

Any update Jamie? Cheers, Pete

Very nice - the iPad, Serialo pairing looks like it would be effective for our warehouse staff too....