Hi, One of our clients did an upgrade from NAV 2016 to Business Central with LS Retail. Some of their items are set to 'Standard Cost'. They did not update the cost on the Item card before they posted the Inventory qty take on, thus posting the transaction at a zero cost. They also decided that they would bring in the qty per the NAV 2016 figures per store, which meant that some stores had a negative qty, not sure how, but they do.
We ran the Standard Cost worksheet to populate a revaluation journal but had to exclude the items that had an entry for a negative adjustment or sale. Once we ran the revaluation journal, the adjust cost function was run as well, but it did not update the cost of the sale line. Can anyone tell me why or what we have missed?
On that note, how do we adjust the cost for the negative adjustment lines from the take-on? This process has been a nightmare so far, as they have over 20 000 items.
Thanks for all your help.