Setting Up Inventory as a General Ledger Source
This section explains how to set up inventory as a general ledger source.
Topics include the following:
- Understanding Inventory Transaction Types
- Mapping Inventory General Ledger Accounts
- Setting Up Financial Group Exceptions
Understanding Inventory Transaction Types
The following table lists which inventory transaction types are mapped to the debit and credit categories in the general ledger.
Inventory Transaction Type | Debit Account Type | Credit Account Type | Notes |
---|---|---|---|
Receive From Vendor |
Inventory |
Purchases |
|
Return To Vendor |
Purchases |
Inventory |
This debit and credit are a reversal of a vendor receipt. |
Stock Order Transfer |
|
Inventory |
This credit is paired with the “Stock Order in Transit” transaction type. The credit is logged under the sending location. |
Stock Order in Transit |
Inventory In Transit |
|
This debit is paired with the “Stock Order in Transit” transaction type. The debit is logged under the receiving location. |
Receive Transfer |
Inventory |
InventoryIn |
Indicates a receipt of a Stock Transfer. |
Adjustment |
Inventory |
Inventory Adjustment (by adjustment reason) |
The debit and credit are reversed for a negative adjustment. |
Sale |
COGS |
Inventory |
The Inventory |
Pick for Order |
WIP |
Inventory |
Depending on the frame’s source, this debit and credit are posted from POS or the DC. |
Ship For Order |
|
WIP |
This credit is paired with the “Order In Transit” transaction type. The credit is logged under the sending location. |
Order In Transit |
WIPInTransit |
|
This debit is paired with the “Ship For Order” transaction type. The debit is logged under the receiving location. |
Receive For Order |
WIP |
WIPInTransit |
Indicates that the POS inventory was received from POS at the DC or lab. The DC receives “enclosed” frames. |
Deliver |
Inventory |
WIP |
The POS inventory was delivered to the patient. |
Return to Stock |
Inventory |
WIP |
|
Lost in Transit |
Inventory Adjustment |
WIPInTransit |
|
Receipt for Stock Order |
Inventory |
InventoryIn |
|
Manual Stock Receipt |
Inventory |
Purchases |
This is a receipt of stock without first being sent. (The item has not yet been removed from an “In Transit” transaction type, for example, Stock Transfer In Transit.) |
Manual Vendor Receipt |
Inventory |
Purchases |
This is a receipt of stock without placing it “On Order” from a Vendor Order (as is done with the Receive From Vendor transaction type). |
Stock Transfer |
|
Inventory |
This credit is paired with the “Stock Transfer In Transit” transaction. The credit logged from the sending location. |
Stock Transfer In Transit |
InventoryIn |
|
This debit is paired with the “Stock Transfer” transaction. The debit is logged from the receiving location. |
Undo Deliver |
WIP |
Inventory |
This is a reversal of a Deliver transaction. |
Merchandise Drop |
Inventory |
WIP |
Returns a work-in-process frame to inventory. A user can reverse this transaction by selecting Actions > Reinstate Drop on the POS Orders tab. The system then posts a Merchandise drop with a quantity of -1. |
Undo Receive |
WIPInTransit |
WIP |
This transaction type reverses a Receive for Order transaction type. |
OTC Sale |
COGS |
Inventory |
This debit and credit are for Misc/Accessories only. |
Return |
Inventory |
COGS |
|
Hold Order |
WIP |
|
This transaction type posts at POS when a release order is placed on hold. This debit is paired with the Withdraw WIP-In-Transit transaction type. |
Withdraw WIP-In-Transit |
|
WIPInTransit |
This transaction type posts for the office location if the order was sent to an “outside” lab. The transaction type posts for the lab location if the order was sent to an “inside” lab. This credit is paired with the Hold Order transaction type. |
Receive From Outside Lab |
WIP |
Purchases |
|
Negative Balance Cost Adjustment |
Inventory |
COGS |
This transaction type posts when receiving quantity when prior on-hand inventory was negative at a different cost. Debit/Credit may be reversed. |
COGS Adjustment |
COGS |
Inventory |
When using average cost for inventory valuation, this transaction type posts to adjust the cost of an order when the cost of goods sold (COGS) for an item at the office location is different than the average cost for the item when it is picked at the distribution center. |
Mapping Inventory General Ledger Accounts
You can map inventory general ledger accounts and post inventory transactions that reflect the current inventory on hand, work in progress, and inventory in-transit quantities. These mappings include credits and debits for each inventory transaction type. See Understanding Inventory Transaction Types.
To map inventory general ledger accounts
- In AcuityLogic Admin, click Company and select Company Setup.
- In the Company Information window, click the GL Setup link.
- In the GL Setup window, from the Source drop-down list, select Inventory.
- To export the general ledger inventory transaction types, item type mapping details, and financial group exceptions and view them in a Microsoft Excel spreadsheet, click Export.
- Click Edit next to an inventory transaction type.If no inventory transactions are displayed, contact AcuityLogic Customer Care to add the default general ledger mappings to your company.
- To map a transaction type by an account and record a general ledger account number:
- From the Account Mapping column drop-down list, select Account.
This option uses the same general ledger account number for all item types with no exceptions by item type or financial group.
- From the GL Account Number column drop-down list, select a general ledger account number for the transaction type.The general ledger account numbers are maintained in the General Ledger Account window. See Setting Up Account Numbers and Names.
- Click Update.
- From the Account Mapping column drop-down list, select Account.
- To map an Inventory, InventoryInTransit, WIP, or COGS account type by an item type and record a general ledger account number:
- From the Account Mapping column drop-down list, select Item Type.
This option allows for different general ledger account numbers to be used for each item type.
- Click Map Item Types.
The GL Setup by Item Type window opens.
- To assign the same general ledger account number to all item types associated with the account type, select a general ledger account number from the Inventory Account Number drop-down list and click Apply to all Item Types.
- To select a different general ledger account number for an inventory item type, click Edit next to the item type in the table, select a new general ledger account number from the Inventory GL Account Number column drop-down list, and click Update.
- You can set up financial group exceptions for each item type. See Setting Up Financial Group Exceptions.
- The account and financial group exceptions selected for a transaction type mapped by item type will apply for all other transaction types using the same account type. For example, if you configure the Receive From Vendor transaction type to map by item type, the account and financial group exceptions selected will apply to all other transaction types using the Inventory account type, including the Pick for Order and Return To Vendor transaction types.
- Click Return to close the GL Setup by Item Type window.
- Click Update in the GL Setup window
- From the Account Mapping column drop-down list, select Item Type.
- To map an Inventory Adjustment transaction type by a reason and record a general ledger account for the transaction type:
- From the Account Mapping column drop-down list, select Reason.
- Click Map Reasons.
The GL Setup by Reason window opens.
The reasons are maintained in the Inventory Adjustment Reasons window. Click Master Data Admin, select Inventory, and click the Inventory Adjustment Reasons link. - To assign the same general ledger account number to all inventory adjustment reasons, select a general ledger account number from the Adjustment Reason Account drop-down list and click Apply to all Reasons.
- To select a different general ledger account number for an inventory adjustment reason, click Edit next to the reason in the table, select a new general ledger account number from the GL Account Number column drop-down list, and click Update.
- Click Return to close the GL Setup by Reason window.
- Click Update in the GL Setup window.
- To determine the general ledger account number that will be used when exporting these inventory general ledger transactions, from the Center Mapping column drop-down list, select one of the following options and click Update:
- Select Office to use the office’s general ledger center code. This option allows you to post to different general ledger subaccounts at different office locations.
- Select Company to use the company’s general ledger center code.
- Click Return to close the GL Setup window.
Setting Up Financial Group Exceptions
You can set up financial group exceptions for inventory transaction types mapped by item type. Using financial groups exceptions, you can post inventory transactions for items assigned to specific financial groups to different general ledger accounts. Before setting up financial groups exceptions, you need to set up financial groups. See Maintaining Financial Groups.
To set up financial group exceptions
- In AcuityLogic Admin, click Company and select Company Setup.
- In the Company Information window, click the GL Setup link.
- In the GL Setup window, from the Source drop-down list, select Inventory.
- Click Edit next to an inventory transaction type mapped by item type.
- Click Map Item Types.
- Click Add Financial Group Exceptions next to an item type.
- In the Setup by Financial Group window, click Add Setup.
- In the Financial Group drop-down list, select the financial group that you want assigned to a different general account.
- In the Account Number drop-down list, select the account you want to assign.
- Click Insert.
- Click Return to close the Setup by Financial Group window.