FrontAccounting forum — Cost of goods

Re: Cost of goods

null@example.com (sannyferns) — Thu, 23 Dec 2010 15:06:34 +0000

I avoid this problem by firts working at the unit cost in spreadsheet (if i am taking a long lists of itmes into the inventory) and then

Supper 1 invcoe

qty 10 x 25 = 100 - this will give me unit cost as 25 then
I add gl line crediting transport account with 50
so I book supplier 1 invoice @ 200

then
Suppler 2 account I debit transport cozt @ 50/-

This way my unit cost is increased and transport cost becomes zero and I have booked both the suppliers with correct invoice amount and settle them at the agreed payment tems.
Is this what we are looking for ?

Re: Cost of goods

null@example.com (itronics) — Tue, 07 Dec 2010 18:08:55 +0000

Sorry, I do not understand what do you want to change Eglis.
Janusz

Re: Cost of goods

null@example.com (Eglis) — Mon, 06 Dec 2010 22:42:12 +0000

Can you do it in this way??? The problem should be in defoult configuration of Item.
at first
when we record a purchase invoice.
Dr internal acc of inventory (xx)
Cr Supplier (xx)
In this registration it is neccasary to not show the qty received in warehouse but the duty towards the supplier.

Second
Transport service invoice
Dr internal acc of inventory (x)
Cr Supplier (x)

Third
Inventory
Dr inv acc 15... (xxx) -here we can show the qty in warehouse.
Cr internal acc of inventory (xxx)

Thanks & Best regards,
Eglis

Re: Cost of goods

null@example.com (Eglis) — Fri, 30 Jul 2010 20:26:03 +0000

Can you do it in this way
when I register a purchase invoice and in the same time I will click in a box the registration should be
GL temporary acc of inventory 15..../AP of supplier
after this
I will register the transportation invoice
GL temporary acc of inventory 15..../AP of supplier
and the third registration should be
adjustment inventory
GL Inventory/temporary acc of inventory 15....

Re: Cost of goods

null@example.com (itronics) — Fri, 16 Jul 2010 07:34:21 +0000

This is not so easy. Transportation costs are subject to payment, so it should be registered on AP account of freight company, therefore we have to entry separate supplier invoice for it. Also additional transportation charges change cost of items involved in given delivery, and have no influence on other items in inventory, so cost invoice have to set relation to selected delivery. Do you know how it is maintained in other accounting packages from user point of view?

Janusz

Re: Cost of goods

null@example.com (Eglis) — Thu, 15 Jul 2010 20:07:26 +0000

My opinion,
at first,
it is not necessary to crate items for services. The users need to have the commodity to register the service expenses directly to account of expenses, and in the same time the software will ask if this service need to be distributed in cost of goods or not.
I think for the administrator of FA this should be very easy.

Re: Cost of goods

null@example.com (chaitanya) — Thu, 15 Jul 2010 17:03:31 +0000

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

Re: Cost of goods

null@example.com (itronics) — Mon, 12 Jul 2010 13:30:42 +0000

Do you see any idea how to deal with this case to avoid need for manual item cost update?
Janusz

Re: Cost of goods

null@example.com (chaitanya) — Mon, 12 Jul 2010 09:45:05 +0000

Hi Eglis,

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

Thanks

Cost of goods

null@example.com (Eglis) — Sat, 10 Jul 2010 21:35:50 +0000

Hello,
How it should be increased the cost of goods with shipping, tax etc. ?
for examples:
1- Invoice from supplier A
qty 10 x price 20 = 200 $
GL inventory/AP-Supplier A 200 $
2- Invoice from supplier B
transport of goods (sold by supplier A) in amount 50 $
GL inventory/AP-Supplier B 50 $

Cost of goods in reports should be (200+50)/10 = 25$/per unit

Thanks