Hi All,

I am an amateur stitching together a solution from the FM Business
Solution pack.

I am trying to keep the inventory accurate. The solution pack pulls
from inventory when an order is created, but it does not add back to
inventory when an order is cancelled or quantity is reduced.

I am looking for some guidance as to where I should start.

Thank you!

Tim

I would love to help, but I can't get the thing to work at all.

Inventory stays the same on creation of sales order.

Matt

On 01/22/2007 11:41:12 Tim <tg (AT) brennan-company (DOT) com> wrote:

You have to click on Check Stock to the left of the item number.

Any help is greatly appreciated.

Tim

On 2007-01-24 10:30:19 -0500, Matt Wills <Im (AT) witz (DOT) end> said:

I tried that. Nothing.

I'll keep digging.

Matt

On 01/24/2007 10:38:23 Tim <tg (AT) brennan-company (DOT) com> wrote:

In article <1241426.YOVBKLEB (AT) news (DOT) verizon.net>, Matt Wills
<Im (AT) witz (DOT) end> wrote:

I don't know about the latest versions, but in the past some of
FileMaker Inc's own solutions have had glaringly obvious bugs. Not a
great advert for their own product. (

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On 2007-01-24 15:09:27 -0500, Helpful Harry
<helpful_harry (AT) nom (DOT) de.plume.com> said:

Now that doesn't give me much confidence!

I am an interface programmer and honestly know little about database
development. But, I have to admit, the BPS seems thrown together. It is
relational only in that the sales solution pulls the contact info from
the contact database, then it stores the very same information in its
own database. Therefor you can not update contact info from the sales
module. Kinda sucks.

I guess I will have to get my hands dirty and try it from scratch.
Better yet, maybe have a pro do it. Now there's an idea, eh?

Pros I have talked with about the project keep pushing me towards Servoy.

Tim

If the database offers a way to cancel or change orders, you should be
able via some simple scripts to adjust the inventory quantities. On
the Cancel Order Button, you could attach a script that went through
all the line items of the order and add the QTY back to the Inventory
QTY table ( InvQty = InvQty + OrderQty)

For order amount changes, I would write a script that stepped through
each line item, evaluating "if original qty is greater than adjusted
qty then Inventory qty = Inventory Qty + (orginal qty - adjusted qty).
This should add back the quantity that was subtracted from the order.

Second eval would be the reverse, if teh adjusted Qty was more than the
original QTY then you need to subtract more from your Inventory Qty.

Attach these scripts to buttons on the form you are using and run them
from this form.

I have not looked at the Inventory starter solution in the BPP, but I
am using 3 seperate DB's from their basic starter templates merging
them into one DB and its been a real time saver.

I hope this helps.

David

On Jan 22, 11:41 am, Tim <t... (AT) brennan-company (DOT) com> wrote:

In article <2007012415271616807-tg@brennancompanycom>, Tim
<tg (AT) brennan-company (DOT) com> wrote:

It is of course free, so the old "you get what you pay for" springs to
mind ... although there are some solutions being sold as shareware and
"commercial" that are even worse. Some of the databases that come as
demos on the cover CD of my Mac magazine make me shudder.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)