Receiving Location cost cannot exceed the defined limit in customized IC Transfer screen

By | January 7, 2019

Now a days most of us are already aware about the standard Sage 300 I/C transfer screen functionality. In this blog, we are going to discuss about some additional functionality which we have customized.

Let’s take a short overview of standard Sage 300 I/C transfer screen functionality.

Use I/C Transfers screen to:

  • Enter and post stock transfers between physical inventory locations if you store items at more than one location.
  • Import transfer transactions from other Sage 300 ERP databases or from non-Sage 300 ERP programs.
  • Export transfer transactions.
  • Process the inventory transfer, including details for serialized or lotted items, as usual.

If we can see in the standard functionality, the user can post Transfer entries it doesn’t matter whether receivable location cost exceeds than the actual cost for receivable location in such way we have customized standard IC transfer screen

New stuff: Additional Task Scheduler Setting with Sage 300

We have customized I/C transfer screen such that the Transfer should be restricted for posting if the Receiving Location will have the cost impact which value exceeds than the defined limit and for this, we will create a custom table and that table will contain location and the limit for that location.

Let’s take an example to understand better.

Suppose an user has created Transfer entries for item A1-103/0 with Receivable location Mumbai and we have already defined a limit for Mumbai location will be 1000 using a customized table.

Now the system will check actual transaction costing for receivable location Mumbai and if is exceeds costing which we have already defined from the customized table then Entry will get save else System will through error message.

Note: – We have considered only transfer type from IC Transfer screen and functionality may change as per client requirement

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 offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at [email protected]. We will be glad to assist you.