![]() The mechanics of importing the product quantities as a stock change or sale order in an inventory system will obviously depend on the inventory system, but using Finale Inventory as an example, the process will be something like the sequence of steps described here. If you are given the choice, the XLS file format is usually preferable to CSV because importing CSV data into Excel is prone to errors like Excel removing leading zeros from part numbers, if you are not careful.Įxample of importing the product quantities into Finale Inventory The other columns are useful to keep around as a sanity check, but one can assume, if you are providing quantities for specific products, that your part numbers match the inventory system that they will be applied to. The two important columns in this report are the Part Number column, and the Devices (quantity) column. That will product a report like the one shown in Figure 1.įigure 1 – Printing the report “basic_product_totals_portrait” and choosing the XLS file format. ![]() landscape doesn’t matter in this case) and in the file selection dialog, choose XLS or CSV as the output file format, instead of the default PDF. From Finale 3D, do the menu item “File > Print > Report > basic_product_totals_portrait” (portrait vs. Your responsibility may be simply to give that company a list of product quantities from your show in a format that can be processed. You may be in a situation in which you have no idea what inventory management system the 3rd party company is using. What if you have scripted a show in Finale 3D using a product list from a 3rd party company, and you want to provide that company with the product quantities used in your show so they can be reserved or relieved from that company’s stock counts? This section explains how to export the data, and walks through an example of how a 3rd party company might import your data as a stock change using Finale Inventory. Documentation on these inventory management options, however, is tailored to the company doing the inventory management. Finale 3D also provides an integration with Finale Inventory, which expands the capabilities of inventory management to include stock reservations, sales orders, packed shows, quotes, and other real world complexities. Finale 3D provides for basic inventory management as described in Basic inventory management in Finale 3D, which obviously includes deducting a show’s product quantities from stock counts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |