The following article describes how G/L accounts are used through several different functions within the Inventory module:
...
| Account | Description | Credit $ | Debit $ | Unit $ | Credit Qty | Debit Qty | Comment | Source |
|---|---|---|---|---|---|---|---|---|
| 01-01-000-00-1403 | Inventory-Ingredients | 0 | 775 | 1.55 | 0 | 500 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Inventory Type - Inventory G/L Account |
| 01-01-000-00-9001 | Inventory Adjustment | 775 | 0 | 1.55 | 500 | 0 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Adjustment Code - G/L Account |
PLEASE NOTE* If no GL Account is assigned to the Adjustment Code, then the posting will untilize the Adjustment GL Account assigned to the Inventory Type.
Inventory Usage
Inventory - Inventory Usage
...
Action: Adjusted the Inventory for the Item from 750 to 900 for the Item. Selected TRANSFER Adjustment Code.
| Account | Description | Credit $ | Debit $ | Unit $ | Credit Qty | Debit Qty | Comment | Source | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-01-000-00-1403 | Inventory-Ingredients | 0 | 0 | NULL | 0 | 150 | 232.5 | 1.55 | 0 | 150 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Inventory Type - Inventory G/L Account |
| 01-01-000-00-9016 | Inventory Physical Adjustment | 232.5 | 0 | 1.55 | 150 | 0 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Adjustment Code - G/L Account |
Inventory - Physical by Location - Negative Row Offsets
Action: Increase of a Negative Inventory Row (-100 qty), initiated when above sample Physical by Location was performed.
| Account | Description | Credit $ | Debit $ | Unit $ | Credit Qty | Debit Qty | Comment | Source | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-01-000-00-1403 | Inventory-Ingredients | 0 | 155.00 | 1.55 | 0 | 100 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Inventory Type - Inventory G/L Account | ||||
| 01-01-000-00-9016 | Inventory Physical Adjustment | 155.00 | 0 | 0 | NULL | 150 | 0 | 1.55 | 100 | 0 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Adjustment Code - G/L Account |
Action: Reduction of Oldest Positive Inventory Row (FIFO) to offset the Negative Inventory Row, initiated when above sample Physical by Location was performed.
| Account | Description | Credit $ | Debit $ | Unit $ | Credit Qty | Debit Qty | Comment | Source |
|---|---|---|---|---|---|---|---|---|
| 01-01-000-00-1403 | Inventory-Ingredients | 155.00 | 0 | 1.55 | 100 | 0 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Inventory Type - Inventory G/L Account |
| 01-01-000-00-9016 | Inventory Physical Adjustment | 0 | 155.00 | 1.55 | 0 | 100 | *ICS 48 2 - Automatic Posting From ICS - Unit Adjustment | Adjustment Code - G/L Account |
Work Order Production
Work Order - Produce
...
| Account | Description | Credit $ | Debit $ | Unit $ | Credit Qty | Debit Qty | Comment | Source |
|---|---|---|---|---|---|---|---|---|
| 01-01-000-00-14031413 | Inventory-IngredientsFormula | 37.1 | 0 | 0.371 | 100 | 0 | *ICS 48 4 - Automatic Posting From ICS Receiver 14967 | Inventory Type - Inventory G/L Account |
| 01-01-000-00-9017 | Inventory-Work Order Formula | 0 | 37.1 | 0.371 | 0 | 100 | *ICS 48 4 - Automatic Posting From ICS Receiver 14967 | Formula Master - Division - G/L Account |
| 01-01-000-00-1405 | Inventory-Packaging | 5.25 | 0 | 0.525 | 10 | 0 | *ICS 48 4 - Automatic Posting From ICS Receiver 15231 | Inventory Type - Inventory G/L Account |
| 01-01-000-00-9017 | Inventory-Work Order Formula | 0 | 5.25 | 0.525 | 0 | 10 | *ICS 48 4 - Automatic Posting From ICS Receiver 15231 | Formula Master - Division - G/L Account |
| 01-01-000-00-9017 | Inventory-Work Order Formula | 42.35 | 0 | 0.09625 | 10 | 0 | *ICS 48 4 - Automatic Posting From ICS WO Receiver 15501 | Formula Master - Division - G/L Account |
| 01-01-000-00-1423 | Inventory-Finished Product | 0 | 42.35 | 0.09625 | 0 | 10 | *ICS 48 4 - Automatic Posting From ICS WO Receiver 15501 | Inventory Type - Inventory G/L Account |