/
POINF022 - Replenish ReOrder report ignored the criteria selection for 'BOM Parents?'

POINF022 - Replenish ReOrder report ignored the criteria selection for 'BOM Parents?'

Owned by Beth Blok (Unlicensed)
Last updated: Nov 22, 2019
1 min read

Problem

BOM Parents are being treated as normal items to be ordered and this criteria was being ignored

Solution

SQL skills required

A working knowledge of SQL Management Studio is required to complete this task

Download the attached SQL script and apply this to your database 7.02.00.00 and higher.



Related articles







Related content

Debtor Child sales orders do not appear in the Parent / Head Office account - 7.00.175 SR10 and prior
Debtor Child sales orders do not appear in the Parent / Head Office account - 7.00.175 SR10 and prior
Jiwa 7
More like this
Where Supply Order Units > 1 stock is being over-ordered using Replenish to Minimum Re-Order method
Where Supply Order Units > 1 stock is being over-ordered using Replenish to Minimum Re-Order method
Jiwa 7
More like this
Re-order reports sometimes give an error 'Failed to retrieve data from the database' when running
Re-order reports sometimes give an error 'Failed to retrieve data from the database' when running
Jiwa 7
More like this
Debtor Parent Price element is not being applied to child debtor accounts
Debtor Parent Price element is not being applied to child debtor accounts
Jiwa 7
More like this
BMMGT010 - Bill of Materials Component WIP is not reporting components correctly where output > 1. Grouping by Work Orders is not available
BMMGT010 - Bill of Materials Component WIP is not reporting components correctly where output > 1. Grouping by Work Orders is not available
Jiwa 7
More like this
Part numbers changing on sales orders, quotes, purchase orders, shipments and bookins
Part numbers changing on sales orders, quotes, purchase orders, shipments and bookins
Jiwa 7
More like this