如何使库存物品标签（IN619200）在收到的每个物品的每单位上打印一个标签？ [英] How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?

问题描述

现成的 Acumatica库存项目标签报告（ IN619200 ）的设计目的是为仅当商品已序列化时才在收据上显示订单项。我们将修改报告，使用户可以选择收据编号，并让系统根据每个项目的接收数量生成标签数量，无论它们是否已序列化

Out-of-box Acumatica Inventory Item Label report (IN619200) is designed to print multiple labels for the line item on the receipt only when the item is serialized. We will be modifying report that will allow user to select a receipt number and have the system generate the number of labels based on the quantity received for each item regardless if they are serialized or not

推荐答案

我们将修改现成的库存标签报告（IN619200），该报告将按收到的数量打印每个标签，而对于未序列化的库存项目，仅打印所有数量的标签。

We will be modifying out-of-box Inventory Label Report (IN619200), which would print each label per quantity received rather just one for all quantity for non-serialized stock item.

我们需要一个用户表，并用数据填充它。

We need a user table and need to populate it with data.

CREATE TABLE UsrNumbers(Number INT PRIMARY KEY);
GO 
INSERT UsrNumbers 
SELECT TOP 1000 ROW_NUMBER() OVER (ORDER BY name) FROM sys.all_columns;

其中 1000 的最大可能值

现在为 UsrNumber DAC（数据访问类）创建code>并发布自定义，以便在报表中使用 DAC 。

Now Create DAC (Data Access Class) for UsrNumber and publish customization so that DAC can be used in report.

using System;
using PX.Data;

namespace InventoryLabelReportExtPkg
{
    [Serializable]
    public class UsrNumbers : IBqlTable
    {
        #region Number
        [PXDBInt(IsKey = true)]
        [PXUIField(DisplayName = "Number")]
        public virtual int? Number { get; set; }
        public abstract class number : IBqlField { }
        #endregion
    }
}

现在在Acumatica报表设计器中修改库存标签报表（IN619200），并在Schema Builder中包含以下关系。

Now modify Inventory Label Report (IN619200) in Acumatica Report designer and include a relation as below in Schema Builder.

下载部署包

这篇关于如何使库存物品标签（IN619200）在收到的每个物品的每单位上打印一个标签？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！