155 Comments for this entry

  • Muhammad Saad

    Dear Mindaugas

    At one of my customer in AX- 2009, we ran Inventory Closing as on 30th June 2012, on 30th June 2012, at a movement it was stopped and through an error “Cannot create a record in Price (InventItemPrice). Item number: PM-0074, the record already exists”.

    I have read in some blog that if we unmark Latest Purchase Price and Latest Cost Price check boxes on item master this will resolve the above error, so I did that.

    At that time we did not notice that Inventory Closing was paused in process because In Invent Trans we could see Inventory Closing Transactions.

    Now next day we realized that we have to cancel Inventory Closing as some of the transactions were not posted, since Inventory Closing was paused in between so before cancelling I have to complete closing first.

    Now when I am resuming the inventory closing system is throwing error “The transactions on voucher ICV-1112-000001 do not balance as per 6/30/2012. (Company currency: -0.00 – secondary currency: 0.00)”

    Please help.

    • denisfed

      Hello Muhammad
      Most probably, it is caused by roundings write-off. Please, check that all your inventSettlement records for the given inventory closing, which have balanceSheetposting filled, also have operationsAccount filled as well. If they do not have operation account filled, fill it with a job and continue inventory closing. Most probably, you have roundings write-off for purchase operations. These operations use Consumption account from Inventory posting setup for Purchase operation. In many cases, consultants forget to fill-out this setting. (It is not used in most cases and everything except inventory closing, works pretty well without this setup in most cases). But when inventory closing is being run, it uses this setting to define ledger account for roundings write-off…

      Regards
      Denis

  • Rohana

    Hi Dennis,

    We have AX 4.0 with sp1. after closing a inventory on 04/30/2012 One item cost value in dimension report around 42K in local currency. At the day of 05/22/ 2012 i ran recalculate for that item and item cost value will changed even april month transaction value too. So i want to clarify that after completing IC for particular period even recalculation will change the cost values of closure periods.

    Regards,

    Rohana

    • denisfed

      Hello Rohana
      Both inventory closing and inventory recalculation can change the value of inventory Transaction from closed periods. It happens when some of the past period’s inventory issues are settled to inventory receipts from current period. It can happen if inventory transactions are posted out of order. It often happens when stock arrived w/o accompanying invoice and you start to sell it today, but you post purchase invoice only 3-4 days later.
      In this case, inventory recalculation and inventory closing can easily change CostAmountAdjustment of closed period transactions. The same thing can happen also when you are revaluating past period receipt transactions (say – posting late inventory mark ups for past period invoices).

      Also, I want to mention that in this case, even though transaction itself is from past period, adjustment record in inventSettlement table has date of your last recalculation or closing. That’s why, strictly speaking, we should not use wording ‘cost value of inventory transaction’. It is better to use term ‘balance of inventory transaction per-date’. You should not just add inventTrans.costAmountPosted to inventTrans.costAmountAdjustment and use it as final value. You should take inventTrans.costAmountPosted for the transaction and then add-up all adjustments from inventSettlements for the transactions, made before reporting date.

      I consider that the field inventTrans.costAmountAdjustment is one of the most misleading features of logistics module in Axapta. Author of the module decided that an inventory transaction can have a lot of settlements (say – a 1000). He decided, that it would be much faster to take initial cost (inventTrans.costAmountPosted), add total amount of corrections (inventTrans.costAmountAdjustment) and then SUBTRACT adjustments AFTER reporting date, taken from inventSettlement. A peformance improvements from this method are questionable, but as a result of this design decision, 99% of consultants and developers simply add-up inventTrans.costAmountAdjustment to inventTrans.CostAmountPosted and then surprise that Axapta is changing the value of closed transactions…

      Regards
      Denis

      • Rohana

        Hi Dennis,

        Thanks lot for your information. Normally after IC for particular period we generate financial value report for the inventory value report. ( IM> Reports> Status> Inv. Value> Inv. Value by Dimension report. )

        So it will give ware house item finanicial cost value. So after submitting it to the management then cost value will change means they will mislead when some body inquiry it.

        So if you can clarify How can we get exact value of inventory from AX report it self ? FYI from that day on wards that item cost is perfect.

        Apart from that is there any way/method to identify those king of item before we get a report from the DAX ?

        Highly appreciate your thoughts.

        Regards,

        Rohana.

        • denisfed

          Hello Rohana
          First of all, you use correct report. It do calculate inventory value per-date. (So – I was wrong about my suspicions that you simply use some home-made incorrect report). The problem is: Probably you have some issues with inventory receipts/issues order. If you want to find exact reason for this discrepancy, you can try the following:
          1. Copy your production database into test environment and run inventory closing. (Not recalculation. Inventory closing saves settlements into persistent table and you can analyze your cost structure).
          2. Try to find issue or receipt transaction with changed value.
          3. For this inventory transaction, click Inventory->Cost explorer. This tool shows you the cost tree of every inventory transaction. You can check all inventory transactions/adjustments which contributed into the cost of this inventory transaction.
          4. Browse the whole tree. Most probably you will find that some of contributing transactions were either posted after 30.04, either adjusted after 30.04. This is the reason why one of your old transactions (closed by 30.04) were adjusted in May.
          The problem is: It is too time consuming to run this check every time when you need to find reason for the post factum cost change. Moreover, you cannot prevent situations like this from happening. Users post transactions with incorrect date; Receipts are posted after issues; All similar stuff happens every day. And every time it can lead to a change in cost price of the item, which had not had movements in the last month.
          So, I guess, you can just live with it. Better to have some standard answer for an auditor. Something like ‘our costs often are late and it causes sometimes to change in cost price of an item without movements in the given month’. You are not the only one who are facing this issue. Maybe Microsoft will fix it in future releases (I heard rumors that they are going to heavily rewrite inventory costing module in future versions), but maybe it won’t…

          Regards
          Denis

          • Rohana

            Hi Dennis,

            Once again thanks for your valuable thought. will do it in test env. and will get back.

            Regards,

            Rohana

  • Agus

    Hi Denis,

    Thank you for this interesting article. You could write a whole book on this topic!

    I wonder about something. I believe the iteration that you explain is iteration within same level (self iteration). What about the outer iteration that read the next inventcostlist of the same item, would you explain what may cause that?
    I have item with transfer orders that has reached maximum iteration 100 for it self iteration, and also exceed the outer iteration of 100, yet the cost amount deviation is still high.

    Thank you.

    • denisfed

      Hello Agus
      Most probable reason are loops in cost price. Most probably, if you check suspicious lot in cost explorer, you will see that some transactions have themselves as one of their cost contributors…

      Regards
      Denis

  • Rohana

    Dear Dennis,

    Related to my above postings. Once you mentioned that closed periods cost values change due to abnormal issues order. So can you briefly explain it?

    I want to make sure one of clarification regarding AX 4.0 recalculation. If I know exactly one item cost is abnormal and then if i did recalculation for that item how adjustments were taken place against what transaction and so on. Is there any method or place to monitor that settlements and their references too ?

    waiting your feedback.

    Regards,

    Rohana

    • denisfed

      Hello Rohana
      Abnormal issue order happens when your issues goes from inventory before related receipts are posted. Say, you posted first purchase order for 100 pieces on 01.06. Then you have posted transfer journal for 5 pieces on 25.05 (remember, on posting the system checks for negative inventory only on current date, so you can easily have a situation when your issue is posted before receipt).On closing of may, you would have your sales inventory transaction closed. (Because if would be fully settled to transfer journal receipt transaction). Then on closing of June, it might happen that your receipt from 01.06 was settled to your inventory transfer issue from 25.05. In this case, your sales inventory transaction would be adjusted in June, because adjustment of inventory transfer issue would be propagated to inventory transfer receipt and then to sales order inventory transaction…
      Regarding monitoring: First- you can check the content of inventCostListTrans table during inventory closing (I wrote something about it in my article). Another approach is to copy database to test environment, then run closing and use cost explorer to analyze cost sources for the given inventory transactions…

      Regards
      Denis

  • Agus

    Thanks Denis for your quick response. Will look at that.

  • Verner Jensen

    Hi Denis.
    Thanks for at brilliant article about this Topic :-)

    Best Regards

    Verner

  • Waldemar

    Dear Denis,

    Спасибо за эту замечятельную статью!

    It helped me to put some light on this “black magic”. It looks like most people don’t really understand how it works and just trust and hope that the result will be OK.

    I have one short question:

    Do the flags “Physical stock” and “Financial stock” on a Dimension group already affect how inventory transactions are created by the system?
    Basically, I am talking about the InventTrans (which is the main basis for Recalculation, as far as I know?).
    Or do these flags only affect how Recalculation and Closing is done?

    Our problem is we realised one month after live-going, that our Dimension group misses these flags and we need to run Recalculation and Closing. So we are asking ourselves, if it will just affect the Closing or the situation is worse and our inventory transactions are already f***ed up.

    I would really appreciate your help!
    Waldemar

    • denisfed

      Hello Waldemar
      First of all: Thanks for kind words!
      Speaking about changing physical/financial dimension flags after going live: First of all, you would probably find that for some of values of the dimension (say – you forgot to enable flag for Batch number), you have negative stock, because someone sold 5 pieces for a batch which has only 3 pieces. Physical Inventory flag, strictly speaking,do not influence costing. It only influence on-hand level check in time of physical inventory issues. Financial inventory flag DO affect costing, because it directly influence how instant cost price (in time of issue posting) is calculated and how settlements between issues and receipts is executed during final costing.
      In your situation, I would try the following (first in TEST environment of course): 1. Rollback inventory closing if you have any. 2. Disable check which prevents you from changing inventory dimensions setup. 3. Run inventory closing and check results. If results are more or less normal looking, and if you do not have so many messages about ‘Insufficient receipts’ during closing, you can check old transactions and change inventory dimensions for them. (Functions button in inventory details form). Cancel closing, change dimensions, run it again. After 2-3 iterations you will be able to fix all invalid data.
      If you have too many error messages after test closing – well, perhaps you still need to change dimension setup, but in this case, be prepared that for next couple of months, your per-batch costs will be very strange from time to time. Anyway – it won’t make situation any worst, because now you simply cannot calculate per-batch costs for all items and batches, but after you enable this setting, you will have reasonable costs for most of batches, and strange costs only for smaller part of them…

      Regards
      Denis

  • Gillian

    Hi Denis

    I was wondering if you can advise why adjustments are calculated on transafer orders when running the inventory close.

    reason being, when we run our close Ax tries to post adjustments for transfer orders, and throws an error that no financial dimension exists, however you do not specify a fin dimeansion on a transfer order?

    • denisfed

      Hello Gillian
      First of all: it is very normal for inventory closing to make adjustments to transfer. It is not very usual to make these adjustments as posteable to GL, but it can happen when the system writes-off roundings or hanging adjustment during final iteration of inventory closing. In this case, system takes dimensions from related records in inventTransPosting table (you can see it in Dimensions tab of inventory transactions for the transfer). In turn, during posting, the system fills-out inventTransPosting.dimension field with dimensions specified in item details (inventTable) for the item in transfer line. So, to correct the situation you need:
      1. Make sure that all your items has reasonable dimensions in inventTable
      2. Write a job, which will run over inventTransPosting records for all non-closed inventory transactions of transfer orders and fill inventTransPosting.dimension with relevant information from inventTable.

      Regards
      Denis

  • Waldemar

    Hi Denis,

    I refer to my comment at November 9th, 2012 on 3:06 pm.
    Just wanted to give you an update, maybe it is interesting for you.

    We have some luck, that we didn’t run any closings or recalculation yet. So:

    1. We decided to postpone the closing
    2. We created new Dimension group with “Physical inventory” and “Financial inventory” set for Batch (before, the Batch was activated and mandatory, but didn’t have these flags)
    3. We assigned the new Dimension group to items using code and ignoring MS checks.
    4. We run Recalculation just for a subset of items and the guys in accounting are happy with the results.

    I am still not sure, we will have any problems (or maybe differences in general) while daily working and posting on sales orders.
    But from your reply I understand that we will:
    “Financial inventory flag DO affect costing, because it directly influence how instant cost price (in time of issue posting) is calculated”

    So we are going to test some more (Closing etc.) and do the closing in December.

    I will update here; I hope our case will help somebody who has similar situation.

  • Pranav

    Hi Mindaugas,

    Thanks for the wonderful article. It helped us a lot.
    I need your advice on service items. In the item model group, we have now stocked product as a field. Should that be checked in general for service items? What’s impact if we check it or not?

    I came accross this issue because for AX for Retail. if i want to do any transaction for a service item, then that item should have stocked checked in item model group. Stocked product unchecked items doesn’t appear in POS.

    I created a service item with stocked product checked, did some transactions. Although there are no settlements, but still i am not sure what is the best way out for service items.

    Thanks in advance.

    Pranav

  • Mesru

    Thank you for the article! It really helped me.

    The line at first confused me: “4. Then this two pieces was transferred back to wh2 on the 6th day of the month. (Trsf2)”. I think it should be “4.Then this two pieces was transferred back to WH1 on the 6th day of the month. (Trsf2)”

  • Jarod

    how to setup standard cost revaluation base on batch number? i tried to select physical and financial posting in dimension group but unfortunately it only display until location level in standard cost transaction inquiry screen. any idea to include batch number for each revaluation record.

    • denisfed

      Hello Jarod
      As far as I understand, standard costing support price storage and calculation only per item dimensions. I guess, the best approach for you would be to add another inventory dimension (item dimension) and use it for costing purposes. Anther solution – you can simply use one of the existing item dimensions as a replacement for this batch costing dimension. (I guess, your ‘batch’ is not usual batch. You are trying to use it for other purpose).

      Regards
      Denis

  • Waldemar

    Hi Denis,

    As stated in my previous comments, our problem was that we had a wrong dimension group.
    AX didn’t allow to change the dimension group for items which already have transactions. But in our case we haven’t run any recalculations or closing in our system.

    I just wanted to give you a short feedback:
    We changed the dimension group using a Job. After 2-3 months we don’t notice any problems with that.

    The original idea was to purchase/sale with batches and allow to calculate costs per batch. In most cases it worked. In some rare cases users did mistakes by not using batches.

    Regards,
    Waldemar

  • Ashish

    Hi Denis,

    During inventory close, system is throwing an error that the account number for sales order consumption is not defined for item 90100. I checked the item and consumption account is defined in the item group. I also checked transactions and found that consumption entry is posted on sales order transactions.

    What could be the issue? Please share your ideas.

    Thanks,
    Ashish

    • denisfed

      Hello Ashish
      Inventory closing takes accounts not from current inventory posting setup and not from GL voucher. When IC is creating the records in inventSettlement, it fill-out account numbers with historical account data from inventTransPosting table. Try to check all Sales inventory transactions for your item. Check content of Ledger tab. If for one of the records you will see empty field Accounts-Financial->Operations account – that’s it. You have cancel your closing, fill-out this field of this record (or several records) with necessary data and then run closing again.

      Regards
      Denis

  • Ashish

    Thanks Denis for your reply.

    I looked in inventtransposting table for the concerned item and found that the ledger account rec id was present for all the records of sales order consumption entry. I am not getting what could be missing here. Please advise.

    Thanks,
    Ashish

  • Vamsi Pranith

    Hi Denis,
    When the recalculation/closing is done, is there a table where AX maintains the lot id which was used for settlement purposes? When I purchase the goods, there is a lot id that is generated and I want to find out that lot id, when the recalculation/closing is executed after the sale has been done and the cost has been adjusted, so that I can generate a report out of the system to show that which was the lot id that was used for the settlement purposes?

  • CHelsea

    HI Denis,
    We are attempting a month end inventory recalucation and we are receiving the following error:
    “Recaluculate Inventory
    – Item FLOTANSTA
    – No account number exists for acccount type cost for project

    Any ideas???
    Your help would be greatly appreciated,

    • Alison J

      Hi Chelsea,

      I guess item FLOTANSTA has a project category associated with it and also has been used for project transactions.
      I would review AX project module- posting profiles, especially with posting type ‘Cost’ related to the relevant project item transaction.

      I hope, I’ve made sense.

      Regards,

      AJ

    • denisfed

      Hello Chelsea
      From one side, I can agree with Alison on her advise. Probably, in the closed period, you have adjusted inventory transaction with project id. During posting, system is trying to find project cost account and fails for some reason.Try to:
      1. Run inventory recalculation, wait till it stops with error message
      2. Run a query which will show all projIds for inventory transactions adjusted by your recalculations for your item.
      3. Check that cost account is defined for all projects and your item.

      From other side, I could not find any place in standard inventory recalculation and posting algorithms, which would try to fetch the ledger account from project posting setup. Perhaps – we are dealing with a customization to standard functionality…

      Regards
      Denis

  • Philip

    Hello Denis,

    By accident, we have a Inventory Closing Cancellation stuck with InventCostStatus == Calculation. Resuming isn’t available as an option.

    The cancellation voucher has settlements, but has never posted. Any ideas on what we should do to fix this ?

    Regards,

    • denisfed

      Hello Philip

      Just go to your original inventory closing and click ‘Cancel’ again. When you are canceling inventory closing, the system first tries to find and continue existing (terminated for some reasons) cancellation closing and continue it.
      So – instead of clicking ‘Continue’ on cancellation closing, just cancel your original closing for 2nd time. (As I said – it will continue old cancellation, not create new one).

      Regards
      Denis

  • Madhu

    Hi Denis,

    Does the running average cost (average cost before close/recalc) include Marked quantity or Marked cost price? Since the marked transactions can have varied Costs, we were thinking that these are not considered in the running average calculation nor in Inventory close process. Can you please comment on this? Right now, the average cost calculation is including these marked quantity transactions.

    • denisfed

      Hello Madhu

      Normally – both closing and recalculation process marked transactions in separate stage – in the very beginning of calculation, before doing anything else. On success, these marked transactions are tagged as closed and, subsequently, are ignored during normal average/FIFO/LIFO cost calculation process. Nevertheless, if you have wrong markings (say – markings between inventory transactions with different set of financial inventory dimensions), these markings are being cleared during marking processing phase and these improperly marked transactions are later processed during normal averaging/FIFO/LIFO phases….

      Regards
      Denis

  • Philip

    Thanks Denis for your quick reply. Everything canceled correctly and the suspect month has been re-closed.
    The Closing and Adjustment Form by default initially shows Active, so the issue had gone unnoticed for 30 days until we tried to do our month-end Production Order Costings. Trying to end the Production Orders alerted us of the closing issue.

    Thanks again for the help.

    Regards,

    Philip

  • ramil

    Hi Denis,

    thanks for sharing your insights on AX 2009 inventory closing it helps me a lot in analyzing the postings and update made by the system after Inventory closing procedure.

    question, do you have any idea were we can get the total amount with posting type “Weighted average inventory closing” which updates only General Ledger Account and does not update Item Cost? I find out that some of the entry made by the system after inventory closing in General Ledger Account does not update the Item Cost level and only the related inventory Ledger account that results to difference between inventory value and ledger account.

    Also, can you list down the name of the table in AOT being updated after inventory closing? and those table that can be used to get the total financial updated items, physically updated items, item issuance that are settled during inventory closing and adjustment made by inventory closing…

    hope you can help me.

    thanks,

    Ramil

    • denisfed

      Hello Ramil
      The situation you are describing is very strange. Normally, GL postings of inventory closing are created from inventSettlement table. And update to inventSettlement is causing update to cost fields in inventTrans. I can imagine only one explanation for your situation: After inventory closing, someone run a job, which destroyed some of the settlements or transactions.

      Another possibility is that you run several inventory cancelations. IC cancelation code for Weigthed average model has a bug, which was fixed in DAX2009 CU6 (or CU7) andreintroduced in DAX2012 (in DAX2012R2 it is still in place). Inventory cancelation deletes dummy tranfsers, in turn deleting related inventory settlements. Since posting to GL happens afterward, it might be that GL voucher from cancelation is not equal to GL voucher from closing. As a result, your GL balance after cancellation can be different from the one before inventory closing. (Usually difference is not so big, because adjustments for dummy transfer transaction are not made too often, mostly in case of roundings/errors write-off).

      The list of the tables updated during inventory closing is very short: InventTrans,InventSettlement,InventCLosing,LedgerTrans,LedgerBalancesDimTrans,LedgerBalancesTrans. If you use new standard cost mechanism, it can also update inventCostTrans,inventCostSum, inventCostVariance tables. During inventory closing, it an also add/delete records to InventCostList and inventCostListTrans tables, but ther are working tables and should be emptied by the system in the end of closing…

      Regards
      Denis

  • ahsan

    When the clositng routine was executed the system gave me this error ‘Dimension Cost Center must be specified for account 418100.’

    I have made the Cost Center mandatory with this ledger account. I want to know why the system is asking me to specify the dimension . is this because of settlement entry the system wil throw ?

    • denisfed

      Hello Ahsan
      During inventory closing/recalculation, dimension for posting goes by the following chain: InventTransPosting->InventSettlement->LedgerTrans. If one of the settled or adjusted transactions is from previous periods, when you had not had ‘mandatory dimension’ checkbox set, this dimension might be empty in inventTransPosting. As a consequence, this empty dimension is copied to inventSettlement, later the system is trying to post ledgerTrans with empty dimension.
      You have to options to fix it:
      1. Make job which will fill-out all old inventTransPosting dimensions with some reasonable values.
      2. You can just clear ‘Mandatory dimension’ checkbox on next several inventory closings, so old historical data could be processed without too much problems.

      Regards
      Denis

  • ahsan

    Thanks ! Denis .. i went with option two

  • Ahsan

    I am having the below error while running the Inventory Close Procedure

    ‘Item number: 000003
    Transaction: Sales order CC042227, lot ID 00268434_098
    Unit cost price 419,39 can be wrong as the transaction cannot be fully settled’

    any know reason for this ?

    • denisfed

      Hello Ahsan
      It means that you sold more than your purchased. :) More specifically – some of your issue inventory transaction do not have related receipt inventory transactions. It is not very good, but later, when you post delayed purchase invoices, next inventory closing will adjust issue cost price of your current period issues. (But with dates from next period).

      Regards
      Denis

  • Aquino

    Hi Denis,

    Quick question, in AX 2012, if you run a inventory close as of Feb 28, 2014 and it not been run for several months, what dates are the ledger postings made for? Since we have released statement for prior months, we do not want the system going back and making postings to those previous months.

    Thanks,

    • denisfed

      Hi Aquino
      General ledger postings (as well as inventSettlement records) are always created with the date of running inventory closing/recalculation. So if you are running IC for 28.02.2014, this date is used even for adjustment made for inventory transactions of previous periods (Jan,Dec,Nov etc)
      Regards
      Denis

  • fatih

    Hi,
    How to prevent instant sales order inventory issue transaction. This only required to be calculated and go in transactions on month ending inventory closing process.

    I already did it with a simple code comment in ax 2009 but now i cant find the place of the code.
    Hope you can help me on this issue

    Thanks

    • denisfed

      Hello
      Try to redefine inventMovement.financialIssueCostValue() to return 0 for this item. If you also want to suppress similar posting for physical operations, modify InventMovement.estimatedPhysicalValue().

      Regards
      Denis

  • daniela

    Hi Denis,
    Thanks for sharing this article, it really helps me a lot to understand these topic.
    I have a problem and hope you can help me. We ran a recalculation of the whole inventory, wich after a while send a message that it had reached its maximum iterations. After 2 months we noticed we had differences between inventory and accounting, and traced it back to that recalculation.
    What we noticed is that the process had made an adjustment on the inventory of $353.00 from one article, but it hadn’t updated to GL which caused the difference. Could it had been because the process stopped because of the iterations?

    Sorry for my english i’m not very good at it, hope you can help me!

    • denisfed

      Hello Daniela

      Most probably, you are facing consequence of old bug which was fixed in the very last RollUp for DAX2009 (RollUp8, as far as I remember), but reappeared in DAX2012. It happens when you work with average inventory model. When you close inventory with average model, it creates dummy transfers and, potentially, adjustments to these transfers. When you cancel recalculation/closing, it deletes transfers and adjustments for these transfers. The problem is: before RU8 these adjustments were deleted BEFORE posting stage. So, from time to time, you can witness a situation when voucher for closing and voucher for cancellation differs to some extent. (Luckily, it happens not too often, because, normally, adjustment for dummy transfer are not posted to GL. But in some cases- say when system writes-off rounding in the end of calculation, system can create, as an exception, posteable adjustments for dummy transfer).
      Another typical problem – if your recalculation ends because of reaching maximum iteration, it often can lead to different cost price in issue and receipt parts of transfers. Normal closing, if it adjusts issue part of transfer and then terminates because of iteration exhaustion, writes-off this adjustments as a rounding error (and issue and receipt costs price remains the same). Recalculation never writes-off rounding errors, it simply adjust issue part and does not adjust corresponding receipt. As a result – you have hanging balance on the receiving warehouse. (and subsequent inventory closings do not adjust it). I try not to use recalculations at all. If I really need it, I simply enter high enough number of iterations- say 300. (Yes – By default, closing/recalculation does not allow to enter more than 99 iterations, but this check can be easily disabled).

      Regards
      Denis

  • Gogglebox

    Hi all,

    I have a ‘newbie’ question, although it has puzzled us.

    Is it possible or advisable/inadvisable to run the close procedure at the same time as stock is being processed elsewhere – for example, at the same time as a replenishment batch job is being run, or the warehouse is performing goods in transactions and so on?

    We are looking for a time to run close when the system is relatively quiet, but it’s a struggle to identify a time when there are no stock movements, given we have 24*7 website sales and so on.

    Thanks in advance,

    G

    • denisfed

      Hello
      It is possible to run stock closing anytime. Of course, inventory closing seriously increase load on AOS and SQL Server, so it is better to run it in the time of lowest user activity, but nevertheless normally it should not prevent system from operation. Every helper thread can lock maximum 100 inventory transactions and about 200 inventory settlement records. In the end of transaction, it can lock inventory on-hand data for processed items for a second or so. So – in the worst case, it can block normal logistic users for several seconds. The only big exception is InventSumLogTTS table. Because of design bug, Inventory closing/recalculation inserts data into this table (totally useless data) and any attempt to update explosion, run dynamic plan update, run production order scheduling can hang for much longer then several seconds, because if might need to wait for every helper thread. In my last post I wrote how to block inventSumLogTTS update from inventory closing, so if it will become a problem for you- you can just block this functionality.

      Regards
      Denis

  • Nirmal

    Hi,

    We are getting the error when we run inventory closing,
    ———–
    Item Number XXXXX
    “Value of department = is not allowed in account XXXXXX”..
    Posting cancelled
    ——————

    I understand from the user that they have posted adjustment journal by updating department dimension for one item and after adjustment they have chnaged it back.

    Able to trace the transction which was posted with department change.. Not sure how to get rid of this error..

    Is it possible to skip this item from inventory closing?

    Or is there a way we can skip only this transaction from c;losing?

    appreciate your inputs..

    Thanks,
    Nirmal

  • Vikrant Verma

    Fantastic artical Denis it has actually cleared my All doubts I am having in IC and adjustment procedure
    Thanks
    Vikrant

2 Trackbacks / Pingbacks for this entry

Leave a Reply