Partial Delivery based on Order

Questions related to using nuBuilder Forte.

Partial Delivery based on Order

Unread postby andria » Mon Jun 07, 2021 12:45 am

Hello.

I created a fast form called Request from Customer. Inside the table contains (req_id, req_product, req_quantity, req_paiement). Each request contains only 1 product for delivery. Delivery are: Full (One time) or Partial like If I received an order for 1000 quatities for delivery. But the delivery is partial: 500 first time, 250 second time and 250 the final delivery.
Should I create a subform to manage this partial delivery? And how to print each delivery? And I cannot create new delivery if I attempts 1000 quantities

Thanks for advising me.

Regards

Andria

PS: New to NuBuilder and trying to work on this best open source web database apps
andria
 
Posts: 3
Joined: Thu Jun 03, 2021 9:08 pm
nuBuilder Version: 4.5

Re: Partial Delivery based on Order

Unread postby kev1n » Mon Jun 07, 2021 2:25 pm

Hi,

It's probably best to use a Subform to manage these partial deliveries.

And I cannot create new delivery if I attempts 1000 quantities


Can you explain in more detail what you mean or what doesn't work.?
kev1n
nuBuilder Team
 
Posts: 1763
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Partial Delivery based on Order

Unread postby andria » Mon Jun 07, 2021 5:18 pm

kev1n wrote:
Hi,

And I cannot create new delivery if I get 1000 quantities


Can you explain in more detail what you mean or what doesn't work.?


Based on the quantity requested by the customer. Ex: 1000 units (it will be on request form). So if i proceed partial delivery: 500 first, 250 second and 250 third on the subform, the requested quantites are reached. So I'd like to stop adding record on the subform.

Regards

A
andria
 
Posts: 3
Joined: Thu Jun 03, 2021 9:08 pm
nuBuilder Version: 4.5

Re: Partial Delivery based on Order

Unread postby kev1n » Mon Jun 07, 2021 11:20 pm

To limit the number of rows in a Subform, add an beforeinsertrow event to it.
Use a calc field on the main form to calculate the sum of quantities.
kev1n
nuBuilder Team
 
Posts: 1763
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Partial Delivery based on Order

Unread postby andria » Tue Jun 08, 2021 4:43 am

Thanks for your help. It's work fine.
I appreciate.
andria
 
Posts: 3
Joined: Thu Jun 03, 2021 9:08 pm
nuBuilder Version: 4.5


Return to General

Who is online

Users browsing this forum: No registered users and 12 guests