If some merchandise transformations have been done (materials were processed and a finished product resulted, but this product is in the merchandise category since it can be acquired) then the transformations are recorded through the accounting article: 345=711 (in this example: 3711=711). Is the adjustment done through an accounting entry? Can you create an accounting schema/ do you have to create a new product?
A: Changing the accounting nature of a product can be done through the use of an Inventory Move (e.g. from the merchandise warehouse to the finished products warehouse).
In order for this changing process to function, you need to set the following in the Accounting tab in the Product window:
Product Asset 1 : alternative account used for changes of the accounting nature.
Product COGS 1
and in the Accounting tab in the Warehouse & Locators window
Product Asset = Product Asset 1 from products
Product COGS = Product COGS 1 from products
This way, the accounting nature of a product will be changed through the use of an Inventory Move.
How can you adjust the situations where the stock of a product is 0, but the value is different from 0?
A: You can use the Cost Adjustment process, found in Performance Analysis -> Costing -> Verify/Correct, that, depending on the selected Cost Adjustment Type, generates cost lines that will be written in the product cost lines even if the document has yet to be completed.
* Cost Adjustment Type: Cost Difference: this will enter the following two lines in the Cost Details tab of the Product Costs window for the products that have the sum of their quantities equal to 0, but whose values are different from 0: +1 and -1 quantities with the value equal to the observed difference (entry/exit, depending on the situation).
* Cost Adjustment Type: Landed Cost Difference: same as with Cost Difference, with the exception that the analysed cost element is of Landed Cost type;
* Cost Adjustment Type: Clear Costs: This verifies if, for a certain product/lot, there is a quantity greater than 0 in the cost queue for "Landed Cost" type cost elements and quantity = 0 for the standard cost. This difference is discharged the same as with Cost Difference.
When completing the document, the corresponding GL Journal is of the form: Debit = Product COGS and Credit = Cost Adjustment, both from the Product' accounting definitions, with the value = the observed difference.
In order for this process to operate these adjustments, you need to select the Adjust COGS checkbox in the Accounting Schema window.
Why are some products available with "-" ? In the Info - Product window, the stock appears with "-", whereas the stock on the warehouse file is 0.
A: The available stock is not equivalent to OnHand Quantity, so that, in the Info Product window, the columns have the following meaning:
1. Total Available Quantity = On Hand Quantity + Quantity Ordered - Quantity Reserved
2. Available Quantity = On Hand Quantity - Quantity Reserved
3. Quantity Reserved = sales order quantity
The fact that you have a positive value in the Total Available Quantity column when you shouldn't signifies that there is a sales order that was wrongly entered. To ge rid of this minus, identify the column and close the document.
The Storage vs. Transaction (SocrateOpen) process has returned data. What is the verification/correction procedure now?
A: There is no correction procedure in the interface, because this situation is rarely encountered and not reproducible. The correction is carried out by the technical consultant.
The reports significance is:
- all the documents that modify the onhand quantity are registered in the transactions table;
- a summary of the transactions representing the onhand quantity grouped by instance and locator can be found in the stock table.
- normally, the sum of the transactions quantities grouped by product, instance and locator needs to be equal to what can be found in the stocks.
The report will display those products that do not have the transactions sum equal to what can be found in the stocks.