Vendor Tracking Specs

Vendor Master

  • Advanced Searches, Sorts, Locates, Filters and Grouping on all Vendor attributes
  • Transaction History of each Vendor
  • View Open Memos pertaining to active vendor
  • Vendor statistics, showing invoice and memo aging, and "batting average" (ratio of memos to invoices)
  • Export filtered vendor lists to Excel

Vendor Memos

  • Record goods received on consignment from Vendors
  • Vendor memos can be converted to returns or to purchases
  • Memo aging report used to control memos

Vendor Memo Purchases

  • Record goods previously received on consignment to Vendors that are now purchased from that vendor
  • Memo Purchases converted from a memo with quick "check off list" method, at which time memo details can be over written

Vendor Memo Returns

  • Record goods previously received on consignment that are being returned by that vendor
  • Memo Returns converted from a memo with quick "check off list" method

Direct Purchases

  • Record invoices from vendors without first receiving the goods on consignment
  • Produces Purchase Orders to facilitate control over invoices received from supplier

Reporting

  • Reports can be Printed on Paper, Exported to Excel for further analysis, EMailed, or saved as a PDF where appropriate
  • Sales analysis Data Mining shows views of inventory sales summary and detail, margins and net profit - Grouped by and sortable by LotID, LineID, Shape, CustomerID, SalesRep, SKU and VendorID
  • Manufactured Loose Goods sales analysis shows Loose goods content of sale and consumption of Manufactured goods - Grouped and sortable by Shape, Color, Clarity, SKU, Customer and Vendor. Exportable to Excel for further analysis
  • Manufacturing Outwork sales analysis shows Outwork content of sale and consumption of Manufactured goods - Grouped and sortable by Shape, LineID and Vendor
  • Manufacturing Component sales analysis shows Outwork content and percentages of Loose Goods, Finished Goods, Outwork and Metal of Manufactured goods - Grouped and sortable by Shape, LineID and Vendor
  • Vendor Memo Aged report lists open memos aged according to memo date, and grouped by either Customer or Customer within Sales Rep