web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Costs of goo...
Microsoft Dynamics GP (Archived)

Inventory Costs of goods does not always post

(0) ShareShare
ReportReport
Posted on by Jerry Tournoux 205

Has anyone else seen this? If so do you have any suggestions?  I posted the following back in September 09 on Victoria's blog.  I followed the advice and cannot find any items set up incorrectly.  I cannot reproduce this on demand.  I do have all of this set up in dev and test environment but, again, I cannot reproduce it.  I have been tracking the occurrences of these over time and had it happen eleven times since March 1, 2012. I know that the items have posted properly on many other invoices. Also, when this happens, it is all the items on the invoice, not just one or two.

We post approximately 500 invoices each night in a batch after hours.  No other processes are running at that time (except web orders coming in through eConnect.)  We have one company, three inventory sites.  Cost of goods comes from item. first account segment picks up sit ID. We are running GP10 SP5. We use SOP, GL, POP and Inventory.  We have a lot of custom but our partners have not been able to find the cause either. 

Any help would be greatly appreciated.

Thanks, Jerry

Victoria,

Great information. Thanks for writing. I was wondering if there is a way to be sure that an invoice would post the INV & COG. We have a lot of custom and I often find things that don’t work quite right. So I try to catch everything by running exception scripts prior to posting (at night in a batch). I check for unmatched distributions while it’s an invoice but is there a way to see COG before hand?
Thanks, Jerry

Victoria Yudin Reply September 15, 2009 at 3:43 am

Jerry,

There is no easy way to do this. If you were doing it manually, you would need to go into each item and check the distribution accounts set up for it. Since the sales transaction will not post without the Inventory and COGS accounts it is not a question of whether they are there, but more of whether they are correct. If you are looking to check the amounts that will be used, that is a lot more difficult, since it will depend on the order that invoices are posted and your cost layers at that exact point in time. All in all, not an easy task.

My 2 cents would be that rather than checking the distributions before posting, check the setup in GP and the logic of any imports or customizations to confirm they are correct. Set up a test environment and test everything. I know this is sometimes easier said than done, but that is the best way to do it.

-Victoria

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    First check IV00101.IVIVINDX and IV01010.IVCOGSIX make sure they are the account indexes of your GL accounts for inventory and COGS. Then check SOP10200.INVINDX and SOP10200.CSLSINDX and SOP10200.NONINVEN. The account indexes again must be for your inventory and COGS GL accounts plus NONINVEN needs to be 0. It sounds like for some reason when posting it things the items are not Sales Inventory items.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Jerry,

    Just to confirm, are you saying that there are no INV and COGS distributions on the SOP invoices at all?   If so, the 3 reasons I can think of are:

    1. the items are marked as non-inventory, as Richard suggests
    2. the cost for the item at the time is 0
    3. the items are set up with an Item Type that does not track quantities or COGS (Misc Charges, Services, Flat Fee)
  • Jerry Tournoux Profile Picture
    Jerry Tournoux 205 on at

    Yes, That is what I am saying.  But again, only on “random” invoices.  

    These items work on other invoices – so I think we can count out #1

    I can see the costs in the order and the invoice in SOP30300.UNITCOST; SOP30300.ORUNTCST; SOP30300.XTNDCOST; SOP30300.OREXTCST – makes # 2 out.

    As for # 3, I revert back to # 1.

    It seems like there might be a lock reading from or writing to a table.  But since posting is the only thing going on, I can’t believe that would be the case.

    Do you know the actual stored procedures involved in the posting process that get costs?  I suppose there are too many to say.  Do you think it might be feasible to just run a trace very night during posting and wait for a night when I get one?  The posting generally takes about 10 – 15 minutes.  If you think this might be a possibility, can you recommend how to set up the trace?

    Thanks,

    Jerry

  • Melissa Sandrovich Profile Picture
    Melissa Sandrovich on at

    Hi Jerry!  It's been a while - hope things are good in Ohio!

    Are these invoices that are imported?  I would take a look at an invoice where the items didn't post correctly versus an invoice where the same item did and compare all the fields on the lines as well as the header info.  Also check to see if there is a discrepency between the order and invoice it created - maybe something is happening during the transfer process.   You may have already done this, but wanted to suggest anyway.

    Melissa Sandrovich

  • Jerry Tournoux Profile Picture
    Jerry Tournoux 205 on at

    Hi Melissa! Great to hear from you again. Ohio has been pretty nice lately.  But I bet the mountains in CO are much better!

    Yeah, I did try that that already. I compared the order to the matching invoices and compared field by field ones that worked and ones that didn't.  I can't find anything different in SOP30200 - SOP30300.  That's wht I was thinking if I knew more of the sprocs that posting uses, I might find a clue in some other table I am ignoring.  What do you think about running profiler every day during posting until it happens again?

    Oh and by the way, the invoices are not imported. They are created through Dynamics Sales Transaction Entry..

  • Melissa Sandrovich Profile Picture
    Melissa Sandrovich on at

    Can't complain about CO!!

    I am not sure that it's the posting causing the issue, but maybe when the order is created or transfered.  Are you able to see the inventory transactions for these posted invoices in the inventory inquiry screens?  And do they have a cost associated with them?  

    Also - since I'm old and can't remember - is your slaes trx entry screen modified?  Or have you added any new 3rd parties when this started happening?

    I can see if I can find the stored procs it is using, but I really think we might need to be looking at the orders as they go in.  Have you noticed if is the same user that is either enterring or transferring these?

    It always fun to try and find the issue when the problem is sporadic :)

  • Jerry Tournoux Profile Picture
    Jerry Tournoux 205 on at

    Indeed! Always fun to solve one of a kind puzzles like this!

    You are certainly NOT old!! But I can understand why you'd WANT to forget all the custom we have in Sales Trx Entry.  We have a ton of customizations to it!  Nothing new 3rd party added prior to this.  I don't really know how long it's been happening.  It was just more recently, that we identified it as something of a priority.

    The inventory transactions do not happen for these invoices/items, so there is no cost.  I did say earlier that it's all or nothing.  That's usually true,  However, as I've been digging more, I've found a few instances where only one or some did not post correctly.  

    I also thought I found another clue.  I found that on every one that didn't post, there is a value of zero on the SOP30300.EXTQTYAL .  It looks like that's always the case for orders, but the invoicesthat work right  have a qty >0.  I thought this was a real clue until I noticed that there are many more instances of this happening when COGS and inventory did post.  But every one that didn't post, had zero for the EXTQTYAL..

    Jerry ;)

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    If you check the values of SOP10200.NONINVEN and SOP30300.NONINVEN for these orders where it messed up are all the values zero? Does happen to all items or just certain ones? All clues keep pointng back to the idea that for some reason at the time of posting GP thought these items were not sales inventory items. How big are the sales batches you are posting? It is possible your server is getting near 100% utilization doing GP and other work? Do you have an external applications that may been putting locks on GP inventory tables?

  • Melissa Sandrovich Profile Picture
    Melissa Sandrovich on at

    I was going to suggest the same thing - maybe the processor is getting bogged down with the number of transactions.  Or are they posting at the same time there is another process running on the server?  Is it posisble to break these apart into smaller batches?  

  • Jerry Tournoux Profile Picture
    Jerry Tournoux 205 on at

    The value for NONINVEN in both the SOP10200 and SOP30300 is zero in all cases on these invoices.  Out the the twelve occurrences I've documented since March, 11 of them had no inventory transaction nor COGS for any item on the invoice.  There was one invoice that had one item record the IV transaction and the COGS.

    I don't believe our server is running anywhere near 100%.  i will check that though. It rarely spike above 30 - 40 when all users are on.

    We regularly (nightly) post the invoices batch with about 500 invoices.  Our average line item count is around 5.  So, we are posting about 2500 line items.  There are no other processes or jobs running other than eConnect (hmm) when posting occurs.  As I say that - I wonder...... eConnect runs and brings orders in from our web site.  It writes to the SOP tables.  Do you suppose there could be an issue there if an order was being inserted???  I am going to look at the record of order times on the days these happened.. But would it have to be the same line item??.....hmmmm...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans