RQ Tips: Map G/L Accounts by Inventory Adjustment Reason Codes

Jun 30, 2014 — Karrie Stokes

Did you know that you can report shrinkage and inventory adjustments in your general ledger based on the reason for the adjustment? 

You already have inventory adjustment reason codes that you are using every time you process an adjustment. You can take that to the next level by mapping general ledger expense accounts directly to those reason codes. Instead of just seeing a total amount of adjustments or shrinkage, you can see totals by theft, write off, price protection, PO receiving error, etc.

To set this up, first create new expense accounts in the G/L Account Setup screen under Settings / Company Settings / Finance.

Then go to Settings / Company Settings / Inventory / Inventory Adjustment Reason Code Setup. You can select a G/L Account for each reason code, or you can pick and choose which ones report to a specific account. If no account is mapped, then the inventory corrections account selected on the product SKU will be used.

This is a great way to customize your financial reporting. 

If you have any questions about this feature or RQ in general, please contact your Account Manager directly.

Topics: Retail Operations, Fraud, RQ, Mobile Industry, Business Intelligence

Recent Posts

Comments