로트/일련번호를 기준으로 평가하기¶

재고 가치 평가 에 대한 조회를 로트 또는 일련번호 기준으로 실행합니다:

1. Compare and differentiate purchasing cost, based on lot or serial numbers.

2. Track the actual cost of manufactured products, based on the real cost of each tracked component used.

3. Depreciate specific lot or serial numbers when they sit in stock for too long.

환경 설정¶

가치 평가를 로트 ​​또는 일련번호를 기준으로 실행하려면 먼저 로트 및 일련 번호 기능 을 활성화하세요. 그런 다음 재고 관리 앱 ‣ 품목 ‣ 품목 으로 이동하여 원하는 품목을 선택하거나, 새로운 품목을 생성하려면 새로 만들기 를 클릭합니다.

On the product form, in the Category field, choose a product category. Ensure the product category’s Costing Method is set to First In First Out (FIFO) or Average Cost (AVCO).

다음으로, 품목을 로트 또는 일련번호로 추적할 수 있도록 재고 추적 확인란에 표시합니다. 그런 다음 옆에 있는 필드를 클릭하여 드롭다운 메뉴가 나타나면 로트 기준 또는 고유 일련 번호 기준 을 선택합니다.

Doing so makes the Valuation by Lot/Serial number checkbox appear below it. Tick that checkbox, and the configuration to track valuation by lot or serial numbers is complete.

Valuation layers¶

To understand how valuation by lots and serial numbers works, consider these scenarios:

1. Purchase and sell products: cost is calculated based on the product category’s costing method.

2. Create new lot/serial numbers using an inventory adjustment: value of the new lot/serial number is assigned to the cost from the product form.

3. Inventory adjustment to update quantities for an existing lot/serial number: value is assigned based on the most recent cost for that lot/serial number.

For both AVCO and FIFO methods, the Cost field on the product form is calculated using this formula:

\(Avg~Cost = \frac{Total~Value}{Total~Qty}\)

제품 구매¶

Consider how purchasing products affect the inventory valuation, in the table below.

Create new lot/serial number¶

Creating a new lot/serial number through an inventory adjustment assigns the same value as the cost on the product form.

To make an inventory adjustment, and assign a lot number, go to Inventory app ‣ Operations ‣ Physical Inventory. Then, click New.

In the new inventory adjustment line that appears, set the Product, create the Lot/Serial Number, set the Counted Quantity, and click Apply.

To view the valuation layer, go to Inventory app ‣ Reporting ‣ Valuation. The Total Value per unit matches the Cost on the product form.

Example

Continuing the example in the table above, when the product cost is $15, the valuation for a newly-created LOT3 is also be $15.

Existing lot/serial number¶

When adjusting the quantity of an existing lot/serial number, the value is based on the most recent valuation layer for that specific lot/serial number.

Example

Continuing the example in the table above, the value for LOT 1 is $10.

So, when the quantity is updated from 1.00 to 2.00, the additional quantity is also valued at $10, reflecting the latest valuation layer for LOT 1.

View valuation¶

To find the average cost of a specific lot/serial number, go to Inventory app ‣ Products ‣ Lots/Serial Numbers, and select the desired record.

Both the Cost and Average Cost fields show a unit’s average cost. The Total Value reflects the total on-hand value for that lot/serial number.

로트/일련번호의 평가 계층을 보려면 평가 보고서 를 통해 확인하거나, 로트/일련번호의 평가 스마트 버튼을 클릭하면 확인할 수 있습니다. 이와 같이 세부적인 내역별 기록은 특정한 로트/일련번호에 해당하는 각 재고 이동이 평가에 어떠한 영향을 미치는지 확인하는 데 도움이 될 수 있습니다.

Valuation report¶

Display the valuation of lots and serial numbers in the database by going to Inventory app ‣ Reporting ‣ Valuation.

On the resulting Stock Valuation report, click the search bar, and in the Group By section of the resulting drop-down menu, select Lot/Serial number.

Valuation smart button¶

To access a filtered part of the Stock Valuation report, specific to a lot or serial number, go to Inventory app ‣ Products ‣ Lots/Serial Numbers, and select the desired item.

On the Lot/Serial Numbers page, click the Valuation smart button.