How to handle Inventory Shipment in Sage 300 ERP

By | January 27, 2014

An Inventory Control’s Shipment form will serve the purpose for shipping items from inventory and for returning items fromcustomers in Sage 300 ERP.

If suppose your company has a very simple Sales Process means where there are no Quotations, Sales Order and Delivery Challan but only movement of goods and invoicing. Then in that case without having OE (Sales) Module of Sage 300 ERP you can make the material shipment entry by using Inventory Module of Sage itself, and invoicing and receipt will be done by A/R (Accounts Receivable) module of Sage. This will save the license cost.

Use this form for the following:

• Enter and post new shipment of items.
• Enter sales returns against the shipment or delivery of items.
• Assign serial and/or lot numbers if you have the Serialized Inventory and Lot Tracking license installed.

Let’ see the screen shot of I/C Shipments in Sage 300 ERP.

IC shipment

You have to decide whether to post each new shipment as you enter it, or save the shipments to post them later in a batch using the Post Transactions form.Once after posting the above entry, stock is decreased in location 1by10 Qty.

For verification let’s see the I/C Inventory Movement Report:

Inventory movement

Our X3 Blogs: Sage ERP X3 – Tips, Tricks and Components

There will be an accounting effect for I/Cshipment entry:

1

Let’s see how to make Return Entry using I/C Shipment screen:

Suppose your customer returned the goods due to receiving damaged goods.

Have a look on the below screen shot where by using I/C Shipment you can also make thesales return, just you need to select the type as Return in Sage 300 ERP.

IC shipment

Here Qty. Returned is 5. Let’s post the entry and see the effect on the Inventory for that,have a look onthe I/C Inventory Movement Report in the Sage 300 ERP.

Inventory movement

After having a look on the above report we can verify that the Qty is reduced from the location 1 by 5 Qty.

There will be an accounting effect for I/C shipment entry:

2

From G/L Journal Entry screen you can drill down and see the source document window in Sage 300 ERP, means the shipment or return window can be viewed directly from the G/L Journal Entry window.

By having a view on the above entries and the reports we can conclude that from the single screen we can directly make the shipment from the Inventory module without going to Sales module and also we can make the return against the shipment from the same screen which is the one of the exclusive feature of Sage 300 ERP.

1Standard cost functionality in Sage 300 ERP
2Quantity On Hand Drilldown feature for OE Order Entry Screen
3. Cost Variance Analysis in Sage 300 ERP
4. Adjustment Entry in Inventory Control
5Stock Status Report in Sage 300 ERP