Need Help to transfer Inventory to another warehouse

##Cost Detail

[Cost Detail Report:30,15,15, 15, 15, 15]
>Group|Product|Portion|Sold|Price|Cost
{REPORT COST DETAILS:M.GroupCode.asc,C.Name.asc,C.PortionName,C.Quantity,C.AvgPrice,C.Cost}
>>TOTALS|||Sold|Revenue|Cost
>Totals|||{REPORT COST DETAILS:C.Quantity.sum,C.AvgPrice.sum,C.Cost.Sum}

##Profit Loss

[Products:5,5, 3, 3, 3, 3, 3, 3, 3]
@{REPORT COST DETAILS:M.GroupCode.asc::,}
>Name|Portion|Qty|Sales|Cost|Cost%|PM%|PM|P%
>>GROUP|$1|||||||
{REPORT COST DETAILS:C.Name.asc,C.PortionName,
C.Quantity.Sum,
[([C.AvgPrice]*[C.Quantity]).Sum],
[([C.Cost]*[C.Quantity]).Sum],
[($5/$4)];#0.00 %;-#0.00 %,
[($4-$5)/$3];#0.00 %;-#0.00 %,
[($4-$5)];0.00,
[(($4-$5)/$5)];#0.00 %;-#0.00 %:M.GroupCode="$1"}

>Totals for:|{REPORT COST DETAILS:[='$1'],C.Quantity.Sum,[([C.AvgPrice]*[C.Quantity]).Sum],[([C.Cost]*[C.Quantity]).Sum],[($4/$3)];#0.00 %;-#0.00 %,[($3-$4)/$2];#0.00 %;-#0.00 %,[($3-$4)];0.00,[(($3-$4)/$4)];#0.00 %;-#0.00 %:M.GroupCode=="$1"}

>>TOTALS||Qty|Sales|Cost|Cost%|PM%|PM|P%
> ||{REPORT COST DETAILS:C.Quantity.Sum,[([C.AvgPrice]*[C.Quantity]).Sum],[([C.Cost]*[C.Quantity]).Sum],[($3/$2)];#0.00 %;-#0.00 %,[($2-$3)/$1];#0.00 %;-#0.00 %,[($2-$3)];0.00,[(($2-$3)/$3)];#0.00 %;-#0.00 %}

[Groups:5,5, 3, 3, 3, 3, 3, 3, 3]
>Group||Qty|Sales|Cost|Cost%|PM%|PM|P%
{REPORT COST DETAILS:M.GroupCode.asc,'',
C.Quantity.Sum,
[([C.AvgPrice]*[C.Quantity]).Sum],
[([C.Cost]*[C.Quantity]).Sum],
[($5/$4)];#0.00 %;-#0.00 %,
[($4-$5)/$3];#0.00 %;-#0.00 %,
[($4-$5)];0.00,
[(($4-$5)/$5)];#0.00 %;-#0.00 %}

>>TOTALS||Qty|Sales|Cost|Cost%|PM%|PM|P%
> ||{REPORT COST DETAILS:C.Quantity.Sum,[([C.AvgPrice]*[C.Quantity]).Sum],[([C.Cost]*[C.Quantity]).Sum],[($3/$2)];#0.00 %;-#0.00 %,[($2-$3)/$1];#0.00 %;-#0.00 %,[($2-$3)];0.00,[(($2-$3)/$3)];#0.00 %;-#0.00 %}

##Inventory Transactions

[Purchases by Group:2, 1,1, 1]
>GROUP|||Amount
{REPORT INVENTORY TRANSACTION DETAILS:T.ItemGroup,'','',T.TotalPrice.Sum}

> | |Total|{REPORT INVENTORY TRANSACTION DETAILS:T.TotalPrice.Sum}

[Item Purchases:2, 1,1, 1]
>Item|Qty|Unit|Amount
{REPORT INVENTORY TRANSACTION DETAILS:T.Name,T.Quantity.Sum,T.Unit,[T.TotalPrice.Sum]}

>Total|{REPORT INVENTORY TRANSACTION DETAILS:T.Quantity.Sum,'',T.TotalPrice.Sum}

##Stock

[Inventory Report:2, 1,1]
>Item|Qty|Unit
{REPORT INVENTORY}

##Consumption

[Inventory Consumption:2, 1,1, 1, 1, 1, 1, 1]
>Item|Used|Unit|Pred|InStock|Added|Removed|Variance
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption.Sum,C.Unit,C.Inventory.Sum,C.InStock.Sum,C.Added.Sum,C.Removed.Sum,[($5-($2+$4))];0.00;-0.00;0.00:C.Consumption>0}
2 Likes