It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by bonmaklad
well I was wondering if a form of cron job could do it. I've got a butchers, so a single item (cow) with be broken down into multiple SKUS and then sold off.
So as you can image I am ignoring the complex track keeping of FIFO and just placing everything into one code
but I can't be manually inputting in sales every day or week.
If I set up unicenta to a mysql database and then get the sales to be pushed across daily, that might work hmmm
very confusing
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
you have got to be kidding me.... it wasn't working because stock was at 0...
hmm and when I do it it says no journal has been created....
direct sales delivery on the other hand does COGS and stock... my gosh what am I doing wrong!
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
there is no outstanding sales orders to be delivered
/sales/inquiry/sales_orders_view.php?OutstandingOnly=1
Just double checked, it is a direct sales invoice
/sales/sales_order_entry.php?NewInvoice=0
I thought I was doing a direct invoice... hmm
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 
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?
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?
So Front Accounting is an amazing opensource accouning package
Unicenta is an amazing opensource point of sale package
how do I make love?
haha
or even very simple, can I export sales from one to the other etc.
Would prefer unicenta to auto update frontaccounting but worst case an upload will work
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
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?
Hey Joe,
I went onto your demo site and saw that it's when you "print" an invoice you see the nice format and when you "view" an invoice you get the horrid format.
So then I went back to my site and saw that when I press print, nothing happens
So...Why does my invoices not look like your beautiful examples.....
https://frontaccounting.com/fawiki/index.php?n=Main.SalesInvoicePrintLayout
I am in the middle of paying someone to change the format from that old format to something similar to this and they showed me this link.
so where are you hiding the good invoices
/modules/import_multijournalentries/import_multijournalentries.php
full link it gives
yep got it now but... the link goes to page not found.
the /import_multijournalentries.php seems to be there in the files
yep can't find it. I have highly custom so maybe it's hidden somewhere. (the link that is)
quicker question... where in the menu is it meant to come up haha
strange I just copied company 3 and placed it in company 4 and made it 777 weird...
so installed, uninstalled and tried back and forth but all I get is this error:
Cannot open the extension setup file '../company/4/installed_extensions.php' for writing.
but there is no SQL to add in the folders... anywhere I can download the zip? to check it's the same
I have placed this on freelancer but if anyone here has any understanding of what I want, let me know ASAP:
Project Description:
I require the following requirements complete for use with FRONT ACCOUNTING SOFTWARE:
B1.1 a plugin that will allow the user to upload a csv file (bank statement) to front accounting
F1.1.1 upload must take user to a screen where all the uploads are and allow user to assign expenses and deposits to GL accounts
F1.1.2 user will have drop down boxes for GL accounts to choose from
F1.1.3 user will have drop down option for GST (TAX)
F1.1.4 system will call this info from SQL database
F1.1.5 will allow user to add descriptions
F1.1.6 plugin will determine if + or - and make all + a debit and all - a credit (will also grey out the other)
F1.1.7 if user does not complete, no action will move forward: therefore only is user completes upload and selection of all expenses and invoices, will this be processed as a journal
F1.1.8 plugin will post all options to GL accounts and automatically journal to GST accounts
F1.1.9 Other exceptions may be made for New Zealand GAP accounting methods.
F1.1.10 User will be given an error and reason why this has not be transferred
F1.1.11 will allow user to choose to delete a line from upload
F1.1.12 help boxes will be hover over Delete, account description
F1.1.13 date, debit, credit will not be changeable by the user
F1.1.14 description, account, gst and delete will be editable by the user
F1.1.15 title will be "Bank Reconciliation" with an upload button for a pre determined csv file
F1.1.16 Once file is uploaded prototype.png will appear below and allow user to handle all of their rows from the csv file
We already have a design that can be incorporated. We just need someone to ensure they can build this plugin that will automatically process journals and read the csv file.
B1.2 Invoice Templates for Front Accounting
F1.2.1 User must have a standard invoice of A4 size with logo
this is a fairly simple extra, just need someone to change what I think is an XML file, for when a user wants to send an invoice it will show a nice looking one.
There may be more work in the pipeline for this project. We require suitable SQL and PHP programmer with a good knowledge of english and accounting practices (we do not require New Zealand Accounting knowledge as this is more of a programming issue)
thanks.
Michael
ok finally figured it out....
I never added the line without adding the line you don't see the tax dada... lol
case closed
FrontAccounting forum → Posts by bonmaklad
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.