I/C SHIPMENTS REPORT

In Sage 300 ERP, under I/C Module, we have various standard reports which prints detailed transaction information related to Inventory like inventory movement, stock available on each inventory location along with transfer slip etc. But since there is no direct provision to print the report related to I/C Shipments of Inventory Control Module in Sage 300,… Read More: I/C SHIPMENTS REPORT »

Restriction on Ordered Quantity based on Conversion Factor of Non Stocking UOM of an item in Order Screen

In Sage 300 ERP, Order Entry Screen used for to place orders against customers by entering all the order details. Order details like Item than needs to be sale along with quantity ordered & their Unit of measures (UOM). The unit of measure can be user defined as well and has no validations/restrictions. Now what… Read More: Restriction on Ordered Quantity based on Conversion Factor of Non… »

Restrict users from doing IC Return entry with zero unit cost

In Sage 300, IC Return Entry screen use to take unwanted inventories/Items from a buyer and from the Respective location with the details of the customer, Item, Quantity, etc. as we know the standard functionality of IC Return screen, user can able to post Return transaction with Quantity “Zero”. Let’s take simple Example to understand… Read More: Restrict users from doing IC Return entry with zero unit… »

Restrict users for posting of IC shipment and IC Return Entry for blank customer number

In Sage 300, IC shipment Entry screen used to keep record of shipments of items out of inventory from the Respective Location with the details of the Item Number, Item Description, Quantity, unit price, etc.  But as per standard functionality users can create IC Shipments transaction without selecting customer number. One of our client requested… Read More: Restrict users for posting of IC shipment and IC Return… »

Date/Time type conversion for Sage 300 date fields

As we all are aware that Sage 300 stores the Audit Date and Audit Time in the SQL tables. Many times there are necessity to check the audits for organizational purpose but user cannot identify the time stored in the table due to its structure. We will be discussing the conversion of the time and… Read More: Date/Time type conversion for Sage 300 date fields »