Search results for query: *

My company needs a multi level BOM crystal report. We have about 5 to 6 levels of BOM and my users want a report such that if a top level item is entered in the report, it will print all the components 5-6 levels deep. We are not happy with the Great Plains report writer so that option is ruled...

I am looking for that code too. If anyone has it, please post here.

can you post how you did it?

Has anyone worked on creating a sql script to get the same data that a T&M prebilling report will get? I am trying to create a script and dont know which tables and fields to look at.

thank you.

Hello there, I have several sales orders with configured items. However, the configuration options for these sales lines are not defined in Great Plains, instead they are mentioned in the comment field. My task is to generate a sql script to insert these configuration options for these sales...

thank you for the script. what is 1RECEIVEDAMTS in the first view. Is it another view or is it a custom table. Can you post the script for this. Scott

I have assigned the task of determining future availability of our inventory items in weekly time buckets. Has anyone tried to do this before and if so, can you provide details/scripts that will help out.

Robert, That is very handy. can you post the batch file later. It will be very helpful.

Yes, please email it to me. It is scott-williams at hotmail dot com I appreciate the effort.

I would like to generate a crystal report that provide a multi level whereused information in BOMs. I started writing the script with table BM010115 but I am stuck because of the following issue: ITEM A SubItem B SubItem C SubItem D subSubItem E...

You do not have a date criteria applying to sales documents which is why you are seeing them.

can you post your view or query here and maybe we can look the issue.

Is Labelview integrated with Great Plains for your system, Cryrep? I mean can you print labels from great plains window or do you go to another window outside the system.