Sage X3

ORIGEN FUENTE:  https://www.greytrix.com/blogs/sagex3/2015/04/30/how-to-get-the-sum-of-mask-column-in-sage-x3/ You may come across a situation, where you may want to get the sum of Mask column in Sage ERP X3. Sage ERP X3 has a special function to get the sum of Mask column. New Stuff:  How to Execute Miscellaneous Type Workflow Programmatically Sigma : This function is used to get sum of Mask column. Syntax : sigma( [ variable = ] indice_start, indice_end, expression ) Parameter details:         Variable: Name of the loop variable. indice_start: Numerical expression stating the start of the range over which the variable may vary. indice_end : N umerical expression stating the end of the range over which the variable may vary.             Expression: Numerical or alphanumerical expression. Kindly refer to the below snippet of code for better understanding.

Origen: Sage City https://www.sagecity.com/support_communities/sage_erp_x3/b/sageerp_x3_product_support_blog/posts/basic-setup-for-subcontract-orders Subcontract products are products that are purchased from a third party vendor, sold and managed in stock. Unlike the manufactured product, raw material will be required but with no internal operations. Parameters associated with Subcontracts: There are five basic setup steps needed: 1. Setup a product category that uses a Type of Flow which includes Subcontract at Common data, Products, Product categories 2. Setup a Subcontract Location type and Location at Common data, Product tables, Location types 3. Setup a Subcontractor supplier at Common data, BPs, Suppliers and Customers (subcontract suppliers are both Suppliers and Customers) Assign a subcontract location to the subcontract supplier on the Ship-to Customer tab of the BP Customer record 4. Create a Subcontract Product assigned to a s

Origen: By  Greytrix   |   November 25, 2015 0 Comment Sage X3 defines a method through which we can execute a specific file of an action. Generally, when an action is called, the standard code file will be executed. But sometimes, we may need to execute a specific file of an action. New Stuff:  How to restrict purchase invoice creation without purchase receipt? We can do this using the following method. Call TRAITE_CHAR(VALBOUT,PARBOUT,””,”X1ACTAFF”,””,1,”SPEX1ACTAFF”) From GTRAITE Here, VALBOUT and PARBOUT :  character strings. X1ACTAFF : Action SPEX1ACTAFF : Specific TRT file of action ‘X1ACTAFF’ Refer the below screen-shot to understand the functionality. The above code runs the specific file ‘SPEX1ACTAFF’ when action ‘X1ACTAFF’ gets executed. If we don’t pass specific file name then the standard file of action will be executed.

Origen: By  Greytrix   |   January 22, 2019 0 Comment In Sage Enterprise Management (Sage X3) we may need to copy the file from one folder to another folder. We will do it by using .bat process. Syntax: Subprog MoveFile(PATH1,PATH2) Value Char PATH1 Value Char PATH2 Local integer RETURN_VALUE RETURN_VALUE=Delfile(filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’) Local Char WRET(250) (0..4) Openo filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’ Using [FACS] WRET(0)=”copy “+PATH1+” “+PATH2 Wrseq WRET(0) Using [FACS] Openo Using [FACS] System CHAINE=(filpath(“TMP”,””,””,””,””,adxmac(0))+’\copy.bat’) ###To execute the bat file End Here, PATH1 = Source Location PATH2 = Destination Location