Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need help designing simple solution.

Francis P.
in Development Standards

Featured Replies

Hi all,

I have a very simple table with the following fields (product , from_location , to_location , quantity and date). How can I create a three column report that to shows totals received, issued and on hand for each location.

Thanks.

This, surprisingly, is not going to be simple. Do you also have a table of Locations (where each location has a unique record) and a similar table for products?

  • Author

Yes I have both these tables.

Well, to produce a report for a single location, you'd find all transactions affecting the location (whether from or to) and sort them by product, then by type (incoming or outgoing). To calculate the type, you need to have the selected location's ID in a global field or variable. Hopefully, the rest is obvious.

Another approach is to have the selected location's ID in a global field in the Products table. Then you can have two relationships linking Products to Transactions, matching on both ProductID and LocationID.

  • Author

How do I get the selected location ID in a global field or variable? I know how to create global fields.

Assuming the report process is scripted, and that the script is called from the selected location's record, start the script by:

SetField [ AnyTable::gLocationID ; Locations::LocationID ]

or

SetVariable [ $$locationID ; Locations::LocationID ]

Create an account or sign in to comment

https://fmforums.com/topic/86179-need-help-designing-simple-solution/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.