Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Manufacturing & Supply Chain

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 5th February 2007, 20:35
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
Qty of item in Prod Order does not match BOM qty
Baan: Other/Unknown

Hello,

I have an item in our system where when a Production Order is raised for a top level part but the quantity for the bottom level part does not match the BOM qty of the item.

ie. Top level part A qty ordered (tisfc001.qrdr) =100
Bottom level part B net qty (ticst001.qune) = 66

The BOM qty for the bottom level part is 1 and the Production Order has been raised manually.

Which tables do I need to check to trace this issue ?

Cheers Neal
Reply With Quote
  #2  
Old 6th February 2007, 07:32
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c, Infor LN 10.4 - DB: Oracle 12c, SQL Server 2000, 2008, 2012 - OS: RHEL 6, Windows 2003, 2008
Thumbs up

1) Do you use projects(pcs) and therefore estimated customized bom?
2) In the standard BOM of the main item(A), does item B have a "Length" and "Width" defined or whats the value in the field "Number of units"?
3) Check the BOM unit of the main item (A) in the item master.
4) Last but not least, check the tdinv150 table, which is the planned inventory transaction table, to see whats the quantity planned for the item B..

These are the checks i could think of..

sk
Reply With Quote
  #3  
Old 6th February 2007, 10:12
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
Hello sk thanks for the reply.

1) No we do not use projects
2) Length = 0, Width = 0 and number of units = 0
3) BOM unit in item master = 0
4) Quantity in the Planned Inventory Transaction is 45.2571. What is taken into consideration when calculating this figure.

Cheers Neal
Reply With Quote
Sponsored Links
  #4  
Old 6th February 2007, 11:52
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c, Infor LN 10.4 - DB: Oracle 12c, SQL Server 2000, 2008, 2012 - OS: RHEL 6, Windows 2003, 2008
==> 3) BOM unit in item master = 0

How were you able to enter that value? In Item Master, this particular field wouldnt accept 0s, atleast in my case. I am not sure if there is any customization at your end but under normal circumstances, the BOM unit should be a value greater than 0. So care to throw some light on this?

==> 4) Quantity in the Planned Inventory Transaction is 45.2571. What is taken into consideration when calculating this figure.

I take it that the combination of Order Type and Transaction Type for the above quantity was [Production Order] and [Material Requirement]. If so, then the planned quantity is nothing but the quantity that is "to be" issued to a production order. Therefore if you had issued it partially, only the balance to be issued will be shown here. Before any issues happen, this is exactly the same quantity that was estimated at the time of production order creation.

sk
Reply With Quote
  #5  
Old 6th February 2007, 13:08
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
==> 3) BOM unit in item master = 0

Looking at our item master all of our components are set up like this and the system will accept zero if we change it. No customisation at this end but we are running ags0.

==> 4) Quantity in the Planned Inventory Transaction is 45.2571. What is taken into consideration when calculating this figure.

Yes you are correct this figure is the subsequent delivery.

Cheers Neal

PS. I will talk to support to try and get some assistance with the net quantity of the component part in ticst001 and post their findings.
Reply With Quote
  #6  
Old 6th February 2007, 19:12
jim s's Avatar
jim s jim s is offline
Member
 
Join Date: Aug 2001
Location: NH, USA
Posts: 62
jim s is on a distinguished road
Baan: IVc4 - DB: Oracle - OS: Unix
The BOM Unit in the item master is the number of units your BOM is based on. By definition this only involves manufactured items, so you can't modify this field for purchased items. It's normally (0), but if it's something else it just has no effect. If you change a purchased item with BOM Unit (0) to manufactured, you get an error "Quantity not allowed", though in typical Baan fashion it doesn't give you any indication of what field it's referring to. Enter a value of 1 or greater and it accepts it. Change it back to purchased and it just retains the value in the field but doesn't use it.

For manufactured items BOM Unit should normally be (1). If you use unusually small quantities of something in the BOM, you can base the BOM on some multiple quantity so that the quantity of the BOM line isn't too miniscule to use.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Total qty per item in BOM structure teddybear Tools Development 3 7th July 2006 13:06
Extra qty in prod order completed sathasivan Manufacturing & Supply Chain 1 24th November 2004 23:15
Partial backflush of delivered qty on prod order Neal Matthews Manufacturing & Supply Chain 0 30th September 2004 18:42


All times are GMT +2. The time now is 19:37.


©2001-2018 - Baanboard.com - Baanforums.com