Jump to content

Invoice Database... Issue with Creating New Record.


Thedm
 Share

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

Recommended Posts

I am creating an invoice database.

It is a standard invoice solution with one minor glitch.

Each customer CAN have a different price with each product.

To solve this i created a join table between products and customers and put a portal on the customer page where the user can from a drop down change any price manually.
That works fine.

But now when I try to create a new invoice the invoice table doesn't insert the customer name-address etc.

Here is what I have.

I cant see the forest through the trees on this one... can anyone give a hint.

thanks

post-110416-0-53788100-1401290516_thumb.

post-110416-0-71651600-1401290517_thumb.

post-110416-0-51237300-1401290519_thumb.

Link to comment
Share on other sites

I realize one of my main issues is that I have Cutomers-->Products-->>Custom Price then join that with Invoices.. vs Customer-->Invoices join with products... But i dont see another way to do custom prices..

Link to comment
Share on other sites

Hi Thedm,

 

Your relationship between invoices and customers will not be valid until there is Line_item. 

This is a curious way of doing the relationship.

 

Why not make a new instance of your CUSTOMER table (copy it) and place it right from INVOICES and relate based on _kf_Customer >_kp_Customer.

Your set.. the price relation will do it's own thing.

 

Good luck

Jeroen

Link to comment
Share on other sites

  • 1 month later...

This topic is 2593 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.