FrontAccounting forum — Inventory not changing..

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 22:27:23 +0000

no seriously, once there was "stock" then when it sells it does the journal. Must have a IF THIS = 0 THEN NOTHING statement somewhere.

I put the stock all in via journal and not stock lol

Re: Inventory not changing..

null@example.com (PHPdv) — Thu, 19 Jun 2014 06:04:07 +0000

Can you send me your sql file so that I can check?

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 02:44:26 +0000

you have got to be kidding me.... it wasn't working because stock was at 0...

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 02:40:37 +0000

hmm and when I do it it says no journal has been created....

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 02:39:34 +0000

direct sales delivery on the other hand does COGS and stock... my gosh what am I doing wrong!

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 02:37:59 +0000

when I do a direct invoice on your demo site, this is what I see journal wise, it's just sales and receivables no stock or COGS?

Account Code

Account Name

Dimension

Debit

Credit

Memo

4010

Sales

13.26

1200

Accounts Receivables

13.93

2150

Sales Tax

0.67

Total

13.93

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 02:35:15 +0000

there is no outstanding sales orders to be delivered

/sales/inquiry/sales_orders_view.php?OutstandingOnly=1

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 02:32:03 +0000

Just double checked, it is a direct sales invoice

/sales/sales_order_entry.php?NewInvoice=0

Re: Inventory not changing..

null@example.com (bonmaklad) — Thu, 19 Jun 2014 02:10:36 +0000

I thought I was doing a direct invoice... hmm

Re: Inventory not changing..

null@example.com (PHPdv) — Wed, 18 Jun 2014 23:13:43 +0000

If you want to skip delivery then you should test direct invoices feature, it auto generate delivery and sale order just for completion of normal sale cycle.

Re: Inventory not changing..

null@example.com (bonmaklad) — Wed, 18 Jun 2014 23:07:01 +0000

yes this is what I looked at on the demo site. I coded out (hid) the sales quote and delivery as its not needed... I mean if someone orders, you invoice and then deliver at the same time.

so I don't touch sale order and delivery

hmm so I either need to set up sales orders and deliveries (which I just tested and the GL showed no movements)

or I need to ensure Sale Invoices does it for me

hmm confusing. Front Accounting is much nicer for service

Re: Inventory not changing..

null@example.com (PHPdv) — Wed, 18 Jun 2014 22:30:57 +0000

did you use Direct invoice feature? Some time people are mixing sale order with invoices and delivery. normally the sale cycle is as follow
1) Quotation -- NO impact on stock
2) Sale order -- No impact on Stock
3) Sale Delivery-- here is stock is reduce
4) Sale invoice -- its depend upon inventory configuration, normally no impact on stock
5) Payment of Sale invoice
6) Allocation of that pavement to invoice

Regards.
PHPDv

Re: Inventory not changing..

null@example.com (bonmaklad) — Wed, 18 Jun 2014 21:19:03 +0000

ok I tried having it as STOCK and COGS and did a dummy invoice and stil the stock doesn't go down and COGS doesn't go up

I don't have to "DELIVER" the goods do i?

Re: Inventory not changing..

null@example.com (joe) — Wed, 18 Jun 2014 21:12:04 +0000

The Item Adjustment Account could f.i. Be an account called 5040 Purchase Price Variance, but you can also use another expense (COGS) account.

The Item Assembly Cost Account could be a stock account, 1530 Stock of Work in Progress.

You should set these accounts as default in System and General GL Setup and in Item Categories to avoid confusing when creating new Items.

Joe

Re: Inventory not changing..

null@example.com (bonmaklad) — Wed, 18 Jun 2014 20:59:56 +0000

Hey Joe,

So when invoicing the front accounting will take the place you have set up as inventory adjustment?

therefore if I made it the STOCK account, it would move it from stock to COST OF SALE?

If this was true, wouldn't the bank be wrong and the COGS be correct?