
An
inquiry screen is used to extract information from one or more table and
present it in the from of a grid. It help us to display the records based on
the filter criteria we entered.
In
Sage X3, we have a multiple inquiry screens available such as Stock by product,
stock by lot,stock by site etc where we can search a stock available by product
wise, lot wise and site wise etc. Stock by product screen help us to check the
stock of a product we want to search by specifying the name of the product in
the field. But if want to search based on some condition we can search the same
by creating a formula. Sage X3 provide us a functionality of creating a formula where we can create a formula
based on any condition.
Sage
X3 allows the user to add formula to inquiries criteria that can help to filter
a specific record based on the condition specified in the formula. Here we want
to search a stock of a product only whose product status is active.
To
create a formula follow the below steps:
Navigate
to : Set
up > General Parameters > Formula
- Click
new to create a formula. - Select
the formula type as “Stock selection”. - Provide
the code , description and short description. - Enter
the condition in the formula based on which you need to search a product.
We have specified [F:ITM]ITMSTA=1 as
we want to search the product whose status is active.
- Click on the create button. Refer the below figure

In
this way we have to created a formula
named as ZSP and now we can use the same formula in inquiry screen.
Follow
the below steps to add the formula in inquiry screen:
Navigate to : Stock > Inquiries > Stock by Product.

Here we have specified the
product in the From product and To product field and clicked on search so we
can see the stock available for those product. If we wont specify any product
and click on search then all the products will get display whose status is
active as well as in active.
Since we need to search for all those product whose status is active. Click on the criteria button on the right side. Refer the below figure.

The
below window will get pop up. Scroll down to enter the formula.
Select
the formula you have created by clicking on the selection. Then click ok.
Once
you click on OK, then all the product will get display whose status is active.
Refer the below figure.

In this way we can create a formula based on which we want to search a product and can be used in the inquiry screen.
In this blog, we came to know how we can create a formula and to use those formula in the inquiry screen.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence.
Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU integrations include Sage X3 for Sage CRM, Salesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide.
Greytrix is a recognized Sage champion ISV Partner for GUMU Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU
integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU
integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.
For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We will like to hear from you.
Viagra Ontario no online order prescription viagra Cialis Pericoloso
Any Danger In Using Expired Amoxicillin lasix side effects in elderly buy lasix uk
Cialis 20mg 12 St prednisolone para que sirve sildenafil cialis generico
priligy reviews Priligy Correct Dosage Of Amoxicillin
I’m not that much of a online reader to be honest but
your sites really nice, keep it up! I’ll go ahead and bookmark your site to come back down the road.
All the best
A motivating discussion is definitely worth comment. There’s no
doubt that that you ought to publish more about this subject, it might not
be a taboo matter but typically folks don’t talk about such subjects.
To the next! Cheers!!
I want to to thank you for this excellent read!!
I definitely loved every bit of it. I have got you
bookmarked to look at new stuff you post…
Oh my goodness! Amazing article dude! Many thanks, However I am going through difficulties
with your RSS. I don’t know why I cannot join it. Is there anyone else getting similar RSS issues?
Anybody who knows the answer can you kindly respond? Thanx!!
Hello there, I discovered your web site by the use of
Google whilst looking for a related subject,
your site came up, it appears to be like great. I’ve bookmarked it in my google bookmarks.
Hello there, just turned into aware of your blog through Google, and found that
it is truly informative. I am gonna watch out for brussels.
I’ll appreciate should you continue this in future.
Numerous other folks will probably be benefited out of your writing.
Cheers!
Excellent post. Keep writing such kind of information on your page.
Im really impressed by it.
Hello there, You’ve done an incredible job. I will definitely
digg it and in my opinion recommend to my friends.
I’m confident they’ll be benefited from this web site.
Does your website have a contact page? I’m having trouble
locating it but, I’d like to shoot you an email. I’ve got
some creative ideas for your blog you might be interested in hearing.
Either way, great blog and I look forward to seeing
it grow over time.
Great blog you have got here.. It’s difficult to find good quality writing
like yours nowadays. I really appreciate individuals like you!
Take care!!
I don’t even understand how I stopped up right here, however I assumed this submit
was once great. I do not recognise who you are
however certainly you are going to a famous blogger in the event you are not already.
Cheers!
certainly like your web-site however you need to test the spelling on quite a
few of your posts. Several of them are rife with spelling problems and I find it
very bothersome to inform the truth on the other hand I will certainly
come back again.
Very nice article, totally what I needed.
Hi there, just wanted to say, I loved this post.
It was helpful. Keep on posting!
If some one wants expert view concerning running a blog afterward
i recommend him/her to pay a quick visit this web site, Keep up the pleasant job.
Thank you for the good writeup. It in fact was a amusement account it.
Look advanced to more added agreeable from you!
However, how could we communicate?
You can certainly see your skills within the article
you write. The world hopes for even more passionate writers like you who are not afraid to say how they believe.
At all times go after your heart.
Very good article. I will be dealing with a few of these issues as well..
Hi there! I could have sworn I’ve visited this blog before but
after browsing through many of the articles I realized it’s new to me.
Anyhow, I’m certainly happy I came across it and I’ll be book-marking
it and checking back regularly!
I visited many sites except the audio quality for audio songs present
at this website is truly fabulous.
Hello, this weekend is nice for me, because this occasion i am reading this
impressive educational piece of writing here at my home.
If some one wants expert view regarding blogging and site-building after that i advise him/her
to go to see this web site, Keep up the pleasant work.
If you would like to get a great deal from this piece of writing then you have to apply these methods to your won web site.
Just desire to say your article is as amazing. The clarity in your post is just great and i
could assume you are an expert on this subject. Well with your
permission let me to grab your RSS feed to keep up to date with forthcoming post.
Thanks a million and please continue the enjoyable work.
I’ve been browsing online more than 4 hours
today, yet I never found any interesting article like yours.
It’s pretty worth enough for me. In my view, if all site owners and bloggers made good content as
you did, the net will be a lot more useful than ever
before.
It is in point of fact a nice and useful piece of information. I’m satisfied that you shared this helpful information with us.
Please keep us informed like this. Thank you for sharing.
Hi, I do believe this is a great site. I stumbledupon it ;
) I will revisit once again since i have saved as a favorite it.
Money and freedom is the greatest way to change, may you be rich
and continue to help others.
hey there and thank you for your information – I have certainly picked up
anything new from right here. I did however expertise some technical points using
this site, since I experienced to reload the web
site a lot of times previous to I could get it to load correctly.
I had been wondering if your hosting is OK?
Not that I am complaining, but sluggish loading instances times will sometimes affect your placement in google and
can damage your high quality score if ads and marketing with Adwords.
Anyway I’m adding this RSS to my e-mail and could look out
for much more of your respective exciting content. Make sure you update this again very soon.
Thanks for the auspicious writeup. It in reality used to be a entertainment
account it. Look complicated to more added agreeable from
you! By the way, how can we be in contact?
Howdy! I know this is kinda off topic but I’d figured I’d ask.
Would you be interested in trading links or maybe
guest writing a blog post or vice-versa? My blog
covers a lot of the same subjects as yours and I feel we could greatly benefit from each other.
If you happen to be interested feel free to send me an e-mail.
I look forward to hearing from you! Wonderful blog by the
way!
Hey there just wanted to give you a quick heads up.
The text in your content seem to be running off the screen in Opera.
I’m not sure if this is a format issue or something to do with browser compatibility but I thought I’d post to let you know.
The design look great though! Hope you get the issue fixed soon. Kudos
Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my
blog that automatically tweet my newest twitter updates.
I’ve been looking for a plug-in like this for quite some time and was hoping
maybe you would have some experience with something like
this. Please let me know if you run into anything.
I truly enjoy reading your blog and I look forward to your new updates.
When I originally commented I clicked the
“Notify me when new comments are added” checkbox and now each time a comment is added I get four e-mails with
the same comment. Is there any way you can remove me from that service?
Bless you!
Всі фільми новинки 2020 року онлайн українською в хорошій якості link
Новинки фільми, серіали,
мультфільми 2021 року, які вже вийшли Ви можете дивитися українською на нашому сайті link
Thank you for the auspicious writeup. It if truth be told was once a
enjoyment account it. Look advanced to more added
agreeable from you! However, how can we communicate?
Have you ever thought about writing an e-book or guest authoring on other
websites? I have a blog based on the same topics you discuss and would really like to have you
share some stories/information. I know my visitors would enjoy your work.
If you’re even remotely interested, feel free to shoot me an email.
Hi there friends, how is all, and what you would like
to say about this piece of writing, in my view its truly amazing in support
of me.
I’m gone to convey my little brother, that he
should also pay a quick visit this weblog on regular basis to
obtain updated from most up-to-date gossip.
I do agree with all the ideas you’ve offered to your post.
They are really convincing and can certainly work.
Nonetheless, the posts are very quick for novices. May you please prolong them a bit
from next time? Thank you for the post.
Thanks for sharing such a nice idea, paragraph is fastidious, thats why i have
read it entirely
Не пропустіть кращі новинки кіно українською 2021 року link
Дивитися фільми онлайн в
HD якості українською мовою link
Фільми українською в хорошій якості – онлайн без реклами link
Всі фільми новинки 2020 року онлайн українською в хорошій якості link
Нові фільми 2021 року. link
Дивитися фільми українською мовою онлайн в HD якості
link
Дивитися популярні фільми 2021-2021 року link
Greetings! I’ve been reading your weblog for a while now and finally got the bravery to go ahead and give you a shout out
from Houston Texas! Just wanted to mention keep up the good job!
I was curious if you ever thought of changing the page layout of
your blog? Its very well written; I love what youve got to say.
But maybe you could a little more in the way of content so people could connect
with it better. Youve got an awful lot of text for only having one or 2 images.
Maybe you could space it out better?
Hello There. I found your blog using msn. This is an extremely well written article.
I’ll be sure to bookmark it and return to read more of your useful information.
Thanks for the post. I will certainly return.
Greetings, I do think your site may be having browser compatibility issues.
When I take a look at your web site in Safari, it looks
fine however, if opening in Internet Explorer, it’s got
some overlapping issues. I merely wanted
to give you a quick heads up! Other than that, fantastic blog!
Excellent weblog right here! Additionally your
site a lot up fast! What host are you using? Can I get your affiliate link to your host?
I desire my website loaded up as quickly as yours lol
Hello to every one, the contents present at this website are really amazing for
people knowledge, well, keep up the nice work fellows.
Awesome site you have here but I was wanting to know if you knew of any user discussion forums that
cover the same topics discussed in this article? I’d really like to be a
part of online community where I can get comments from
other knowledgeable individuals that share the same interest.
If you have any suggestions, please let me know.
Cheers!
You can certainly see your enthusiasm within the work you
write. The sector hopes for even more passionate writers like you who are not afraid to mention how they believe.
At all times go after your heart.
Hello to every one, it’s in fact a good for me to pay a quick
visit this website, it contains precious Information.
Hi, I do think this is a great website. I stumbledupon it
😉 I will revisit once again since i have book marked it.
Money and freedom is the greatest way to change, may you be rich and continue to guide
other people.
Hello there, I found your website by the use of Google at the same time as searching
for a comparable matter, your website got here up,
it looks great. I have bookmarked it in my google bookmarks.
Hi there, simply become aware of your blog via Google, and found that it’s really informative.
I am going to be careful for brussels. I’ll appreciate for those who continue this in future.
Lots of other people will be benefited from your writing.
Cheers!
I think the admin of this web page is genuinely working hard for his web page, as here every
information is quality based stuff.
Найкращі українські фільми 2021 року Папы 2022
Дивитися фільми онлайн в HD якості українською мовою Папы 2022
Дивитися фільми українською мовою онлайн в
HD якості Link
Найкращі фільми 2021 Папы 2022
Нові фільми 2021 року. Наруто Ураганные Хроники 424 серия (2 сезон)
Дивитися популярні фільми 2021-2021 року смотреть форсаж хоббс и шоу хорошем качестве
https://stromectolis.com/# stromectol over the counter
Не пропустіть кращі новинки кіно українською 2021 року Моя собака Идиот
Дивитися фільми українською мовою онлайн в HD якості Link
Фільми українською в хорошій
якості – онлайн без реклами Link
Фільми та серiали 2020 українською мовою в HD якості Link
Фільми та серiали 2020 українською мовою в HD якості Link
Фільми українською в хорошій якості – онлайн без реклами Link
Нові сучасні фільми дивитися українською мовою онлайн в хорошій якості HD Вечер с Владимиром Соловьевым
Всі фільми новинки 2020 року онлайн українською в хорошій
якості Вечер с Владимиром Соловьевым
Дивитися фільми українською онлайн filmiwap.store
Нові сучасні фільми дивитися українською мовою онлайн в хорошій якості HD Захар Беркут
non prescription viagra alternative viagra stories pictures what happens if women take viagra
how to tell if a man is taking viagra do you need prescription for viagra what happens if a woman takes viagra
plaquenil weight loss reviews plaquenil for covid buy plaquenil
plaquenil lupus hydroxychloroquine 200 mg for sale plaquenil weight gain
purchase oral ivermectin minocycline 100mg tablets ivermectin generic cream
hydroxychloroquine online purchase hydroxychloroquine for sale online plaquenil price
prednisone 20 no prescription prednisone canadian pharmacy prednisone 10mg cost
us cialis purchase buy cialis south africa best ed cialis pills
medicines for ed cheap medications online ed drugs online from canada
prednisone sale 20mg prednisone 10mg prednisone daily
generic cipla cialis cialis what makes you harder viagra or cialis
prednisone 5mg coupon buy prednisone online prednisone nz
prednisone over the counter buy prednisone prednisone 50
ed drugs compared ed natural treatment cheap pet meds without vet prescription
can ed be cured soma therapy ed fast ed meds online
ed meds online canada how can i order prescription drugs without a doctor prescription drugs canada buy online
prescription drugs without prior prescription best non prescription ed pills canadian online pharmacy
canadian pharmacy online cvs prescription prices without insurance buy prescription drugs from canada cheap
cures for ed non prescription ed pills best ed treatment
reputable canadian mail order pharmacies discount prescription drugs online reputable canadian mail order pharmacies
cure ed ed pill best drug for ed
stromectol 3 mg tablets price stromectol pills for humans stromectol price usa
buy clomid clomid tablets for sale clomid for sale
buy clomid clomid tablets clomid for sale canada