Transactions from Miscellaneous Issues/Receipts were not linked to the automatic journal. Due to this, the system does not provide stock impact for entries that users create for transactions (i.e., STK entries).
All new entries will have STK impact if we select an automatic journal to that entry transaction. The question is, what happened to the earlier entries that were produced before the automatic journal was selected?
So, to have an impact on the old entries we need to perform the below steps.
Navigate to: Setup → Stock → Entry Transactions → Misc. Issue/receipts
Select the automatic journal and validate the entry transactions.
After Selection the automatic journal in the entry transaction screen, all new entries which are created will have a stock impact
For the old entries, you need to update the accounting code (ENTCOD_0) ‘STKIS’ and change the stock interface flag (AGGIFAFLG_0) to ‘1’ through the Table Maintenance.
Navigate to: Development → Utilities → Maintenances → In Lines
Select the Table as STOJOU and enter the details of the entry for which you need to update both fields.
You need to search ENTCOD and update the accounting code and similarly update the AGGIFAFLG to ‘1’ and then save that entry.
Once both fields are updated you can run the Account interface for the required date.
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 X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 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 X3 to Sage business partners, end users and Sage PSG worldwide.
Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – 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.