Question about Bill of Materials and Crystal reports

Posted By drakehs over 8 years ago

My client is on Sage 100, 2014 Product update 7. Currently, I am trying to write a Crystal report for Bill of Materials.

I need to have a field brought n that is the current bill or default bill for the bill of materials. I can pull the bill of materials but it pull all of the revisions, I would like to only have the current bill because this company has 10,000 bill of materials. Does anyone know what field that this might be?

Also, in the older versions of Sage 100, I use to get the fields called "Link to next Line" and also "Previous index number" but I can no longer find those fields. I am sure that these have changed but I cannot find a new data dictionary listing that consultants us to be privy to in the past.

Can anyone help me with this because I called support and they are having a hard time in finding this information?

0 Dandar over 8 years ago

If I am understanding correctly, you are looking for "BM_BillHeader.CurrentBillRevision".

Also, for the links to the next and previous lines, do you mean that you are trying to traverse the line items in a bill of materials? If so, you should be able to use the BM_BillDetail.LineKey field. That field tells you what line an item appears in a particular bill.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KBatch over 8 years ago in reply to Dandar

As was stated, you want to be pulling header records where "BM_BillHeader.Revision" = "BM_BillHeader.CurrentBillRevision".

The Next and Previous line links went away when BM1 & BM2 were replaced by BM_BillHeader and BM_BillDetail at version 4.40. Beginning with 4.40 you will pull all detail lines that have the same BillNo and Revision as the header record.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Question about Bill of Materials and Crystal reports

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING