当前位置：文江博客话题详情

有什么办法可以限制 NetSuite 批次/序列号的唯一性吗？

发布于 2025-01-11 10:56:00 字数 398 浏览 1 评论 0原文

我遇到 NetSuite 序列号/批号可以重复的问题，如图所示下面，

我想通过设置/开发来防止出现重复的批号，或者退后一步，通过一份报告/SuiteQL 来监控重复的批号。

预先感谢您的任何提示！

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

蒲公英的约定 2025-01-18 10:56:00

我想我已经克服了监控重复批号的问题，就像下面的截图一样。

感谢 SuiteQL 查询工具支持你可能会得到下面的SQL。

--2022/3/4 Query Lot/Serial Number Duplicate Purchase Order
SELECT
    B.tran_id,
    A.inventory_number
FROM
(
SELECT
    inventoryNumber.inventorynumber AS inventory_number
FROM
    transaction INNER JOIN
        transactionLine ON transaction.id = transactionLine.transaction
    INNER JOIN
        inventoryAssignment ON (transactionLine.id = inventoryAssignment.transactionline
        AND
        transactionLine.transaction = inventoryAssignment.transaction )
    INNER JOIN
        inventoryNumber ON inventoryAssignment.inventorynumber = inventoryNumber.id
WHERE
    UPPER(transaction.type) IN ('PURCHORD')
GROUP BY
    inventoryNumber.inventorynumber
HAVING COUNT(inventoryNumber.inventorynumber) > 1
) AS A
JOIN
(
    SELECT
    transaction.tranid AS tran_id,
    inventoryNumber.inventorynumber AS lot_number
FROM
    transaction FULL JOIN
        transactionLine ON transaction.id = transactionLine.transaction
    INNER JOIN
        inventoryAssignment ON (transactionLine.id = inventoryAssignment.transactionline
        AND
        transactionLine.transaction = inventoryAssignment.transaction )
    INNER JOIN
        inventoryNumber ON inventoryAssignment.inventorynumber = inventoryNumber.id
WHERE
    UPPER(transaction.type) IN ('PURCHORD')
) AS B
    ON A.inventory_number = B.lot_number

I think I had overcome the problem of monitoring the duplicate Lot Number, just like the screenshot below.

Thanks for SuiteQL Query Tool support And you may get the SQL bellow.

--2022/3/4 Query Lot/Serial Number Duplicate Purchase Order
SELECT
    B.tran_id,
    A.inventory_number
FROM
(
SELECT
    inventoryNumber.inventorynumber AS inventory_number
FROM
    transaction INNER JOIN
        transactionLine ON transaction.id = transactionLine.transaction
    INNER JOIN
        inventoryAssignment ON (transactionLine.id = inventoryAssignment.transactionline
        AND
        transactionLine.transaction = inventoryAssignment.transaction )
    INNER JOIN
        inventoryNumber ON inventoryAssignment.inventorynumber = inventoryNumber.id
WHERE
    UPPER(transaction.type) IN ('PURCHORD')
GROUP BY
    inventoryNumber.inventorynumber
HAVING COUNT(inventoryNumber.inventorynumber) > 1
) AS A
JOIN
(
    SELECT
    transaction.tranid AS tran_id,
    inventoryNumber.inventorynumber AS lot_number
FROM
    transaction FULL JOIN
        transactionLine ON transaction.id = transactionLine.transaction
    INNER JOIN
        inventoryAssignment ON (transactionLine.id = inventoryAssignment.transactionline
        AND
        transactionLine.transaction = inventoryAssignment.transaction )
    INNER JOIN
        inventoryNumber ON inventoryAssignment.inventorynumber = inventoryNumber.id
WHERE
    UPPER(transaction.type) IN ('PURCHORD')
) AS B
    ON A.inventory_number = B.lot_number

回复收藏 0 原文

~没有更多了~