Jump to content

Purchase Orders with portals ?


Pascal_82
 Share

This topic is 4340 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi there ! I have a database of items I have in stock with a reorder level field and a database of purchase orders. What I want to do is when I create a new purchase order, all the items that need to be reorder appears automaticaly in the new purchase order. Is it possible to do this with portals ?

Thanks !

Link to comment
Share on other sites

It can be done with a looping script. Not all items are ordered from the same vendor, right? So, you'd need to find all items that need to be reordered. Sort by vendor. Then loop, creating a PO and POLineItems whenever you encounter a new vendor.

This is one of those scripts that makes you love Filemaker, btw.

Link to comment
Share on other sites

In order to do this, you'll need to study up on scripting. If you only have one vendor, it's much easier. You can find all the items to reorder, then create a new PO (in a new window), capture its ID and then import your items into a POLineItems table, setting the parent POID.

Find Items that need reorder.

Create new PO in new window. Set _kF_VendorID and capture $PO_ID.

Switch to POLI layout.

Import records from found Items.

Replace _kF_PO_ID with $PO_ID

Go to Related PO form view.

Link to comment
Share on other sites

This topic is 4340 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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