Jump to content

Chris Bassett

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by Chris Bassett

  1. Is there a way to get the bill of materials for an assembly using the SDK or ODBC? I need to be able to run BOM reports from outside of Sage 50 so that our shop workers can see a complete BOM for a given assembly. Lately I've been using SQL and ODBC to access data from Sage (not the SDK) so I'd like to do the same for a BOM report. CAn someone assist with this? Mainly looking for some explanations on how the LINEITEM database table is configured and how to interpret/read BOMs using SQL.
  2. Can Sage please add the ability to build sub assemblies that go 3, 4 or 5 levels deep (recursively build sub-assemblies). For example, if I have an assembly numbered 5000. 5000 includes a sub assembly called 4000. 4000 is an assembly, and contains subassembly 3000. 3000 is an assembly and contains a dozen stock items. It would be nice if the Build or Work Ticket function could build assembly 3000 first, then build 4000 assembly (which includes the 3000 assembly), and then finally build the 5000 assembly (of which the 4000 is a subassembly) when you build the "top level" 5000 assembly. --OR-- An alternative would be for the Build window to show all sub assemblies and their bills of materials (in a tree form, perhaps) so that you can see what stock items and sub-assemblies are contained within a top-level assembly.
×
×
  • Create New...