Re: [WebERP-developers] Is the write off variance correctly defined in suppliers invoice?

[Phil D. <ph...@lo...>]

You might have to flesh this out a bit Exson... not sure I fully understand.
I think it is right to base the GL posting date using the date of the 
invoice - if the "prohibit GL postings to periods before" system 
parameter is set to a period after the period identified by looking at 
the invoice date then the GL posting will occur in the first period 
following the "prohibit GL postings to periods before" system parameter. 
I don't think the input date has much to do with the GL posting. Using 
the weighted average costing - the quantity on hand at the time at the 
time the invoice is posted is required to identify the number of items 
that the variance needs to be averaged over. There is no retrospective 
costing going on or possible.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 20/09/15 20:45, ExsonQu wrote:
> *Dear all,*
>
>                Thank you for your long time efforts to webERP.
>                
>                When I studied the suppliers invoice scripts, I found that the
> WriteOffVariance is based on Current Quantity On Hand (The supplier's
> *invoice input date*):
>        
>                ($EnteredGRN->This_QuantityInv - $TotalQuantityOnHand) *
> (($EnteredGRN->ChgPrice /  $_SESSION['SuppTrans']->ExRate) -
> $EnteredGRN->StdCostUnit);
>                 The TotalQuantityOnHand is from following sql:
>                	$sql ="SELECT SUM(quantity) FROM locstock WHERE stockid='" .
> $EnteredGRN->ItemCode . "'";
>                But the Period GL posted is up to the *invoice date* input by
> users.
>                I think it make sense if suppliers' *invoice date* and *input
> date* within the same period.
>               But does it still make sense if the *input date* and *invoice
> date *are not within the same period? Need we change it to the historical
> (invoice date) QOH?
>               
>               Any comments are highly appreciated!
>
>               Thanks and best regards!
>
>               Exson
>
>               
>
>                
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-write-off-variance-correctly-defined-in-suppliers-invoice-tp4658329.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>