Update Gross Price of transactions while Save\Create

By | November 26, 2013
0 Comment

Most of the times while doing the customization for creating\updating the transactions, in which we are asked to update the Gross price of the product on click of save\create button, we came across a problem where we are able to updates the gross price but fails to update the others fields which are directly calculated on Gross Price.

On referring the below screen shot you will find that some fields like Net Price, Margin, Ex Tax total, tax etc. depends on the Gross Price of the products.

GROPR-1

We researched out and found that there is an action “AM_GROPRI” which is being called on change of each line that updates the Fields according to the entered gross Price and on calling the same from save\create button was giving the errors.

While looking for a workaround for this we found the solution for this. All we have to do is that we need to call the below-mentioned actions:

Call CLCNETPRI([M]QTY(NOL), [M:SOH0]CUR, NOL) From TRTVENPRI

Call CLCPFM([M]DSTOFCY(NOL), [M:SOH1]PRITYP, [M]CHGTYP, [M:SOH0]ORDDAT, [M:SOH0]CUR, NOL, 1) From TRTVENPRI

Calling the above actions will automatically update the respective fields.

Hope this solves the problem.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. 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 for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.