Jump to content

Invoice from InvLineItems


stretch

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

Recommended Posts

I am having great difficulty creating a working relationship between my InvLineItems and Invoice files as I have a unique set of fields that I am working with.

I ship various products via truck from various suppliers and it is all organized via my "Orders" file. As the load is shipped, I enter the shipped weight in "Orders" and a "InvoiceLineItems" record is created. I need to get the info from InvLineItems to my Invoice.

My "InvoiceLineItems" entries are created from my Orders file via a relationship defined through a "ShipSerial" field that is unique to each order.

My "InvoiceLineItems" has the following pertinent fields:

ShipSerial (key in InvLineItems to Orders relationship)

LoadSerial (unique serial number, cannot modify)

ShipWeight

TruckName

LoadB/LNo

InvoiceNo

My Invoice file has the following fields:

InvoiceNo (key field to InvLineItems)

ShipSerial (key to Orders) - not sure I need this one

LoadSerial (another key to InvLineItems)

The only time that I can get these all to work is when I check the "Also Delete Related Record" and the 'Allow creation of related record" in edit relationships box. I do not want to delete or add - I just need to bring forward.

I hope that I am making myself clear but let me know if any more explanation is needed.

Link to comment
Share on other sites

This topic is 7386 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
×
×
  • Create New...

Important Information

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