Transaction Ledger not per Product inside the Portal
Im tackling the inventory, and hit a problem with the inventory transaction ledger combining all the inventory movement into one inside a portal.
im following PhilModJunk's awesome guide here http://forums.filemaker.com/posts/a6ef951917?page=4
using these as instructed, i put them all inside the LINE_ITEM Table (see below)
the relationship is
the INVENTORY_IN and INVENTORY_OUT is set up like invoices (sales and purchase orders)
The problem im encountering is that the cBal, sBalanceRunning, sBalance are combining all the products inside the Portal
1. How to fix this?
2. And should i put an inventory count in PRODUCT table for the start of the count?
i was expecting something that tracks individual inventory transactions. can this be created?
example of individual transaction
[Product Transaction Form View]
Product A (selected record of product)
[Portal of Transactions]
Invoice# , Supplier / Customer, Date, Qty, Price
Can this be made in filemaker?