Inbound and Outbound Inventory Movements are used to record the following:
|Inventory Movement Use Case||Typically Used Type|
|To record opening balances.||Accounting|
|To fix stock levels after cycle counts.||Accounting|
|To fix stock levels after an inventory reconciliation to the GL.||Accounting|
|To update inventory balances for a customer return.||Accounting|
|To record warehouse transfers.||Inventory Transfer|
An Inbound Inventory Movement will increase the quantity available on the Inventory Quantity Available record.
An Outbound Inventory Movement will decrease the quantity available on the Inventory Quantity Available record.
Accounting Entries by Movement Type
Inventory movements with a type of Non-Accounting and Inventory Transfer do not book an entry into the general ledger. These types of movements only affect the inventory balance.
Inventory movements with a type of Accounting do record entries to the General Ledger (GL):
Inbound Inventory Movement
Debit GL Account
- Defaults to the Inventory GL Account listed on the product unless specifically overwritten in this screen for an Inbound Inventory Movement.
Credit GL Account
- This field must be specifically set in this screen for the Inbound Inventory Movement.
Outbound Inventory Movement
Debit GL Account
- This field must be specifically set in this screen for the Outbound Inventory Movement.
Credit GL Account
- Defaults to the Inventory GL Account listed on the product unless specifically overwritten in this screen for an Outbound Inventory Movement.
Important: A user-defined posting status should not be created or assigned as a default status on any Inventory Movement objects. This will interfere with the posting of these records.Note: With the Hibiscus Fall 2019 release, when a user deletes Inventory Movements, they are automatically deleted from the Recycle Bin.
Use this article to learn more about the following:
- Reconcile Physical Product Counts to Inventory Balances (Cycle Counts)
- Process Extended Returns to a Manufacturer (RMAs)
Reconcile Physical Product Counts to Inventory Balances (Cycle Counts)
Accounting Seed is a perpetual inventory system. This means that there is no need for a physical inventory of your warehouse to update your accounting records. However, it is prudent to periodically audit your physical inventory balances and compare them to actual inventory balances recorded in Accounting Seed to ensure any product has not been damaged, stolen or incorrectly processed.
Cycle count adjustments are processed as inbound or outbound inventory movements on the appropriate Inventory Quantity Available record. Users may want to note the adjustment with a cycle count date. An Inventory Quantity Available report can easily be exported to Excel to create cycle count sheets.On the case object, add lookups to the objects listed below. This will allow you to associate a case to a specific installed asset, or sales order inventory movement.
- To adjust an Inventory Quantity Available balance up, use the Inbound Inventory Movements object.
- To adjust an Inventory Quantity Available balance down use the Outbound Inventory Movements object.
Process Extended Returns to a Manufacturer (RMAs)
Please see the Customer Returns knowledge article before reading this article. This article is used to help organizations extend customer returns when the product needing to be returned has to be shipped back to an original equipment manufacturer. An extended return such as this is called a Return Merchandise Authorization (RMA). Accounting Seed recommends using the Salesforce case object to tie together transactions that relate to an RMA. Furthermore, statuses and comments related to the case should be added to match your specific RMA process.
Accounting Seed recommends the following relationships are made in your Salesforce instance to the case object to process the RMA effectively:
- Sales Order Inventory Movement
On the following objects, add lookups to the case. This will allow you to associate multiple transactions that may need to take place to close the product return.
- Inbound Inventory Movement
- Outbound Inventory Movement
- Purchase Order
- Sales Order
With these additional relationships to the case object, a user can record multiple inventory movements as needed to match the status of the physical device.
Article is closed for comments.