276

(8 replies, posted in Accounts Receivable)

That may work, I will look closer at that.

tom

277

(8 replies, posted in Accounts Receivable)

Not really.

The customer has an invoice for $68.50 he pays $68.50, so I will expect to allocate that entire payment to his account.

The very act of receiving the $68.50 will incur a processing fee of $2.36 (let's say that is 3% discount rate + $0.30/transaction)
That is a expense that has nothing to do with the customer.

tom

278

(5 replies, posted in Accounts Payable)

I added a Quick Entry for Supplier Invoice/Credit and I do not see how that will generate the desired effect.

It should add to the total I owe that supplier.
It should also add to the Freight Inwards (4300)

I am hoping to not worry about GL Account codes for day to day normal operations...

tom

279

(5 replies, posted in Accounts Payable)

I donno, would I need to enter the invoice and then enter the shipping charges separately?

I figured that a very high percentage of invoices include some form of shipping or handling charge that it would merit adding that field to the form.

I'd like to stay away from the GL area when possible, too many chances for errors (self inflicted)

tom

280

(8 replies, posted in Accounts Receivable)

I guess I could, but I like to keep things simple.

I would likely pick the wrong account code and really mess up the books...

I figured it might be a common enough need to warrant an extra field on the page.

I guess I only want to have to THINK about account codes when I need to be the accountant but
more importantly, I don't want to have to think when I am the salesman or getting payments

tom

281

(8 replies, posted in Accounts Receivable)

I accept payments basically 3 ways

1) Credit Card
2) Paypal
3) Good old cash/check

#1 and #2 have expenses associated with them

#1 I get billed monthly and can add a misc expense

#2 gets fees with each transaction

So while I want to allocate 100% of the payment to the customer, I also want to enter a 'Bank Charges' item for the fees.

Would it make sense to add a field for this in sales/customer_payments.php ?

A lot of people do use paypal or other payment services.

#3 of course is no problem.

tom

As fro #3 it looks like a Bank Deposit will do it.
The default GL Acct is 3000 (Sales) does the acct matter since we're talking about something from the prior year?

283

(5 replies, posted in Accounts Payable)

When I receive an Invoice I typically have a shipping charge.

How should that be entered?

I do see a way to add a GL Entry to go with the invoice, but with shipping
charges (Inward Freight) being relatively common I figured there should
(could) be a field on the Invoice entry form (purchasing/supplier_invoice.php)

tom

Well maybe the answer for #2 is to enter a dummy invoice.

If that is correct I will edit my original post

I am not an accountant, but a programmer.

Can someone explain in FA terms how to set up my opening values?

1) Stock Level

Looks like Item Adjustment is the right place to add initial stock.
If I have correct Unit Cost will that also take care of and required GL entries,
such as Cost of Goods sold?
(So I can avoid any Journal Entries)

2) Supplier Balances

I would say Journal Entry (since that seems to be the catch-all answer) but
I do not see how to associate that entry with a specific supplier.

3) Bank accounts

Again Journal entry (ditto) but how to say which account?
I have a bank account and a paypal account

4) Customer Balances/Credits

I don't need them, I ship on paid items only, but if we answer this the thread
may become worthy of being Sticky...

5) Did I leave anything important out?

tom

286

(4 replies, posted in Items and Inventory)

When doing Inventory Adjustments where does it get the Unit Cost from?

I am starting to get the hang of basic accounting (LOL) and I am not sure if I ill need to use dimensions.

If I add them later will I have to start from scratch or will I be able to add them later without much trouble?

I realize that any prior transactions will not have the dimension associated with them.

288

(4 replies, posted in FA Modifications)

I agree.

I also was wondering it it would be a good idea (or not!) to allow renaming the files to give them a meaningful name.

Since the backups folder is inside the company directory the DB name is not really required ether.

How about adding a NAME (no extension) and it is it blank use the current naming?

tom

not sure in this case, but I found many cases where I was not seeing the PDF file because I needed to allow popups in my browser for my site.

290

(3 replies, posted in Setup)

How are these organized?

Is there a way to export/retire old data (let's say 5 years old)?

If this got used for everything it could consume a lot of space fast.

aka

/inventory/inquiry/stock_status.php

It lists:

Location     Quantity On Hand     Re-Order Level     Demand     Available     On Order

My question is about the "On Order" field:

When the item is a Manufactured item, should the code check Work Orders to see how many are scheduled to be made?
It might be more useful than just displaying 0, because then you will see Demand (from Orders) and Orders (from Work Orders)

If this is logical I could look at doing it...

tom

292

(4 replies, posted in Manufactoring)

tom wrote:

Why do work orders complete immediately?

That's an 'Assemble' type of WO

'Advanced Manufacture' does have steps...

I am still looking at the side effects of work orders to see how Purchasing can see shortages in Raw Materials needed by manufacturing...

tom

293

(2 replies, posted in Report Bugs here)

The reason I suggest that ordering is the pull-down list is constructed like this:

Category:
    product
    product
Category:
   product
   product

They are sorted by item Description, not stock_id

So I Ended up with

Category1
    product1
Category2
    product2
Category1
    product3
Category2
    product4
Category1
    product5
Category2
    product6
Category1
    product7
Category2
    product8

Since the items are displayed by category, maybe we should order them that way on the search?

tom

294

(4 replies, posted in Manufactoring)

Why do work orders complete immediately?

When I think of a Work Order I envision it be be like issuing a PO to the production floor which will cause them to
build the widget and when done deliver them into inventory, which would close the work order.

So far the flow is fine, with one exception... there is no time delay between issuing the work order and it being completing...

If there was an "In Process" state then we could have a Work In Progress report that we could give to manufacturing to tell them what work needs to be done.

or am I missing something?

additionally...

We could then allow work orders to be entered that create a demand greater than our stock level.
Of course, the work order could not be closed until there was sufficient stock.

Sales Orders create demand on goods that can be purchased or manufactured
Work Orders create demand on goods that are purchased

tom

295

(2 replies, posted in Manufactoring)

I have added that into my import script.

I will get it added to the downloads section soon

When I run a where used query I see:

GRIT-12 - 12quot; Grit Kit

when it should say

GRIT-12 - 12" Grit Kit

HTML

<tr class='evenrow'>
<td ><a href='../../manufacturing/manage/bom_edit.php?stock_id=GRIT-12' accesskey='Q'>GRIT-12 - 12<u>q</u>uot; Grit Kit</a></td>
<td >Garage</td>
<td >Default</td>
<td >1</td>

This is because the short cut key syntax uses &,

Maybe before checking for the & the code should urldecode the string and then re-urlencode the string?

I looked around in the code, but got a bit lost...
I am sure you know right where to go...

tom

297

(12 replies, posted in Setup)

Take a look at existing modules.

It is very simple, the add module (FA code) puts the hooks in to add a link to your page and when it is clicked your page is called...

Also the simpler modules can help figure out fa function calls (db_query, etc)

tom

In includes/ui/ui_lists.inc

The order by is simply: s.description

It also includes the category description so if different categories have similar named products you will get the stock listed in alpha sort with the same category names interspersed.

Maybe a better sort order would be c.description,s.description so we group the items within one category together and then sort the stock items

tom

ps. what is MB_FLAG = 'K' ? (s.mb_flag='M' OR s.mb_flag='K')

299

(5 replies, posted in Items and Inventory)

Well it looks like my next task will be to import BOM's

I do not like the way Sales Kits appear on the Sales Order/Invoice.

It looks like Manufacturing/BOM's is the way to go

tom

300

(59 replies, posted in Modules Add-on's)

Not bad for a hacker of my vintage...

yes i recall having wrapper functions for the basic stuff to handle the PHP3 to PHP4 transition...
(or maybe it was PHP4 point releases... a lot was in flux then)

Tom