 | Inventory Valuation For Investors: FIFO And LIFO |  |
 | Inventory Valuation For Investors: FIFO And LIFO
Are you one of those investors who doesn't look at how a company accounts for its inventory? For many companies, inventory represents a large (if not the largest) portion of assets and, as such, m |
|
|
| Magnolia Costing-Weighted Average Method | |
| In Magnolia we can select Costing Methods.
Here I am expalining how weighted avarage method works withan example.
Suppose we have A Item 'ABC'
Current Stock : 10
Current Cost Price : 50
New Ship ment came, and Costed, details wil |
|
|
| Fully return in goods exchange | |
| Is there any option in goods exchange, when the customer returns all the quantity and needs all the money back?
Yes, In goods exchange, there is check box called 'Fully Return'. On ticking this, the sales person will be able to do as explained above. |
|
|
| primary key check | |
| --**************************************************************************************
SELECT US_1.TABLE_NAME,US_1.COLUMN_NAME,*--,US_2.TABLE_NAME,US_2.COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE US_1
INNER JOIN
INFORMATION_SCHEMA.RE |
|
|
| Sql 2008 features | |
| SQL 2008 Features
---------------------------
1) Compound Operators
Compound Operator Old Syntax New Syntax
+= (Add EQUALS) SET @Index = @Index + 1 SET @Index += 1
-= (Subtract EQUALS) SET @Step = @Step - 1 SET @Step -= 1
*= (Multiply EQUALS) SET @T |
|
|
