26 Reply by chaitanya

(1 replies, posted in FA Modifications)

This feature is not available.

Go to forum: FA Modifications

27 Reply by chaitanya

(8 replies, posted in Accounts Payable)

Thanks Joe and Avb3 for the replies.

How do I handle this.

I want to load the opening balance as Tax Payable of 123,558.00

Should I just make a debit entry to 'Net Tax Payable' account ?

Thanks

Go to forum: Accounts Payable

28 Reply by chaitanya

(8 replies, posted in Accounts Payable)

Hi Avb3,

Thanks for the reply but while defining TAX we do not define Net Tax Payable account.
Could you please help to understand ?

Thanks

Go to forum: Accounts Payable

29 Topic by chaitanya

(8 replies, posted in Accounts Payable)

Hi,

In tax inquiry one get details for Net payable tax.
When the tax is paid to the authority, how should that payment entry be done.

Type of entry and ledgers to be selected.

Thanks,

Go to forum: Accounts Payable

30 Reply by chaitanya

(14 replies, posted in Banking and General Ledger)

Hi All,

It is really a crucial requirement to have a listing of the cheques in a single deposit cheque number, payer and amount.

But in FA we do not capture 1. Bank 2. cheque number as separate fields.
While transferring amount to bank from undeposited account. We would again need a listing.

Thanks,

Go to forum: Banking and General Ledger

31 Reply by chaitanya

(9 replies, posted in Items and Inventory)

So far I could not get a chance to analyse the situation.

Go to forum: Items and Inventory

32 Reply by chaitanya

(7 replies, posted in Banking and General Ledger)

Hi thhui,

I guess the submitted code is rolled out in 2.3 beta please check.

Thanks

Go to forum: Banking and General Ledger

33 Reply by chaitanya

(7 replies, posted in FA Modifications)

thanks

Go to forum: FA Modifications

34 Reply by chaitanya

(9 replies, posted in Items and Inventory)

Hi Eglis,

I am also facing same issue.
So far we can not do this is FA.

Thanks

Go to forum: Items and Inventory

35 Topic by chaitanya

(0 replies, posted in Wish List)

Hi,

Is is possible to implement disabling the user input while loading/processing ?
While ajax request is submitted and processing can page be grayed out and blocked for any action ?

Thanks

Go to forum: Wish List

36 Reply by chaitanya

(7 replies, posted in FA Modifications)

Hi Janusz,

I would like to suggest that we should display Tax calculation on PO view / print.
It is required for Accounts Department to allocate amount for PO or drawing a cheque.

Is it easy to have this enhancement ? smile

Thanks,

Go to forum: FA Modifications

37 Reply by chaitanya

(4 replies, posted in Items and Inventory)

Hello again,

Supplier Invoice also uses same policy in adjusting the cost difference.
Function updates the average cost considering get_qoh_on_date as of GRN date but the resulting cost affects overall inventory.

Should there be NO date filter for calculating qoh ?

In order to be more clear on cost diff. adjustment can we update memo like this

if ($amt != 0.0)
                {
                    $cost_diff = $mat_cost - $deliveries[1];
                    $memo = "Cost difference adjustment for ".$entered_grn->item_code.". ".$deliveries[0]." items delivered since ".$old_date.". The cost difference is ".$cost_diff;
                   
                    add_gl_trans($trans_type, $invoice_id, $date_,    $stock_gl_code["cogs_account"],
                        $stock_gl_code['dimension_id'], $stock_gl_code['dimension2_id'], $memo,
                        $amt, null, null, null,
                        "The general ledger transaction could not be added for the price variance of the inventory item");

Thanks,

Go to forum: Items and Inventory

38 Reply by chaitanya

(4 replies, posted in Items and Inventory)

Hi Joe,

Thanks for the tip. I need your help to understand the following case.

There are 2 PO deliveries done.
On June 23, 2010 - Qty - 3437 For Price - 33.77335 (Delivery # 1)
On April 01, 2010 - Qty - 1213 For Price - 33.34450 (Delivery # 2)

Std cost after second entry updates to - 33.34450 (It results in cost depreciation causing the out of sync.)
By calculation it should be - 33.66148

After code view it seems that function update_average_material_cost in grn_db.inc considers get_qoh_on_date as of transaction date.

Is there any reason for get_qoh_on_date ?
Average cost affects all inventory irrespective of dates.

Please help to understand the issue.

Other point is rep204 (Outstanding GRN) uses Std Cost. It should be unit_price of PO.

Thanks,

Go to forum: Items and Inventory

39 Topic by chaitanya

(4 replies, posted in Items and Inventory)

Hi Guys,

Please try this scenario.

Decimal places for Prices/Amounts: 2 (It is preferred for Invoice Printing)

First Inventory adjustment for a new item - qty - 2650 for unit cost 5.46
First Inventory adjustment for a new item - qty - 800 for unit cost 5.48

This results in standard cost - 5.46
Inventory valuation as per report = 18,837
Inventory GL = 18,853
Difference = -16

If all of this inventory is sold, inventory GL will show 16 units remaining and COGS will be 18,837. As qty becomes higher difference amplifies.

In our live company, the difference is of 40,000.  roll

After analysis, it seems that the cost is rounded during averaging process.  It creates the COGS difference. The rounding is set to Prices/Amounts decimals set by user.

Since cost is used for internal COGS calculation, can rounding be avoided for cost ? It will result in proper cost and thus reduce the difference.

Also can we keep track of cost change history along with the reason of cost update like WO, GRN, Cost Update and transaction number, it helps to analyse.

Please help to resolve the issue. smile

Thanks,

Go to forum: Items and Inventory

40 Reply by chaitanya

(11 replies, posted in Accounts Payable)

Hi Joe,

Thanks, this should be fine.

Company accountant advised  to pass a  'Reverse' JE to adjust the outstanding GRN at the year end.
That should take care of inventory valuation by GL and by stock.

Please correct if this is not the correct/best way.

Thanks,

Go to forum: Accounts Payable

41 Reply by chaitanya

(11 replies, posted in Accounts Payable)

Hi,

I tried a scenario. Made PO and accepted delivery for an item.
Item is sold. The inventory balance goes in credit, resulting in
Inventory valuation as per BS to be negative.
 
Should this be okay ? Or I am getting it wrong.

I am testing more cases related to GRN.
Will update soon.

Thanks,

Go to forum: Accounts Payable

42 Reply by chaitanya

(11 replies, posted in Accounts Payable)

smile

Actually I have query here. When we have GRN/PO delivery done but Invoice is pending, till the time, will the Inventory account not mismatch with actual stock ?

Should this be accounted as liability against Inventory ?

Thanks

Go to forum: Accounts Payable

43 Reply by chaitanya

(11 replies, posted in Accounts Payable)

Hi Joe,

When the delivery is done the stock is credited and purchase is debited.

I checked the system but did not found any GL entry for PO delivery i.e. GRN

Am I wrong somewhere ?

Thanks

Go to forum: Accounts Payable

44 Reply by chaitanya

(4 replies, posted in Items and Inventory)

refs
comments
audit_trail

are supportive tables storing reference, memo and auditing data respectively.

Go to forum: Items and Inventory

45 Reply by chaitanya

(4 replies, posted in Items and Inventory)

sales_orders and sales_order_details

Go to forum: Items and Inventory

46 Reply by chaitanya

(2 replies, posted in Announcements)

Thanks a lot Rthor

Adding couple of examples at relevant place may help.
Great Job! Keep it up !

Go to forum: Announcements

47 Reply by chaitanya

(5 replies, posted in Accounts Receivable)

Hi Joe, Janusz,

Please correct if I got this wrong.

We may use credit note transaction for writing off bad debts.
Credit Note Type - Items written off
Write off the cost of the items to - Bad Debts A/c

Thanks

Go to forum: Accounts Receivable

48 Reply by chaitanya

(5 replies, posted in Accounts Receivable)

ephraim wrote:

I was wondering if anyone had a procedure for writing off a bad debt from a customer under FrontAccounting. I know I can make a journal entry to a bad debt expense account from Accounts receivable, but that doesn't take care of the customer balance in the reports.

Any ideas?

Thanks

Need guideline from moderators.

Go to forum: Accounts Receivable

49 Reply by chaitanya

(7 replies, posted in Banking and General Ledger)

smile I would like it a try once I am done with current project go live.

Before starting I would like to discuss the logic, will send mail to developers list.

Go to forum: Banking and General Ledger

50 Reply by chaitanya

(7 replies, posted in Banking and General Ledger)

Hi Joe,

Do we have any progress on this feature ?
Misc type of bank deposits and payments would be easier for editing.
Can we release that part first and then take care of others ?

Regards,

Go to forum: Banking and General Ledger