search

Acumatica / Acumatica-LotSerialNbrAttribute-2023R1-ONWARD

Adding Attribute Support to Lot/Serial Number
GNU General Public License v3.0
8 stars 1 forks source link

readme

Project Status

Adding Attribute Support to Lot/Serial Number

Acumatica ERP lets you define attributes for flexible, meaningful classification of an Entity (Lead, Stock/Non-Stock Items Etc.) as required for your company's specific needs. An attribute is a property that enables you to specify additional information for Entity in the system.

This extension allows to add attribute support to Lot/Serial Number so that each Lot/Serial Number's unique characteristic (Example – color variation, stone pattern etc. in case of Granite Slab) can be tracked. With this extension, you can:

Prerequisites

Quick Start

Installation

Install customization deployment package
  1. Download PXLotSertialNbrAttributeExtPkg.zip from respective branch.
  2. In your Acumatica ERP instance, navigate to System -> Customization -> Customization Projects (SM204505), import PXLotSertialNbrAttributeExtPkg.zip as a customization project
  3. Publish customization project.

Migrating from https://github.com/Acumatica/Acumatica-LotSerialNbrAttribute solution:

You need to execute below SQL Script. We recommend you to verify solution in Sandbox environment prior using in production environment. 

UPDATE CSAttributeGroup 
SET EntityType = 'PX.LotSerialNbrAttribute.Ext.INItemLotSerialInfo' 
WHERE EntityType = 'PX.LotSertialNbrAttribute.Ext.UsrInventoryLotSerialContainer' 
GO 
UPDATE INItemLotSerial 
SET NoteID = UsrInventoryLotSerialContainer.NoteId 
FROM INItemLotSerial 
    INNER JOIN UsrInventoryLotSerialContainer 
    ON  UsrInventoryLotSerialContainer.CompanyID = INItemLotSerial.CompanyID 
    AND UsrInventoryLotSerialContainer.InventoryID = INItemLotSerial.InventoryID 
    AND UsrInventoryLotSerialContainer.LotSerialNbr = INItemLotSerial.LotSerialNbr

Usage

  1. Go to Attributes Screen (CS205000) and create new attributes if you need to. You can create attribute/s with numeric control types (Integer and Decimal) as well.

  2. Navigate to Lot/Serial classes Screen (IN207000) and select the class for which you need to specify list of Attributes.

  3. Navigate to Stock Item Screen (IN202500) and create a new Stock Item having Lot/Serial class created in Step # 2.

  4. Create Purchase Order (PO301000) for Stock Item created in Step # 3. And move forward with creating Purchase Receipt (PO302000) for this Purchase Order.

  5. Click on Allocations button, you should be able to see Attributes specified in Step # 2 and can specify value for them. Also, you can specify value for Mfg Lot/Serial as well.

  6. Apply Attribute from First button copies attribute values specified for very first Lot/Serial Number and applies to rest of the Lot/Serial Number displayed in the dialog. One can specify value for each individual Lot/Serial Number as well.

  7. Attribute value can be assigned similarly for Lot/Serial Number while receiving inventory using Receipt (IN301000) and Move (AM302000) Screens as well via Allocations dialog.

  8. Lot/Serial screen (IN202501) can be used to assign Attribute values, image, description, detailed description, Sales Price, MSRP and E-Commerce settings at individual Lot/Serial Number (IN202501); values are defaulted from Stock Item (IN202500) during receiving process

  9. Lot/Serial screen (IN202501) can be used to view information like Warehouse, Location, Created With, Assigned To, Cost, Price Sold For and history.

  10. Attribute values can be imported via Import Lot/Serial Attributes custom import scenario available via customization package.

  11. Lot/Serial Screen (IN202501) is available for REST API via custom Web Services Endpoint (eCommerceLotSerial)

  12. Add Item Lot/Serial option can be utilized to search Lot/Serial Number by attribute value and allocate in Sales Order (SO301000), Material (AM300000), Service Orders (FS300100), Appointments (FS300200), Issues (IN302000), Adjustments (IN303000), Transfers (IN304000) Screens. Columns for Attribute/s will be dynamically added in displayed dialog.

Known Issues

  1. Attributes having numeric control type (Integer or Decimal) are not supported as User defined fields (UDF) at present

Source Code

Contact Acumatica customization team for additional feature to be developed by community members for consideration to be part of general availability of this customization via submitting a New Customization Request Case.

For customer specific additional feature; a second level of customization must be created on top of this customization by referencing extension library.

Support and Maintenance

Acumatica will provide upgraded package within 90 days of each major release. If you require package to be upgraded prior to this release schedule then annual customization maintenance plan is required.

Assistance with setup, training, troubleshooting issues with this customization requires annual customization maintenance plan. Contact Acumatica customization team by submitting a New Customization Request Case.

Additional Feature Request

Please submit a New Customization Request Case to determine effort and cost.

Copyright and License

Copyright © 2023 Acumatica

This component is licensed under the GPL-3.0 License, a copy of which is available online here