Jump to content
Sign in to follow this  
JJAW

Duplicating an Invoice Problem

Recommended Posts

We currently use Filemaker 8.5. We have a number of repeat customers. Instead of creating a new invoice I often duplicate a previous invoice. The problem I have is our costs on items change. Right know when I duplicate a record it duplicates with the cost of the old record and doesn't update the record with our current costs.

I have to re-enter the item number of the item to get the current cost to show.

Any quick fix to this?

Share this post


Link to post
Share on other sites

I don't really see how you'd have 1 product per Invoice, as you imply. Perhaps so. If so, just Set Field [ product ID, product ID ], then Exit Record, to bring in the current cost. Which is the same as what you're doing manually.

Share this post


Link to post
Share on other sites

We have a total of 8 lines of products we can enter. The product costs are not updating to our current cost on any of the lines.

Share this post


Link to post
Share on other sites

How come the newly created invoice isn't the opposite of orphaned ... deprived, childrecords shouldn't exist at all since the autoenter in the parentID would lack matching.

How come only 8 lines exists, where the products are entered.

You're giving yourself away here, shouldn't it be repeating fields you are using here??

Invoicing from fm3 and upwards should instead go by this principle:

http://www.filemakerpros.com/joinprint.sit

Duplicating a structure as this would require, some scripting in both the tables involved, alternatively could Applescripting deal with both tables in one single command!

--sd

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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