It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Items and Inventory → Inventory not changing..
Probably simple but for the life of me I don't get it. Set up business as retailer and when I invoice and pay invoice the stock doesnt move...
so when I am inputting in invoices stock goes up
but stock doesn't go down on receipt of invioce and no cost of sales.
hmm any ideas?
I only have one item it is set up:
Category:
Systems Services Consulting Butchery
Item Type:
ManufacturedManufactured Purchased Service
Sales Account: SALES
Inventory Account: STOCK
C.O.G.S. Account: COST OF GOODS
Inventory Adjustments Account: Bank
Item Assembly Costs Account: Bank
Hello,
Your two last accounts should NOT be a bank account, but a cost (expense) account.
Joe
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?
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
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?
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
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 
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.
I thought I was doing a direct invoice... hmm
Just double checked, it is a direct sales invoice
/sales/sales_order_entry.php?NewInvoice=0
there is no outstanding sales orders to be delivered
/sales/inquiry/sales_orders_view.php?OutstandingOnly=1
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
13.93
direct sales delivery on the other hand does COGS and stock... my gosh what am I doing wrong!
hmm and when I do it it says no journal has been created....
you have got to be kidding me.... it wasn't working because stock was at 0...
Can you send me your sql file so that I can check?
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
FrontAccounting forum → Items and Inventory → Inventory not changing..
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.