Ok, you just create the item as a service item. You can still buy this service item from a supplier. And the purchase is booked directly against COGS account (or whatever account you set in the item as purchase account).

/Joe

3,702

(12 replies, posted in Announcements)

It is planned to be downloadable when the project is more majure. There is still a lot to be done on the wiki.
Until then you may put your link to this one.

/Joe

Hello Digger, if you try these operations on the demo site,  you will see that all you asked for is possible. Please try for yourself smile.

However, if you go direct to the Supplier Invoice without PO, you can only enter GL entry lines. But this is possible in release 2.3.

/Joe

3,704

(14 replies, posted in Accounts Receivable)

I would recommend using the class cart, in /sales/includes/cart_class.inc, explained by Janusz.

Simply include this file and create an object of this class. And then fill this object with your invoice details and item lines. You can see ,in /sales/sales_order_entry.php, how to fill the items and invoice details and finally how to save the object with the write method.
This way you are using the internal core of FA to get everything updated, including (invoice, debtor trans, delivery, sales order, GL transactions etc.). So by studying this file, you will see how to do it.

This is much better than trying to explain how everything is connected in DB.
If you are curious about this, however, there is an ER-diagram and Table scheme for download on the download documentation page.

/Joe

You will have to login as superadmin (login as admin on your first company, often the Training Co.)

/Joe

It seems that the file /reporting/includes/tcpdf.php is broken. Please replease this file with a fresh one from CVS repository or installation package.

/Joe

It seems that directory /company/6 is write protected. Enable it and try copy the files from company/0 into this folder. You should make /company folder and all subfolders write enabled.

/Joe

You will have to make a join to the cust_branch table and the salesman table in the SQL statements in rep101.php. Then you should add a parameter in reports_main.php for rep101.php, Sales Person, and in the report rep101.php add a parameter for the salesman to the SQL functions.
If you cannot do that yourself, you can try to ask for help in the Jobs Wanted / Offered Forum.

/Joe

3,709

(4 replies, posted in Reporting)

Strange, I can not reproduce this error. Something seems to be out of sync, in including the config.php.
Do you see something strange in the error_log?

/Joe

3,710

(0 replies, posted in Announcements)

We have established a new FAQ (Frequently Asked Questions) Page, accessible from the Menu.



We appreciate any help you can provide to this FAQ Page. Please leave them on the 'Contact Us' Page.

/Joe

No, I am afraid not. You will have to split these items into 2 different ones with different UOM.

/Joe

3,712

(2 replies, posted in Accounts Receivable)

Please look for yourself on the demo site .
Try to credit a Sales Invoice or make a free Credit Invoice. You can either return the items to the location or write them off. You can change the  prices.
A dispute where you will have to issue money back is not related to the Invoice/Credit Note but to a dispute.
The Credit Note will automatically be used to allocate the underlying Invoice if credited from a Sales Invoice (Inquiry), otherwise it can be used to allocate other Invoices.

/Joe

3,713

(8 replies, posted in Reporting)

in the line 318

if (isset($bankaccount['bank_name']))

change to the following:

if (isset($bankcccount['bank_name']) && $doctype != ST_SALESQUOTE)

/Joe

I tried the same operation just without problems. Maybe the references is out of sync. Please increase it manually to see if it helps.

/Joe

You probably know that you can click down an Item for editing, after you have entered it. Here you can also edit the description smile

/Joe

The problems are that there are so many things involved. You can also use the bank deposits and payments for payments to/from suppliers/customers. Everything has to be taking care of. Allocations and all such stuff has to be edited. So you see it is a difficult task.
Do you fancy trying? smile.

/Joe

3,717

(2 replies, posted in Items and Inventory)

1. You have 3 different ways of entering dates. MMDDYYYY, DDMMYYYY  or YYYYMMDD with a separator.
   You can void the transaction in Setup tab and enter again with correct date.
2. Please set the $go_debug to 1 in config.php file to catch any errors.
3. You can't, but you should enter the purchase prices after discounts. This price is you purchase price for the items.

/Joe

3,718

(2 replies, posted in FA Modifications)

Alvin, I am not sure if I understand you. We have Reorder Levels to be input on Item and Inventory tab.
It is in the Lower Right position in Maintenence section.

/Joe

You must always pay in the Customers Currency (domestic here), despite which bank currency account you are paying to.
This information is also written below in the form, if you are paying to a different bank currency account.

/Joe

Payments to suppliers don't create any costs (unless there are bank charges or discounts). You are paying from a bank account and you are debiting the Accounts Payable account, which is not presented in the P&L statement. You will see those transactions in the Balance Sheet under the period.
The costs are taking when the delivery is done for items and when the supplier invoice is done for services.

/Joe

This is an auto incremented primary key value. You never see this value in FA, but is there for keying.

/Joe

Hello again,
In version 2.3 we will implement the revaluation as an option to do it manually and also do it on a special Journal Entry.
Yes the wiki need to be updated.

/Joe

3,723

(5 replies, posted in Reporting)

I am not sure about that. You may accidently inactivate an item, and you will never see that there should be shipped a couple of more items, right?

/Joe

3,724

(3 replies, posted in Setup)

Ah, I see. Using the references might not work if there is a miss in the sync, just as you say. I am sorry.

/Joe

Thanks slackie, glad you sorted it out smile

/Joe