Update Inventory from POS and Sales History

[BrianKL]

I am working with FMP 4.1. I am trying to set up a system that allows The Point Of Sale (POS)Invoice to write to Sales History file and reduce inventory in the process. Let's say that I have line item A which is on the invoice, when the invoice is printed the line item(s)is wrote to Sales History (along with all the pertinent information from the invoice), and the line item is reduced in the inventory file.

How do I write from one file to the other From POS(invoice) to Sales.

Thanks in advance!

Brian

[Rumble Seat]

I might be way off base, but this appears to be simple. The Line Items database is itself a Sales History, right? So that would not require anything, except perhaps a way to view and filter that list?

To reduce Stock depends on how that file is set up. My idea looks like this:

Invoices, with related to Line Items

Stock, with related Purchases, and also related to the same Line Items.

At any given time, Stock = Sum(Purchases::Qty_Bought) - Sum(Sales::Qty_Sold)

Does that help?

[ January 25, 2002: Message edited by: Rumble Seat ]

[BrianKL]

Ok, I have 3 databases. One of them is not important in this matter. The Inventory file has a layout of the Invoice and another layout from which you can enter inventory. When the sale takes place, the invoice is completed. When they press the botton 'complete', all of the customer information and multiple line items are wrote to a Sales file. Then from the Sales file the Quantity Sold for each line item is deducted from the QOH in the Inventory file.

Or, do I just need to update the Inventory file (reduce inventory) at the point of writing the data to Sales file. Also, what is the script for adding a new record in another database?

Thanks,

Brian

[Rumble Seat]

How to create a new record in another file:

In Sales create a script "New Sale" that Creates a New Record.

In POS create a script that Performs Script (External > Sales > New Sale)

hope that helps.