Help needed to see the finish date of sales order set

25 views
Skip to first unread message

SEUNGWOO KANG

unread,
Nov 8, 2020, 8:27:09 PM11/8/20
to frePPLe users
Each sales order usually has 100~400 items, as a package. Is it possible to see the date when all the items in sales order package are ready?

Johan De Taeye

unread,
Nov 9, 2020, 2:23:51 AM11/9/20
to freppl...@googlegroups.com

 

Hello,

 

FrePPLe’ data model doesn’t have the concept of a “sales order line” within a sales order.

 

>>Each sales order usually has 100~400 items, as a package. Is it possible to see the date when all the items in sales order package are ready?

 

This can be modeled by creating a delivery operation for the sales order.

You create an extra operation for each sales order, and assign it using the “sales orders.delivery operation” field to the sales order.

In the “operation material” table you create records for the 100~400 items that are required for the order.

 

In the resulting plan you will see:

-          The sales order is delivered only when all components are available.  By setting the “sales order.minshipment” field you can also allow partial shipments where all components are delivered partially.

-          The consumption of all items is synchronized. Ie all items are consumed from inventory at the time when the most constraining item is available.

 

Johan De Taeye

Mob: +32 477.385.362

Skype: jdetaeye

Visit us at https://frepple.com

--
You received this message because you are subscribed to the Google Groups "frePPLe users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to frepple-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/frepple-users/36445730-8a1e-4e97-896a-43589c07cac0n%40googlegroups.com.

SEUNGWOO KANG

unread,
Nov 11, 2020, 4:13:36 AM11/11/20
to frePPLe users
Thank you very much Johan,
May I ask one more question?
There is purchase order that has 3 days of lead time
date, qty
Nov 13, 100
Nov 12, 100
Nov 11, 100

How can I change the purchase order like below? (give lead time as an interval)
Nov 13, 100
Nov 10, 100
Nov 7, 100

Best regards,
SEUNGWOO KANG




Johan De Taeye

unread,
Nov 11, 2020, 5:22:46 AM11/11/20
to freppl...@googlegroups.com

 

You can use a supplier calendar and/or capacity to model a supplier schedule:

eg a supplier than delivers only on a specific day in the week

eg a supplier where you place your purchase order once a month

 

See this example model:  https://frepple.org/docs/current/user-guide/examples/supplier/supplier-capacity.php

SEUNGWOO KANG

unread,
Nov 16, 2020, 12:32:13 AM11/16/20
to frePPLe users
When I click the triangle by the item it reads "item with ID "00001 2구미늘[20*13]EA" doesn't exist. Perhaps it was deleted?"
Please help.

Johan De Taeye

unread,
Nov 16, 2020, 2:47:05 AM11/16/20
to freppl...@googlegroups.com

 

> When I click the triangle by the item it reads "item with ID "00001 2구미늘[20*13]EA" doesn't exist. Perhaps it was deleted?"

 

From which screen you see this error? And which frepple release are you using?

 

Could it be there is some special character in your item name? Eg leading or trailing spaces?

SEUNGWOO KANG

unread,
Nov 16, 2020, 9:57:47 PM11/16/20
to frePPLe users
I'm trying 6.8.0 version and attached video file which shows the menu. Is there a list for allowed special characters?
201117 dead item.mp4

Johan De Taeye

unread,
Nov 17, 2020, 2:13:12 AM11/17/20
to freppl...@googlegroups.com

 

>> Is there a list for allowed special characters?

 

All characters should be possible. It appears to me like our escaping of special characters misses out a case.

 

If you look in the database table “item”, you should be able to see the full unescaped name of this item.

Johan De Taeye

unread,
Nov 17, 2020, 11:50:09 AM11/17/20
to frePPLe users
I did some testing, and I believe this happens when you have tabs in the name.
Could that be your case?

Op dinsdag 17 november 2020 om 08:13:12 UTC+1 schreef Johan De Taeye:

SEUNGWOO KANG

unread,
Dec 5, 2020, 3:57:06 AM12/5/20
to frePPLe users
Hi, Johan
We produce an item, or buy it when the production is in short.
How can I make purchase operation as alternate for production?

Johan De Taeye

unread,
Dec 5, 2020, 4:15:00 AM12/5/20
to freppl...@googlegroups.com

 

Hi,

 

First of all, please use a separate thread/topic for new questions.  

Continuing on a single thread makes the answers not reusable to others that have the same question.

 

>>How can I make purchase operation as alternate for production?

 

Have a look at https://frepple.org/docs/current/user-guide/examples/operation/operation-alternate.php

This example has 2 alternate production operations.

 

You can do the same to model make-or-buy decisions:   you create a production operation with priority 1, and you create an item-supplier record with priority 2.

Make sure to set the search mode correctly to get a good selection of the alternate.

Reply all
Reply to author
Forward
0 new messages