Sage X3 - Add a new left list browser to view product quantity in sale order screen



It might be useful for some of the sale executive to able to view product quantities on hand before place order for their customers in Sale Order screen. You able to do that by adding new left list browser (object) in sale order screen, sale executive could always refer to this browser before creating new sale order base on the available quantities for the product in each of the product site.

To achieve this, first, you need to create a new object by linking table to ITMMVT 'Product Site Total' table.


Add fields that you want to display in left list browser. You can have the fields added in Selection tab from other table like ITMMASTER and ITMMVT.

By linking the table between ITMMVT with ITMMASTER in Environment tab.

Once new object (left list browser) has been created, you can add it in sale order window. Don't forget do the global validation and entry transaction validation for each of the sale order entry transaction.

You should able to see new left list browser in Sale Order screen with all products and products quantity for each of the product site.



You could filter left list browser by adding some script in SPESOH to display the product belong to the site that you entered in sale header screen.

To achieve the filtering by adding script in SPESOH. Get the left list browser name when sale order screen is opening.


Add code in FILGAUCHE event (It is used to filter left list records). Records will be filtered according to sale site that you enter in sale header.


Kill the global variable once exit from sale order screen.




Comments

  1. Chris18 April 2018 at 06:16

    How did you get the left list browser name when sale order screen is opening?

    ReplyDelete
    Replies
    1. Kean Hui18 April 2018 at 17:57

      You can use currbox to get the active left list browser

      Delete
  2. TJ Ligammare30 April 2019 at 06:51

    Thanks for this, it is very helpful. Do you think there is a way to filter by the ITMREF as it is entered into the sales order lines?

    ReplyDelete

Post a Comment

Popular posts from this blog

Sage X3 - Regenerate Syracuse Certificate

Image
There are some of the reasons that you need to regenerate Sage X3 Syracuse certificate, the reasons could be: 1. Expired of certificate 2. Uninstall or re-install of X3 Syracuse 3. Changes of server information 4. Incomplete, corrupted or missing of information in Certificate 5. Changes of password of SageRT (Granted administrator user running X3 services) The possible error below that you encountered below might required regenerate the certificate in order for you able to login Sage X3 again. 1. Cannot read passphrase file. Maybe it has been created under another operating user. 2. Error connect ECONNREFUSED. Here are the steps to regenerate certificate for Syracuse: 1. Go to Syracuse installation directory, <Syracuse>\syracuse\cert_tools. Make backup of output folder by rename it.Click on certgen.bat, this will open a command prompt. 2. Fill in all necessary information for Country, State, City, Organization, Organization Unit, Name and Va
Read more

Sage X3 - Install and configure SMTP in IIS 6 by using gmail account

Image
Install and Configure SMTP in IIS 6 by using GMAIL Account You can use your gmail as relay server to allow email to be sending out from X3 workflow. To enable it, you need to turn on 'Allow less secure apps' in your gmail account setting. In order to use SMTP relay server Windows Server 2012 , you need to enable SMTP server and Telnet Client in Add roles and features wizard. Once SMTP installed, go to IIS6.0 Manager, select the IP Address. Go to Delivery tab, click on outbound security button. Enter your gmail account and password. Tick TLS encrytion.  On same Delivery tab, click on outbound connection button, change the port to 587.  Click on Advance button, change the smart host to smtp.gmail.com. You may reset IIS and start SMTP virtual server once it's done. To use Sage X3 workflow emailing, you have to login X3, set up parameters value, configure workflow rules and user assignment. Go to parameter values, select S
Read more

Sage X3 - Add or customize report in X3

Image
This is to show you how you can create a new or customize existing crystal report and link it to Sage X3. Here is taking Customer Invoice report as an example without changing any report parameters. First, You have to create a new report dictionary. Go to Development > Script Dictionary > Reports, select SBONFAC 'Customer Invoice' , rename it to ZSBONFAC. Change the Report name to ZSBONFAC also, this should same as your crystal report name. Once report dictionary created, you may add new print code for the report dictionary. Go to Setup > Destination > Print Code, create new print code for SBONFAC with new Print code = ZSBONFAC.  You need to create the default value for the new report, it will populate the default value before report is printed. Go to Setup > Destination > Default Values, duplicate SBONFAC and create new ZSBONFAC. Copy default values from SBONFAC to ZSBONFAC  for all the parameters. You may modify exis
Read more